/**
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:共享)',
    `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),
    (1, -1, '表情素材', 2),

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

