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 COMMENT '用户id',
    `task_id` BIGINT COMMENT '任务id',
    `task_detail_id` BIGINT COMMENT '任务明细id',
    `create_time` DATETIME 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 COMMENT = '火山大模型生成视频收藏表' ROW_FORMAT = DYNAMIC;