From 760d3e49fedb974628bbd7e30f6daf4baf6962b8 Mon Sep 17 00:00:00 2001
From: whycrzg <ruanzhigang@whycst.com>
Date: 星期四, 11 十一月 2021 10:57:18 +0800
Subject: [PATCH] V1.91 edit at date 2021-11-11 1：修改`db_battinf`.`tb_battinf` 表下 新增字段 price_factor
---
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 6c9a6e6..664681c 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -641,6 +641,7 @@
" `charge_type` int(11) DEFAULT '1' COMMENT '充放电状态：1:限流充电；2；逆变充电'," +
" `buscouple_state` int(11) DEFAULT '0' COMMENT '母联状态：0：无母联；1:有母联'," +
" `tmp_id` int(11) DEFAULT '0'," +
+ " `price_factor` float DEFAULT '1' COMMENT '电价系数'," +
" PRIMARY KEY (`num`)," +
" UNIQUE KEY `index_battgroup_id` (`BattGroupId`) USING BTREE," +
" KEY `index_station_id` (`StationId`)," +
@@ -937,6 +938,16 @@
+ " ADD COLUMN `tmp_id` int(11) DEFAULT '0';");
}
+ //添加tmp_id
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='price_factor'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ + " ADD COLUMN `price_factor` float DEFAULT '1' COMMENT '电价系数';");
+ }
+
//设置column 去掉默认NOT NULL
{
--
Gitblit v1.9.1