From 8f77d0c25cdd37d4cc96c923b46ae28607bae51d Mon Sep 17 00:00:00 2001 From: jiang <893224616@qq.com> Date: 星期四, 18 八月 2022 16:17:23 +0800 Subject: [PATCH] 根据redis消息更新推流列表 --- sql/update.sql | 20 ++++++++++++++++++++ 1 files changed, 20 insertions(+), 0 deletions(-) diff --git a/sql/update.sql b/sql/update.sql index b575f0f..d61ad35 100644 --- a/sql/update.sql +++ b/sql/update.sql @@ -52,13 +52,33 @@ alter table stream_push add pushTime varchar(50) default null; alter table stream_push + add status int DEFAULT NULL; +alter table stream_push add updateTime varchar(50) default null; +alter table stream_push + add pushIng int DEFAULT NULL; alter table stream_push change createStamp createTime varchar(50) default null; +alter table gb_stream + drop column status; alter table user add pushKey varchar(50) default null; +update user set pushKey='453df297a57a5a7438934sda801fc3' where id=1; +alter table parent_platform + add treeType varchar(50) not null; +update parent_platform set parent_platform.treeType='BusinessGroup'; +alter table parent_platform drop shareAllLiveStream; + +alter table platform_catalog + add civilCode varchar(50) default null; +alter table platform_catalog + add businessGroupId varchar(50) default null; + +/********************* ADD ***************************/ +alter table stream_push + add self int DEFAULT NULL; -- Gitblit v1.8.0