From c975b0b40041aa8135c8f08c760b4dc5991625ef Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期五, 18 八月 2023 15:53:23 +0800
Subject: [PATCH] ALTER TABLE `web_site`.`tb_fault_upload` ADD COLUMN `main_id` INT NULL AFTER `create_time`;
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
index e8a86a8..d2bf488 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
@@ -5496,6 +5496,7 @@
" `create_time` datetime DEFAULT NULL," +
" `alarm_num` INT NULL COMMENT '告警实时表的id'," +
" `alarm_type` INT NULL COMMENT '告警分类:1-电池,2-设备,3-电源'," +
+ " `main_id` int(11) DEFAULT NULL," +
" PRIMARY KEY (`id`)" +
") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='故障隐患上传表,用于故障隐患考核';";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
@@ -5537,6 +5538,16 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Fault_Upload_Table
+ " ADD COLUMN `alarm_type` INT NULL COMMENT '告警分类:1-电池,2-设备,3-电源';");
}
+ res = null;
+ //添加 main_id
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='web_site'"
+ + " AND table_name='tb_fault_upload'"
+ + " AND column_name='main_id'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Fault_Upload_Table
+ + " ADD COLUMN `main_id` int(11) DEFAULT NULL;");
+ }
res = null;
//删除列station_name
--
Gitblit v1.9.1