From d436fcee8e8aab3edd3215497e3760b9f661aeb5 Mon Sep 17 00:00:00 2001 From: Administrator <1525436766@qq.com> Date: 星期四, 08 十二月 2022 10:20:13 +0800 Subject: [PATCH] 2.新增告警详情表'db_alarm.tb_alarm_detail'-告警详情 CREATE TABLE `tb_alarm_detail` ( `id` bigint(19) NOT NULL AUTO_INCREMENT, `alm_id` varchar(15) DEFAULT NULL COMMENT '告警id', `alm_reason` text COMMENT '告警原因', `alm_advice` varchar(255) DEFAULT NULL COMMENT '告警建议', `alm_type` int(5) NOT NULL DEFAULT '0' COMMENT '告警来源：0电源，1设备，2电池', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 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 13023a0..2139954 100644 --- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java +++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java @@ -259,6 +259,7 @@ 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`"; + public final static String Tb_Alarm_Detail_Table = DB_ALARM + ".`tb_alarm_detail`"; /***************************** db_app_sys 数据库 ***************************************/ -- Gitblit v1.9.1