From e6eea8578691fb3e5f4b2ca236ddba4de039a795 Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期二, 14 一月 2025 10:37:28 +0800
Subject: [PATCH] 4.表'db_battinf.tb_battinf'新增字段用于连接自定义端口设备 `comm_port` int(11) NOT NULL DEFAULT '102' COMMENT '通信端口号[0-默认端口 ]-现适用于BTS2202',
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 15 +++++++++++++--
1 files changed, 13 insertions(+), 2 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 08fe28d..aed34d7 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -1113,6 +1113,8 @@
" `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 '拓扑图类型'," +
+ " `acdc_secuity_flag` int(11) NOT NULL DEFAULT '0' COMMENT '交直流屏柜启用状态'," +
+ " `comm_port` int(11) NOT NULL DEFAULT '0' COMMENT '拓扑图类型'," +
" PRIMARY KEY (`num`)," +
" UNIQUE KEY `index_battgroup_id` (`BattGroupId`) USING BTREE," +
" KEY `index_station_id` (`StationId`)," +
@@ -1552,7 +1554,7 @@
+ " ADD COLUMN `topology_map_type` int(11) NOT NULL DEFAULT '0' COMMENT '拓扑图类型';");
}
res = null;
- //添加acdc_secuity_flag ---- 拓扑图类型
+ //添加acdc_secuity_flag ---- 是否包含交直流监控屏
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_battinf'"
+ " AND table_name='tb_battinf'"
@@ -1561,7 +1563,16 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ " ADD COLUMN `acdc_secuity_flag` int(11) NOT NULL DEFAULT '0' COMMENT '是否包含交直流监控屏[0-不包含 1-包含]';");
}
-
+ res = null;
+ //添加comm_port ---- 通信端口
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='comm_port'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ + " ADD COLUMN `comm_port` int(11) NOT NULL DEFAULT '102' COMMENT '通信端口[0-使用默认端口]';");
+ }
--
Gitblit v1.9.1