From c23932eb00edfa5f734b0d17eced838c5c7577c0 Mon Sep 17 00:00:00 2001 From: 648540858 <456PANlinlin> Date: 星期三, 17 十一月 2021 22:58:41 +0800 Subject: [PATCH] #221 --- sql/mysql.sql | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/sql/mysql.sql b/sql/mysql.sql index dba42c1..cd5bbea 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -23,6 +23,7 @@ updateTime varchar(50) not null, port int not null, expires int not null, + subscribeCycleForCatalog int not null, hostAddress varchar(50) not null, charset varchar(50) not null ); @@ -66,6 +67,7 @@ id int auto_increment primary key, deviceId varchar(50) not null, + channelId varchar(50) not null, alarmPriority varchar(50) not null, alarmMethod varchar(50), alarmTime varchar(50) not null, @@ -92,6 +94,7 @@ create table device_mobile_position ( deviceId varchar(50) not null, + channelId varchar(50) not null, deviceName varchar(255) null, time varchar(50) not null, longitude double not null, -- Gitblit v1.8.0