From 07b21c8d224f7930a894b1e1bd468195a181df8c Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期三, 14 六月 2023 16:29:21 +0800
Subject: [PATCH] 5.'db_alarm.tb_devalarm_data'新增告警重要等级 `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'
---
BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
index f3eb48e..a6961f9 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
@@ -68,6 +68,7 @@
" alm_confirmed_time datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
" alm_cleared_type int(11) NOT NULL DEFAULT '0'," +
" usr_Id int(11) NOT NULL DEFAULT '0'," +
+ " `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]'," +
" PRIMARY KEY (num)," +
" KEY index_record_id (record_id)," +
" KEY index_dev_id (dev_id)," +
@@ -91,6 +92,15 @@
if(false == res.next()) {
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data__History_Table
+ " ADD COLUMN alm_value float NOT NULL DEFAULT '0';");
+ }
+ //添加指定的alm_severity列'告警重要等级[0:重要；1:紧急]'
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_alarm'"
+ + " AND table_name='tb_devalarm_data_history'"
+ + " AND column_name='alm_severity'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data__History_Table
+ + " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]';");
}
} catch (SQLException e) {
e.printStackTrace();
@@ -127,6 +137,7 @@
" alm_confirmed_time datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
" alm_cleared_type int(11) NOT NULL DEFAULT '0'," +
" usr_Id int(11) NOT NULL DEFAULT '0'," +
+ " `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]'," +
" PRIMARY KEY (num)," +
" KEY index_record_id (record_id)," +
" KEY index_dev_id (dev_id)," +
@@ -172,6 +183,16 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data_Table
+ " ADD COLUMN `msg_flag` tinyint NOT NULL DEFAULT 0;");
}
+ res = null;
+ //添加指定的alm_severity列(告警重要等级[0:重要；1:紧急])
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_alarm'"
+ + " AND table_name='tb_devalarm_data'"
+ + " AND column_name='alm_severity'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data_Table
+ + " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1