| | |
|---|
| | | " `acvol_high_limit` float NOT NULL DEFAULT '200' COMMENT '交流上限阈值'," +
|
|---|
| | | " `acvol_low_limit` float NOT NULL DEFAULT '200' COMMENT '交流下限阈值'," +
|
|---|
| | | " `dcoutvol_low_limit` float NOT NULL DEFAULT '43.2' COMMENT '直流输出电压下限阈值'," +
|
|---|
| | | " `is_ac_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含交流配电柜[1-包含，0-不包含]'," + |
|---|
| | | " `is_dc_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含直流配电柜[1-包含，0-不包含]'," + |
|---|
| | | " `is_highfreq_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含高频配电柜[1-包含，0-不包含]'," + |
|---|
| | | " `swtich_num` int(32) NOT NULL DEFAULT '65535' COMMENT '开关路数'," + |
|---|
| | | " PRIMARY KEY (`num`)," +
|
|---|
| | | " KEY `index_station_id` (`StationId`)," +
|
|---|
| | | " KEY `index_powerdev_id` (`PowerDeviceId`)," +
|
|---|
| | |
|---|
| | | sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table
|
|---|
| | | + " ADD COLUMN `is_highfreq_cabinet` int(11) NOT NULL DEFAULT '1' COMMENT '是否包含高频配电柜[1-包含，0-不包含]';");
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | res = null;
|
|---|
| | | //添加字段swtich_num ----- 开关路数->整流模块数量
|
|---|
| | | res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
|---|
| | | + " WHERE table_schema='db_pwrdev_inf'"
|
|---|
| | | + " AND table_name='tb_pwrdev_inf'"
|
|---|
| | | + " AND column_name='swtich_num'");
|
|---|
| | | if(false == res.next()) {
|
|---|
| | | sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table |
|---|
| | | + " ADD COLUMN `swtich_num` int(32) NOT NULL DEFAULT '65535' COMMENT '开关路数';");
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
| | | e.printStackTrace();
|
|---|
| | | } finally {
|
|---|
