| BattMonitor_DB_Builder/bin/com/database_util/DB_battinf.class | 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
BattMonitor_DB_Builder/bin/com/database_util/DB_battinf.classBinary files differ
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt
@@ -1,6 +1,14 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V1.93 edit at date 2024-01-13 1.数据库'db_battinf.tb_battinf'新增字段 `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]' 2.数据库'db_battinf.tb_battinf_update_record'新增字段 `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]' V1.92 edit at date 2024-01-10 1.新增数据库'db_pwrdev_data_rt.tb_pwrdev_rt_info' CREATE TABLE `tb_pwrdev_rt_info` ( BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -793,15 +793,34 @@ " PRIMARY KEY (`num`)" + ") ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;"; Sql_Mysql sql = new Sql_Mysql(pool.getConn()); ResultSet res = null; try { if(true == recreate) { //sql.sqlMysqlExecute(sql_str01); } sql.sqlMysqlExecute(sql_str02); res = null; //添加sign_type ---- 验签格式0-常规 1-正常1拖2[61850设备有效] res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_battinf'" + " AND table_name='tb_battinf_update_record'" + " AND column_name='sign_type'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Battinf_Update_Record_Table + " ADD COLUMN `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]';"); } } catch (SQLException e) { e.printStackTrace(); } finally { if(null != res) { try { res.close(); } catch (SQLException e) { e.printStackTrace(); } } sql.close_con(); } } @@ -1434,6 +1453,16 @@ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table + " ADD COLUMN `StationType` varchar(255) DEFAULT NULL COMMENT '站点类型[例如110V/22V]';"); } res = null; //添加sign_type ---- 验签格式0-常规 1-正常1拖2[61850设备有效] res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_battinf'" + " AND table_name='tb_battinf'" + " AND column_name='sign_type'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table + " ADD COLUMN `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]';"); }
@@ -80,7 +80,7 @@ //--------------------------------------------------------------------------------------------// public final static String AppSys_Table = DB_AppSys + ".`tb_app_sys`"; public final static String FBSDevStateChangeInf_Table = DB_AppSys + ".`tb_fbsdev_statechange_inf`"; public final static String BattInf_Table = DB_BATT_INF + ".`tb_battinf`"; 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`"; @@ -253,6 +253,7 @@ public static final String Tb_Fault_Upload_Application_Table = WEB_Site +".`tb_fault_upload_application`"; //故障隐患上传表,用于故障隐患考核 /***************************** db_battinf数据库 ***************************************/ public final static String BattInf_Table = DB_BATT_INF + ".`tb_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`"; //基站信息表 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -1,6 +1,14 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V1.93 edit at date 2024-01-13 1.数据库'db_battinf.tb_battinf'新增字段 `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]' 2.数据库'db_battinf.tb_battinf_update_record'新增字段 `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]' V1.92 edit at date 2024-01-10 1.新增数据库'db_pwrdev_data_rt.tb_pwrdev_rt_info' CREATE TABLE `tb_pwrdev_rt_info` ( BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java
@@ -34,7 +34,7 @@ /**************************************************************************/ /**************************************************************************/ public final static boolean app_debug = false; public final static float m_VersionNum = (float) 1.92; public final static float m_VersionNum = (float) 1.93; public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908"; /**************************************************************************/ /**************************************************************************/
