From 1aa2196c56888adf219e786be07458bac0da83a6 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期四, 09 二月 2023 10:36:15 +0800
Subject: [PATCH] V1.52 edit at date 2023-02-09 1.'db_battinf'.'tb_battinf'新增字段 `LoadCurrFromDis` float NOT NULL DEFAULT '0' COMMENT '负载电流-[来源核容放电数据]
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
index 7f4f247..e94710e 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -787,6 +787,7 @@
" `cellShowType` int(11) NOT NULL DEFAULT '0' COMMENT '电池类型[0：铅酸 1：锂电]'," +
" `NomCapWH` float NOT NULL DEFAULT '0' COMMENT '标称容量[KWH]'," +
" `NomCapAH` float NOT NULL DEFAULT '0' COMMENT '标称容量[AH]'," +
+ " `LoadCurrFromDis` float NOT NULL DEFAULT '0' COMMENT '负载电流-[来源核容放电数据]'," +
" PRIMARY KEY (`num`)," +
" UNIQUE KEY `index_battgroup_id` (`BattGroupId`) USING BTREE," +
" KEY `index_station_id` (`StationId`)," +
@@ -1173,6 +1174,16 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ " ADD COLUMN `NomCapAH` float NOT NULL DEFAULT '0' COMMENT '标称容量[AH]';");
}
+ res = null;
+ //添加LoadCurrFromDis ---- 负载电流-[来源核容放电数据]
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='LoadCurrFromDis'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ + " ADD COLUMN `LoadCurrFromDis` float NOT NULL DEFAULT '0' COMMENT '负载电流-[来源核容放电数据]';");
+ }
//设置column 去掉默认NOT NULL
{
--
Gitblit v1.9.1