20200428.sql 348 B

123456789101112
  1. ALTER TABLE `industrial_land_supply_consultation`
  2. ADD COLUMN `is_default` tinyint(1) DEFAULT '0' COMMENT '是否默认咨询';
  3. UPDATE industrial_land_supply_consultation
  4. SET is_default = 0
  5. WHERE
  6. consultation != '请反馈明确意见';
  7. UPDATE industrial_land_supply_consultation
  8. SET is_default = 1
  9. WHERE
  10. consultation = '请反馈明确意见';