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/sql/Sql_Mysql.java | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java index 1a39a7d..d714f6b 100644 --- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java +++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java @@ -244,6 +244,7 @@ public static final String Tb_Workflow_Link_Table = WEB_Site +".`tb_workflow_link`"; //工作流节点表 public static final String Tb_Workflow_Main_Table = WEB_Site +".`tb_workflow_main`"; //工作流主表 + public static final String Tb_Fault_Upload_Table = WEB_Site +".`tb_fault_upload`"; //故障隐患上传表,用于故障隐患考核 /***************************** db_battinf数据库 ***************************************/ public final static String DeverrorRecord_Table = DB_BATT_INF + ".`tb_deverror_record`"; //机房问题记录表 -- Gitblit v1.9.1