From 65ba5339b9aba17751b4136caad2d1518a54197b Mon Sep 17 00:00:00 2001 From: Administrator <1525436766@qq.com> Date: 星期五, 13 一月 2023 13:54:05 +0800 Subject: [PATCH] V1.50 edit at date 2023-01-13 1.'web_site.tb_alarm_voice_set'--告警语音设置表单独判断如下数据表字段是否存在并创建 `user_id` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL COMMENT '1:有效\n0:无效\n', `next_timestamp` bigint(20) DEFAULT NULL COMMENT '下次播放的时间戳', 2.新建表'db_pwrdev_alarm.tb_pwrdev_alarm_config' CREATE TABLE `tb_pwrdev_alarm_config` ( `num` bigint(20) NOT NULL AUTO_INCREMENT, `SMS_CommPort` varchar(10) NOT NULL DEFAULT ' ', `SMS_CommPort_ReInit` tinyint(1) NOT NULL DEFAULT '0', `Beeper_CommPort` varchar(10) NOT NULL DEFAULT ' ', `Beeper_CommPort_ReInit` tinyint(1) NOT NULL DEFAULT '0', `SMS_Alarm_Text` varchar(100) NOT NULL DEFAULT ' ', `SMS_Alarm_EN` tinyint(1) NOT NULL DEFAULT '0', `Beeper_Alarm_EN` tinyint(1) NOT NULL DEFAULT '0', `Beeper_Sound_OFF` tinyint(1) NOT NULL DEFAULT '0', `AlarmDevIP` varchar(30) NOT NULL DEFAULT '192.168.10.223', `SMS_Alarm_ipPort` int(11) NOT NULL DEFAULT '26', `Beeper_Alarm_ipPort` int(11) NOT NULL DEFAULT '27', PRIMARY KEY (`num`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; 3.新建表'db_pwrdev_alarm.tb_pwrdev_time_adj_alarm' CREATE TABLE `tb_pwrdev_time_adj_alarm` ( `num` bigint(20) NOT NULL AUTO_INCREMENT, `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0', `alarm_typeId` int(11) NOT NULL DEFAULT '0', `detect_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00', `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00', PRIMARY KEY (`num`), KEY `index_powerdev_id` (`PowerDeviceId`) ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8; 4.新建表'db_pwrdev_alarm.tb_pwrdev_time_out_alarm' CREATE TABLE `tb_pwrdev_time_out_alarm` ( `num` bigint(20) NOT NULL AUTO_INCREMENT, `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0', `alarm_typeId` int(11) NOT NULL DEFAULT '0', `alarm_index` int(11) NOT NULL DEFAULT '0', `timeout_tag` int(11) NOT NULL DEFAULT '0', `read_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00', `system_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00', `resume_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00', PRIMARY KEY (`num`), KEY `index_powerdev_id` (`PowerDeviceId`) ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8; --- BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 3 +++ 1 files changed, 3 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 ad2b003..a701fba 100644 --- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java +++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java @@ -304,6 +304,9 @@ public final static String Pwrdev_Alarm_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_alarm`"; public final static String Pwrdev_Alarm_History_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_alarm_history`"; public final static String Pwrdev_Alarm_Param_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_alarm_param`"; + public final static String Pwrdev_Alarm_Config_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_alarm_config`"; + public final static String Pwrdev_Time_Adj_Alarm_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_time_adj_alarm`"; + public final static String Pwrdev_Time_Out_Alarm_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_time_out_alarm`"; -- Gitblit v1.9.1