From 05400e898de01bb507bbe1b026700805e4d6c8cd Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期三, 28 十二月 2022 10:53:09 +0800
Subject: [PATCH] 5.db_app_sys.tb_app_sys 新增字段 `AppServer_Reinit_BattGroupData_FBO4830_EN` tinyint(1) NOT NULL DEFAULT '0',
---
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 10 ++++++++++
1 files changed, 10 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
index 109fd80..c21753c 100644
--- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
+++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -717,6 +717,16 @@
+ " ADD COLUMN `AppServer_Reinit_BattGroupData_LD9_EN` BOOLEAN NOT NULL DEFAULT false"
+ " AFTER `AppServer_Reinit_BattGroupData_EN`");
}
+ /**************************** db_app_sys 表中添加 AppServer_Reinit_BattGroupData_FBO4830_EN 列(用于4830主程序动态加载设备参数) *******************************************/
+ res0 = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_app_sys'"
+ + " AND table_name='tb_app_sys'"
+ + " AND column_name='AppServer_Reinit_BattGroupData_FBO4830_EN'");
+ if(false == res0.next()) {
+ sqlMysqlExecute("ALTER TABLE " + AppSys_Table
+ + " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO4830_EN` BOOLEAN NOT NULL DEFAULT false"
+ + " AFTER `AppServer_Reinit_BattGroupData_LD9_EN`");
+ }
//---------------------------------------------------------------------------------------------//
sqlMysqlExecute(table_1);
--
Gitblit v1.9.1