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

DROP TABLE IF EXISTS `ai_ivh_timbre`;

CREATE TABLE `ai_ivh_timbre` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',

    `user_id` BIGINT NOT NULL COMMENT '用户ID',
    `timbre_name` VARCHAR(255) NOT NULL COMMENT '音色名称',
    `timbre_name_view` VARCHAR(255) NOT NULL COMMENT '音色名称 (展示)',
    `stage_status` VARCHAR(10) DEFAULT 'SUBMIT' COMMENT '任务阶段状态，当 Status：MAKING 时 (SUBMIT：素材提交, AUDIT：人工审核, PROCESS：预处理 (仅形象定制有), TRAIN：智能训练, CONFIRM：效果确认 (照片定制无此阶段), END：完成)',

    `timbre_key` VARCHAR(255) COMMENT '音色Key',
    `timbre_sample` VARCHAR(255) 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(user_id, timbre_name, timbre_name_view, stage_status, timbre_key, timbre_sample, timbre_gender, expire_date) VALUES
  (1, 'zx_voice', 'zx_voice', 'CONFIRM', 'timbre_10564', 'https://vhalign-1251316161.cos.ap-guangzhou.myqcloud.com/ttsdemo/prod/884/10564/884_10564_125839.wav', 1, '2025-03-27 16:43:24')
;