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 NOT NULL COMMENT '素材风格ID',
    `category_name` VARCHAR(255) NOT NULL 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, category_name, sort) VALUES
    (1, '人物素材', 7),
    (1, '场景素材', 6),
    (1, '表情素材', 5),
    (1, '兽类素材', 4),
    (1, '道具素材', 3),
    (1, '特效素材', 2),
    (1, 'AI素材', 1),

    (2, '人物素材', 7),
    (2, '场景素材', 6),
    (2, '表情素材', 5)
;