From 7feacb4ed70cfa0055a85918ed96cbfd59f9785d Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期四, 24 一月 2019 16:04:47 +0800
Subject: [PATCH] 程序运行时初始化表中数据
---
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 37 ++++++++-----------------------------
1 files changed, 8 insertions(+), 29 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
index 4c5af07..2dca13d 100644
--- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
+++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -91,7 +91,6 @@
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`";
@@ -137,8 +136,15 @@
public final static String CustomPage_Table = WEB_Site + ".`tb_custompage`"; //导航数据表
public final static String Announce_Table = WEB_Site + ".`tb_announce`"; //公告表
public final static String BattAttention_Table = WEB_Site + ".`tb_batt_attention`"; //创建电池组单体关注表
- public final static String BattpowerOff_Table = WEB_Site + ".`tb_battpower_off`"; //机房停电表
+ public final static String BattpowerOff_Table = WEB_Site + ".`tb_battpower_off`"; //机房停电表
+
+ /***************************** db_battinf数据库 ***************************************/
+ public final static String DeverrorRecord_Table = DB_BATT_INF + ".`tb_deverror_record`"; //机房问题记录表
+ public final static String BattinfApply_TABLE = DB_BATT_INF + ".`tb_battinf_apply`"; //机房安装审批表
+ public final static String BattinfEx_TABLE = DB_BATT_INF + ".`tb_battinf_ex`"; //基站信息表
+ public final static String BattinfRebuild_TABLE = DB_BATT_INF + ".`tb_battinf_rebuild`"; //机房配组表
+ public final static String BattmonTestcap_TABLE = DB_BATT_INF + ".`tb_battmon_testcap`"; //机房标准测试曲线记录表
//--------------------------------------------------------------------------------------------//
//--------------------------------------------------------------------------------------------//
@@ -264,32 +270,6 @@
+ "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'," +
- " `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, "
@@ -541,7 +521,6 @@
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