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 NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `name` VARCHAR(50) NOT NULL COMMENT '风格名称',
    `lora_style_name` VARCHAR(255) NOT NULL COMMENT '风格LoRA名称',
    `lora_style_path` VARCHAR(500) NOT NULL COMMENT '风格LoRA路径'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='短剧创作-风格LoRA表';

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