From 4bda14b098bc943324c73a8365c8bcd721beaa5a Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期四, 08 九月 2022 15:27:47 +0800 Subject: [PATCH] 修复cseq序号回退 --- sql/update.sql | 30 ------------------------------ 1 files changed, 0 insertions(+), 30 deletions(-) diff --git a/sql/update.sql b/sql/update.sql index 14d98c2..e69de29 100644 --- a/sql/update.sql +++ b/sql/update.sql @@ -1,30 +0,0 @@ -alter table stream_push - add serverId varchar(50) not null; -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; - - -alter table device_mobile_position change cnLng longitudeGcj02 double default null; -alter table device_mobile_position change cnLat latitudeGcj02 double default null; -alter table device_mobile_position - add longitudeWgs84 double default null; -alter table device_mobile_position - add latitudeWgs84 double default null; -alter table device_mobile_position drop geodeticSystem; - - - -- Gitblit v1.8.0