yvjia/db/comfy_project.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `comfy_project`;
CREATE TABLE `comfy_project` (
     PRIMARY KEY (`id`),
     `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'ID',
     `project_name` VARCHAR(20) NOT NULL COMMENT '项目名称',
     `comfy_lora_style_id` BIGINT COMMENT '风格LoRA ID',
     `comfy_lora_character_id` BIGINT COMMENT '人物LoRA ID',
     `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
     `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='短剧创作-项目表';

INSERT INTO comfy_project(project_name) VALUES (
    '我的仙狐娘娘'
);