yvjia/db/crt_lora_figure.sql

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

DROP TABLE IF EXISTS `crt_lora_figure`;
CREATE TABLE `crt_lora_figure` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `name` VARCHAR(255) NOT NULL COMMENT '人物名称',
    `lora_figure_name` VARCHAR(255) NOT NULL COMMENT '人物LoRA名称',
    `lora_figure_path` VARCHAR(500) NOT NULL COMMENT '人物LoRA路径'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='短剧创作-人物LoRA表';

INSERT INTO crt_lora_figure(id, name, lora_figure_name, lora_figure_path) VALUES
    (1, '柳王妃', 'liuwangfei-0012', '/etc/ComfyUI/custom_nodes/xxx/liuwangfei-0012.safetensors'),
    (2, '陆司明', 'lusiming-0001', '/etc/ComfyUI/custom_nodes/xxx/lusiming-0001.safetensors')
;