BattMonitor_DB_Builder/bin/com/database_util/DB_Param.classBinary files differ
BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Alarm.classBinary files differ
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt
@@ -1,6 +1,16 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V1.82 edit at date 2023-07-24 1.'db_param.tb_dev_param'表新增 上上限告警等级和下下限告警等级 `alm_high_level_upper` int(11) NOT NULL DEFAULT '1' COMMENT '上上限告警等级', `alm_low_level_lower` int(11) NOT NULL DEFAULT '1' COMMENT '下下限告警等级', 2.'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'表新增上上限告警等级和下下限告警等级 `alarm_limitL_lower_level` int(11) NOT NULL DEFAULT '1' COMMENT '下下限告警等级', `alarm_limitH_upper_level` int(11) NOT NULL DEFAULT '1' COMMENT '上上限告警等级', V1.81 edit at date 2023-07-21 1.'db_param.tb_dev_param'表新增'alm_delay_time'-山西新增告警延迟告警参数，延迟当前告警触发，筛除波动告警以及误告警 `alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '告警延迟时长[单位：秒]', BattMonitor_DB_Builder/src/com/database_util/DB_Param.java
@@ -63,6 +63,8 @@ " `alm_low_coe_lower` float NOT NULL DEFAULT '0' COMMENT '下下限告警系数值'," + " `alm_low_coe_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '下下限阈值使能[0-不启用 1-启用]'," + " `alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '告警延迟时长[单位：秒]'," + " `alm_high_level_upper` int(11) NOT NULL DEFAULT '1' COMMENT '上上限告警等级'," + " `alm_low_level_lower` int(11) NOT NULL DEFAULT '1' COMMENT '下下限告警等级'," + " PRIMARY KEY (num)," + " KEY index_alm_id (alm_id)," + " KEY index_dev_id (dev_Id)" + @@ -125,6 +127,26 @@ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table + " ADD COLUMN `alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '告警延迟时长[单位：秒]';"); } res = null; //添加alm_high_level_upper res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_param'" + " AND table_name='tb_dev_param'" + " AND column_name='alm_high_level_upper'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table + " ADD COLUMN `alm_high_level_upper` int(11) NOT NULL DEFAULT '1' COMMENT '上上限告警等级';"); } res = null; //添加alm_low_level_lower res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_param'" + " AND table_name='tb_dev_param'" + " AND column_name='alm_low_level_lower'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table + " ADD COLUMN `alm_low_level_lower` int(11) NOT NULL DEFAULT '1' COMMENT '下下限告警等级';"); } } catch (SQLException e) { e.printStackTrace(); } finally { BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java
@@ -347,6 +347,8 @@ " `alarm_limitH_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '上上限使能[0-不启用 1-启用]'," + " `alarm_limitL_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '下下限使能[0-不启用 1-启用]'," + " `alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '告警延迟时长[单位：秒]'," + " `alarm_limitH_upper_level` int(11) NOT NULL DEFAULT '1' COMMENT '上上限告警等级'," + " `alarm_limitL_lower_level` int(11) NOT NULL DEFAULT '1' COMMENT '下下限告警等级'," + " PRIMARY KEY (`num`)" + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表';"; Sql_Mysql sql = new Sql_Mysql(pool.getConn()); @@ -418,6 +420,27 @@ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " ADD COLUMN `alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '告警延迟时长[单位：秒]';"); } res = null; //添加 alarm_limitH_upper_level --上上限告警等级 res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_pwrdev_alarm'" + " AND table_name='tb_pwrdev_alarm_param_forsx'" + " AND column_name='alarm_limitH_upper_level'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " ADD COLUMN `alarm_limitH_upper_level` int(11) NOT NULL DEFAULT '1' COMMENT '上上限告警等级';"); } res = null; //添加 alarm_limitL_lower_level --下下限告警等级 res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_pwrdev_alarm'" + " AND table_name='tb_pwrdev_alarm_param_forsx'" + " AND column_name='alarm_limitL_lower_level'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " ADD COLUMN `alarm_limitL_lower_level` int(11) NOT NULL DEFAULT '1' COMMENT '下下限告警等级';"); } res = sql.sqlMysqlQuery("SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Inf_Table); StringBuffer buf_base = new StringBuffer("INSERT INTO " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + "(PowerDeviceId,alm_id,alm_level,alarm_limitH,alarm_limitH_EN,alarm_limitL,alarm_limitL_EN,alarm_name,alarm_type) VALUES"); BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -1,6 +1,16 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V1.82 edit at date 2023-07-24 1.'db_param.tb_dev_param'表新增 上上限告警等级和下下限告警等级 `alm_high_level_upper` int(11) NOT NULL DEFAULT '1' COMMENT '上上限告警等级', `alm_low_level_lower` int(11) NOT NULL DEFAULT '1' COMMENT '下下限告警等级', 2.'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'表新增上上限告警等级和下下限告警等级 `alarm_limitL_lower_level` int(11) NOT NULL DEFAULT '1' COMMENT '下下限告警等级', `alarm_limitH_upper_level` int(11) NOT NULL DEFAULT '1' COMMENT '上上限告警等级', V1.81 edit at date 2023-07-21 1.'db_param.tb_dev_param'表新增'alm_delay_time'-山西新增告警延迟告警参数，延迟当前告警触发，筛除波动告警以及误告警 `alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '告警延迟时长[单位：秒]', BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java
@@ -32,7 +32,7 @@ /**************************************************************************/ /**************************************************************************/ public final static boolean app_debug = false; public final static float m_VersionNum = (float) 1.81; public final static float m_VersionNum = (float) 1.82; public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908"; /**************************************************************************/ /**************************************************************************/
