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);
|
|
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 AUTO_INCREMENT=5 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-ÍÑ¿Û';");
|
}
|
|
|
|
|
} 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'," +
|
" `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'," +
|
" 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_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 AUTO_INCREMENT=246 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_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'," +
|
" `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'," +
|
" 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';");
|
}
|
} 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);
|
}
|
}
|
