From 7c6470fbf96f290a3788b2c7ea891e9b6ab8d6f7 Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期三, 03 十一月 2021 16:10:45 +0800
Subject: [PATCH] 优化设备列表显示效果

---
 sql/mysql.sql |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)

diff --git a/sql/mysql.sql b/sql/mysql.sql
index dba42c1..4501257 100644
--- a/sql/mysql.sql
+++ b/sql/mysql.sql
@@ -66,6 +66,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 +93,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