yvjia/db/ai_material_category.sql

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

DROP TABLE IF EXISTS `ai_material_category`;
CREATE TABLE `ai_material_category` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `lora_id` BIGINT COMMENT '素材风格ID',
    `category_name` VARCHAR(255) NOT NULL COMMENT '素材分类名称',
    `is_share` TINYINT DEFAULT '-1' COMMENT '是否共享(-1:不共享, 1:共享)',
    `is_enable_feedback` TINYINT DEFAULT '1' COMMENT '是否显示在反馈表单',
    `sort` INT DEFAULT '1' COMMENT '排序',
    INDEX `idx_category_name` (`category_name`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='素材分类表';

INSERT INTO ai_material_category(lora_id, is_share, category_name, sort) VALUES
    (null, 1, '特效素材', 1),

    (1, -1, '人物素材', 7),
    (1, -1, '场景素材', 6),
    (1, -1, '异兽素材', 5),
    (1, -1, '道具素材', 3),

    (2, -1,  '人物素材', 7),
    (2, -1,  '场景素材', 6),
    (2, -1,  '异兽素材', 5),
    (2, -1,  '道具素材', 4),

    (1, -1, '表情素材', 2),
    (2, -1,  '表情素材', 3),

    (3, -1, '国漫', 10),
    (3, -1, '日漫', 9),
    (3, -1, '美漫', 8),
    (3, -1, '韩漫', 7),

    (4, -1, 'CG渲染', 10),
    (4, -1, '国漫', 9),
    (4, -1, 'Q版', 8)
;