| BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
@@ -21,6 +21,8 @@ createDevalarm_Data_Table(pool, recreate); createTb_Alarm_Message(pool, recreate); } @@ -280,4 +282,43 @@ sql.close_con(); } } /** * * @Title: createTb_Alarm_Message * @Description: 告警短信 * @param pool * @param recreate * @author author * @date 2021年9月6日 */ public static void createTb_Alarm_Message(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Alarm_Message; String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Alarm_Message + " (" + "`id` bigint(19) NOT NULL AUTO_INCREMENT,\n" + " `phone` varchar(15) DEFAULT NULL COMMENT '短信发送至手机号',\n" + " `full_device_name` varchar(255) DEFAULT NULL COMMENT '设备全名',\n" + " `alarm_time_category` varchar(255) DEFAULT NULL COMMENT '告警时间段',\n" + " `alarm_message` varchar(255) DEFAULT NULL COMMENT '告警信息',\n" + " `alarm_ids` varchar(255) DEFAULT NULL COMMENT '短信对应的告警id',\n" + " `create_time` datetime DEFAULT NULL,\n" + " `update_time` datetime DEFAULT NULL COMMENT '记录更新时间',\n" + " `status` tinyint(1) DEFAULT NULL COMMENT '发送状态,0-未发送,1-发送完成,2-发送失败',\n" + " PRIMARY KEY (`id`)" + ") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='告警短信';"; 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(); } } } BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
@@ -59,6 +59,10 @@ 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(); } } } BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -174,7 +174,8 @@ public final static String User_Battgroup_Baojigroup_Battgroup_Table = DB_USER + ".`tb_user_battgroup_baojigroup_battgroup`"; // public final static String User_Battgroup_Baojigroup_Table = DB_USER + ".`tb_user_battgroup_baojigroup`"; // public final static String User_Limit_Table = DB_USER + ".`tb_user_limit`"; // public static final String Tb_User_Work = DB_USER + ".`tb_user_work`"; public static final String Tb_Work_Alarm = DB_USER + ".`tb_work_alarm`"; @@ -228,6 +229,7 @@ public final static String Bts_Station_Event_Table = DB_ALARM + ".`tb_bts_station_event`"; public final static String Battalarm_Data_Table = DB_ALARM + ".`tb_battalarm_data`"; public final static String Battalarm_Data_History_Table = DB_ALARM + ".`tb_battalarm_data_history`"; public final static String Tb_Alarm_Message = DB_ALARM + ".`tb_alarm_message`"; /***************************** db_app_sys 数据库 ***************************************/ @@ -273,6 +275,7 @@ /***************************** db_fbo_testdata 数据库 ************************************/ public final static String Fbotestdata_Inf_Table = DB_FBO_TESTDATA + ".`tb_fbotestdata_inf`"; //--------------------------------------------------------------------------------------------// //--------------------------------------------------------------------------------------------// public Connection mysql_con; BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -219,3 +219,9 @@ V1.70 edit at date 2021-8-31 1：解决APP和平台界面告警派单功能，db_alarm数据库中`tb_battalarm_data`，`tb_devalarm_data` 数据库中均添加两个字段work_flag,msg_flag(‘tinyint’) V1.71 edit at date 2021-9-6 1：db_user库新建表tb_user_work、tb_work_alarm,db_alarm数据库中新建表`tb_alarm_message`
@@ -27,7 +27,7 @@ /**************************************************************************/ /**************************************************************************/ public final static boolean app_debug = false; public final static float m_VersionNum = (float) 1.69; public final static float m_VersionNum = (float) 1.71; public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908"; /**************************************************************************/ /**************************************************************************/
