From 892edbb24686203df88fbf3d93d0c24f35c4868a Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期一, 27 三月 2023 08:58:12 +0800
Subject: [PATCH] 放电计划临时表字段更新
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 21 +++++++++++++--------
1 files changed, 13 insertions(+), 8 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 a1e40d0..b6a3a94 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
@@ -4671,18 +4671,23 @@
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Battdischarge_Plan_Temp_Table;
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Battdischarge_Plan_Temp_Table + " (" +
" `id` int(11) NOT NULL AUTO_INCREMENT," +
- " `station_id` varchar(20) DEFAULT NULL COMMENT '机房id'," +
- " `station_name` varchar(100) DEFAULT NULL COMMENT '机房名称'," +
- " `batt_group_id` int(11) DEFAULT NULL COMMENT '包机组id'," +
- " `batt_group_name` varchar(100) DEFAULT NULL COMMENT '电池组名称'," +
+ " `station_id` varchar(20) DEFAULT NULL," +
+ " `station_name` varchar(100) DEFAULT NULL," +
+ " `batt_group_id` int(11) DEFAULT NULL," +
+ " `batt_group_name` varchar(100) DEFAULT NULL," +
" `group_id` bigint(20) DEFAULT NULL COMMENT '班组id,与包机组一致'," +
" `group_name` varchar(200) DEFAULT NULL COMMENT '班组名称,与包机组一致'," +
" `node_station` tinyint(1) DEFAULT NULL COMMENT '是否节点站'," +
- " `mon_cap_std` float DEFAULT NULL COMMENT '标称容量'," +
- " `mon_vol_std` float DEFAULT NULL COMMENT '标称单体电压'," +
+ " `mon_cap_std` float DEFAULT NULL," +
+ " `mon_vol_std` float DEFAULT NULL," +
" `cap_percent` float DEFAULT NULL COMMENT '放电容量百分比'," +
- " `discharge_start_time` datetime DEFAULT NULL COMMENT '放电开始时间'," +
- " `create_time` datetime DEFAULT NULL COMMENT '创建时间'," +
+ " `discharge_start_time` datetime DEFAULT NULL," +
+ " `create_time` datetime DEFAULT NULL," +
+ " `create_user_id` int(11) DEFAULT NULL," +
+ " `submit_status` tinyint(1) DEFAULT NULL COMMENT '0:未提交,1:已提交'," +
+ " `approve_status` tinyint(1) DEFAULT NULL COMMENT '0:待审核,1:审核通过,2:审核拒绝'," +
+ " `approve_time` datetime DEFAULT NULL," +
+ " `approve_user_id` int(11) DEFAULT NULL," +
" PRIMARY KEY (`id`)" +
") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='放电计划临时表';";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
--
Gitblit v1.9.1