yvjia/db/crt_model.sql

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

DROP TABLE IF EXISTS `crt_model`;
CREATE TABLE `crt_model` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `name` VARCHAR(50) NOT NULL COMMENT '名称',
    `model_name` VARCHAR(255) NOT NULL COMMENT '模型名称',
    `model_path` VARCHAR(255) NOT NULL COMMENT '模型路径'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='短剧创作-风格LoRA表';

INSERT INTO crt_model(id, name, model_name, model_path) VALUES
    (1, 'F.1-dev.safetensors', 'FLUX1/flux1-dev-fp8.safetensors', '/etc/ComfyUI/custom_nodes/xxx/F.1-dev.safetensors')
;