From 2920ed8bc47d17b8250a3436db35832c6af6d5ea Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期六, 13 四月 2024 16:15:12 +0800
Subject: [PATCH] 1表'db_ram.db.tb_fbs9100s_stemnode_state'新增字段 `k2_st` int(5) NOT NULL DEFAULT '0' COMMENT '组2接触器k状态（0-断开 1-闭合）'
---
BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java | 10 +++++++++-
1 files changed, 9 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
index 0dd7b01..694abe7 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
@@ -4921,7 +4921,15 @@
+ " AND column_name='k1_st'");
if(false == res.next()) {
sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table
- + " ADD COLUMN `k1_st` int(11) NOT NULL DEFAULT '0' COMMENT '接触器k1状态（0-断开 1-闭合）';");
+ + " ADD COLUMN `k1_st` int(5) NOT NULL DEFAULT '0' COMMENT '组1接触器k状态（0-断开 1-闭合）';");
+ }
+ res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100s_stemnode_state'"
+ + " AND column_name='k2_st'");
+ if(false == res.next()) {
+ sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table
+ + " ADD COLUMN `k2_st` int(5) NOT NULL DEFAULT '0' COMMENT '组2接触器k状态（0-断开 1-闭合）';");
}
--
Gitblit v1.9.1