From dc6769664e36ffc70ea3af597e4f3dbb93c2b6bf Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期四, 26 五月 2022 12:10:46 +0800 Subject: [PATCH] 兼容不规范的时间格式iso8601格式;升级fastjson版本 --- 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