From 9348f97afb69f6c65e8b456ae6ac585bf9789477 Mon Sep 17 00:00:00 2001
From: LiJun <LiJun@192.168.10.10>
Date: 星期四, 18 十月 2018 13:31:00 +0800
Subject: [PATCH] 机房状态表中添加续航列以及创建机房状态历史记录表
---
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
index e39ded0..5c30f65 100644
--- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
+++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -113,6 +113,9 @@
public final static String UserPermitGroupTable = DB_USER + ".`tb_user_permitgroup`";
public final static String UserPermitGroupDataTable = DB_USER + ".`tb_user_permitgroup_data`";
public final static String UserJieJiaRiTable = DB_USER + ".`tb_user_jiejiari`";
+
+
+ public final static String BTSStationEvent_Table = DB_ALARM + ".`tb_bts_station_event`"; //机房状态历史表
//--------------------------------------------------------------------------------------------//
//--------------------------------------------------------------------------------------------//
public Connection mysql_con;
@@ -396,6 +399,23 @@
+ "INDEX index_dev_id (`dev_id`), "
+ "PRIMARY KEY (`num`)) "
+ "ENGINE=InnoDB DEFAULT CHARSET=utf8;";
+
+
+
+
+ String table_9 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.BTSStationEvent_Table
+ + " ( `num` BIGINT NOT NULL AUTO_INCREMENT, "
+ + "`station_id` BIGINT NOT NULL DEFAULT 0, "
+ + "`dev_id` BIGINT NOT NULL DEFAULT 0, "
+ + "`record_datetime` varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00', "
+
+ + "`station_event_type` INT NOT NULL DEFAULT 0, "
+ + "`station_event_trig` INT NOT NULL DEFAULT 0, "
+
+ + " INDEX index_dev_id (`dev_id`), "
+ + " INDEX index_station_id (`station_id`), "
+ + " PRIMARY KEY (`num`) ) "
+ + " ENGINE=InnoDB DEFAULT CHARSET=utf8";
//-------------------------------------------------------------------------------------//
//-------------------------------------------------------------------------------------//
sqlMysqlUseDB(Sql_Mysql.DB_AppSys);
@@ -453,6 +473,7 @@
sqlMysqlExecute(table_6);
sqlMysqlExecute(table_7);
sqlMysqlExecute(table_8);
+ sqlMysqlExecute(table_9);
//---------------------------------------------------------------------------------------------//
ResultSet res = sqlMysqlQuery("show index from " + BattInf_Table + " where column_name='BattGroupId'");
--
Gitblit v1.9.1