diff options
| author | doufenghu <[email protected]> | 2018-11-14 14:14:31 +0800 |
|---|---|---|
| committer | doufenghu <[email protected]> | 2018-11-14 14:14:31 +0800 |
| commit | 2e66aeb4a7f4de50de11e238da8c8c08f16bd56d (patch) | |
| tree | 27f7b45ed912f3ff82c7e7c1fb78252dc61159af /db | |
| parent | 413434fcec6669816cd84b706f38d864c44a2379 (diff) | |
fix(sql):增加串联设备局点ip对照表
Diffstat (limited to 'db')
| -rw-r--r-- | db/init/galaxy_data_mysql.sql | 2 | ||||
| -rw-r--r-- | db/init/galaxy_stru_mysql.sql | 13 |
2 files changed, 15 insertions, 0 deletions
diff --git a/db/init/galaxy_data_mysql.sql b/db/init/galaxy_data_mysql.sql index dae855c..3124ac7 100644 --- a/db/init/galaxy_data_mysql.sql +++ b/db/init/galaxy_data_mysql.sql @@ -43,3 +43,5 @@ insert into `sys_role`(`ID`,`NAME`,`DATA_SCOPE`,`REMARK`,`STATUS`,`CREATE_TIME` insert into `sys_user`(`ID`,`photo`,`LOGIN_ID`,`NAME`,`EMAIL`,`IDENTITY`,`PASSWORD`,`CREATE_TIME`,`STATUS`,`COMPANY_ID`,`ENTITY_ID`,`OFFICE_ID`) values (1,'/transit_org/upload/userfiles/1/images/photo/2016/06/20111208121013748.gif','admin','管理员','[email protected]',0,'b51940cbaa371b4b6c4c51ddc9cc9f31d279af47da62973c46b5e7fb','2015-07-08 17:10:29',1,2,2,4),(140,'','test','测试人员','[email protected]',0,'89fd104554c4b1709338d997bd3e867312ef0420d9e8e73c6abe6b54','2016-05-01 12:29:09',1,2,2,12),(143,'','swagger','swagger','[email protected]',0,'70296b1de334d891a619c4b02b259c22e361114c1e31b8ce94936cef','2018-08-08 17:55:51',1,2,2,17); +/*Data for the table `ntc_device_info` */ +INSERT INTO `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) VALUES (1,1,1,'10.4.2.1',NULL),(2,1,2,'10.4.2.2','2018-11-13 13:56:15'),(3,1,3,'10.4.2.3','2018-11-13 13:57:07'),(4,1,4,'10.4.2.4','2018-11-13 13:57:24'),(5,1,5,'10.4.2.9','2018-11-13 13:57:40'),(6,1,6,'10.4.2.10','2018-11-13 13:57:59'),(7,1,7,'10.4.2.11','2018-11-13 13:58:25'),(8,1,8,'10.4.2.12','2018-11-13 13:58:36'),(9,1,9,'10.4.2.13','2018-11-13 13:58:47'),(10,1,10,'10.4.2.14','2018-11-13 13:59:01'),(11,1,11,'10.4.2.15','2018-11-13 13:59:10'),(12,2,1,'10.3.2.1','2018-11-13 14:01:54'),(13,2,2,'10.3.2.2','2018-11-13 14:01:55'),(14,2,3,'10.3.2.3','2018-11-13 14:01:55'),(15,2,4,'10.3.2.4','2018-11-13 14:01:55'),(16,2,5,'10.3.2.5','2018-11-13 14:01:55'),(17,2,6,'10.3.2.6','2018-11-13 14:01:55'),(18,2,7,'10.3.2.7','2018-11-13 14:01:57'),(19,2,8,'10.3.2.8','2018-11-13 14:01:57'),(20,2,9,'10.3.2.9','2018-11-13 14:01:57'),(21,2,10,'10.3.2.10','2018-11-13 14:01:57'),(22,2,11,'10.3.2.11','2018-11-13 14:01:57'),(23,2,12,'10.3.2.12','2018-11-13 14:01:57'),(24,2,13,'10.3.2.13','2018-11-13 14:01:57'),(25,2,14,'10.3.2.14','2018-11-13 14:01:57'),(26,2,15,'10.3.2.15','2018-11-13 14:01:57'),(27,2,16,'10.3.2.16','2018-11-13 14:01:57'),(28,2,17,'10.3.2.17','2018-11-13 14:01:57'); diff --git a/db/init/galaxy_stru_mysql.sql b/db/init/galaxy_stru_mysql.sql index 95e6fd3..e403a81 100644 --- a/db/init/galaxy_stru_mysql.sql +++ b/db/init/galaxy_stru_mysql.sql @@ -26,6 +26,7 @@ DROP TABLE IF EXISTS `ntc_lwhh_report`; DROP TABLE IF EXISTS `ntc_lwhh_stat_daily`; DROP TABLE IF EXISTS `ntc_lwhh_stat_hour`; DROP TABLE IF EXISTS `pz_control_report`; +DROP TABLE IF EXISTS `ntc_device_info`; DROP TABLE IF EXISTS `ntc_pz_report`; DROP TABLE IF EXISTS `ntc_pz_stat_daily`; DROP TABLE IF EXISTS `ntc_pz_stat_hour`; @@ -389,6 +390,18 @@ CREATE TABLE `pz_control_report` ( +/*Table structure for table `ntc_device_info` */ +CREATE TABLE `ntc_device_info` ( + `id` INT(11) NOT NULL AUTO_INCREMENT, + `entrance_id` INT(11) NOT NULL, + `link_id` INT(11) NOT NULL, + `manager_ip` VARCHAR(128) NOT NULL, + `create_time` DATETIME DEFAULT NULL, + PRIMARY KEY (`id`) USING BTREE +) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4; + + + /*Table structure for table `ntc_pz_stat_daily` */ |