From c19ad94c3ec45245914a7682174db5fb650ee08e Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期日, 15 一月 2023 15:27:47 +0800 Subject: [PATCH] 优化目录更新，更新失败时只更新收到的内容不重置所有通道和自动拉流 --- sql/update.sql | 22 ++-------------------- 1 files changed, 2 insertions(+), 20 deletions(-) diff --git a/sql/update.sql b/sql/update.sql index 0ab8d29..2e5d569 100644 --- a/sql/update.sql +++ b/sql/update.sql @@ -1,21 +1,3 @@ -alter table stream_push - add serverId varchar(50) not null; +-- 2.6.6->2.6.7 alter table device - add geoCoordSys varchar(50) not null; -alter table device - add treeType varchar(50) not null; -update device set device.geoCoordSys='WGS84'; -update device set device.treeType='CivilCode'; -alter table device_channel - add longitudeGcj02 double default null; -alter table device_channel - add latitudeGcj02 double default null; -alter table device_channel - add longitudeWgs84 double default null; -alter table device_channel - add latitudeWgs84 double default null; -alter table device_channel - add businessGroupId varchar(50) default null; - - - + add keepaliveIntervalTime int default null; \ No newline at end of file -- Gitblit v1.8.0