From 62697323bdd7066551705630adf7d64f3f9f84c2 Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期三, 24 七月 2024 09:47:31 +0800
Subject: [PATCH] 2.表'db_battinf.tb_battinf'新增字段 `topology_map_type` int(11) NOT NULL DEFAULT '0' COMMENT '拓扑图类型',
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 12 ++++++++++++
1 files changed, 12 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 11e77cc..0b514db 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -1047,6 +1047,8 @@
" `LoadCurrFromDis` float NOT NULL DEFAULT '0' COMMENT '负载电流-[来源核容放电数据]'," +
" `NodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '节点站标识:0:不是节点站[默认] 1:节点站'," +
" `StationType` varchar(255) DEFAULT NULL COMMENT '站点类型[例如110V/22V]'," +
+ " `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]'," +
+ " `topology_map_type` int(11) NOT NULL DEFAULT '0' COMMENT '拓扑图类型'," +
" PRIMARY KEY (`num`)," +
" UNIQUE KEY `index_battgroup_id` (`BattGroupId`) USING BTREE," +
" KEY `index_station_id` (`StationId`)," +
@@ -1475,6 +1477,16 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ " ADD COLUMN `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]';");
}
+ res = null;
+ //添加topology_map_type ---- 拓扑图类型
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='topology_map_type'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ + " ADD COLUMN `topology_map_type` int(11) NOT NULL DEFAULT '0' COMMENT '拓扑图类型';");
+ }
--
Gitblit v1.9.1