update.sql 717 B

123456789101112131415161718192021
  1. -- 请按如下分类提交sql!!!
  2. -- Version todo
  3. -- uat todo
  4. -- prod todo
  5. ------------------------------------
  6. -- 表结构
  7. ------------------------------------
  8. ALTER TABLE `zh_tender`
  9. ADD COLUMN `c_mode` tinyint(1) NULL DEFAULT 0 COMMENT '变更清单模式' AFTER `c_rule_first`;
  10. ALTER TABLE `zh_change_ledger`
  11. ADD COLUMN `features` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT '项目特征' AFTER `memo`;
  12. ALTER TABLE `calculation`.`zh_sub_project`
  13. ADD COLUMN `lock_file` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '资料归集,是否锁定' AFTER `filing_template_name`;
  14. ------------------------------------
  15. -- 表数据
  16. ------------------------------------