~whyclj/BattMonitor_DB_Builder.git

parent: 358ae8bb | 补丁 | 提交 | ignore whitespace

V1.78 edit at date 2023-06-14 1.db_pwrdev_alarm.tb_pwrdev_alarm_param_fors...

Administrator

2023-06-14 78ee1030cd8515fdf45529cffff9407ebb224de2

V1.78 edit at date 2023-06-14
	1.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增字段标识上上限以及下下限使能
		  `alarm_limitH_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT
'上上限使能[0-不启用  1-启用]',
  		  `alarm_limitL_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT
'下下限使能[0-不启用  1-启用]',

5个文件已修改

	BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Alarm.class	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt	4 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java	22 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt	4 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| 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

@@ -2,6 +2,10 @@
    注意:1.新增电源机房时需要重新运行
    

V1.78 edit at date 2023-06-14
    1.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增字段标识上上限以及下下限使能	
          `alarm_limitH_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '上上限使能[0-不启用  1-启用]',
            `alarm_limitL_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '下下限使能[0-不启用  1-启用]',
    
V1.77 edit at date 2023-06-09
    1.修复创建表'db_alarm.tb_alarm_relation'初始化表中字段错误bug

 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java

@@ -344,6 +344,8 @@
                "  `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 '告警下下限阈值'," + 
                "  `alarm_limitH_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '上上限使能[0-不启用  1-启用]'," + 
                "  `alarm_limitL_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '下下限使能[0-不启用  1-启用]'," + 
                "  PRIMARY KEY (`num`)" + 
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表';";
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());
@@ -383,7 +385,27 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table 
                        + " ADD COLUMN `alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '告警下下限阈值';");
            }
            res = null;
            //添加 alarm_limitH_upper_en -- 上上限使能[0-不启用  1-启用]
            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_en'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table 
                        + " ADD COLUMN `alarm_limitH_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '上上限使能[0-不启用  1-启用]';");
            }
            
            res = null;
            //添加 alarm_limitL_lower_en -- 下下限使能[0-不启用  1-启用]
            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_en'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table 
                        + " ADD COLUMN `alarm_limitL_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '下下限使能[0-不启用  1-启用]';");
            }
            
            res = sql.sqlMysqlQuery("SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Inf_Table);
            StringBuffer buf_base = new StringBuffer("INSERT INTO " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + "(PowerDeviceId,alm_id,alm_level,alarm_limitH,alarm_limitH_EN,alarm_limitL,alarm_limitL_EN,alarm_name,alarm_type) VALUES");

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -2,6 +2,10 @@
    注意:1.新增电源机房时需要重新运行
    

V1.78 edit at date 2023-06-14
    1.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增字段标识上上限以及下下限使能	
          `alarm_limitH_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '上上限使能[0-不启用  1-启用]',
            `alarm_limitL_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '下下限使能[0-不启用  1-启用]',
    
V1.77 edit at date 2023-06-09
    1.修复创建表'db_alarm.tb_alarm_relation'初始化表中字段错误bug

 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java

@@ -32,7 +32,7 @@
    /**************************************************************************/
    /**************************************************************************/
    public final static boolean app_debug = false;
    public final static float m_VersionNum = (float) 1.77;
    public final static float m_VersionNum = (float) 1.78;
    public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908";
    /**************************************************************************/
    /**************************************************************************/

			@@ -2,6 +2,10 @@
			注意:1.新增电源机房时需要重新运行


			V1.78 edit at date 2023-06-14
			1.db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx 新增字段标识上上限以及下下限使能
			`alarm_limitH_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '上上限使能[0-不启用 1-启用]',
			`alarm_limitL_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '下下限使能[0-不启用 1-启用]',

			V1.77 edit at date 2023-06-09
			1.修复创建表'db_alarm.tb_alarm_relation'初始化表中字段错误bug

			@@ -344,6 +344,8 @@
			" `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 '告警下下限阈值'," +
			" `alarm_limitH_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '上上限使能[0-不启用 1-启用]'," +
			" `alarm_limitL_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '下下限使能[0-不启用 1-启用]'," +
			" PRIMARY KEY (`num`)" +
			") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='山西电源告警参数表';";
			Sql_Mysql sql = new Sql_Mysql(pool.getConn());
			@@ -383,7 +385,27 @@
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
			+ " ADD COLUMN `alarm_limitL_lower` float NOT NULL DEFAULT '0' COMMENT '告警下下限阈值';");
			}
			res = null;
			//添加 alarm_limitH_upper_en -- 上上限使能[0-不启用 1-启用]
			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_en'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
			+ " ADD COLUMN `alarm_limitH_upper_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '上上限使能[0-不启用 1-启用]';");
			}

			res = null;
			//添加 alarm_limitL_lower_en -- 下下限使能[0-不启用 1-启用]
			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_en'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table
			+ " ADD COLUMN `alarm_limitL_lower_en` tinyint(4) NOT NULL DEFAULT '1' COMMENT '下下限使能[0-不启用 1-启用]';");
			}

			res = sql.sqlMysqlQuery("SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Inf_Table);
			StringBuffer buf_base = new StringBuffer("INSERT INTO " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + "(PowerDeviceId,alm_id,alm_level,alarm_limitH,alarm_limitH_EN,alarm_limitL,alarm_limitL_EN,alarm_name,alarm_type) VALUES");

			@@ -32,7 +32,7 @@
			/**************************************************************************/
			/**************************************************************************/
			public final static boolean app_debug = false;
			public final static float m_VersionNum = (float) 1.77;
			public final static float m_VersionNum = (float) 1.78;
			public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908";
			/**************************************************************************/
			/**************************************************************************/