From cd89d5beaee8783c105bcfd1745b317a207ddbf8 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期六, 09 四月 2022 15:54:38 +0800
Subject: [PATCH] V2.18 edit at date 2022-04-09 1.修改表`db_battinf`.`tb_battinf`表新增字段-->用于标识当前新疆锂电BTS包的数量 `PackCount` int DEFAULT '1' COMMENT '锂电池包数量'
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 14 +++++++++++++-
1 files changed, 13 insertions(+), 1 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 83bfa19..2c96e38 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -642,6 +642,7 @@
" `buscouple_state` int(11) DEFAULT '0' COMMENT '母联状态：0：无母联；1:有母联'," +
" `tmp_id` int(11) DEFAULT '0'," +
" `price_factor` float DEFAULT '1' COMMENT '电价系数'," +
+ " `PackCount` int DEFAULT '1' COMMENT '锂电池包数量'," +
" PRIMARY KEY (`num`)," +
" UNIQUE KEY `index_battgroup_id` (`BattGroupId`) USING BTREE," +
" KEY `index_station_id` (`StationId`)," +
@@ -947,6 +948,17 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ " ADD COLUMN `price_factor` float DEFAULT '1' COMMENT '电价系数';");
}
+
+ //添加PackCount锂电池包数量-新疆锂电BTS时新增
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='PackCount'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ + " ADD COLUMN `PackCount` int DEFAULT '1' COMMENT '锂电池包数量';");
+ }
+
//添加sort_id
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_battinf'"
@@ -954,7 +966,7 @@
+ " AND column_name='sort_id'");
if(false == res.next()) {
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
- + " ADD COLUMN `sort_id` float DEFAULT '1' COMMENT '电价系数';");
+ + " ADD COLUMN `sort_id` float DEFAULT '1' COMMENT '';");
}
//设置column 去掉默认NOT NULL
--
Gitblit v1.9.1