yvjia/db/ai_material_lora.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2025/07/28 15:57:12
*/

DROP TABLE IF EXISTS `ai_material_lora`;
CREATE TABLE `ai_material_lora` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `lora_name` VARCHAR(255) NOT NULL COMMENT '素材风格名称',
    `is_enable_feedback` TINYINT DEFAULT '1' COMMENT '是否显示在反馈表单',
    `sort` INT DEFAULT '1' COMMENT '排序',
    INDEX `idx_lora_name` (`lora_name`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='素材风格表';

INSERT INTO ai_material_lora(lora_name, sort) VALUES
    ('精品主角团', 10),
    ('简笔画素材', 9),
    ('2D动漫', 8),
    ('3D动漫', 7)
;