| | |
| | | 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 |
| | | ); |
| | |
| | | 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, |
| | |
| | | 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, |