BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Alarm.classBinary files differ
BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Data_Rt.classBinary files differ
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt
@@ -1,9 +1,15 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V2.04 edit at date 2024-09-09 1.修复表 'db_battinf.tb_stattion_inf'表中字段'together_flag'默认初始插入全为0=>将为0的字段修改为当前最大值 2.表'db_pwrdev_data_rt.tb_pwrdev_acdcdata'新增字段 `m17_out_vol` float NOT NULL DEFAULT '0' COMMENT '模块17输出电压', `m18_out_vol` float NOT NULL DEFAULT '0' COMMENT '模块18输出电压', `m19_out_vol` float NOT NULL DEFAULT '0' COMMENT '模块19输出电压', `m20_out_vol` float NOT NULL DEFAULT '0' COMMENT '模块20输出电压', V2.03 edit at date 2024-07-18 1.表 'db_param.tb_app_param'新增参数 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Alarm.java
@@ -249,6 +249,12 @@ sql.close_con(); } } /** * 南网告警规则模板表 * @param pool * @param recreate */ private static void createPwrdev_Alarm_Param_Table(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_Param_Table; String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_Param_Table + " (" + BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Data_Rt.java
@@ -589,6 +589,42 @@ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table + " ADD COLUMN `m16_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器16输出电压';"); } //添加m17_out_vol res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_pwrdev_data_rt'" + " AND table_name='tb_pwrdev_acdcdata'" + " AND column_name='m17_out_vol'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table + " ADD COLUMN `m17_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器17输出电压';"); } //添加m18_out_vol res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_pwrdev_data_rt'" + " AND table_name='tb_pwrdev_acdcdata'" + " AND column_name='m18_out_vol'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table + " ADD COLUMN `m18_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器18输出电压';"); } //添加m19_out_vol res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_pwrdev_data_rt'" + " AND table_name='tb_pwrdev_acdcdata'" + " AND column_name='m19_out_vol'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table + " ADD COLUMN `m19_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器19输出电压';"); } //添加m20_out_vol res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_pwrdev_data_rt'" + " AND table_name='tb_pwrdev_acdcdata'" + " AND column_name='m20_out_vol'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table + " ADD COLUMN `m20_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器20输出电压';"); } //添加is_acb1_over_currA res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -1,9 +1,15 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V2.04 edit at date 2024-09-09 1.修复表 'db_battinf.tb_stattion_inf'表中字段'together_flag'默认初始插入全为0=>将为0的字段修改为当前最大值 2.表'db_pwrdev_data_rt.tb_pwrdev_acdcdata'新增字段 `m17_out_vol` float NOT NULL DEFAULT '0' COMMENT '模块17输出电压', `m18_out_vol` float NOT NULL DEFAULT '0' COMMENT '模块18输出电压', `m19_out_vol` float NOT NULL DEFAULT '0' COMMENT '模块19输出电压', `m20_out_vol` float NOT NULL DEFAULT '0' COMMENT '模块20输出电压', V2.03 edit at date 2024-07-18 1.表 'db_param.tb_app_param'新增参数
