From 541329aa9f5a8f78b6b6b1b0a2029974237dbae2 Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期三, 13 十一月 2024 08:42:26 +0800
Subject: [PATCH] 4.'db_app_sys.tb_app_sys'表新增字段 `AppServer_Reinit_BattGroupData_FBO60010CT_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'FBO60010CT_ZX重载数据标识', `AppServer_Reinit_BattGroupData_61850_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61850设备重载电池组数据',
---
BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java | 20 +++++++++++++++++++-
1 files changed, 19 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java b/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
index e5e1378..90fd5cd 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
@@ -729,7 +729,7 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
+ " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO4831_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '閲嶆柊FBO4831绾跨▼鍔犺浇鏈烘埧淇℃伅';");
}
- //娣诲姞fbo4831閲嶈浇鏁版嵁
+ //娣诲姞fbo4830閲嶈浇鏁版嵁
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_app_sys'"
+ " AND table_name='tb_app_sys'"
@@ -738,6 +738,24 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
+ " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO4830_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '閲嶆柊FBO4830绾跨▼鍔犺浇鏈烘埧淇℃伅';");
}
+ //娣诲姞FBO60010CT閲嶈浇鏁版嵁
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_app_sys'"
+ + " AND table_name='tb_app_sys'"
+ + " AND column_name='AppServer_Reinit_BattGroupData_FBO60010CT_EN'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
+ + " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO60010CT_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'FBO60010CT_ZX閲嶈浇鏁版嵁鏍囪瘑';");
+ }
+ //娣诲姞61850閲嶈浇鏁版嵁
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_app_sys'"
+ + " AND table_name='tb_app_sys'"
+ + " AND column_name='AppServer_Reinit_BattGroupData_61850_EN'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
+ + " ADD COLUMN `AppServer_Reinit_BattGroupData_61850_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61850璁惧閲嶈浇鐢垫睜缁勬暟鎹�';");
+ }
} catch (SQLException e) {
e.printStackTrace();
--
Gitblit v1.9.1