From 3e14a623345669722d42cae5914d4ade70fc5c9e Mon Sep 17 00:00:00 2001
From: DELL <DELL@WIN-3EOIPEE9ML1>
Date: 星期三, 27 三月 2024 15:12:01 +0800
Subject: [PATCH] V1.97 edit at date 2024-03-27 1.新增数据表 'web_site.tb_resset_station' CREATE TABLE `tb_resset_station` ( `num` int(11) NOT NULL AUTO_INCREMENT, `stationid` varchar(255) NOT NULL DEFAULT '0' COMMENT '机房id', `last_start_time` datetime NOT NULL DEFAULT '2024-01-01 00:00:00' COMMENT '上次启动时间', `time_interval` float NOT NULL DEFAULT '720' COMMENT '启动时间间隔', `enable` int(11) NOT NULL DEFAULT '1' COMMENT '是否生效:1生效', PRIMARY KEY (`num`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='机房内阻测试计划信息表';
---
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 c56f6bb..702168c 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
@@ -728,6 +728,15 @@
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閲嶈浇鏁版嵁
+ 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_FBO4830_EN'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
+ + " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO4830_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '閲嶆柊FBO4830绾跨▼鍔犺浇鏈烘埧淇℃伅';");
+ }
} catch (SQLException e) {
e.printStackTrace();
--
Gitblit v1.9.1