From c74abef816c15953e1699ec1e3efa665c05ea566 Mon Sep 17 00:00:00 2001
From: whycrzg <ruanzhigang@whycst.com>
Date: 星期一, 06 九月 2021 17:27:53 +0800
Subject: [PATCH] db_user库新建表tb_user_work、tb_work_alarm,db_alarm数据库中新建表`tb_alarm_message`
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 72 +++++++++++++++++++++++++++++++++++
1 files changed, 71 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
index f7b2ebf..6e2e937 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
@@ -58,7 +58,11 @@
createUser_Limit_Table(pool, recreate);
createUser_Log_Table(pool, recreate);
-
+
+ createTb_User_Work(pool, recreate);
+
+ createTb_Work_Alarm(pool, recreate);
+
}
/**
@@ -1032,4 +1036,70 @@
sql.close_con();
}
}
+
+ public static void createTb_User_Work(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_User_Work;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_User_Work + " (" +
+ " `id` int(11) NOT NULL AUTO_INCREMENT,\n" +
+ " `workId` int(11) NULL DEFAULT NULL,\n" +
+ " `userId` int(11) NULL DEFAULT NULL COMMENT '维护员id',\n" +
+ " `imageBefore` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处理前照片',\n" +
+ " `imageAfter` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处理后照片',\n" +
+ " `workWay` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处理办法',\n" +
+ " `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '告警描述',\n" +
+ " `workSuggest` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '建议',\n" +
+ " `managerId` int(11) NULL DEFAULT NULL COMMENT '管理员审核',\n" +
+ " `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核意见',\n" +
+ " `createTime` datetime NULL DEFAULT NULL COMMENT '创建时间-接单时间',\n" +
+ " `endTime` datetime NULL DEFAULT NULL COMMENT '结束时间',\n" +
+ " `checkStatus` tinyint(4) NULL DEFAULT NULL COMMENT '审核状态',\n" +
+ " `checkedTime` datetime NULL DEFAULT NULL COMMENT '审核时间',\n" +
+ " PRIMARY KEY (`id`) USING BTREE" +
+ ") ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 ROW_FORMAT = Dynamic;";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ if(true == recreate) {
+ sql.sqlMysqlExecute(sql_str01);
+ }
+ sql.sqlMysqlExecute(sql_str02);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+
+ public static void createTb_Work_Alarm(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Work_Alarm;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Work_Alarm + " (" +
+ " `id` int(11) NOT NULL AUTO_INCREMENT,\n" +
+ " `alarmRecId` int(11) NULL DEFAULT NULL COMMENT 'tb_battalarm_data的num',\n" +
+ " `alarmRecordId` bigint(20) NULL DEFAULT NULL COMMENT 'battalarm和devalarm的record_id',\n" +
+ " `stationId` int(11) NULL DEFAULT NULL COMMENT '站点机房id',\n" +
+ " `battGroupId` int(11) NULL DEFAULT NULL COMMENT 'tb_battalarm_data的BattGroupId',\n" +
+ " `deviceId` int(11) NULL DEFAULT NULL,\n" +
+ " `managerId` int(11) NULL DEFAULT NULL COMMENT '管理员id',\n" +
+ " `userId` int(11) NULL DEFAULT NULL COMMENT '维护员id',\n" +
+ " `status` tinyint(4) NULL DEFAULT NULL COMMENT '状态',\n" +
+ " `dispatchTime` datetime NULL DEFAULT NULL COMMENT '派单时间',\n" +
+ " `alarmLevel` tinyint(4) NULL DEFAULT NULL COMMENT '告警等级',\n" +
+ " `alarmName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '告警名称',\n" +
+ " `alarmTime` datetime NULL DEFAULT NULL,\n" +
+ " `createTime` datetime NULL DEFAULT NULL,\n" +
+ " PRIMARY KEY (`id`) USING BTREE,\n" +
+ " INDEX `idx_device_id`(`deviceId`) USING BTREE" +
+ ") ENGINE=InnoDB AUTO_INCREMENT=1447 DEFAULT CHARSET=utf8 ROW_FORMAT = Dynamic;";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ if(true == recreate) {
+ sql.sqlMysqlExecute(sql_str01);
+ }
+ sql.sqlMysqlExecute(sql_str02);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+
}
--
Gitblit v1.9.1