~whyclj/BattMonitor_DB_Builder.git

parent: 717dcf5e | 补丁 | 提交 | show whitespace

2.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增字段 `alarm_limitH_upper` f...

Administrator

2023-06-09 358ae8bb194bde152b62b492adfaf743b0ef45c8

2.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增字段
		`alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '告警上上限阈值',
		`alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '告警下下限阈值',

	3.db_pwrdev_alarm.tb_pwrdev_alarm 新增字段
		`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT
'告警重要等级[0:重要；1:紧急]',

	4.db_pwrdev_alarm.tb_pwrdev_alarm_history 新增字段
		`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT
'告警重要等级[0:重要；1:紧急]',

4个文件已修改

	BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Alarm.class	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt	12 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java	43 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt	12 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Alarm.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -1,10 +1,22 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
    

	
V1.77 edit at date 2023-06-09
    1.修复创建表'db_alarm.tb_alarm_relation'初始化表中字段错误bug
        sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.Tb_Alarm_Relation_Table 
                          + " CHANGE  alm_ponit alm_point varchar(255) DEFAULT '' COMMENT '告警点';");    
    2.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增字段
        `alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '告警上上限阈值',
        `alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '告警下下限阈值',

    3.db_pwrdev_alarm.tb_pwrdev_alarm 新增字段
        `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]',

    4.db_pwrdev_alarm.tb_pwrdev_alarm_history 新增字段
        `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]',					  
		
    
V1.76 edit at date 2023-05-31
    1.修复'db_user.tb_user_log'表新增2列无法添加,运行时默认删除30天之前的操作日志

 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java

@@ -181,6 +181,7 @@
                "  `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," + 
                "  `usr_Id` int(11) NOT NULL DEFAULT '0'," + 
                "  `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]'," + 
                "  `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'," + 
                "  PRIMARY KEY (`num`)," + 
                "  KEY `index_record_id` (`record_id`)," + 
                "  KEY `index_pwrdev_id` (`PowerDeviceId`)," + 
@@ -225,6 +226,16 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table 
                        + " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'");
            }
            res = null;
            //添加 alm_severity  告警重要等级[0:重要；1:紧急]
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_pwrdev_alarm'"
                    + " AND table_name='tb_pwrdev_alarm'"
                    + " AND column_name='alm_severity'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table 
                        + " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
@@ -255,6 +266,7 @@
                "  `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," + 
                "  `usr_Id` int(11) NOT NULL DEFAULT '0'," + 
                "  `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'," + 
                "  `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'," + 
                "  PRIMARY KEY (`num`)," + 
                "  KEY `index_record_id` (`record_id`)," + 
                "  KEY `index_pwrdev_id` (`PowerDeviceId`)," + 
@@ -299,6 +311,15 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table 
                        + " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'");
            }
            //添加 alm_severity -- 告警重要等级[0:重要；1:紧急]
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_pwrdev_alarm'"
                    + " AND table_name='tb_pwrdev_alarm_history'"
                    + " AND column_name='alm_severity'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table 
                        + " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
@@ -321,6 +342,8 @@
                "  `alarm_name` varchar(255) NOT NULL DEFAULT '' COMMENT '当前告警描述'," + 
                "  `alarm_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-上下限有效  1-上限有效  2-下限有效'," + 
                "  `alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '告警来源是点位时告警使能[0:不启用；1：启用]'," + 
                "  `alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '告警上上限阈值'," + 
                "  `alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '告警下下限阈值'," + 
                "  PRIMARY KEY (`num`)" + 
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表';";
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());
@@ -340,6 +363,26 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table 
                        + " ADD COLUMN `alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '告警来源是点位时告警使能[0:不启用；1：启用]';");
            }
            res = null;
            //添加 alarm_limitH_upper -- 告警上上限阈值
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_pwrdev_alarm'"
                    + " AND table_name='tb_pwrdev_alarm_param_forsx'"
                    + " AND column_name='alarm_limitH_upper'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table 
                        + " ADD COLUMN `alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '告警上上限阈值';");
            }
            res = null;
            //添加 alarm_limitL_lower -- 告警下下限阈值
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_pwrdev_alarm'"
                    + " AND table_name='tb_pwrdev_alarm_param_forsx'"
                    + " AND column_name='alarm_limitL_lower'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table 
                        + " ADD COLUMN `alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '告警下下限阈值';");
            }
            
            
            res = sql.sqlMysqlQuery("SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Inf_Table);

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -1,10 +1,22 @@
蓄电池监控平台建表程序
    注意:1.新增电源机房时需要重新运行
    

	
V1.77 edit at date 2023-06-09
    1.修复创建表'db_alarm.tb_alarm_relation'初始化表中字段错误bug
        sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.Tb_Alarm_Relation_Table 
                          + " CHANGE  alm_ponit alm_point varchar(255) DEFAULT '' COMMENT '告警点';");    
    2.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增字段
        `alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '告警上上限阈值',
        `alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '告警下下限阈值',

    3.db_pwrdev_alarm.tb_pwrdev_alarm 新增字段
        `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]',

    4.db_pwrdev_alarm.tb_pwrdev_alarm_history 新增字段
        `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]',					  
		
    
V1.76 edit at date 2023-05-31
    1.修复'db_user.tb_user_log'表新增2列无法添加,运行时默认删除30天之前的操作日志

			@@ -1,10 +1,22 @@
			蓄电池监控平台建表程序
			注意:1.新增电源机房时需要重新运行



			V1.77 edit at date 2023-06-09
			1.修复创建表'db_alarm.tb_alarm_relation'初始化表中字段错误bug
			sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.Tb_Alarm_Relation_Table
			+ " CHANGE alm_ponit alm_point varchar(255) DEFAULT '' COMMENT '告警点';");
			2.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增字段
			`alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '告警上上限阈值',
			`alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '告警下下限阈值',

			3.db_pwrdev_alarm.tb_pwrdev_alarm 新增字段
			`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]',

			4.db_pwrdev_alarm.tb_pwrdev_alarm_history 新增字段
			`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]',


			V1.76 edit at date 2023-05-31
			1.修复'db_user.tb_user_log'表新增2列无法添加,运行时默认删除30天之前的操作日志

			@@ -181,6 +181,7 @@
			" `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," +
			" `usr_Id` int(11) NOT NULL DEFAULT '0'," +
			" `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警来源[0-来源于点表；1-来源于电源告警参数]'," +
			" `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'," +
			" PRIMARY KEY (`num`)," +
			" KEY `index_record_id` (`record_id`)," +
			" KEY `index_pwrdev_id` (`PowerDeviceId`)," +
			@@ -225,6 +226,16 @@
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table
			+ " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'");
			}
			res = null;
			//添加 alm_severity 告警重要等级[0:重要；1:紧急]
			res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
			+ " WHERE table_schema='db_pwrdev_alarm'"
			+ " AND table_name='tb_pwrdev_alarm'"
			+ " AND column_name='alm_severity'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table
			+ " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'");
			}
			} catch (SQLException e) {
			e.printStackTrace();
			} finally {
			@@ -255,6 +266,7 @@
			" `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," +
			" `usr_Id` int(11) NOT NULL DEFAULT '0'," +
			" `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'," +
			" `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'," +
			" PRIMARY KEY (`num`)," +
			" KEY `index_record_id` (`record_id`)," +
			" KEY `index_pwrdev_id` (`PowerDeviceId`)," +
			@@ -299,6 +311,15 @@
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
			+ " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '告警触发来源[0-来源于点表；1-来源于电源告警参数]'");
			}
			//添加 alm_severity -- 告警重要等级[0:重要；1:紧急]
			res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
			+ " WHERE table_schema='db_pwrdev_alarm'"
			+ " AND table_name='tb_pwrdev_alarm_history'"
			+ " AND column_name='alm_severity'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
			+ " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'");
			}
			} catch (SQLException e) {
			e.printStackTrace();
			} finally {
			@@ -321,6 +342,8 @@
			" `alarm_name` varchar(255) NOT NULL DEFAULT '' COMMENT '当前告警描述'," +
			" `alarm_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-上下限有效 1-上限有效 2-下限有效'," +
			" `alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '告警来源是点位时告警使能[0:不启用；1：启用]'," +
			" `alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '告警上上限阈值'," +
			" `alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '告警下下限阈值'," +
			" PRIMARY KEY (`num`)" +
			") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表';";
			Sql_Mysql sql = new Sql_Mysql(pool.getConn());
			@@ -340,6 +363,26 @@
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
			+ " ADD COLUMN `alarm_en_node` int(4) NOT NULL DEFAULT '1' COMMENT '告警来源是点位时告警使能[0:不启用；1：启用]';");
			}
			res = null;
			//添加 alarm_limitH_upper -- 告警上上限阈值
			res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
			+ " WHERE table_schema='db_pwrdev_alarm'"
			+ " AND table_name='tb_pwrdev_alarm_param_forsx'"
			+ " AND column_name='alarm_limitH_upper'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
			+ " ADD COLUMN `alarm_limitH_upper` float NOT NULL DEFAULT '200' COMMENT '告警上上限阈值';");
			}
			res = null;
			//添加 alarm_limitL_lower -- 告警下下限阈值
			res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
			+ " WHERE table_schema='db_pwrdev_alarm'"
			+ " AND table_name='tb_pwrdev_alarm_param_forsx'"
			+ " AND column_name='alarm_limitL_lower'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
			+ " ADD COLUMN `alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '告警下下限阈值';");
			}


			res = sql.sqlMysqlQuery("SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Inf_Table);