yvjia/db/crt_lora_style.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2025/06/03 10:09:22
*/

DROP TABLE IF EXISTS `crt_lora_style`;
CREATE TABLE `crt_lora_style` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `category_id` BIGINT NOT NULL COMMENT '风格分类ID',
    `name` VARCHAR(255) NOT NULL COMMENT '风格名称',
    `thumb` VARCHAR(1000) COMMENT '风格缩略图',
    `lora_style_name` VARCHAR(255) NOT NULL COMMENT '风格LoRA名称',
    `lora_style_path` VARCHAR(500) NOT NULL COMMENT '风格LoRA路径',
    `sort` INT DEFAULT '1' COMMENT '排序',
    INDEX `idx_category_id` (`category_id`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='短剧创作-风格LoRA表';

INSERT INTO crt_lora_style(id, category_id, name, thumb, lora_style_name, lora_style_path, sort) VALUES
    (1, 1, 'Hyatsu梦幻宝石眼睛v2', '', 'hyatsu_gemstone_dream_eyes_v2', '/etc/ComfyUI/custom_nodes/xxx/hyatsu_gemstone_dream_eyes_v2.safetensors', 2),
    (2, 1, '日系漫画风', '', 'japanese_anime_style', '/etc/ComfyUI/custom_nodes/xxx/japanese_anime_style.safetensors', 1)
;