From 875ea65eec4b55f2b06a99c3d9de05b237ffb3de Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期三, 23 十月 2024 11:00:36 +0800
Subject: [PATCH] 3.表'db_battinf.tb_battinf'新增字段'acdc_secuity_flag'用于标识是否包含-交直流监控屏
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 10 ++++++++++
1 files changed, 10 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
index dda3f38..7d31579 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -1551,6 +1551,16 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ " ADD COLUMN `topology_map_type` int(11) NOT NULL DEFAULT '0' COMMENT '拓扑图类型';");
}
+ res = null;
+ //添加acdc_secuity_flag ---- 拓扑图类型
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='acdc_secuity_flag'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ + " ADD COLUMN `acdc_secuity_flag` int(11) NOT NULL DEFAULT '0' COMMENT '是否包含交直流监控屏[0-不包含 1-包含]';");
+ }
--
Gitblit v1.9.1