From 0ad8a11d8df047f8c7186d7e776b1bdae5ad1ba1 Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期三, 18 五月 2022 10:44:39 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/wvp-28181-2.0' into wvp-28181-2.0 --- sql/update.sql | 15 ++++++++++----- 1 files changed, 10 insertions(+), 5 deletions(-) diff --git a/sql/update.sql b/sql/update.sql index 2a16265..9c18c26 100644 --- a/sql/update.sql +++ b/sql/update.sql @@ -1,7 +1,12 @@ -ALTER TABLE stream_proxy ADD status bit(1) not null; +alter table parent_platform + add startOfflinePush int default 0 null; -# 鍘婚櫎瀛愭煡璇紭鍖栨煡璇㈤�熷害 -alter table device_channel - add subCount int default 0 null; +alter table parent_platform + add administrativeDivision varchar(50) not null; -update device_channel dc set dc.subCount = (select te.count from (SELECT count(0) as count FROM device_channel WHERE parentId = dc.channelId) te) \ No newline at end of file +alter table parent_platform + add catalogGroup int default 1 null; + +alter table device + add ssrcCheck int default 0 null; + -- Gitblit v1.8.0