- ALTER TABLE `industrial_land_supply_consultation`
- ADD COLUMN `is_default` tinyint(1) DEFAULT '0' COMMENT '是否默认咨询';
- UPDATE industrial_land_supply_consultation
- SET is_default = 0
- WHERE
- consultation != '请反馈明确意见';
- UPDATE industrial_land_supply_consultation
- SET is_default = 1
- WHERE
- consultation = '请反馈明确意见';
|