16 lines
992 B
SQL
16 lines
992 B
SQL
ALTER TABLE `live_scene_record`
|
||
ADD COLUMN `text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '转写语音文字内容' AFTER `record_type`,
|
||
ADD COLUMN `task_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '语音转写文字任务id' AFTER `text`,
|
||
ADD COLUMN `voice_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '视频转为mp3后的地址' AFTER `task_id`,
|
||
ADD COLUMN `is_txt` smallint(6) NULL DEFAULT 0 COMMENT '是否转写语音文字' AFTER `voice_url`,
|
||
ADD COLUMN `to_txt_status` smallint(6) NULL DEFAULT 0 COMMENT '语音转写文字状态，0：未转；1：转码成功；2：转码中' AFTER `is_txt`;
|
||
|
||
ALTER TABLE `live_scene_live_info`
|
||
DROP COLUMN `text`,
|
||
DROP COLUMN `task_id`,
|
||
DROP COLUMN `voice_url`;
|
||
|
||
ALTER TABLE `live_scene_live_info`
|
||
ADD COLUMN `is_txt` smallint NULL DEFAULT 0 COMMENT '是否转写语音文字' AFTER `is_show`;
|
||
|