/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `ai_ivh_make_virtualman_task`;

CREATE TABLE `ai_ivh_make_virtualman_task` (
   PRIMARY KEY (`id`),
   `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
   `user_id` BIGINT COMMENT '用户ID',
   `request_id` VARCHAR(255) ,
   `task_id` VARCHAR(255) COMMENT '任务ID',
   `quota_code` VARCHAR(255) COMMENT '配额编码',

   `anchor_name` VARCHAR(255) NOT NULL COMMENT '主播名称',
   `anchor_name_view` VARCHAR(255) NOT NULL COMMENT '主播名称 (展示)',

   `make_type` VARCHAR(255) NOT NULL COMMENT '定制类别 (IMAGE：2D小样本-标准版(专属口型), IMAGE_GENERAL：2D小样本-标准版(通用口型), IMAGE_4K：2D小样本-高精版(专属口型), VOICE：2D小样本声音, IMAGE_PHOTO：2D小样本(照片数智人))',
   `identity_cos_url` VARCHAR(1000) COMMENT '视频格式授权书',
   `identity_written_cos_url` VARCHAR(1000) COMMENT 'PDF格式授权书',
   `material_cos_url` VARCHAR(1000) NOT NULL COMMENT '形象定制素材',
   `is_remove_background` TINYINT(1) DEFAULT '-1' COMMENT '形象定制是否带原始背景 (-1否, 1是)',
   `sex_type` VARCHAR(10) NOT NULL COMMENT '性别 (MALE：男, FEMALE：女)',
   `notes` VARCHAR(255) COMMENT '定制备注信息',
   `text_driver` VARCHAR(1000) COMMENT '用于生成驱动demo的文本内容',
   `voice_driver_cos_file` VARCHAR(1000) COMMENT '生成驱动 demo 的音频文件路径',

   `task_status` VARCHAR(10) COMMENT '任务制作状态 (AUDIT：审核中，MAKING：进行中, SUCCESS：制作成功, FAIL：制作失败)',
   `task_status_info` TEXT COMMENT '任务制作状态信息 (仅 FAIL 有值)',

   `stage_status` VARCHAR(10) COMMENT '任务阶段状态，当 Status：MAKING 时 (SUBMIT：素材提交, AUDIT：人工审核, PROCESS：预处理 (仅形象定制有), TRAIN：智能训练, CONFIRM：效果确认 (照片定制无此阶段), END：完成)',
   `stage_status_info` VARCHAR(1000) COMMENT '任务阶段状态信息 (仅 CONFIRM 有值) ({\"TrainResult\": .. )',

   `confirm_status` VARCHAR(10) COMMENT '确认效果状态 (AGREE：认同, REJECT：驳回)',
   `confirm_status_info` VARCHAR(1000) COMMENT '确认效果状态信息 (仅 REJECT 有值)',

   `result` TEXT COMMENT '供客户进行效果确认的 Demo 视频 url 地址',

   `tencent_order_code` VARCHAR(255) COMMENT '腾讯订单号',
   `launch_note` VARCHAR(255) COMMENT '发起任务备注',

   `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
   UNIQUE KEY `anchor_name_UNIQUE` (`anchor_name`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='AI数智人-定制主播/音色任务表';

INSERT INTO ai_ivh_make_virtualman_task(user_id, request_id, task_id, quota_code, anchor_name, anchor_name_view, make_type, identity_written_cos_url, material_cos_url, sex_type, task_status, stage_status, result) VALUES
    (1, 'gz6c6d3da317114350091232332', '884_9323_w', '', 'zx_voice', 'zx_voice', 'VOICE', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/baa2bbb3-5787-4aee-859e-5a919560fd2f/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/baa2bbb3-5787-4aee-859e-5a919560fd2f/audio/b.zip', 'MALE', 'CONFIRM', 'TRAIN', ''),
    (1, 'gz6c6d3da317114350091232332', '884_9322_w', '', 'V1_20240326143648', 'V1', 'VOICE', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/baa2bbb3-5787-4aee-859e-5a919560fd2f/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/baa2bbb3-5787-4aee-859e-5a919560fd2f/audio/b.zip', 'MALE', 'CONFIRM', 'TRAIN', ''),
    (1, 'gz6c6d3da317109289315211855', '908_9048_w', '', 'jiayang', 'jiayang', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', '', 'MALE', 'CONFIRM', 'TRAIN', '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}'),
    (1, 'gz6c6d3da317109289315211855', '908_9045_w', '', 'paul', 'paul', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', '', 'MALE', 'CONFIRM', 'TRAIN', '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}'),
    (1, 'gz6c6d3da317109289315211854', '908_9044_w', '', '测试_20240323174545', '测试', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/908/384a5636-2447-4b7c-975f-60fcb45983f0/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/908/4954b43f-c2e2-4a79-848e-5f962f2d704d/video/c.mp4', 'MALE', 'SUCCESS', 'SUBMIT', ''),
    (1, 'bjedbe7bc817110073485381157', '908_9097_w', '', '李四_20240323174545', '李四', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/908/c051489b-2a0e-4ca7-8680-9043aadb0882/idcard/%E4%B9%A6%E9%9D%A2%E7%89%88-%E5%AE%9A%E5%88%B6%E6%95%B0%E5%AD%97%E4%BA%BA%E5%BD%A2%E8%B1%A1%E6%8E%88%E6%9D%83%E4%B9%A6V1.0.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/908/c051489b-2a0e-4ca7-8680-9043aadb0882/video/%E8%AE%AD%E7%BB%83%E7%B4%A0%E6%9D%90.mp4', 'FEMALE', 'MAKING', 'SUBMIT', ''),
    (1, '2656dfa2-ab8b-476e-96aa-1002e92754d3', '', '616fd7ea-39af-4ee8-8a52-0623ee1a43f0', '张三-测试_20240323174545', '张三-测试', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/a7808222-9b34-42af-a419-46e970d177eb/video/c.mp4', 'FEMALE', 'MAKING', 'SUBMIT', ''),
    (1, '7d7ba035-ab89-4a43-80cb-87e2f93fd333', '', 'bf49c596-195b-4685-bfce-732afb151f64', '陈嘉阳-测试_20240323174541', '陈嘉阳-测试', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.ap-nanjing.myqcloud.com/customer-pipeline/884/276b9647-c7bc-475b-8b7d-634be9d6b98d/video/训练素材.mp4', 'MALE', 'SUCCESS', 'TRAIN', '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}'),
    (16, '7d7ba035-ab89-4a43-80cb-87e2f93fd333', '', 'bf49c596-195b-4685-bfce-732afb151f64', '陈嘉阳-测试_20240323174542', '陈嘉阳-测试', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.ap-nanjing.myqcloud.com/customer-pipeline/884/276b9647-c7bc-475b-8b7d-634be9d6b98d/video/训练素材.mp4', 'MALE', 'SUCCESS', 'TRAIN', '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}'),
    (15, '7d7ba035-ab89-4a43-80cb-87e2f93fd333', '', 'bf49c596-195b-4685-bfce-732afb151f64', '陈嘉阳-测试_20240323174543', '陈嘉阳-测试', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.ap-nanjing.myqcloud.com/customer-pipeline/884/276b9647-c7bc-475b-8b7d-634be9d6b98d/video/训练素材.mp4', 'MALE', 'SUCCESS', 'TRAIN', '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}'),
    (14, '7d7ba035-ab89-4a43-80cb-87e2f93fd333', '', 'bf49c596-195b-4685-bfce-732afb151f64', '陈嘉阳-测试_20240323174544', '陈嘉阳-测试', 'IMAGE_GENERAL', 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', 'https://virtualhuman-cos-prod-1251316161.cos.ap-nanjing.myqcloud.com/customer-pipeline/884/276b9647-c7bc-475b-8b7d-634be9d6b98d/video/训练素材.mp4', 'MALE', 'SUCCESS', 'TRAIN', '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}')
;

# 实际可用数智人备份：
# INSERT INTO `backendsys`.`ai_ivh_make_virtualman_task` (`id`, `user_id`, `request_id`, `task_id`, `quota_code`, `anchor_name`, `anchor_name_view`, `make_type`, `identity_cos_url`, `identity_written_cos_url`, `material_cos_url`, `is_remove_background`, `sex_type`, `notes`, `text_driver`, `voice_driver_cos_file`, `task_status`, `task_status_info`, `stage_status`, `stage_status_info`, `confirm_status`, `confirm_status_info`, `result`, `create_time`, `update_time`) VALUES (4, 1, 'gz6c6d3da317109289315211855', '908_9045_w', '', 'paul', 'paul', 'IMAGE_GENERAL', NULL, 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', '', -1, 'MALE', NULL, NULL, NULL, 'CONFIRM', NULL, 'TRAIN', NULL, NULL, NULL, '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}', '2024-04-22 15:05:09', '2024-04-22 15:05:09');
# INSERT INTO `backendsys`.`ai_ivh_make_virtualman_task` (`id`, `user_id`, `request_id`, `task_id`, `quota_code`, `anchor_name`, `anchor_name_view`, `make_type`, `identity_cos_url`, `identity_written_cos_url`, `material_cos_url`, `is_remove_background`, `sex_type`, `notes`, `text_driver`, `voice_driver_cos_file`, `task_status`, `task_status_info`, `stage_status`, `stage_status_info`, `confirm_status`, `confirm_status_info`, `result`, `create_time`, `update_time`) VALUES (3, 1, 'gz6c6d3da317109289315211855', '908_9048_w', '', 'jiayang', 'jiayang', 'IMAGE_GENERAL', NULL, 'https://virtualhuman-cos-prod-1251316161.cos.accelerate.myqcloud.com/customer-pipeline/884/e648e622-cf40-4e4e-a16d-a8f0d0ffba2a/idcard/b.pdf', '', -1, 'MALE', NULL, NULL, NULL, 'CONFIRM', NULL, 'TRAIN', NULL, NULL, NULL, '{\"TrainResult\":[\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/f67aaf5c1b514c4ab577aae114d779f0.mp4\",\"https://videomaker-resources.ivh.qq.com/broadcast/Basic/video/7deeddc648c94d189c3ba1bcb02cf9ae.mp4\"]}', '2024-04-22 15:05:09', '2024-04-22 15:05:09');