From 44b250eed29fab7959d18015c27b96da3e4beb47 Mon Sep 17 00:00:00 2001 From: lin <lin@pop-os.localdomain> Date: 星期三, 01 二月 2023 09:32:52 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/wvp-28181-2.0' into wvp-28181-2.0 --- sql/update.sql | 65 +------------------------------- 1 files changed, 2 insertions(+), 63 deletions(-) diff --git a/sql/update.sql b/sql/update.sql index b575f0f..2e5d569 100644 --- a/sql/update.sql +++ b/sql/update.sql @@ -1,64 +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; -alter table device_channel - add gpsTime 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; -alter table device_mobile_position - add createTime varchar(50) default null; - -alter table device_alarm - add createTime varchar(50) default null; - -alter table gb_stream - change createStamp createTime varchar(50) default null; - -alter table parent_platform - add createTime varchar(50) default null; -alter table parent_platform - add updateTime varchar(50) default null; - -alter table stream_proxy - add updateTime varchar(50) default null; - -alter table stream_push - add pushTime varchar(50) default null; -alter table stream_push - add updateTime varchar(50) default null; -alter table stream_push - change createStamp createTime varchar(50) default null; - - -alter table user - add pushKey varchar(50) default null; - - - + add keepaliveIntervalTime int default null; \ No newline at end of file -- Gitblit v1.8.0