From ec8ab540f8af6dca862d3ec9967e9042fa7dd8eb Mon Sep 17 00:00:00 2001 From: hotcoffie <35990065+hotcoffie@users.noreply.github.com> Date: 星期六, 07 五月 2022 17:42:31 +0800 Subject: [PATCH] Merge branch '648540858: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