From 1e77c5a213d3150baefbcd806f7e685f689da17e Mon Sep 17 00:00:00 2001 From: DELL <1525436766@qq.com> Date: 星期二, 25 二月 2025 19:51:11 +0800 Subject: [PATCH] `label_cfg` varchar(255) NOT NULL DEFAULT '' COMMENT '实时监控标签配置(空字符串所有都选中)' --- BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 11 +++++++++++ 1 files changed, 11 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 aed34d7..c10a3b1 100644 --- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java +++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java @@ -1574,6 +1574,17 @@ + " ADD COLUMN `comm_port` int(11) NOT NULL DEFAULT '102' COMMENT '通信端口[0-使用默认端口]';"); } + res = null; + //添加label_cfg ---- 实时监控标签配置 + res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + + " WHERE table_schema='db_battinf'" + + " AND table_name='tb_battinf'" + + " AND column_name='label_cfg'"); + if(false == res.next()) { + sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table + + " ADD COLUMN `label_cfg` varchar(255) NOT NULL DEFAULT '' COMMENT '实时监控标签配置(空字符串所有都选中)';"); + } + -- Gitblit v1.9.1