~whyclj/BattMonitor_DB_Builder.git

parent: 700199e9 | 补丁 | 提交 | show whitespace

5.'db_alarm.tb_devalarm_data'新增告警重要等级 `alm_severity` int(11) NOT NULL DEF...

Administrator

2023-06-14 07b21c8d224f7930a894b1e1bd468195a181df8c

5.'db_alarm.tb_devalarm_data'新增告警重要等级
		`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT
'告警重要等级[0:重要；1:紧急]'

	6.'db_alarm.tb_devalarm_data_history'新增告警重要等级
		`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT
'告警重要等级[0:重要；1:紧急]'

4个文件已修改

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

 BattMonitor_DB_Builder/bin/com/database_util/DB_Alarm.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -17,9 +17,15 @@
    3.'db_alarm.tb_battalarm_data'新增告警重要等级
        `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'
        
    3.'db_alarm.tb_battalarm_data_history'新增告警重要等级
    4.'db_alarm.tb_battalarm_data_history'新增告警重要等级
        `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]',
    
    5.'db_alarm.tb_devalarm_data'新增告警重要等级
        `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'
	
    6.'db_alarm.tb_devalarm_data_history'新增告警重要等级
        `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；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 

 BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java

@@ -68,6 +68,7 @@
                "  alm_confirmed_time datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + 
                "  alm_cleared_type int(11) NOT NULL DEFAULT '0'," + 
                "  usr_Id int(11) NOT NULL DEFAULT '0'," + 
                "  `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]'," + 
                "  PRIMARY KEY (num)," + 
                "  KEY index_record_id (record_id)," + 
                "  KEY index_dev_id (dev_id)," + 
@@ -91,6 +92,15 @@
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data__History_Table 
                                + " ADD COLUMN alm_value float NOT NULL DEFAULT '0';");
            }
            //添加指定的alm_severity列'告警重要等级[0:重要；1:紧急]'
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_alarm'"
                    + " AND table_name='tb_devalarm_data_history'"
                    + " AND column_name='alm_severity'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data__History_Table 
                        + " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]';");
            }
        } catch (SQLException e) {
            e.printStackTrace();
@@ -127,6 +137,7 @@
                "  alm_confirmed_time datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + 
                "  alm_cleared_type int(11) NOT NULL DEFAULT '0'," + 
                "  usr_Id int(11) NOT NULL DEFAULT '0'," + 
                "  `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]'," + 
                "  PRIMARY KEY (num)," + 
                "  KEY index_record_id (record_id)," + 
                "  KEY index_dev_id (dev_id)," + 
@@ -172,6 +183,16 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data_Table 
                                + " ADD COLUMN `msg_flag` tinyint NOT NULL DEFAULT 0;");
            }
            res = null;
            //添加指定的alm_severity列(告警重要等级[0:重要；1:紧急])
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_alarm'"
                    + " AND table_name='tb_devalarm_data'"
                    + " AND column_name='alm_severity'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data_Table 
                        + " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]';");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -17,9 +17,15 @@
    3.'db_alarm.tb_battalarm_data'新增告警重要等级
        `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'
        
    3.'db_alarm.tb_battalarm_data_history'新增告警重要等级
    4.'db_alarm.tb_battalarm_data_history'新增告警重要等级
        `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]',
    
    5.'db_alarm.tb_devalarm_data'新增告警重要等级
        `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'
	
    6.'db_alarm.tb_devalarm_data_history'新增告警重要等级
        `alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；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

			@@ -17,9 +17,15 @@
			3.'db_alarm.tb_battalarm_data'新增告警重要等级
			`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'

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

			5.'db_alarm.tb_devalarm_data'新增告警重要等级
			`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；1:紧急]'

			6.'db_alarm.tb_devalarm_data_history'新增告警重要等级
			`alm_severity` int(11) NOT NULL DEFAULT '0' COMMENT '告警重要等级[0:重要；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

			@@ -68,6 +68,7 @@
			" alm_confirmed_time datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
			" alm_cleared_type int(11) NOT NULL DEFAULT '0'," +
			" usr_Id int(11) NOT NULL DEFAULT '0'," +
			" `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]'," +
			" PRIMARY KEY (num)," +
			" KEY index_record_id (record_id)," +
			" KEY index_dev_id (dev_id)," +
			@@ -91,6 +92,15 @@
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data__History_Table
			+ " ADD COLUMN alm_value float NOT NULL DEFAULT '0';");
			}
			//添加指定的alm_severity列'告警重要等级[0:重要；1:紧急]'
			res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
			+ " WHERE table_schema='db_alarm'"
			+ " AND table_name='tb_devalarm_data_history'"
			+ " AND column_name='alm_severity'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data__History_Table
			+ " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]';");
			}
			} catch (SQLException e) {
			e.printStackTrace();
			@@ -127,6 +137,7 @@
			" alm_confirmed_time datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
			" alm_cleared_type int(11) NOT NULL DEFAULT '0'," +
			" usr_Id int(11) NOT NULL DEFAULT '0'," +
			" `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]'," +
			" PRIMARY KEY (num)," +
			" KEY index_record_id (record_id)," +
			" KEY index_dev_id (dev_id)," +
			@@ -172,6 +183,16 @@
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data_Table
			+ " ADD COLUMN `msg_flag` tinyint NOT NULL DEFAULT 0;");
			}
			res = null;
			//添加指定的alm_severity列(告警重要等级[0:重要；1:紧急])
			res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
			+ " WHERE table_schema='db_alarm'"
			+ " AND table_name='tb_devalarm_data'"
			+ " AND column_name='alm_severity'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data_Table
			+ " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]';");
			}
			} catch (SQLException e) {
			e.printStackTrace();
			} finally {