package com.database_util;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.Date;
|
|
import com.base.Com;
|
import com.sql.MysqlConnPool;
|
import com.sql.Sql_Mysql;
|
|
public class DB_Pwrdev_Data_Rt {
|
public static void init(MysqlConnPool pool, boolean recreate) {
|
System.out.println(" db_pwrdev_data_rt init start at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
|
createDB_PWRDEV_DATA_RT (pool);
|
|
|
createPwrdev_Acdata_Table(pool, recreate);
|
|
System.out.println(Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
|
createPwrdev_Acdcdata_Table(pool, recreate);
|
|
System.out.println(Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
|
createPwrdev_Dcdata_Table(pool, recreate);
|
|
createPwrdev_Event_Table(pool,recreate);
|
|
createUpspower_Sinal_Table(pool,recreate);
|
|
createUpspower_Simulate_Table(pool,recreate);
|
|
createPwrdev_Rt_Info_Table(pool,recreate);
|
|
System.out.println(" db_pwrdev_data_rt init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
}
|
|
/**
|
* ´´½¨ db_pwrdev_data_rt Êý¾Ý¿â
|
* @param pool
|
*/
|
private static void createDB_PWRDEV_DATA_RT(MysqlConnPool pool) {
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
sql.sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + Sql_Mysql.DB_PWRDEV_DATA_RT);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_pwrdev_acdcdata ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Acdcdata_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Acdcdata_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Acdcdata_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `acIn1_volA` float NOT NULL DEFAULT '0'," +
|
" `acIn1_volB` float NOT NULL DEFAULT '0'," +
|
" `acIn1_volC` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volA` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volB` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volC` float NOT NULL DEFAULT '0'," +
|
" `acOut_volA` float NOT NULL DEFAULT '0'," +
|
" `acOut_volB` float NOT NULL DEFAULT '0'," +
|
" `acOut_volC` float NOT NULL DEFAULT '0'," +
|
" `acOut_currA` float NOT NULL DEFAULT '0'," +
|
" `acOut_currB` float NOT NULL DEFAULT '0'," +
|
" `acOut_currC` float NOT NULL DEFAULT '0'," +
|
" `dcOut_vol` float NOT NULL DEFAULT '0'," +
|
" `dcOut_curr` float NOT NULL DEFAULT '0'," +
|
" `battgroup1_vol` float NOT NULL DEFAULT '0'," +
|
" `battgroup1_curr` float NOT NULL DEFAULT '0'," +
|
" `battgroup2_vol` float NOT NULL DEFAULT '0'," +
|
" `battgroup2_curr` float NOT NULL DEFAULT '0'," +
|
" `temprature` float NOT NULL DEFAULT '0'," +
|
" `m_outputvol` float NOT NULL DEFAULT '0'," +
|
" `m1_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m2_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m3_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m4_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m5_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m6_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m7_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m8_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m9_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m10_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m11_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m12_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m13_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m14_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m15_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m16_outCurr` float NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_A` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_B` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_C` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_thunder_err` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_powerdown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_A` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_B` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_C` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_thunder_err` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_powerdown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn_monitorerr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dcOut_over_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dcOut_under_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup_down` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_jun_charge` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_off` float NOT NULL DEFAULT '0'," +
|
" `is_acIn1_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_loader_fuse` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup1_fuse` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup2_fuse` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_total_alarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `acIn1_currA` float NOT NULL DEFAULT '0'," + //2021-5-6 µçÔ´ÐÅÏ¢ÐÂÔö×Ö¶Î
|
" `acIn1_currB` float NOT NULL DEFAULT '0'," +
|
" `acIn1_currC` float NOT NULL DEFAULT '0'," +
|
" `loader_curr` float NOT NULL DEFAULT '0'," +
|
" `battgroup1_ah` float NOT NULL DEFAULT '0'," +
|
" `battgroup1_temp` float NOT NULL DEFAULT '0'," +
|
" `battgroup2_ah` float NOT NULL DEFAULT '0'," +
|
" `battgroup2_temp` float NOT NULL DEFAULT '0'," +
|
" `acdcm_temp` float NOT NULL DEFAULT '0'," +
|
" `m1_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m2_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m3_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m4_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m5_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m6_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m7_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m8_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m9_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m10_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m11_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m12_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m13_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m14_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m15_out_vol` float NOT NULL DEFAULT '0'," +
|
" `m16_out_vol` float NOT NULL DEFAULT '0'," +
|
" `is_acb1_over_currA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acb1_over_currB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acb1_over_currC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_poweron` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_poweron` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dcOut_over_curr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup1_state` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup2_state` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup2_down` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup1_overChgCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup2_overChgCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_overVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_underVol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_overCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_acErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_limitCurr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_fuse` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_fuse` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_unbanlance` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_unbanlance` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_freqerr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_freqerr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup1_volLow` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup2_volLow` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dcOut_total_alarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn_total_alarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_junChg` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_powerdev_commErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `userAcIn1_volA` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_volB` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_volC` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_currA` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_currB` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_currC` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_freq` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_volA` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_volB` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_volC` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_currA` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_currB` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_currC` float NOT NULL DEFAULT '0'," +
|
" `userAcIn2_freq` float NOT NULL DEFAULT '0'," +
|
" `m_temper1` float NOT NULL DEFAULT '0'," +
|
" `m_temper2` float NOT NULL DEFAULT '0'," +
|
" `m_temper3` float NOT NULL DEFAULT '0'," +
|
" `m_humidity1` float NOT NULL DEFAULT '0'," +
|
" `m_humidity2` float NOT NULL DEFAULT '0'," +
|
" `m_humidity3` float NOT NULL DEFAULT '0'," +
|
" `userAcIn1_PowerDown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `userAcIn1_CommErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `userAcIn2_PowerDown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `userAcIn2_CommErr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Temp_CommErr1` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Temp_CommErr2` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Temp_CommErr3` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Humi_CommErr1` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Humi_CommErr2` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Humi_CommErr3` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Smoke_Alarm1` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Smoke_CommErr1` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Smoke_Alarm2` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Smoke_CommErr2` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Smoke_Alarm3` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_Smoke_CommErr3` tinyint(1) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
//Ìí¼ÓacIn1_currA
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn1_currA'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn1_currA` float NOT NULL DEFAULT '0' COMMENT '½»Á÷AÏàÊäÈëµçÁ÷';");
|
}
|
|
//Ìí¼ÓacIn1_currB
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn1_currB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn1_currB` float NOT NULL DEFAULT '0' COMMENT '½»Á÷BÏàÊäÈëµçÁ÷';");
|
}
|
|
//Ìí¼ÓacIn1_currC
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn1_currC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn1_currC` float NOT NULL DEFAULT '0' COMMENT '½»Á÷CÏàÊäÈëµçÁ÷';");
|
}
|
|
//Ìí¼Óloader_curr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='loader_curr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `loader_curr` float NOT NULL DEFAULT '0' COMMENT '¸ºÔصçÁ÷';");
|
}
|
|
//Ìí¼Óbattgroup1_ah
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='battgroup1_ah'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `battgroup1_ah` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é1ÈÝÁ¿';");
|
}
|
|
//Ìí¼Óbattgroup1_temp
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='battgroup1_temp'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `battgroup1_temp` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é1ζÈ';");
|
}
|
|
//Ìí¼Óbattgroup2_ah
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='battgroup2_ah'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `battgroup2_ah` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é2ÈÝÁ¿';");
|
}
|
|
//Ìí¼Óbattgroup2_temp
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='battgroup2_temp'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `battgroup2_temp` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é2ζÈ';");
|
}
|
|
//Ìí¼Óacdcm_temp
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acdcm_temp'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acdcm_temp` float NOT NULL DEFAULT '0' COMMENT '¿ª¹Ø¹ñζÈ';");
|
}
|
|
//Ìí¼Óm1_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='m1_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m1_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1Êä³öµçѹ';");
|
}
|
|
//Ìí¼Óm2_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='m2_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m2_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2Êä³öµçѹ';");
|
}
|
|
//Ìí¼Óm3_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='m3_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m3_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3Êä³öµçѹ';");
|
}
|
|
//Ìí¼Óm4_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='m4_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m4_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4Êä³öµçѹ';");
|
}
|
//Ìí¼Óm5_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='m5_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m5_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5Êä³öµçѹ';");
|
}
|
//Ìí¼Óm6_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='m6_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m6_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6Êä³öµçѹ';");
|
}
|
//Ìí¼Óm7_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='m7_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m7_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7Êä³öµçѹ';");
|
}
|
//Ìí¼Óm8_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='m8_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m8_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8Êä³öµçѹ';");
|
}
|
//Ìí¼Óm9_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='m9_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m9_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9Êä³öµçѹ';");
|
}
|
//Ìí¼Óm10_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='m10_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m10_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10Êä³öµçѹ';");
|
}
|
//Ìí¼Óm11_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='m11_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m11_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11Êä³öµçѹ';");
|
}
|
//Ìí¼Óm12_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='m12_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m12_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12Êä³öµçѹ';");
|
}
|
//Ìí¼Óm13_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='m13_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m13_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13Êä³öµçѹ';");
|
}
|
//Ìí¼Óm14_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='m14_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m14_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14Êä³öµçѹ';");
|
}
|
//Ìí¼Óm15_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='m15_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m15_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15Êä³öµçѹ';");
|
}
|
//Ìí¼Óm16_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='m16_out_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m16_out_vol` float NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16Êä³öµçѹ';");
|
}
|
|
//Ìí¼Óis_acb1_over_currA
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acb1_over_currA'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acb1_over_currA` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷AÏà¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acb1_over_currB
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acb1_over_currB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acb1_over_currB` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷BÏà¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acb1_over_currC
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acb1_over_currC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acb1_over_currC` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷CÏà¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acIn1_poweron
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn1_poweron'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn1_poweron` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷1·Óеç';");
|
}
|
|
|
//Ìí¼Óis_acIn2_poweron
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn2_poweron'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn2_poweron` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷2·Óеç';");
|
}
|
|
|
//Ìí¼Óis_dcOut_over_curr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_dcOut_over_curr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_dcOut_over_curr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_battgroup1_state
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup1_state'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup1_state` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø1³ä·Å״̬';");
|
}
|
|
//Ìí¼Óis_battgroup2_state
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup2_state'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup2_state` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø2³ä·Å״̬';");
|
}
|
|
//Ìí¼Óis_battgroup2_down
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup2_down'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup2_down` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é2ϵç';");
|
}
|
|
//Ìí¼Óis_battgroup1_overChgCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup1_overChgCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup1_overChgCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é1³äµç¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_battgroup2_overChgCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup2_overChgCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup2_overChgCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é2³äµç¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod1_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod1_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod1_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod1_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod1_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod1_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1Ƿѹ';");
|
}
|
//Ìí¼Óis_acdcMod1_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod1_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod1_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod1_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod1_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod1_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod1_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod1_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod1_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod2_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod2_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod2_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod2_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod2_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod2_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod2_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod2_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod2_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod2_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod2_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod2_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod2_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod2_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod2_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod3_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod3_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod3_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod3_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod3_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod3_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod3_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod3_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod3_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod3_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod3_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod3_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod3_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod3_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod3_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod4_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod4_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod4_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod4_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod4_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod4_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod4_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod4_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod4_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod4_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod4_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod4_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod4_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod4_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod4_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod5_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod5_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod5_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod5_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod5_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod5_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod5_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod5_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod5_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod5_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod5_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod5_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod5_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod5_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod5_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod6_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod6_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod6_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod6_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod6_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod6_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod6_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod6_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod6_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod6_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod6_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod6_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod6_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod6_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod6_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod7_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod7_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod7_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod7_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod7_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod7_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod7_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod7_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod7_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod7_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod7_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod7_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod7_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod7_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod7_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod8_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod8_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod8_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod8_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod8_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod8_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod8_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod8_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod8_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod8_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod8_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod8_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod8_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod8_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod8_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod9_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod9_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod9_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod9_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod9_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod9_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod9_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod9_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod9_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod9_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod9_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod9_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod9_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod9_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod9_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod10_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod10_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod10_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod10_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod10_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod10_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod10_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod10_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod10_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod10_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod10_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod10_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod10_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod10_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod10_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod11_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod11_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod11_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod11_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod11_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod11_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod11_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod11_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod11_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod11_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod11_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod11_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod11_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod11_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod11_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod12_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod12_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod12_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod12_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod12_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod12_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod12_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod12_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod12_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod12_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod12_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod12_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod12_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod12_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod12_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod13_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod13_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod13_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod13_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod13_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod13_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod13_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod13_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod13_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod13_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod13_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod13_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod13_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod13_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod13_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod14_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod14_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod14_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod14_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod14_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod14_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod14_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod14_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod14_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod14_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod14_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod14_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod14_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod14_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod14_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod15_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod15_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod15_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod15_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod15_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod15_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod15_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod15_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod15_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod15_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod15_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod15_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod15_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod15_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod15_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod16_overVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod16_overVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod16_overVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16¹ýѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod16_underVol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod16_underVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod16_underVol` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16Ƿѹ';");
|
}
|
|
//Ìí¼Óis_acdcMod16_overCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod16_overCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod16_overCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16¹ýÁ÷';");
|
}
|
|
//Ìí¼Óis_acdcMod16_acErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod16_acErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod16_acErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16½»Á÷Òì³£';");
|
}
|
|
//Ìí¼Óis_acdcMod16_limitCurr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod16_limitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod16_limitCurr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16Ä£¿éÏÞÁ÷';");
|
}
|
|
//Ìí¼Óis_acIn1_fuse
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn1_fuse'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn1_fuse` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë1ÈÛË¿¸æ¾¯';");
|
}
|
|
|
//Ìí¼Óis_acIn2_fuse
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn2_fuse'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn2_fuse` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë2ÈÛË¿¸æ¾¯';");
|
}
|
|
//Ìí¼Óis_acIn1_unbanlance
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn1_unbanlance'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn1_unbanlance` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë1ÈýÏ಻ƽºâ';");
|
}
|
|
//Ìí¼Óis_acIn2_unbanlance
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn2_unbanlance'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn2_unbanlance` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë2ÈýÏ಻ƽºâ';");
|
}
|
|
//Ìí¼Óis_acIn1_freqerr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn1_freqerr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn1_freqerr` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë1ƵÂÊÒì³£';");
|
}
|
|
//Ìí¼Óis_acIn2_freqerr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn2_freqerr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn2_freqerr` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë2ƵÂÊÒì³£';");
|
}
|
|
//Ìí¼Óis_battgroup1_volLow
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup1_volLow'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup1_volLow` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é1µçѹµÍ';");
|
}
|
|
//Ìí¼Óis_battgroup2_volLow
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_battgroup2_volLow'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_battgroup2_volLow` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é2µçѹµÍ';");
|
}
|
|
//Ìí¼Óis_dcOut_total_alarm
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_dcOut_total_alarm'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_dcOut_total_alarm` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷×ܹÊÕÏ';");
|
}
|
|
//Ìí¼Óis_acIn_total_alarm
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acIn_total_alarm'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acIn_total_alarm` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷×ܹÊÕÏ';");
|
}
|
|
//Ìí¼Óis_acdcMod1_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod1_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod1_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷1¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod2_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod2_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod2_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷2¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod3_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod3_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod3_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷3¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod4_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod4_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod4_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷4¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod5_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod5_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod5_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷5¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod6_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod6_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod6_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷6¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod7_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod7_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod7_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷7¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod8_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod8_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod8_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷8¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod9_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod9_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod9_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷9¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod10_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod10_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod10_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷10¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod11_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod11_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod11_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷11¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod12_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod12_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod12_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷12¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod13_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod13_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod13_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷13¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod14_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod14_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod14_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷14¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod15_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod15_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod15_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷15¾ù³ä';");
|
}
|
|
//Ìí¼Óis_acdcMod16_junChg
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod16_junChg'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod16_junChg` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷16¾ù³ä';");
|
}
|
|
//Ìí¼Óis_powerdev_commErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_powerdev_commErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_powerdev_commErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'µçԴͨÐŹÊÕÏ';");
|
}
|
|
//Ìí¼ÓuserAcIn1_volA
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_volA'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_volA` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1AÏàµçѹ';");
|
}
|
|
//Ìí¼ÓuserAcIn1_volB
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_volB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_volB` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1BÏàµçѹ';");
|
}
|
|
//Ìí¼ÓuserAcIn1_volC
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_volC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_volC` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1CÏàµçѹ';");
|
}
|
|
//Ìí¼ÓuserAcIn1_currA
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_currA'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_currA` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1AÏàµçÁ÷';");
|
}
|
|
//Ìí¼ÓuserAcIn1_currB
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_currB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_currB` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1BÏàµçÁ÷';");
|
}
|
//Ìí¼ÓuserAcIn1_currC
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_currC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_currC` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1CÏàµçÁ÷';");
|
}
|
//Ìí¼ÓuserAcIn1_freq
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_freq'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_freq` float NOT NULL DEFAULT '0' COMMENT '½»Á÷1ƵÂÊ';");
|
}
|
//Ìí¼ÓuserAcIn2_volA
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_volA'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_volA` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2AÏàµçѹ';");
|
}
|
//Ìí¼ÓuserAcIn2_volB
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_volB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_volB` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2BÏàµçѹ';");
|
}
|
//Ìí¼ÓuserAcIn2_volC
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_volC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_volC` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2CÏàµçѹ';");
|
}
|
//Ìí¼ÓuserAcIn2_currA
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_currA'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_currA` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2AÏàµçÁ÷';");
|
}
|
//Ìí¼ÓuserAcIn2_currB
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_currB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_currB` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2BÏàµçÁ÷';");
|
}
|
//Ìí¼ÓuserAcIn2_currC
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_currC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_currC` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2CÏàµçÁ÷';");
|
}
|
//Ìí¼ÓuserAcIn2_freq
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_freq'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_freq` float NOT NULL DEFAULT '0' COMMENT '½»Á÷2ƵÂÊ';");
|
}
|
//Ìí¼Óm_temper1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m_temper1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m_temper1` float NOT NULL DEFAULT '0' COMMENT '»·¾³Î¶È1';");
|
}
|
//Ìí¼Óm_temper2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m_temper2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m_temper2` float NOT NULL DEFAULT '0' COMMENT '»·¾³Î¶È2';");
|
}
|
//Ìí¼Óm_temper3
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m_temper3'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m_temper3` float NOT NULL DEFAULT '0' COMMENT '»·¾³Î¶È3';");
|
}
|
//Ìí¼Óm_humidity1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m_humidity1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m_humidity1` float NOT NULL DEFAULT '0' COMMENT '»·¾³Êª¶È1';");
|
}
|
//Ìí¼Óm_humidity2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m_humidity2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m_humidity2` float NOT NULL DEFAULT '0' COMMENT '»·¾³Êª¶È2';");
|
}
|
//Ìí¼Óm_humidity3
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m_humidity3'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m_humidity3` float NOT NULL DEFAULT '0' COMMENT '»·¾³Êª¶È3';");
|
}
|
//Ìí¼ÓuserAcIn1_PowerDown
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_PowerDown'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_PowerDown` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë1Í£µç';");
|
}
|
//Ìí¼ÓuserAcIn1_CommErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn1_CommErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn1_CommErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷1²É¼¯Í¨ÐŹÊÕÏ';");
|
}
|
//Ìí¼ÓuserAcIn2_PowerDown
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_PowerDown'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_PowerDown` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë2Í£µç';");
|
}
|
//Ìí¼ÓuserAcIn2_CommErr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='userAcIn2_CommErr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `userAcIn2_CommErr` tinyint(1) NOT NULL DEFAULT '0' COMMENT '½»Á÷2²É¼¯Í¨ÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Temp_CommErr1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Temp_CommErr1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Temp_CommErr1` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'θÐ1ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Temp_CommErr2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Temp_CommErr2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Temp_CommErr2` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'θÐ2ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Temp_CommErr3
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Temp_CommErr3'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Temp_CommErr3` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'θÐ3ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Humi_CommErr1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Humi_CommErr1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Humi_CommErr1` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ʪ¸Ð1ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Humi_CommErr2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Humi_CommErr2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Humi_CommErr2` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ʪ¸Ð2ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Humi_CommErr3
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Humi_CommErr3'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Humi_CommErr3` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ʪ¸Ð3ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Smoke_Alarm1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Smoke_Alarm1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Smoke_Alarm1` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ñ̸Ð1±¨¾¯';");
|
}
|
//Ìí¼Óis_Smoke_CommErr1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Smoke_CommErr1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Smoke_CommErr1` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ñ̸Ð1ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Smoke_Alarm2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Smoke_Alarm2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Smoke_Alarm2` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ñ̸Ð1ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Smoke_CommErr2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Smoke_CommErr2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Smoke_CommErr2` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ñ̸Ð2ͨÐŹÊÕÏ';");
|
}
|
//Ìí¼Óis_Smoke_Alarm3
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Smoke_Alarm3'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Smoke_Alarm3` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ñ̸Ð3±¨¾¯';");
|
}
|
//Ìí¼Óis_Smoke_CommErr3
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_Smoke_CommErr3'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_Smoke_CommErr3` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ñ̸Ð3ͨÐŹÊÕÏ';");
|
}
|
|
|
//Ìí¼ÓacIn2_currA×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn2_currA'");
|
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn2_currA` float NOT NULL DEFAULT '0';");
|
}
|
//Ìí¼ÓacIn2_currB×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn2_currB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn2_currB` float NOT NULL DEFAULT '0';");
|
}
|
//Ìí¼ÓacIn2_currC×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn2_currC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn2_currC` float NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼ÓacIn1_switch_st×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn1_switch_st'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn1_switch_st` int(11) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë1·ÖºÏբ״̬:0---δ֪(ÓÃÓÚ¼æÈÝÒÔÇ°µÄ)£¬1-·ÖÕ¢£¬2-ºÏÕ¢£¬3-ÍÑ¿Û';");
|
}
|
|
//Ìí¼ÓacIn2_switch_st×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acIn2_switch_st'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acIn2_switch_st` int(11) NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊäÈë2·ÖºÏբ״̬ :0---δ֪(ÓÃÓÚ¼æÈÝÒÔÇ°µÄ)£¬1-·ÖÕ¢£¬2-ºÏÕ¢£¬3-ÍÑ¿Û';");
|
}
|
|
//Ìí¼ÓchargLimitCurr×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='chargLimitCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `chargLimitCurr` float NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼ÓjunChargeVol×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='junChargeVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `junChargeVol` float NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼ÓfloatChargeVol×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='floatChargeVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `floatChargeVol` float NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼ÓacVolH_Limit×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acVolH_Limit'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acVolH_Limit` float NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼ÓacVolL_Limit×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acVolL_Limit'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acVolL_Limit` float NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼ÓdcOutVolH_Limit×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='dcOutVolH_Limit'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `dcOutVolH_Limit` float NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼ÓdcOutVolL_Limit×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='dcOutVolL_Limit'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `dcOutVolL_Limit` float NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼ÓacInUseCount×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='acInUseCount'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `acInUseCount` tinyint(4) NOT NULL DEFAULT '0';");
|
}
|
|
int AC_DC_NUM_IN_SYS = 20; //ÕûÁ÷Ä£¿éÊýÁ¿
|
for(int k = 0;k<AC_DC_NUM_IN_SYS;k++) {
|
res = null;
|
//Ìí¼Óm1_outCurr - m20_outCurr×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='m" + (k+1) + "_outCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `m" + (k+1) + "_outCurr` float NOT NULL DEFAULT '0';");
|
}
|
|
res = null;
|
//Ìí¼Óis_acdcMod1_off - is_acdcMod20_off×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod" + (k+1) + "_off'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod" + (k+1) + "_off` float NOT NULL DEFAULT '0';");
|
}
|
|
res = null;
|
//Ìí¼Óis_acdcMod1_err - is_acdcMod20_err×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdcdata'"
|
+ " AND column_name='is_acdcMod" + (k+1) + "_err'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
|
+ " ADD COLUMN `is_acdcMod" + (k+1) + "_err` float NOT NULL DEFAULT '0';");
|
}
|
}
|
|
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_pwrdev_dcdata ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Dcdata_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Dcdata_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Dcdata_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `dcIn1_vol` float NOT NULL DEFAULT '0'," +
|
" `dcIn2_vol` float NOT NULL DEFAULT '0'," +
|
" `dcOut1_vol` float NOT NULL DEFAULT '0'," +
|
" `dcOut1_curr` float NOT NULL DEFAULT '0'," +
|
" `dcOut2_vol` float NOT NULL DEFAULT '0'," +
|
" `dcOut2_curr` float NOT NULL DEFAULT '0'," +
|
" `temprature` float NOT NULL DEFAULT '0'," +
|
" `dcVolH_Limit` float NOT NULL DEFAULT 0 ," +
|
" `dcVolL_Limit` float NOT NULL DEFAULT 0 ," +
|
" `is_dc1_over_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dc1_under_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dc2_over_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dc2_under_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dc_monitorerr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_tempalarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw1trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw2trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw3trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw4trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw5trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw6trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw7trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw8trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw9trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw1trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw2trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw3trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw4trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw5trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw6trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw7trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw8trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw9trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_total_alarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_in1_swtrip` tinyint(1) NOT NULL DEFAULT 0, " +
|
" `is_in2_swtrip` tinyint(1) NOT NULL DEFAULT 0, " +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
//Ìí¼ÓdcVolH_Limit×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_dcdata'"
|
+ " AND column_name='dcVolH_Limit'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Dcdata_Table
|
+ " ADD COLUMN `dcVolH_Limit` float NOT NULL DEFAULT 0;");
|
}
|
res = null;
|
//Ìí¼ÓdcVolL_Limit×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_dcdata'"
|
+ " AND column_name='dcVolL_Limit'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Dcdata_Table
|
+ " ADD COLUMN `dcVolL_Limit` float NOT NULL DEFAULT 0;");
|
}
|
res = null;
|
//Ìí¼Óis_in1_swtrip×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_dcdata'"
|
+ " AND column_name='is_in1_swtrip'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Dcdata_Table
|
+ " ADD COLUMN `is_in1_swtrip` tinyint(1) NOT NULL DEFAULT 0;");
|
}
|
res = null;
|
//Ìí¼Óis_in2_swtrip×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_dcdata'"
|
+ " AND column_name='is_in2_swtrip'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Dcdata_Table
|
+ " ADD COLUMN `is_in2_swtrip` tinyint(1) NOT NULL DEFAULT 0;");
|
}
|
|
int DC_SW_COUNT_AT_FSW = 100;
|
|
for(int i=0;i<DC_SW_COUNT_AT_FSW;i++)
|
{
|
String colname = "is_fsw1_sw"+(i+1)+"_trip";
|
res = null;
|
//Ìí¼Óis_in2_swtrip×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_dcdata'"
|
+ " AND column_name='" + colname + "'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Dcdata_Table
|
+ " ADD COLUMN " + colname + " tinyint(1) NOT NULL DEFAULT 0;");
|
}
|
}
|
for(int i=0;i<DC_SW_COUNT_AT_FSW;i++)
|
{
|
String colname = "is_fsw2_sw"+(i+1)+"_trip";
|
res = null;
|
//Ìí¼Óis_in2_swtrip×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_dcdata'"
|
+ " AND column_name='" + colname + "'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Dcdata_Table
|
+ " ADD COLUMN " + colname + " tinyint(1) NOT NULL DEFAULT 0;");
|
}
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_pwrdev_event ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Event_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Event_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Event_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `power_device_id` int(11) NOT NULL DEFAULT '0' COMMENT 'µçÔ´ID'," +
|
" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼Ê¼þ'," +
|
" `now_state` int(11) NOT NULL DEFAULT '0' COMMENT 'µ±Ç°×´Ì¬'," +
|
" `last_state` int(11) NOT NULL DEFAULT '0' COMMENT 'ÉÏÒ»´Î״̬'," +
|
" `event_type` int(11) NOT NULL DEFAULT '0' COMMENT 'ʼþÀàÐÍ'," +
|
" `event_txt` text NOT NULL COMMENT 'ʼþÃèÊö'," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_upspower_sinal ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createUpspower_Sinal_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Upspower_Sinal_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Upspower_Sinal_Table+ " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `power_device_id` int(11) NOT NULL DEFAULT '0'," +
|
" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¸üÐÂʱ¼ä'," +
|
" `power_supply_state` int(11) NOT NULL DEFAULT '0' COMMENT 'bit0£ºÄæ±ä¹©µç;bit1:ÅÔ·¹©µç'," +
|
" `batt_state` int(11) NOT NULL DEFAULT '0' COMMENT 'bit0:µç³Ø×Ô¼ìÖÐ bit1:µç³Ø¸¡³ä bit2£ºµç³Ø¾ù³ä'," +
|
" `inverter_on` int(11) NOT NULL DEFAULT '0' COMMENT 'Äæ±äÆ÷¿ª»ú'," +
|
" `rectifier_power_supply` int(11) NOT NULL DEFAULT '0' COMMENT 'ÕûÁ÷Æ÷¹©µç״̬£ºbit0:Ö÷Äæ±ä¹©µç bit:µç³ØÄæ±ä¹©µç'," +
|
" `dynamo_access` int(11) NOT NULL DEFAULT '0' COMMENT '·¢µç»ú½ÓÈë'," +
|
" `input_switch_state` int(11) NOT NULL DEFAULT '0' COMMENT 'ÊäÈë¿Õ¿ª bit0£ºÊäÈë¿Õ¿ª¶Ï¿ª bit1:ÊäÈë¿Õ¿ª²»Ö§³Ö'," +
|
" `repire_switch_state` int(11) NOT NULL DEFAULT '0' COMMENT 'άÐÞ¿Õ¿ª bit0£º¿Õ¿ª¶Ï¿ª bit1:¿Õ¿ª²»Ö§³Ö'," +
|
" `pass_switch_state` int(11) NOT NULL DEFAULT '0' COMMENT 'ÅÔ·¿Õ¿ª bit0: ÅÔ·¿Õ¿ª¶Ï¿ª bit1£ºÅÔ·¿Õ¿ª²»Ö§³Ö'," +
|
" `output_switch_state` int(11) NOT NULL DEFAULT '0' COMMENT 'Êä³ö¿Õ¿ª bit0:Êä³ö¿Õ¿ª¶Ï¿ª bit1£ºÊä³ö¿Õ¿ª²»Ö§³Ö'," +
|
" `machine_work_mode` int(11) NOT NULL DEFAULT '0' COMMENT 'Õû»ú¹¤×÷ģʽ£ºbit0:Õý³£Ä£Ê½ bit1:±äƵÆ÷ģʽ bit2:ÖÇÄܲ¢»úģʽ bit3:ÖÇÄܲ¢»úÑÝʾģʽ bit4:ECOģʽ bit5:ÖÇÄÜECOģʽ bit6:ÖÇÄÜECOÑÝʾģʽ'," +
|
" `parallelsys_powerstate` int(11) NOT NULL DEFAULT '0' COMMENT '²¢»úϵͳ¹©µç״̬ bit0-ÅÔ·¹©µç bit1-Ö÷·Äæ±ä¹©µç bit2-µç³ØÄæ±ä¹©µç'," +
|
" `model_online` int(11) NOT NULL DEFAULT '0' COMMENT 'Ä£¿éÔÚÏß bit0:Ä£¿é1ÔÚÏß bit1:Ä£¿é2ÔÚÏß bit2£ºÄ£¿é3ÔÚÏß ... bit11:Ä£¿é12ÔÚÏß '," +
|
" `batt_inswitch_open` int(11) NOT NULL DEFAULT '0' COMMENT 'ÄÚÖõç³Ø¿Õ¿ª¶Ï¿ª'," +
|
" `bcb1_state` int(11) NOT NULL DEFAULT '0' COMMENT 'BCB1״̬ bit0:BCB1δ½ÓÈë bit1£ºBCB1:±ÕºÏ'," +
|
" `bcb2_state` int(11) NOT NULL DEFAULT '0' COMMENT 'BCB2״̬ bit0:BCB2δ½ÓÈë bit1£ºBCB2:±ÕºÏ'," +
|
" `bcb3_state` int(11) NOT NULL DEFAULT '0' COMMENT 'BCB3״̬ bit0:BCB3δ½ÓÈë bit1£ºBCB3:±ÕºÏ'," +
|
" `bcb4_state` int(11) NOT NULL DEFAULT '0' COMMENT 'BCB4״̬ bit0:BCB4δ½ÓÈë bit1£ºBCB4:±ÕºÏ'," +
|
" `ups_alm1` int(11) NOT NULL DEFAULT '0' COMMENT 'ups¸æ¾¯1 bit0:Äæ±äÆ÷²»Í¬²½ bit1:Ö÷·µçѹÒì³£ bit2:ÕûÁ÷Æ÷Òì³£ bit3:Äæ±äÆ÷Òì³£ bit4:ÅÔ·Òì³£ bit5:µç³ØµçѹµÍÓÚÏÂÏÞ bit6:µç³Øµçѹ¹ý¸ß bit7:µç³Øδ½ÓÈë bit8:µç³ØµçѹµÍÓڸ澯 bit9:µç³Ø½Ó·´ bit10:ParaMonCANͨѶÒì³£ bit11:PowerCANͨѶÒì³£ bit12:ÕûÁ÷DSP³ÌÐò´íÎó bit13:ÕûÁ÷FPGA³ÌÐò´íÎó bit14:Äæ±äDSP³ÌÐò´íÎó bit15:Äæ±äFPGA³ÌÐò´íÎó bit16:ÅÔ·DSP³ÌÐò´íÎó bit17:ÅÔ·FPGA³ÌÐò´íÎó bit18:»ú¼ÜÄÚÀëÉ¢×ÜÏßͨѶÒì³£ bit19:»ú¼Ü¼äÀëÉ¢×ÜÏßͨѶÒì³£ bit20:Ö÷¿ØÄ£¿éÉèÖò»Æ¥Åä bit21:LBSÒì³£ bit22:½ô¼±¹Ø»ú bit23:ÅÔ·¾§Õ¢¹Ü¹ÊÕÏ bit24:ÅÔ·ÏàÐò·´'," +
|
" `ups_alm2` int(11) NOT NULL DEFAULT '0' COMMENT 'ups¸æ¾¯2 bit0ÅÔ·¹ýÁ÷ bit1ÅÔ·Òì³£¹Ø»ú bit2Çл»´ÎÊýÏÞÖÆ bit3ECOÇл»´ÎÊýÏÞÖÆ bit4ParaPowerCanͨѶÒì³£ bit5µç³Ø·ÅµçÏÞÁ÷ bit6·ÅµçÆ÷¹ÊÕÏ bit7³äµçÆ÷¹ÊÕÏ bit8LBSÁ¬½ÓÏßÒì³£ bit9µç³ØÐèά»¤ bit10µç³Ø¹ýΠbit11µç³Ø½ÓµØ¹ÊÕÏ bit12Ö÷·ƵÂÊÒì³£ bit13Ä£¿é¹ýΠbit14´Ó¿ØÄ£¿éÉèÖò»Æ¥Åä bit15½Ó¿ÚÄ£¿éÉèÖò»Æ¥Åä bit16¾ù³ä³¬Ê± bit17¸¨ÖúµçÔ´µôµç bit18Ö÷·ÏàÐò·´ bit19ÕûÁ÷Æ÷ÈíÆô¶¯Ê§°Ü bit20Óû§²Ù×÷´íÎó bit21Êä³öÈÛË¿¶Ï bit22Êä³ö¹ýÔØ bit23ϵͳ¹ýÔØ bit24Êä³ö¹ýÔس¬Ê±'," +
|
" `ups_alm3` int(11) NOT NULL DEFAULT '0' COMMENT 'ups¸æ¾¯3 bit0¸ºÔسå»÷תÅÔ· bit1²¢»ú¾ùÁ÷Òì³£ bit2ĸÏßÒì³£¹Ø»ú bit3ÁÙ»úÇëÇóתÅÔ· bit4Ö±Á÷ĸÏß¹ýѹ bit5MonCANͨѶÒì³£ bit6ÊäÈëȱÁã¹ÊÕÏ bit7Äæ±ä¼ÌµçÆ÷¹ÊÕÏ bit8Ö÷··´¹à bit9ÊäÈëµçÁ÷Òì³£ bit10Êä³öµçѹÒì³£ bit11ÊäÈëµçÁ÷³¬ÏÞ bit12ÅÔ·¹ýΠbit13ÁÚ»úÅÔ·¾§Õ¢¹Ü¹ÊÕÏ bit14²¢»úÁ¬½ÓÏßÒì³£ bit15³äµçÆ÷¹ýΠbit16µç³Ø¶Ë¿Ú¶Ì· bit17µç³Ø·¿»·¾³Òì³£ bit18·çÉÈÒì³£ bit19ÅÔ·ȱÁã¹ÊÕÏ bit20ÅÔ·½Ó¹Ü bit21BCB1 ״̬Òì³£ bit22BCB2 ״̬Òì³£ bit23BCB3 ״̬Òì³£ bit24BCB4 ״̬Òì³£'," +
|
" `ups_alm4` int(11) NOT NULL DEFAULT '0' COMMENT 'ups¸æ¾¯4 bit0ÅÔ·SCR·çÉÈÒì³£ bit1ƽºâµç·¹ÊÕÏ bit2ƽºâµç·¹ýÁ÷ bit3ƽºâµç·¹ýΠbit4ʧȥÈßÓà bit5ÈÝÁ¿¹ýÔØ bit6¹¦ÂÊ°åÉèÖò»Æ¥Åä bit7ÅÔ·ÉèÖò»Æ¥Åä bit8Éϳé·ç·çÉÈÒì³£ bit9ϵͳAÏàÊä³öÈÛË¿¶Ï bit10ϵͳBÏàÊä³öÈÛË¿¶Ï bit11ϵͳCÏàÊä³öÈÛË¿¶Ï bit12ÅÔ·ÎÞЧ bit13ÕûÁ÷Æ÷¹ýÁ÷ bit14ÅÔ·¹ýÁ÷³¬Ê± bit15Êä³öÁãµØ¹ýѹ bit16ÊäÈëÈÛË¿¶Ï bit17ÅÔ·ÈÛË¿¶Ï'," +
|
" `ups_conn_err` int(11) NOT NULL DEFAULT '0' COMMENT 'ÐתÓëUPSͨÐŹÊÕÏ'," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `idx` (`power_device_id`) USING BTREE" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='upsµçÔ´Ò£ÐÅʵʱ״̬ÐÅÏ¢±í';";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_pwrdev_rt_info ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Rt_Info_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Rt_Info_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Rt_Info_Table+ " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `CommTxCount` int(11) NOT NULL DEFAULT '0'," +
|
" `CommSuccessCount` int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8;;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_upspower_simulate ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createUpspower_Simulate_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Upspower_Simulate_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Upspower_Simulate_Table+ " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `power_device_id` int(11) NOT NULL DEFAULT '0'," +
|
" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¸üÐÂʱ¼ä'," +
|
" `acin_vola` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊäÈëµçѹ'," +
|
" `acin_volb` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊäÈëµçѹ'," +
|
" `acin_volc` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊäÈëµçѹ'," +
|
" `acout_vola` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³öµçѹ'," +
|
" `acout_volb` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³öµçѹ'," +
|
" `acout_volc` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³öµçѹ'," +
|
" `acout_curra` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³öµçÁ÷'," +
|
" `acout_currb` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³öµçÁ÷'," +
|
" `acout_currc` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³öµçÁ÷'," +
|
" `dcin_vol` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷ÊäÈëµçѹ[µç³Ø×é1µç³Øµçѹ]'," +
|
" `out_freq` float NOT NULL DEFAULT '0' COMMENT 'Êä³öƵÂÊ'," +
|
" `abin_vol` float NOT NULL DEFAULT '0' COMMENT 'ABÏßÊäÈëµçѹ'," +
|
" `bcin_vol` float NOT NULL DEFAULT '0' COMMENT 'BCÏßÊäÈëµçѹ'," +
|
" `cain_vol` float NOT NULL DEFAULT '0' COMMENT 'CAÏßÊäÈëµçѹ'," +
|
" `acin_curra` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊäÈëµçÁ÷'," +
|
" `acin_currb` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊäÈëµçÁ÷'," +
|
" `acin_currc` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊäÈëµçÁ÷'," +
|
" `in_freq` float NOT NULL DEFAULT '0' COMMENT 'ÊäÈëƵÂÊ'," +
|
" `in_powerfactor_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊäÈ빦ÂÊÒòÊý'," +
|
" `in_powerfactor_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊäÈ빦ÂÊÒòÊý'," +
|
" `in_powerfactor_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊäÈ빦ÂÊÒòÊý'," +
|
" `pass_vola` float NOT NULL DEFAULT '0' COMMENT 'AÏàÅÔ·µçѹ'," +
|
" `pass_volb` float NOT NULL DEFAULT '0' COMMENT 'BÏàÅÔ·µçѹ'," +
|
" `pass_volc` float NOT NULL DEFAULT '0' COMMENT 'CÏàÅÔ·µçѹ'," +
|
" `pass_freq` float NOT NULL DEFAULT '0' COMMENT 'ÅÔ·ƵÂÊ'," +
|
" `about_vol` float NOT NULL DEFAULT '0' COMMENT 'ABÏßÊä³öµçѹ'," +
|
" `bcout_vol` float unsigned NOT NULL DEFAULT '0' COMMENT 'BCÏßÊä³öµçѹ'," +
|
" `caout_vol` float NOT NULL DEFAULT '0' COMMENT 'CAÏßÊä³öµçѹ'," +
|
" `abpass_vol` float NOT NULL DEFAULT '0' COMMENT 'ABÏßÅÔ·µçѹ'," +
|
" `bcpass_vol` float NOT NULL DEFAULT '0' COMMENT 'BCÏßÅÔ·µçѹ'," +
|
" `capass_vol` float NOT NULL DEFAULT '0' COMMENT 'CAÏßÅÔ·µçѹ'," +
|
" `out_powerfactor_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³ö¹¦ÂÊÒòÊý'," +
|
" `out_powerfactor_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³ö¹¦ÂÊÒòÊý'," +
|
" `out_powerfactor_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³ö¹¦ÂÊÒòÊý'," +
|
" `out_peakratio_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³ö·åÖµ±È'," +
|
" `out_peakratio_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³ö·åÖµ±È'," +
|
" `out_peakratio_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³ö·åÖµ±È'," +
|
" `out_actpower_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³öÓй¦¹¦ÂÊ'," +
|
" `out_actpower_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³öÓй¦¹¦ÂÊ'," +
|
" `out_actpower_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³öÓй¦¹¦ÂÊ'," +
|
" `out_reapower_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³öÎÞ¹¦¹¦ÂÊ'," +
|
" `out_reapower_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³öÎÞ¹¦¹¦ÂÊ'," +
|
" `out_reapower_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³öÎÞ¹¦¹¦ÂÊ'," +
|
" `out_apppower_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³öÊÓÔÚ¹¦ÂÊ'," +
|
" `out_apppower_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³öÊÓÔÚ¹¦ÂÊ'," +
|
" `out_apppower_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³öÊÓÔÚ¹¦ÂÊ'," +
|
" `out_loadpercent_a` float NOT NULL DEFAULT '0' COMMENT 'AÏàÊä³ö¸ºÔذٷֱÈ'," +
|
" `out_loadpercent_b` float NOT NULL DEFAULT '0' COMMENT 'BÏàÊä³ö¸ºÔذٷֱÈ'," +
|
" `out_loadpercent_c` float NOT NULL DEFAULT '0' COMMENT 'CÏàÊä³ö¸ºÔذٷֱÈ'," +
|
" `sysout_actpower_a` float NOT NULL DEFAULT '0' COMMENT 'ϵͳAÏàÊä³öÓй¦¹¦ÂÊ'," +
|
" `sysout_actpower_b` float NOT NULL DEFAULT '0' COMMENT 'ϵͳBÏàÊä³öÓй¦¹¦ÂÊ'," +
|
" `sysout_actpower_c` float NOT NULL DEFAULT '0' COMMENT 'ϵͳCÏàÊä³öÓй¦¹¦ÂÊ'," +
|
" `sysout_apppower_a` float NOT NULL DEFAULT '0' COMMENT 'ϵͳAÏàÊä³öÊÓÔÚ¹¦ÂÊ'," +
|
" `sysout_apppower_b` float NOT NULL DEFAULT '0' COMMENT 'ϵͳBÏàÊä³öÊÓÔÚ¹¦ÂÊ'," +
|
" `sysout_apppower_c` float NOT NULL DEFAULT '0' COMMENT 'ϵͳCÏàÊä³öÊÓÔÚ¹¦ÂÊ'," +
|
" `sysout_reapower_a` float NOT NULL DEFAULT '0' COMMENT 'ϵͳAÏàÊä³öÎÞ¹¦¹¦ÂÊ'," +
|
" `sysout_reapower_b` float NOT NULL DEFAULT '0' COMMENT 'ϵͳBÏàÊä³öÎÞ¹¦¹¦ÂÊ'," +
|
" `sysout_reapower_c` float NOT NULL DEFAULT '0' COMMENT 'ϵͳCÏàÊä³öÎÞ¹¦¹¦ÂÊ'," +
|
" `dev_envir_temp` float NOT NULL DEFAULT '0' COMMENT 'Õû»ú»·¾³Î¶È'," +
|
" `batt_backup_time` float NOT NULL DEFAULT '0' COMMENT 'µç³Øºó±¸Ê±¼ä'," +
|
" `batt_posivol` float NOT NULL DEFAULT '0' COMMENT 'Õýµç³Øµçѹ'," +
|
" `batt_posicurr` float NOT NULL DEFAULT '0' COMMENT 'Õýµç³ØµçÁ÷'," +
|
" `batt_negavol` float NOT NULL DEFAULT '0' COMMENT '¸ºµç³Øµçѹ'," +
|
" `batt_negacurr` float NOT NULL DEFAULT '0' COMMENT '¸ºµç³ØµçÁ÷'," +
|
" `batt_agecoefficient` float NOT NULL DEFAULT '0' COMMENT 'µç³ØÀÏ»¯ÏµÊý'," +
|
" `batt_temp` float NOT NULL DEFAULT '0' COMMENT 'µç³ØζÈ'," +
|
" `envir_temp` float NOT NULL DEFAULT '0' COMMENT '»·¾³Î¶È'," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `idx` (`power_device_id`) USING BTREE" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='upsµçÔ´Ò£²âÁ¿ÊµÊ±×´Ì¬±í';";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_pwrdev_acdata ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Acdata_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Acdata_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Acdata_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `acIn1_volA` float NOT NULL DEFAULT '0'," +
|
" `acIn1_volB` float NOT NULL DEFAULT '0'," +
|
" `acIn1_volC` float NOT NULL DEFAULT '0'," +
|
" `acIn1_currA` float NOT NULL DEFAULT '0'," +
|
" `acIn1_currB` float NOT NULL DEFAULT '0'," +
|
" `acIn1_currC` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volA` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volB` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volC` float NOT NULL DEFAULT '0'," +
|
" `acIn2_currA` float NOT NULL DEFAULT '0'," +
|
" `acIn2_currB` float NOT NULL DEFAULT '0'," +
|
" `acIn2_currC` float NOT NULL DEFAULT '0'," +
|
" `temprature` float NOT NULL DEFAULT '0'," +
|
" `acVolH_Limit` float NOT NULL DEFAULT 0 ," +
|
" `acVolL_Limit` float NOT NULL DEFAULT 0 ," +
|
|
" `is_acIn1_over_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_A` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_B` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_C` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_thunder_err` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_A` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_B` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_C` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_thunder_err` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_powerdown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_monitorerr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_powerdown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw1trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw2trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw3trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw4trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw5trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw6trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw7trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw8trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw9trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw1trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw2trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw3trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw4trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw5trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw6trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw7trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw8trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw9trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_total_alarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_fuse` tinyint(1) NOT NULL DEFAULT 0, " +
|
" `is_acIn2_fuse` tinyint(1) NOT NULL DEFAULT 0, " +
|
" `is_ac_tempAlarm` tinyint(1) NOT NULL DEFAULT 0, " +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
|
|
//Ìí¼ÓacIn2_currA×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdata'"
|
+ " AND column_name='acIn2_currA'");
|
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdata_Table
|
+ " ADD COLUMN `acIn2_currA` float NOT NULL DEFAULT '0';");
|
}
|
//Ìí¼ÓacIn2_currB×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdata'"
|
+ " AND column_name='acIn2_currB'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdata_Table
|
+ " ADD COLUMN `acIn2_currB` float NOT NULL DEFAULT '0';");
|
}
|
//Ìí¼ÓacIn2_currC×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdata'"
|
+ " AND column_name='acIn2_currC'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdata_Table
|
+ " ADD COLUMN `acIn2_currC` float NOT NULL DEFAULT '0';");
|
}
|
//Ìí¼ÓacVolH_Limit×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdata'"
|
+ " AND column_name='acVolH_Limit'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdata_Table
|
+ " ADD COLUMN `acVolH_Limit` float NOT NULL DEFAULT 0;");
|
}
|
//Ìí¼ÓacVolL_Limit×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdata'"
|
+ " AND column_name='acVolL_Limit'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdata_Table
|
+ " ADD COLUMN `acVolL_Limit` float NOT NULL DEFAULT 0;");
|
}
|
//Ìí¼Óis_acIn1_fuse×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdata'"
|
+ " AND column_name='is_acIn1_fuse'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdata_Table
|
+ " ADD COLUMN `is_acIn1_fuse` tinyint(1) NOT NULL DEFAULT 0;");
|
}
|
//Ìí¼Óis_acIn2_fuse×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdata'"
|
+ " AND column_name='is_acIn2_fuse'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdata_Table
|
+ " ADD COLUMN `is_acIn2_fuse` tinyint(1) NOT NULL DEFAULT 0;");
|
}
|
|
int AC_SW_COUNT_AT_FSW = 64;
|
for(int i=0;i<AC_SW_COUNT_AT_FSW;i++)
|
{
|
String colname = "is_fsw1_sw"+(i+1)+"_trip";
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdata'"
|
+ " AND column_name='" + colname + "'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdata_Table
|
+ " ADD COLUMN `" + colname + "` tinyint(1) NOT NULL DEFAULT 0;");
|
}
|
}
|
for(int i=0;i<AC_SW_COUNT_AT_FSW;i++)
|
{
|
String colname = "is_fsw2_sw"+(i+1)+"_trip";
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdata'"
|
+ " AND column_name='" + colname + "'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdata_Table
|
+ " ADD COLUMN `" + colname + "` tinyint(1) NOT NULL DEFAULT 0;");
|
}
|
}
|
//Ìí¼Óis_ac_tempAlarm×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_data_rt'"
|
+ " AND table_name='tb_pwrdev_acdata'"
|
+ " AND column_name='is_ac_tempAlarm'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdata_Table
|
+ " ADD COLUMN `is_ac_tempAlarm` tinyint(1) NOT NULL DEFAULT 0;");
|
}
|
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
public static void main(String[] args) {
|
MysqlConnPool pool = new MysqlConnPool("192.168.10.79", 3360, 50);
|
//createPwrdev_Acdata_Table(pool, false);
|
init(pool, false);
|
}
|
}
|
