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),
    # 2-沙雕素材-场景素材
    (2, '修仙场景', 10),
    (2, '都市场景', 9),
    (2, '历史场景', 8),
    # 3-沙雕素材-异兽素材
    (3, '异兽', 10),
    (3, '动物', 9),
    # 4-沙雕素材-道具素材
    (4, '修仙道具', 10),
    (4, '都市道具', 9),
    (4, '历史道具', 8),
    # 5-沙雕素材-特效参考
    (5, '常用特效', 10),
    (5, '普通特效', 9),
    (5, '战斗特效', 8),
    (5, '阵法特效', 7),
    (5, '全屏特效', 6),

    # 6-简笔画素材-人物素材
    (6, '精品人物', 10),
    (6, '修仙人物', 9),
    (6, '都市人物', 8),
    (6, '历史人物', 7),
    (6, '末日悬疑人物', 6),
    # 7-简笔画素材-场景素材
    (7, '修仙场景', 10),
    (7, '都市场景', 9),
    (7, '历史场景', 8),
    (7, '8090场景', 7),
    (7, '末日悬疑场景', 6),
    # 8-简笔画素材-异兽素材
    (8, '异兽', 10),
    (8, '动物', 9),
    # 9-简笔画素材-道具素材
    (9, '修仙道具', 10),
    (9, '都市道具', 9),
    (9, '历史道具', 8),
    # 10-简笔画素材-特效参考
    (10, '常用特效', 10),
    (10, '普通特效', 9),
    (10, '战斗特效', 8),
    (10, '阵法特效', 7),
    (10, '全屏特效', 6)
;