| | |
|---|
| | | " `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 '开关路数'," +
|
|---|
| | | " `update_load_curr_en` int(10) NOT NULL DEFAULT '0' COMMENT '是否更新核容的负载电流[0-不更新 1-更新]'," + |
|---|
| | | " PRIMARY KEY (`num`)," +
|
|---|
| | | " KEY `index_station_id` (`StationId`)," +
|
|---|
| | | " KEY `index_powerdev_id` (`PowerDeviceId`)," +
|
|---|
| | |
|---|
| | | sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table
|
|---|
| | | + " ADD COLUMN `swtich_num` int(32) NOT NULL DEFAULT '4095' COMMENT '开关路数';");
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | res = null;
|
|---|
| | | //添加字段update_load_curr_en ----- 是否更新核容的负载电流[0-不更新 1-更新]
|
|---|
| | | res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
|---|
| | | + " WHERE table_schema='db_pwrdev_inf'"
|
|---|
| | | + " AND table_name='tb_pwrdev_inf'"
|
|---|
| | | + " AND column_name='update_load_curr_en'");
|
|---|
| | | if(false == res.next()) {
|
|---|
| | | sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table |
|---|
| | | + " ADD COLUMN `update_load_curr_en` int(10) NOT NULL DEFAULT '0' COMMENT '是否更新核容的负载电流[0-不更新 1-更新]';");
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
| | | e.printStackTrace();
|
|---|
| | | } finally {
|
|---|
