From a47761ab730e6219bd8caedb11249b9a1554e07a Mon Sep 17 00:00:00 2001
From: LiJun <LiJun@192.168.10.30>
Date: 星期五, 16 十一月 2018 15:05:55 +0800
Subject: [PATCH] 添加电池参数表
---
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 46 ++++++++++++++++++++++++++++++----------------
1 files changed, 30 insertions(+), 16 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
index f7685b5..493a1bd 100644
--- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
+++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -77,7 +77,11 @@
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 FBS9100SysParam_Table = DB_RamDB + ".`tb_fbs9100_sysparam`"; //系统参数表
+
+ public final static String BTSGPRSState_Table = DB_RamDB + ".`tb_bts_gprs_state`"; //gprs 信息表
+
+ public final static String FBS9100BattParam_Table = DB_RamDB + ".`tb_fbs9100_battparam`"; //电池组参数表
//--------------------------------------------------------------------------------------------//
//--------------------------------------------------------------------------------------------//
public final static String AppSys_Table = DB_AppSys + ".`tb_app_sys`";
@@ -244,21 +248,31 @@
+ "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;";
+ " `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'," +
+ " `uname` varchar(64) NOT NULL DEFAULT ''," +
+ " `error_en` int(11) NOT NULL DEFAULT '0'," +
+ " `error_dispose` longtext NOT NULL," +
+ " `note` varchar(64) NOT NULL DEFAULT ''," +
+ " `picture_one` longblob," +
+ " `picture_two` longblob," +
+ " `picture_three` longblob," +
+ " `picture_four` longblob," +
+ " `picture_num` int(11) NOT NULL DEFAULT '0'," +
+ " `solve_picture_one` longblob," +
+ " `solve_picture_two` longblob," +
+ " `solve_picture_three` longblob," +
+ " `solve_picture_four` longblob," +
+ " `solve_picture_num` int(11) NOT NULL DEFAULT '0'," +
+ " `solve_uid` int(11) NOT NULL DEFAULT '1002'," +
+ " `solve_uname` varchar(64) NOT NULL DEFAULT ''," +
+ " `solve_record_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00'," +
+ " PRIMARY KEY (`num`)," +
+ " KEY `stationid_index` (`stationid`)" +
+ ") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
String table_3 = "CREATE TABLE IF NOT EXISTS " + BattMainInf_Table
+ " ( `num` BIGINT NOT NULL AUTO_INCREMENT, "
--
Gitblit v1.9.1