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/database_util/DB_web_site.java | 39 ++++++++++++++++++++++++++++++++++++++-
1 files changed, 38 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
index 6b89a8b..b0669f4 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
@@ -4870,12 +4870,49 @@
" PRIMARY KEY (`id`)" +
") ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='告警语音设置';";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+
+ ResultSet rs = null;
try {
if(true == recreate) {
//sql.sqlMysqlExecute(sql_str01);
//sql.sqlMysqlExecute(sql_str02);
}
- sql.sqlMysqlExecute(sql_str02);
+ sql.sqlMysqlExecute(sql_str02);
+
+ /************************** 添加 user_id 字段 **************************************/
+ String sql_str03 = " SELECT * FROM information_schema.columns "
+ + " WHERE table_schema= 'web_site' "
+ + " AND table_name='tb_alarm_voice_set' "
+ + " AND column_name='user_id'";
+ rs = sql.sqlMysqlQuery(sql_str03);
+ if(false == rs.next()) {
+ sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.Tb_Alarm_Voice_Set_Table
+ + " ADD COLUMN `user_id` int(11) DEFAULT NULL;");
+ }
+ /************************** 添加 status 字段 **************************************/
+ rs = null;
+ sql_str03 = " SELECT * FROM information_schema.columns "
+ + " WHERE table_schema= 'web_site' "
+ + " AND table_name='tb_alarm_voice_set' "
+ + " AND column_name='status'";
+ rs = sql.sqlMysqlQuery(sql_str03);
+ if(false == rs.next()) {
+ sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.Tb_Alarm_Voice_Set_Table
+ + " ADD COLUMN `status` int(11) DEFAULT NULL COMMENT '1:有效\\n0:无效\\n';");
+ }
+ /************************** 添加 next_timestamp 字段 **************************************/
+ rs = null;
+ sql_str03 = " SELECT * FROM information_schema.columns "
+ + " WHERE table_schema= 'web_site' "
+ + " AND table_name='tb_alarm_voice_set' "
+ + " AND column_name='next_timestamp'";
+ rs = sql.sqlMysqlQuery(sql_str03);
+ if(false == rs.next()) {
+ sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.Tb_Alarm_Voice_Set_Table
+ + " ADD COLUMN `next_timestamp` bigint(20) DEFAULT NULL COMMENT '下次播放的时间戳';");
+ }
+
+
} catch (SQLException e) {
e.printStackTrace();
--
Gitblit v1.9.1