From d4b05c11c07e771bace8c83327e92216748116ca Mon Sep 17 00:00:00 2001 From: 648540858 <456panlinlin> Date: 星期日, 24 四月 2022 16:34:21 +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