2.'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'表新增上上限告警等级和下下限告警等级 `alar...

Administrator

2023-07-25 db4dbe5b723289678e54521c3d1152cece34f14c

2.'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'表新增上上限告警等级和下下限告警等级
  		`alarm_limitL_lower_level` int(11) NOT NULL DEFAULT '1' COMMENT
'下下限告警等级',
  		`alarm_limitH_upper_level` int(11) NOT NULL DEFAULT '1' COMMENT
'上上限告警等级',
  		`alarm_limitL_level` int(11) NOT NULL DEFAULT '1' COMMENT '下限告警等级',
		`alarm_limitH_level` int(11) NOT NULL DEFAULT '1' COMMENT '上限告警等级',

		原电源告警等级字段'alm_level' 弃用

	3.'db_battinf.tb_station_inf'表新增标识同一机房标识
		`together_flag` int(11) NOT NULL DEFAULT '0'

 BattMonitor_DB_Builder/bin/com/database_util/DB_battinf.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -13,6 +13,9 @@
        
        原电源告警等级字段'alm_level' 弃用
        
    3.'db_battinf.tb_station_inf'表新增标识同一机房标识
        `together_flag` int(11) NOT NULL DEFAULT '0'
		

    
V1.81 edit at date 2023-07-21

 BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java

@@ -651,14 +651,26 @@
                "  `stationLongitude` double NOT NULL DEFAULT '0' COMMENT '经度'," + 
                "  `stationLatitude` double NOT NULL DEFAULT '0' COMMENT '纬度'," + 
                "  `stationAddr` varchar(255) NOT NULL DEFAULT '' COMMENT '机房详细地址'," + 
                "  `together_flag` int(11) NOT NULL DEFAULT '0'," + 
                "  PRIMARY KEY (`num`)" + 
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='机房总站表  = 电池信息表 + 电源信息表 ';";
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());
        ResultSet res = null;
        try {
            if(true == recreate) {            
                //sql.sqlMysqlExecute(sql_str01);
            }
            sql.sqlMysqlExecute(sql_str02);
            //添加 together_flag - 标识同一机房
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_battinf'"
                    + " AND table_name='tb_station_inf'"
                    + " AND column_name='together_flag'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Station_Inf_Table 
                                + " ADD COLUMN `together_flag` int(11) NOT NULL DEFAULT '0';");
            }
			
            
            //录入已存在的蓄电池机房信息
            initBattStationInfoData(pool);

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -13,6 +13,9 @@
        
        原电源告警等级字段'alm_level' 弃用
        
    3.'db_battinf.tb_station_inf'表新增标识同一机房标识
        `together_flag` int(11) NOT NULL DEFAULT '0'
		

    
V1.81 edit at date 2023-07-21