From b57bfd9d4d1ab6e2de15eff090f6efdbe49c65ce Mon Sep 17 00:00:00 2001
From: LiJun <LiJun@192.168.10.18>
Date: 星期五, 02 十一月 2018 17:07:35 +0800
Subject: [PATCH] 修改底层建表程序建表语句
---
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 24 ++++++++++++++++++++++++
1 files changed, 24 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 3c865dd..f7685b5 100644
--- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
+++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -76,6 +76,8 @@
public final static String RamDB_CMCC_POWER_Data = DB_RamDB + ".`cmcc_power_data`";
public final static String BTSStationState_Table = DB_RamDB + ".`tb_bts_station_state`"; //机房状态表
+
+ public final static String FBS9100SysParam_Table = DB_RamDB + ".`tb_fbs9100_sysparam`"; //
//--------------------------------------------------------------------------------------------//
//--------------------------------------------------------------------------------------------//
public final static String AppSys_Table = DB_AppSys + ".`tb_app_sys`";
@@ -84,6 +86,8 @@
public final static String BattCurrInf_Table = DB_BATT_INF + ".`tb_battcurr_inf`";
public final static String BattMainInf_Table = DB_BATT_INF + ".`tb_batt_maint_inf`";
public final static String BattMainProcess_Table = DB_BATT_INF + ".`tb_batt_maint_process`";
+
+ public final static String DEVERRORRECORD_Table = DB_BATT_INF + ".`tb_deverror_record`"; //设备异常记录表
public final static String BattTestDataInf_Table = DB_BATT_TESTDATA + ".`tb_batttestdata_inf`";
@@ -239,6 +243,23 @@
+ "PRIMARY KEY (`num`)) "
+ "ENGINE=InnoDB DEFAULT CHARSET=utf8;";
+ String table_2_1 = "CREATE TABLE IF NOT EXISTS "+DEVERRORRECORD_Table+" (" +
+ " `num` int(11) NOT NULL AUTO_INCREMENT," +
+ " `stationid` varchar(64) NOT NULL DEFAULT '42000001'," +
+ " `record_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00'," +
+ " `error_descript` longtext NOT NULL," +
+ " `uid` int(11) NOT NULL DEFAULT '1002'," +
+ " `error_en` int(11) NOT NULL DEFAULT '0'," +
+ " `note` varchar(64) NOT NULL DEFAULT ''," +
+ " `picture_one` blob," +
+ " `picture_two` blob," +
+ " `picture_three` blob," +
+ " `picture_four` blob," +
+ " `picture_num` int(11) NOT NULL DEFAULT '0'," +
+ " PRIMARY KEY (`num`)," +
+ " KEY `stationid_index` (`stationid`)" +
+ ") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;";
+
String table_3 = "CREATE TABLE IF NOT EXISTS " + BattMainInf_Table
+ " ( `num` BIGINT NOT NULL AUTO_INCREMENT, "
+ "`BattGroupId` INT NOT NULL DEFAULT 0, "
@@ -279,6 +300,8 @@
+ "INDEX index_batt_maint_rec_id (`batt_maint_rec_id`), "
+ " PRIMARY KEY (`num`)) "
+ "ENGINE=InnoDB DEFAULT CHARSET=utf8;";
+
+
String table_3_2 = "CREATE TABLE IF NOT EXISTS " + UsrBattMaintCheck_Table
+ " ( `num` BIGINT NOT NULL AUTO_INCREMENT, "
@@ -464,6 +487,7 @@
sqlMysqlExecute(table_1);
sqlMysqlExecute(table_2);
+ sqlMysqlExecute(table_2_1);
sqlMysqlExecute(table_3);
sqlMysqlExecute(table_3_1);
sqlMysqlExecute(table_3_2);
--
Gitblit v1.9.1