From 9feee6597dc1bb88f7af9eba117a038670f7839d Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 20 九月 2022 15:04:52 +0800
Subject: [PATCH] V1.41 edit at date 2022-09-20 1.新增表'db_ram_db.tb_dev_61851_state'--远程重启装置状态信息表 2.表'db_ram_db.tb_fbs9100_sysparam'新增远程重启装置参数字段 `dev_addr` int(11) NOT NULL DEFAULT '0' COMMENT '61851_设备地址', `tempH_Env` float NOT NULL DEFAULT '0' COMMENT '61851_环境温度高阈值', `tempH_JCQ` float NOT NULL DEFAULT '0' COMMENT '61851_接触器温度高阈值', `currH_ZL` float NOT NULL DEFAULT '0' COMMENT '61851_支路电流高阈值', `km1_switch` tinyint(4) NOT NULL DEFAULT '0' COMMENT '61851_控制KM1开关[1闭合；0：断开]', `km2_switch` tinyint(4) NOT NULL DEFAULT '0' COMMENT '61851_控制KM2开关[1闭合；0：断开]', `km3_switch` tinyint(4) NOT NULL DEFAULT '0' COMMENT '61851_控制KM3开关[1闭合；0：断开]',
---
BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java | 9 +++++++++
1 files changed, 9 insertions(+), 0 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 fd7b02e..d433d55 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
@@ -591,6 +591,15 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
+ " ADD COLUMN AppServer_Reinit_BattGroupData_A059_EN tinyint(1) NOT NULL DEFAULT '0';");
}
+ //娣诲姞杩滅▼閲嶅惎瑁呯疆閲嶈浇鏁版嵁
+ 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_61851_EN'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
+ + " ADD COLUMN `AppServer_Reinit_BattGroupData_61851_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '杩滅▼閲嶅惎瑁呯疆閲嶆柊鍔犺浇鏈烘埧淇℃伅';");
+ }
} catch (SQLException e) {
e.printStackTrace();
--
Gitblit v1.9.1