From 7514f426c53f533740519e4e40d0132b53ab5692 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期五, 12 五月 2023 17:30:08 +0800
Subject: [PATCH] V1.72 edit at date 2023-05-12 1.新增表'web_site.tb_fault_upload' ---故障隐患上传表 CREATE TABLE `tb_fault_upload` ( `id` int(11) NOT NULL AUTO_INCREMENT, `station_name` varchar(500) DEFAULT NULL, `type` int(11) DEFAULT NULL, `description` varchar(500) DEFAULT NULL, `upload_user_id` int(11) DEFAULT NULL, `confirm_user_id` int(11) DEFAULT NULL, `confirm_description` varchar(500) DEFAULT NULL, `confirm_time` datetime DEFAULT NULL, `status` tinyint(4) DEFAULT NULL COMMENT '0:待确认,1确认属实,-1确认不属实', `create_time` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='故障隐患上传表,用于故障隐患考核';
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 34 ++++++++++++++++++++++++++++++++++
1 files changed, 34 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 b46bcfc..b03677d 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
@@ -97,6 +97,8 @@
createWorkflow_Main_Table(pool, recreate); //创建工作流主表
+ createFault_Upload_Table(pool, recreate); //故障隐患上传表
+
System.out.println(" DB_web_site init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
}
@@ -5469,6 +5471,38 @@
sql.close_con();
}
}
+ /**
+ * 故障隐患上传表
+ * @param pool
+ * @param recreate
+ */
+ public static void createFault_Upload_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str_del = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Fault_Upload_Table;
+ String sql_str = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Fault_Upload_Table + " (" +
+ " `id` int(11) NOT NULL AUTO_INCREMENT," +
+ " `station_name` varchar(500) DEFAULT NULL," +
+ " `type` int(11) DEFAULT NULL," +
+ " `description` varchar(500) DEFAULT NULL," +
+ " `upload_user_id` int(11) DEFAULT NULL," +
+ " `confirm_user_id` int(11) DEFAULT NULL," +
+ " `confirm_description` varchar(500) DEFAULT NULL," +
+ " `confirm_time` datetime DEFAULT NULL," +
+ " `status` tinyint(4) DEFAULT NULL COMMENT '0:待确认,1确认属实,-1确认不属实'," +
+ " `create_time` datetime DEFAULT NULL," +
+ " PRIMARY KEY (`id`)" +
+ ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='故障隐患上传表,用于故障隐患考核';";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ if(recreate) {
+ sql.sqlMysqlExecute(sql_str_del);
+ }
+ sql.sqlMysqlExecute(sql_str);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
/**
--
Gitblit v1.9.1