yvjia/db/ai_ivh_timbre_public.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2024/03/25 14:48:02
*/

DROP TABLE IF EXISTS `ai_ivh_timbre_public`;
CREATE TABLE `ai_ivh_timbre_public` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',

    `timbre_key` VARCHAR(255) NOT NULL COMMENT '音色Key',
    `timbre_name` VARCHAR(255) NOT NULL COMMENT '音色名称',
    `timbre_sample` VARCHAR(255) NOT NULL COMMENT '音色示例',
    `timbre_desc` VARCHAR(255) COMMENT '音色描述',
    `timbre_gender` TINYINT(1) COMMENT '音色性别 (1男, 2女)',
    `emotional_categories` VARCHAR(255) COMMENT '情感风格',
    `expire_date` VARCHAR(255) COMMENT '过期时间',

    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='AI数智人-公共音色表';

# INSERT INTO ai_ivh_timbre_public(user_id, anchor_name, anchor_code, header_image, tag, timbre_type, timbre_type_code) VALUES
#   (null, '静儿-黑色连衣裙-坐姿-高脚凳', 'custome_None_1794', 'https://virtualhuman-cos-test-1251316161.cos.ap-nanjing.myqcloud.com/prod/resource-manager/small/284/1794/4991/model_14063_20231226102407/header.png', 'Basic', '2D小样本（专属）', 'small_sample_2d')
# ;