From 61b944654f948047a667d1fab85e85c76290901b Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期三, 11 十月 2023 15:59:09 +0800
Subject: [PATCH] 2.新增表'db_ram_db.tb_check_dialog' CREATE TABLE `tb_check_dialog` ( `num` bigint(20) NOT NULL AUTO_INCREMENT, `dev_id` int(64) NOT NULL DEFAULT '910000001', `test_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00', PRIMARY KEY (`num`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---
BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java | 2 +-
1 files changed, 1 insertions(+), 1 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 a2b2df7..0b9927d 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
@@ -69,7 +69,7 @@
+ " AND table_name='" + tablename + "'"
+ " AND column_name='alm_severity'");
if(false == res2.next()) {
- sql.sqlMysqlExecute(" ALTER TABLE db_alarm." + tablename
+ sql.sqlMysqlTotalExecute(" ALTER TABLE db_alarm." + tablename
+ " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]';");
}
--
Gitblit v1.9.1