yvjia/db/ai_volcengine_video_task.sql

DROP TABLE IF EXISTS `ai_volcengine_video_task`;
CREATE TABLE `ai_volcengine_video_task`  (
                                             `id` bigint NOT NULL AUTO_INCREMENT COMMENT '任务id',
                                             `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
                                             `model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模型',
                                             `img_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片地址',
                                             `resolution` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分辨率',
                                             `duration` tinyint NULL DEFAULT NULL COMMENT '视频时长（秒）',
                                             `text` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文本描述',
                                             `camerafixed` tinyint NULL DEFAULT NULL COMMENT '是否固定镜头 1-是 0-否',
                                             `quantity` tinyint NULL DEFAULT NULL COMMENT '生成数量',
                                             `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                             `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
                                             PRIMARY KEY (`id`) USING BTREE,
                                             INDEX `user_id`(`user_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '火山大模型视频生成任务表' ROW_FORMAT = Dynamic;