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 COMMENT '用户id',
    `model` VARCHAR(255) COMMENT '模型',
    `img_url` VARCHAR(500) COMMENT '图片地址',
    `resolution` VARCHAR(32) COMMENT '分辨率',
    `duration` TINYINT COMMENT '视频时长（秒）',
    `text` VARCHAR(500) COMMENT '文本描述',
    `camerafixed` TINYINT COMMENT '是否固定镜头 1-是 -1-否',
    `quantity` TINYINT COMMENT '生成数量',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME 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 COMMENT = '火山大模型视频生成任务表' ROW_FORMAT = DYNAMIC;