From 5c5b243baeb44fa8ff7c201717c2e425270b519d Mon Sep 17 00:00:00 2001
From: DELL <DELL@WIN-3EOIPEE9ML1>
Date: 星期一, 08 四月 2024 08:45:15 +0800
Subject: [PATCH] V10.02 edit at date 2024-04-08 1.表'db_ckpwrdev_inf.tb_ckpwrdev_inf'新增字段用于测控平台判断模块的标识位
---
BattMonitor_DB_Builder/src/com/database_util/DB_Ckpwrdev_Inf.java | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Ckpwrdev_Inf.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Ckpwrdev_Inf.java
index 8bbf267..931d216 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Ckpwrdev_Inf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Ckpwrdev_Inf.java
@@ -126,6 +126,17 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Ckpwrdev_Inf_Table
+ " ADD column `zjdy_record__time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '紫晶电源协转数据更新时间';");
}
+
+ //新增字段module_switch_status
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ckpwrdev_inf'"
+ + " AND table_name='tb_ckpwrdev_inf'"
+ + " AND column_name='module_switch_status'");
+ if(!res.next()) {
+ //添加字段
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Ckpwrdev_Inf_Table
+ + " ADD column `module_switch_status` varchar(45) DEFAULT '4294967295' COMMENT '高频开关柜交流模块是否启用';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1