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