yvjia/db/ai_material_tag.sql

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

DROP TABLE IF EXISTS `ai_material_tag`;
CREATE TABLE `ai_material_tag` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `category_id` BIGINT NOT NULL COMMENT '素材分类ID',
    `tag_name` VARCHAR(255) NOT NULL COMMENT '素材标签名称',
    `sort` INT DEFAULT '1' COMMENT '排序',
    INDEX `idx_tag_name` (`tag_name`),
    INDEX `idx_category_id` (`category_id`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='素材标签表';

INSERT INTO ai_material_tag(category_id, tag_name, sort) VALUES
    # 1.人物素材
    (1, '都市人物', 10),
    (1, '历史人物', 9),
    (1, '修仙人物', 8),
    (1, '灵异人物', 7),
    (1, '主题人物', 6),
    (1, '火影人物', 5),
    (1, '海贼人物', 4),
    (1, '兽世人物', 3),
    (1, '精选人物', 2),
    (1, 'Q版人物', 1),
    # 2.场景素材
    (2, '都市场景', 7),
    (2, '修仙古风', 6),
    (2, '主题场景', 5),
    (2, '通用场景', 4),
    (2, '末日悬疑', 3),
    (2, '兽世古代', 2),
    (2, '星际宇宙', 1),
    # 3.表情素材
    (3, '身体部件', 2),
    (3, '人物表情', 1),
    # 4.兽类素材
    (4, '异兽素材', 2),
    (4, '动物素材', 1),
    # 5.道具素材
    (5, '通用道具', 3),
    (5, '交通工具', 2),
    (5, '武器装备', 1),
    # 6.特效素材
    (6, '特效素材', 1),
    # 7.AI素材
    (7, 'AI素材', 1)
;