From 76b5571b69a559f54c0aa2cf20289ffd0bdf475b Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期二, 05 十一月 2024 15:32:10 +0800
Subject: [PATCH] 2.表'db_pwrdev_inf.tb_pwrdev_inf' 新增字段 `update_load_curr_en` int(10) NOT NULL DEFAULT '0' COMMENT '是否更新核容的负载电流[0-不更新 1-更新] 3.数据库'db_pwrdev_data_history_gw'中所有的数据表新增字段用于国网的负载电流实时记录 `load_curr` float NOT NULL DEFAULT '0' COMMENT '负载电流',
---
BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java | 12 ++++++++++++
1 files changed, 12 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java
index bbcbac9..c416503 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java
@@ -89,6 +89,7 @@
" `is_dc_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含直流配电柜[1-包含，0-不包含]'," +
" `is_highfreq_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含高频配电柜[1-包含，0-不包含]'," +
" `swtich_num` int(32) NOT NULL DEFAULT '65535' COMMENT '开关路数'," +
+ " `update_load_curr_en` int(10) NOT NULL DEFAULT '0' COMMENT '是否更新核容的负载电流[0-不更新 1-更新]'," +
" PRIMARY KEY (`num`)," +
" KEY `index_station_id` (`StationId`)," +
" KEY `index_powerdev_id` (`PowerDeviceId`)," +
@@ -246,6 +247,17 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table
+ " ADD COLUMN `swtich_num` int(32) NOT NULL DEFAULT '4095' COMMENT '开关路数';");
}
+
+ res = null;
+ //添加字段update_load_curr_en ----- 是否更新核容的负载电流[0-不更新 1-更新]
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_inf'"
+ + " AND table_name='tb_pwrdev_inf'"
+ + " AND column_name='update_load_curr_en'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table
+ + " ADD COLUMN `update_load_curr_en` int(10) NOT NULL DEFAULT '0' COMMENT '是否更新核容的负载电流[0-不更新 1-更新]';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1