From 4d975c21da2d10233d82d6047e72b0d82b7da343 Mon Sep 17 00:00:00 2001 From: 648540858 <456panlinlin> Date: 星期二, 19 四月 2022 11:52:03 +0800 Subject: [PATCH] 优化国标级联目录推送,支持zlm新特性ssrc校验 --- 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