From 3a1e540d43bcb0b5adf3f1cbef99b3ce5847459c Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期一, 24 七月 2023 09:07:46 +0800
Subject: [PATCH] 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 '上上限告警等级',
---
BattMonitor_DB_Builder/src/com/database_util/DB_Param.java | 22 ++++++++++++++++++++++
1 files changed, 22 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Param.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Param.java
index e234eb2..ca9307a 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Param.java
+++ b/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 {
--
Gitblit v1.9.1