From 139d0990eddd8b7847e06c7a16030813c501b9e2 Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期二, 26 十一月 2024 16:57:26 +0800
Subject: [PATCH] 修改

---
 BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java |   12 ++++++++++++
 1 files changed, 12 insertions(+), 0 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 3134812..bdbfbc7 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
@@ -4620,6 +4620,18 @@
 						+ " ADD COLUMN `screensaver_time` int(11) NOT NULL DEFAULT '10' COMMENT '进入屏幕保护时间(不能小于10分钟)';");
 			}
 			/****************************************************************/
+			/****************************************************************/
+			res = null;
+			//添加 moncap [标称容量]
+			res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+					+ " WHERE table_schema='db_ram_db'"
+					+ " AND table_name='tb_fbs9100_setparam'"
+					+ " AND column_name='moncap'");
+			if(false == res.next()) {
+				sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
+						+ " ADD COLUMN `moncap` int(11) NOT NULL DEFAULT '0' COMMENT '标称容量';");
+			}
+			/****************************************************************/
 		} catch (SQLException e) {
 			e.printStackTrace();
 		} finally {

--
Gitblit v1.9.1