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