From 483b1454098287dd6cebf1ea7ed69e9619ec75a0 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期三, 29 三月 2023 09:21:28 +0800
Subject: [PATCH] CREATE TABLE `tb_battdischarge_plan_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `plan_id` int(11) DEFAULT NULL COMMENT '放电计划表主键num', `type` tinyint(4) DEFAULT NULL COMMENT '1-取消计划,2-启动计划,3-修改放电参数,4-修改放电开始时间', `reason` varchar(255) DEFAULT NULL COMMENT '更新原因', `msg` varchar(255) DEFAULT NULL COMMENT '变更前后变化描述', `user_id` int(11) DEFAULT NULL, `create_time` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='放电计划日志表';
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 49 ++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 48 insertions(+), 1 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 3f71d97..379ef24 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
@@ -86,8 +86,10 @@
createTB_Worksheet_Main_Table(pool, recreate);
createTb_Alarm_Voice_Set_Table(pool, recreate);
-
+
createBattdischarge_Plan_Temp_Table(pool,recreate); //创建放电计划临时表
+
+ createBattdischarge_Plan_Log_Table(pool, recreate); //创建放电计划日志表
System.out.println(" DB_web_site init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
}
@@ -4692,9 +4694,11 @@
" `approve_status` tinyint(1) DEFAULT NULL COMMENT '0:待审核,1:审核通过,2:审核拒绝'," +
" `approve_time` datetime DEFAULT NULL," +
" `approve_user_id` int(11) DEFAULT NULL," +
+ " `approve_reason` varchar(255) DEFAULT NULL COMMENT '审核原因'," +
" PRIMARY KEY (`id`)" +
") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='放电计划临时表';";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ ResultSet res = null;
try {
if(true == recreate) {
//sql.sqlMysqlExecute(sql_str01);
@@ -4703,9 +4707,26 @@
}
sql.sqlMysqlExecute(sql_str02); //创建放电计划临时表
+
+ //添加approve_reason 创建时间
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='web_site'"
+ + " AND table_name='tb_battdischarge_plan_temp'"
+ + " AND column_name='approve_reason'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Battdischarge_Plan_Temp_Table
+ + " ADD COLUMN `approve_reason` varchar(255) DEFAULT NULL COMMENT '审核原因';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
+ if(null != res) {
+ try {
+ res.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
sql.close_con();
}
}
@@ -4737,6 +4758,32 @@
}
}
+ /**
+ * 创建放电计划日志表
+ * @param pool
+ * @param recreate
+ */
+ private static void createBattdischarge_Plan_Log_Table(MysqlConnPool pool, boolean recreate) {
+ String str_str = "CREATE TABLE IF NOT EXISTS "+Sql_Mysql.Tb_Battdischarge_Plan_Log_Table+" (" +
+ " `id` int(11) NOT NULL AUTO_INCREMENT," +
+ " `plan_id` int(11) DEFAULT NULL COMMENT '放电计划表主键num'," +
+ " `type` tinyint(4) DEFAULT NULL COMMENT '1-取消计划,2-启动计划,3-修改放电参数,4-修改放电开始时间'," +
+ " `reason` varchar(255) DEFAULT NULL COMMENT '更新原因'," +
+ " `msg` varchar(255) DEFAULT NULL COMMENT '变更前后变化描述'," +
+ " `user_id` int(11) DEFAULT NULL COMMENT '用户id'," +
+ " `create_time` datetime DEFAULT NULL COMMENT '记录时间'," +
+ " PRIMARY KEY (`id`)" +
+ ") ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='放电计划日志表';";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ sql.sqlMysqlExecute(str_str);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+
+ }
/**
--
Gitblit v1.9.1