yvjia/db/ai_volcengine_video_collect.sql

DROP TABLE IF EXISTS `ai_volcengine_video_collect`;
CREATE TABLE `ai_volcengine_video_collect`  (
                                                `id` bigint NOT NULL AUTO_INCREMENT,
                                                `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
                                                `task_id` bigint NULL DEFAULT NULL COMMENT '任务id',
                                                `task_detail_id` bigint NULL DEFAULT NULL COMMENT '任务明细id',
                                                `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
                                                PRIMARY KEY (`id`) USING BTREE,
                                                INDEX `user_id`(`user_id` ASC) USING BTREE,
                                                INDEX `task_detail_id`(`task_detail_id` ASC) USING BTREE,
                                                INDEX `idx_user_task_detail`(`user_id` ASC, `task_id` ASC, `task_detail_id` ASC) USING BTREE,
                                                INDEX `idx_user_task`(`user_id` ASC, `task_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '火山大模型生成视频收藏表' ROW_FORMAT = Dynamic;