From 1c292d4397f410497bebe111a558bc1d5469149b Mon Sep 17 00:00:00 2001 From: Administrator <1525436766@qq.com> Date: 星期三, 22 三月 2023 10:15:07 +0800 Subject: [PATCH] V1.62 edit at date 2023-03-22 1.创建山西电源告警参数表'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'，并录入所有电源设备告警参数 CREATE TABLE `tb_pwrdev_alarm_param_forsx` ( `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `PowerDeviceId` int(11) NOT NULL DEFAULT '0' COMMENT '电源id', `alm_id` int(11) NOT NULL DEFAULT '0' COMMENT '告警id', `alm_level` int(11) NOT NULL DEFAULT '4' COMMENT '告警等级', `alarm_limitH` float NOT NULL DEFAULT '0' COMMENT '告警上限阈值', `alarm_limitH_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '上限告警使能', `alarm_limitL` float NOT NULL DEFAULT '0' COMMENT '告警下限阈值', `alarm_limitL_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '告警下限使能', `alarm_source` int(11) NOT NULL DEFAULT '0' COMMENT '告警数据来源[0-设备告警点位判断；1-当前阈值判断]', `alarm_name` varchar(255) NOT NULL DEFAULT '' COMMENT '当前告警描述', `alarm_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-上下限有效 1-上限有效 2-下限有效', PRIMARY KEY (`num`) ) ENGINE=InnoDB AUTO_INCREMENT=436 DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表'; 2.表'db_pwrdev_alarm.tb_pwrdev_alarm'表新增字段 用于标识当前告警来源 `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]' 3.表'db_pwrdev_alarm.tb_pwrdev_alarm_history'表新增字段 用于标识当前告警来源 `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]' --- BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java index 1010345..ae2276a 100644 --- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java +++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java @@ -312,6 +312,8 @@ public final static String Pwrdev_Time_Adj_Alarm_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_time_adj_alarm`"; public final static String Pwrdev_Time_Out_Alarm_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_time_out_alarm`"; + public final static String Pwrdev_Alarm_Param_ForSX_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_alarm_param_forsx`"; //山西电源告警参数表 + /***************************** db_pwrdev_data_rt 数据库 ************************************/ -- Gitblit v1.9.1