From 8c854f45218f166cb3c89be61201200e01668f08 Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期二, 30 七月 2024 09:43:21 +0800
Subject: [PATCH] 2.表'db_battinf.tb_battinf'新增字段 `topology_map_type` int(11) NOT NULL DEFAULT '0' COMMENT '拓扑图类型', 3.新增表'db_ram_db.tb_dev6159_power_yc'-通信电源核容一体机遥测实时状态表 4.新增表'db_ram_db.tb_dev6159_power_yx'-通信电源核容一体机遥信实时状态表
---
BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java | 230 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 230 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
index 2ec3b91..876ae69 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
@@ -138,6 +138,12 @@
//创建BTS6185相关设备告警阈值遥调表
createDev_6185_AlmpPram_Table(pool, recreate);
+
+ //创建 通信电源核容一体机遥测实时状态表
+ createDev6159_Power_Yc_Table(pool, recreate);
+
+ //创建 通信电源核容一体机遥测实时状态表
+ createDev6159_Power_Yx_Table(pool, recreate);
System.out.println(" Db_Ram_Db init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
}
@@ -245,6 +251,230 @@
}
/**
+ * 创建 通信电源核容一体机遥测实时状态表
+ * @param pool
+ * @param recreate
+ */
+ private static void createDev6159_Power_Yc_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Dev6159_Power_Yc_Table;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Dev6159_Power_Yc_Table + " (" +
+ " `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键'," +
+ " `dev_id` int(11) NOT NULL DEFAULT '0'," +
+ " `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '更新时间'," +
+ " `acin1_vola_ac` float NOT NULL DEFAULT '0' COMMENT '第1路交流A相输入电压-ACSWIB'," +
+ " `acin1_volb_ac` float NOT NULL DEFAULT '0' COMMENT '第1路交流B相输入电压-ACSWIB'," +
+ " `acin1_volc_ac` float NOT NULL DEFAULT '0' COMMENT '第1路交流C相输入电压-ACSWIB'," +
+ " `acin1_curra_ac` float NOT NULL DEFAULT '0' COMMENT '第1路交流A相输入电流-ACSWIB'," +
+ " `acin1_currb_ac` float NOT NULL DEFAULT '0' COMMENT '第1路交流B相输入电流-ACSWIB'," +
+ " `acin1_currc_ac` float NOT NULL DEFAULT '0' COMMENT '第1路交流C相输入电流-ACSWIB'," +
+ " `acin2_vola_ac` float NOT NULL DEFAULT '0' COMMENT '第2路交流A相输入电压-ACSWIB'," +
+ " `acin2_volb_ac` float NOT NULL DEFAULT '0' COMMENT '第2路交流B相输入电压-ACSWIB'," +
+ " `acin2_volc_ac` float NOT NULL DEFAULT '0' COMMENT '第2路交流C相输入电压-ACSWIB'," +
+ " `acin2_curra_ac` float NOT NULL DEFAULT '0' COMMENT '第2路交流A相输入电流-ACSWIB'," +
+ " `acin2_currb_ac` float NOT NULL DEFAULT '0' COMMENT '第2路交流B相输入电流-ACSWIB'," +
+ " `acin2_currc_ac` float NOT NULL DEFAULT '0' COMMENT '第2路交流C相输入电流-ACSWIB'," +
+ " `ac_vol_highlimit_ac` float NOT NULL DEFAULT '0' COMMENT '交流电压告警阈值上限-ACSWIB'," +
+ " `ac_vol_lowlimit_ac` float NOT NULL DEFAULT '0' COMMENT '交流电压告警阈值下限-ACSWIB'," +
+ " `ac_dev_temp_ac` float NOT NULL DEFAULT '0' COMMENT '交流配电柜温度值-ACSWIB'," +
+ " `acin1_vola_cpss` float NOT NULL DEFAULT '0' COMMENT '第1路交流A相输入电压-CPSS'," +
+ " `acin1_volb_cpss` float NOT NULL DEFAULT '0' COMMENT '第1路交流B相输入电压-CPSS'," +
+ " `acin1_volc_cpss` float NOT NULL DEFAULT '0' COMMENT '第1路交流C相输入电压-CPSS'," +
+ " `ac_vol_higlimit_cpss` float NOT NULL DEFAULT '0' COMMENT '交流电压告警阈值上限-CPSS'," +
+ " `ac_vol_lowlimit_cpss` float NOT NULL DEFAULT '0' COMMENT '交流电压告警阈值下限-CPSS'," +
+ " `acin2_vola_cpss` float NOT NULL DEFAULT '0' COMMENT '第2路交流A相输入电压-CPSS'," +
+ " `acin2_volb_cpss` float NOT NULL DEFAULT '0' COMMENT '第2路交流B相输入电压-CPSS'," +
+ " `acin2_volc_cpss` float NOT NULL DEFAULT '0' COMMENT '第2路交流C相输入电压-CPSS'," +
+ " `ac_vola_cpss` float NOT NULL DEFAULT '0' COMMENT '交流A相输出电压-CPSS'," +
+ " `ac_volb_cpss` float NOT NULL DEFAULT '0' COMMENT '交流B相输出电压-CPSS'," +
+ " `ac_volc_cpss` float NOT NULL DEFAULT '0' COMMENT '交流C相输出电压-CPSS'," +
+ " `ac_outcurra_cpss` float NOT NULL DEFAULT '0' COMMENT '交流A相输出电流-CPSS'," +
+ " `ac_outcurrb_cpss` float NOT NULL DEFAULT '0' COMMENT '交流B相输出电流-CPSS'," +
+ " `ac_outcurrc_cpss` float NOT NULL DEFAULT '0' COMMENT '交流C相输出电流-CPSS'," +
+ " `dc_outvol_cpss` float NOT NULL DEFAULT '0' COMMENT '直流输出电压-CPSS'," +
+ " `load_curr_cpss` float NOT NULL DEFAULT '0' COMMENT '负载电流-CPSS'," +
+ " `dc_outvol_highlimit_cpss` float NOT NULL DEFAULT '0' COMMENT '直流输出电压告警阈值上限-CPSS'," +
+ " `dc_outvol_lowlimit_cpss` float NOT NULL DEFAULT '0' COMMENT '直流输出电压告警阈值下限-CPSS'," +
+ " `batt1_vol_cpss` float NOT NULL DEFAULT '0' COMMENT '电池端1电压-CPSS'," +
+ " `batt_chargecurr_cpss` float NOT NULL DEFAULT '0' COMMENT '蓄电池组充电电流-CPSS'," +
+ " `jun_charge_vol_cpss` float NOT NULL DEFAULT '0' COMMENT '均充电压-CPSS'," +
+ " `float_charge_vol_cpss` float NOT NULL DEFAULT '0' COMMENT '浮充电压-CPSS'," +
+ " `batt_charcurr_limit_cpss` float NOT NULL DEFAULT '0' COMMENT '电池充电限流值-CPSS'," +
+ " `batt2_vol_cpss` float NOT NULL DEFAULT '0' COMMENT '电池端2电压-CPSS'," +
+ " `dev_temp_cpss` float NOT NULL DEFAULT '0' COMMENT '高频开关电源柜温度-CPSS'," +
+ " `m1_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块1输出电流-CPSS'," +
+ " `m2_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块2输出电流-CPSS'," +
+ " `m3_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块3输出电流-CPSS'," +
+ " `m4_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块4输出电流-CPSS'," +
+ " `m5_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块5输出电流-CPSS'," +
+ " `m6_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块6输出电流-CPSS'," +
+ " `m7_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块7输出电流-CPSS'," +
+ " `m8_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块8输出电流-CPSS'," +
+ " `m9_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块9输出电流-CPSS'," +
+ " `m10_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块10输出电流-CPSS'," +
+ " `m11_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块11输出电流-CPSS'," +
+ " `m12_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块12输出电流-CPSS'," +
+ " `m13_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块13输出电流-CPSS'," +
+ " `m14_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块14输出电流-CPSS'," +
+ " `m15_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块15输出电流-CPSS'," +
+ " `m16_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块16输出电流-CPSS'," +
+ " `m17_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块17输出电流-CPSS'," +
+ " `m18_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块18输出电流-CPSS'," +
+ " `m19_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块19输出电流-CPSS'," +
+ " `m20_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块20输出电流-CPSS'," +
+ " `m21_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块21输出电流-CPSS'," +
+ " `m22_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块22输出电流-CPSS'," +
+ " `m23_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块23输出电流-CPSS'," +
+ " `m24_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块24输出电流-CPSS'," +
+ " `m25_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块25输出电流-CPSS'," +
+ " `m26_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块26输出电流-CPSS'," +
+ " `m27_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块27输出电流-CPSS'," +
+ " `m28_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块28输出电流-CPSS'," +
+ " `m29_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块29输出电流-CPSS'," +
+ " `m30_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块30输出电流-CPSS'," +
+ " `m31_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块31输出电流-CPSS'," +
+ " `m32_outcurr_cpss` float NOT NULL DEFAULT '0' COMMENT '模块32输出电流-CPSS'," +
+ " `acin_usecount_cpss` int(11) NOT NULL DEFAULT '0' COMMENT '在用交流路数-CPSS'," +
+ " `dcin1_vol_dc` float NOT NULL DEFAULT '0' COMMENT '第1路直流输入电压-DCSWIB'," +
+ " `dcin2_vol_dc` float NOT NULL DEFAULT '0' COMMENT '第1路直流输入电压-DCSWIB'," +
+ " `dcout1_vol_dc` float NOT NULL DEFAULT '0' COMMENT '1段直流母线输出电压-DCSWIB'," +
+ " `dcout1_curr_dc` float NOT NULL DEFAULT '0' COMMENT '1段直流母线输出电流-DCSWIB'," +
+ " `dcvol_highlimit_dc` float NOT NULL DEFAULT '0' COMMENT '直流电压告警阈值上限-DCSWIB'," +
+ " `dcvol_lowlimit_dc` float NOT NULL DEFAULT '0' COMMENT '直流电压告警阈值下限-DCSWIB'," +
+ " `dcout2_vol_dc` float NOT NULL DEFAULT '0' COMMENT '2段直流母线输出电压-DCSWIB'," +
+ " `dcout2_curr_dc` float NOT NULL DEFAULT '0' COMMENT '2段直流母线输出电流-DCSWIB'," +
+ " `dev_temp_dc` float NOT NULL DEFAULT '0' COMMENT '直流配电柜温度-DCSWIB'," +
+ " PRIMARY KEY (`num`)," +
+ " UNIQUE KEY `idx_dev_id` (`dev_id`) USING BTREE" +
+ ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='通信电源核容一体机遥测实时状态表';" +
+ ";";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ if(true == recreate) {
+ sql.sqlMysqlExecute(sql_str01);
+ }
+ sql.sqlMysqlExecute(sql_str02);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+
+ /**
+ * 创建 通信电源核容一体机遥信实时状态表
+ * @param pool
+ * @param recreate
+ */
+ private static void createDev6159_Power_Yx_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Dev6159_Power_Yx_Table;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Dev6159_Power_Yx_Table + " (" +
+ " `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键'," +
+ " `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT '设备ID'," +
+ " `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '更新时间'," +
+ " `ac1_overvola_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流A相过压-ACSWIB'," +
+ " `ac1_undervola_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流A相欠压-ACSWIB'," +
+ " `ac1_lessvola_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流A相缺相-ACSWIB'," +
+ " `ac1_overvolb_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流B相过压-ACSWIB'," +
+ " `ac1_undervolb_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流B相欠压-ACSWIB'," +
+ " `ac1_lessvolb_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流B相缺相-ACSWIB'," +
+ " `ac1_overvolc_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流C相过压-ACSWIB'," +
+ " `ac1_undervolc_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流C相欠压-ACSWIB'," +
+ " `ac1_lessvolc_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流C相缺相-ACSWIB'," +
+ " `acin1_thunder_fault_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '交流输入1防雷器故障-ACSWIB'," +
+ " `ac2_overvola_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流A相过压-ACSWIB'," +
+ " `ac2_undervola_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流A相欠压-ACSWIB'," +
+ " `ac2_lessvola_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流A相缺相-ACSWIB'," +
+ " `ac2_overvolb_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流B相过压-ACSWIB'," +
+ " `ac2_undervolb_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流B相欠压-ACSWIB'," +
+ " `ac2_lessvolb_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流B相缺相-ACSWIB'," +
+ " `ac2_overvolc_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流C相过压-ACSWIB'," +
+ " `ac2_undervolc_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流C相欠压-ACSWIB'," +
+ " `ac2_lessvolc_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流C相缺相-ACSWIB'," +
+ " `acin2_thunder_fault_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '交流输入2防雷器故障-ACSWIB'," +
+ " `ac_dev_temp_alm_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '交流配电柜温度告警-ACSWIB'," +
+ " `acin1_powerdown_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '交流输入1停电-ACSWIB'," +
+ " `acin2_powerdown_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '交流输入2停电-ACSWIB'," +
+ " `ac_monitorerr_fault_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '交流监控单元故障-ACSWIB'," +
+ " `acin1_trip_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流输入开关跳闸-ACSWIB'," +
+ " `acin2_trip_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流输入开关跳闸-ACSWIB'," +
+ " `fsw1_sw1trip_ac` int(11) NOT NULL DEFAULT '0' COMMENT '1段交流母线输出开关0-25跳闸[bit0-开关1 ... bit24 - 开关25]-ACSWIB'," +
+ " `fsw1_sw2trip_ac` int(11) NOT NULL DEFAULT '0' COMMENT '1段交流母线输出开关26-50跳闸[bit0-开关26 ... bit24 - 开关50]-ACSWIB'," +
+ " `fsw1_sw3trip_ac` int(11) NOT NULL DEFAULT '0' COMMENT '1段交流母线输出开关51-64跳闸[bit0-开关51 ... bit13 - 开关64]-ACSWIB'," +
+ " `fsw2_sw1trip_ac` int(11) NOT NULL DEFAULT '0' COMMENT '2段交流母线输出开关0-25跳闸[bit0-开关1 ... bit24 - 开关25]-ACSWIB'," +
+ " `fsw2_sw2trip_ac` int(11) NOT NULL DEFAULT '0' COMMENT '2段交流母线输出开关26-50跳闸[bit0-开关26 ... bit24 - 开关50]-ACSWIB'," +
+ " `fsw2_sw3trip_ac` int(11) NOT NULL DEFAULT '0' COMMENT '2段交流母线输出开关51-64跳闸[bit0-开关51 ... bit13 - 开关64]-ACSWIB'," +
+ " `ac_total_alm_ac` tinyint(4) NOT NULL DEFAULT '0' COMMENT '交流配电柜总告警-ACSWIB'," +
+ " `ac1_overvola_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流A相过压-CPSS'," +
+ " `ac1_undervola_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流A相欠压-CPSS'," +
+ " `ac1_lessvola_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流A相缺相-CPSS'," +
+ " `ac1_overvolb_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流B相过压-CPSS'," +
+ " `ac1_undervolb_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流B相欠压-CPSS'," +
+ " `ac1_lessvolb_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流B相缺相-CPSS'," +
+ " `ac1_overvolc_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流C相过压-CPSS'," +
+ " `ac1_undervolc_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流C相欠压-CPSS'," +
+ " `ac1_lessvolc_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流C相缺相-CPSS'," +
+ " `acin1_powerdown_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '交流输入1停电-CPSS'," +
+ " `acin1_thunder_fault_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '交流输入1防雷器故障-CPSS'," +
+ " `ac2_overvola_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流A相过压-CPSS'," +
+ " `ac2_undervola_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流A相欠压-CPSS'," +
+ " `ac2_lessvola_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流A相缺相-CPSS'," +
+ " `ac2_overvolb_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流B相过压-CPSS'," +
+ " `ac2_undervolb_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流B相欠压-CPSS'," +
+ " `ac2_lessvolb_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流B相缺相-CPSS'," +
+ " `ac2_overvolc_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流C相过压-CPSS'," +
+ " `ac2_undervolc_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流C相欠压-CPSS'," +
+ " `ac2_lessvolc_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流C相缺相-CPSS'," +
+ " `acin2_powerdown_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '交流输入2停电-CPSS'," +
+ " `acin2_thunder_fault_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '交流输入2防雷器故障-CPSS'," +
+ " `monitorerr_fault_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '监控单元故障-CPSS'," +
+ " `dc_outvol_over_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '直流输出过压-CPSS'," +
+ " `dc_outvol_under_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '直流输出欠压-CPSS'," +
+ " `batt_powerdown_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '电池组下电保护告警-CPSS'," +
+ " `mod_fault1_cpss` int(11) NOT NULL DEFAULT '0' COMMENT '模块1-25故障[bit0-模块1... bit24-模块25]-CPSS'," +
+ " `mod_fault2_cpss` int(11) NOT NULL DEFAULT '0' COMMENT '模块25-32故障[bit0-模块26... bit6-模块32]-CPSS'," +
+ " `mod_close1_cpss` int(11) NOT NULL DEFAULT '0' COMMENT '模块1-25关机[bit0-模块1... bit24-模块25]-CPSS'," +
+ " `mod_close2_cpss` int(11) NOT NULL DEFAULT '0' COMMENT '模块25-32关机[bit0-模块26... bit6-模块32]-CPSS'," +
+ " `acin1_trip_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路交流输入开关跳闸-CPSS'," +
+ " `acin2_trip_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路交流输入开关跳闸-CPSS'," +
+ " `dev_total_alm_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '高频开关电源柜总告警-CPSS'," +
+ " `loader_fuse_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '负载熔丝状态-CPSS'," +
+ " `batt1_fuse_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '电池组1熔丝告警-CPSS'," +
+ " `batt2_fuse_cpss` tinyint(4) NOT NULL DEFAULT '0' COMMENT '电池组2熔丝告警-CPSS'," +
+ " `dcvol1_over_dc` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路直流过压-DCSWIB'," +
+ " `dcvol1_under_dc` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路直流欠压-DCSWIB'," +
+ " `dcvol2_over_dc` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路直流过压-DCSWIB'," +
+ " `dcvol2_under_dc` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路直流欠压-DCSWIB'," +
+ " `monitor_fault_dc` tinyint(4) NOT NULL DEFAULT '0' COMMENT '监控单元故障-DCSWIB'," +
+ " `dev_temp_alm_dc` tinyint(4) NOT NULL DEFAULT '0' COMMENT '直流配电柜温度告警-DCSWIB'," +
+ " `dcin1_swtrip_dc` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第1路输入开关跳闸-DCSWIB'," +
+ " `dcin2_swtrip_dc` tinyint(4) NOT NULL DEFAULT '0' COMMENT '第2路输入开关跳闸-DCSWIB'," +
+ " `fsw1_sw1_trip` int(11) NOT NULL DEFAULT '0' COMMENT '1段直流第1-25路开关跳闸[bit0-第1路 ... bit24-第25路]-DCSWIB'," +
+ " `fsw1_sw2_trip` int(11) NOT NULL DEFAULT '0' COMMENT '1段直流第26-50路开关跳闸[bit0-第26路 ... bit24-第50路]-DCSWIB'," +
+ " `fsw1_sw3_trip` int(11) NOT NULL DEFAULT '0' COMMENT '1段直流第51-75路开关跳闸[bit0-第51路 ... bit24-第75路]-DCSWIB'," +
+ " `fsw1_sw4_trip` int(11) NOT NULL DEFAULT '0' COMMENT '1段直流第76-100路开关跳闸[bit0-第76路 ... bit24-第100路]-DCSWIB'," +
+ " `fsw2_sw1_trip` int(11) NOT NULL DEFAULT '0' COMMENT '2段直流第1-25路开关跳闸[bit0-第1路 ... bit24-第25路]-DCSWIB'," +
+ " `fsw2_sw2_trip` int(11) NOT NULL DEFAULT '0' COMMENT '2段直流第26-50路开关跳闸[bit0-第26路 ... bit24-第50路]-DCSWIB'," +
+ " `fsw2_sw3_trip` int(11) NOT NULL DEFAULT '0' COMMENT '2段直流第51-75路开关跳闸[bit0-第51路 ... bit24-第75路]-DCSWIB'," +
+ " `fsw2_sw4_trip` int(11) NOT NULL DEFAULT '0' COMMENT '2段直流第76-100路开关跳闸[bit0-第76路 ... bit24-第100路]-DCSWIB'," +
+ " `dev_total_alm_dc` tinyint(4) NOT NULL DEFAULT '0' COMMENT '直流配电柜总告警-DCSWIB'," +
+ " PRIMARY KEY (`num`)," +
+ " UNIQUE KEY `idx_dev_id` (`dev_id`) USING BTREE" +
+ ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='通信电源核容一体机遥信实时状态表';" +
+ ";";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ if(true == recreate) {
+ sql.sqlMysqlExecute(sql_str01);
+ }
+ sql.sqlMysqlExecute(sql_str02);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+
+ /**
* 创建电操开关遥测实时状态表
* @param pool
* @param recreate
--
Gitblit v1.9.1