From 90a18e3d1d2611e799d4a8481a50be5fb7409db4 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期五, 17 三月 2023 15:51:41 +0800
Subject: [PATCH] V1.61 edit at date 2023-03-16 1.'web_site.tb_battdischarge_plan'表新增字段'nodeStation' `nodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '站点类型[节点站标识:0:不是节点站[默认];1:节点站]' 2.'web_site.tb_battdischarge_plan'表新增字段'baoji_group_id' `baoji_group_id` int(11) NOT NULL DEFAULT '0' COMMENT '包机组id'
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
index cd96c8b..8209173 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
@@ -4585,6 +4585,8 @@
" `preset_curr` float NOT NULL DEFAULT '0'," +
" `dcvolhighlimit` float NOT NULL DEFAULT '0'," +
" `chargecurrset` float NOT NULL DEFAULT '0'," +
+ " `nodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '站点类型[节点站标识:0:不是节点站[默认];1:节点站]'," +
+ " `baoji_group_id` int(11) NOT NULL DEFAULT '0' COMMENT '包机组id'," +
" PRIMARY KEY (`num`)," +
" KEY `index_num` (`num`)" +
") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
@@ -4625,6 +4627,25 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattDischargePlan_Table
+ " ADD COLUMN `already_count` int NOT NULL DEFAULT '0';");
}
+
+ //添加站点类型[节点站标识:0:不是节点站[默认];1:节点站]
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='web_site'"
+ + " AND table_name='tb_battdischarge_plan'"
+ + " AND column_name='nodeStation'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattDischargePlan_Table
+ + " ADD COLUMN `nodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '站点类型[节点站标识:0:不是节点站[默认];1:节点站]';");
+ }
+ //添加baoji_group_id 包机组id
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='web_site'"
+ + " AND table_name='tb_battdischarge_plan'"
+ + " AND column_name='baoji_group_id'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattDischargePlan_Table
+ + " ADD COLUMN `baoji_group_id` int(11) NOT NULL DEFAULT '0' COMMENT '包机组id';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1