update.sql 783 B

1234567891011
  1. -- 会签或签 暂不更新 --
  2. ALTER TABLE `zh_tender_cache`
  3. MODIFY COLUMN `stage_flow_cur_uid` varchar(1000) NOT NULL DEFAULT 0 COMMENT '期-当前流程人id(,间隔)' AFTER `stage_complete_count`,
  4. MODIFY COLUMN `stage_flow_pre_uid` varchar(1000) NOT NULL DEFAULT 0 COMMENT '期-上一流程人id(,间隔)' AFTER `stage_flow_cur_tp`;
  5. ALTER TABLE `zh_shenpi_audit`
  6. ADD COLUMN `audit_type` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '审批类型(1个人,2会签,3或签)' AFTER `audit_id`,
  7. ADD COLUMN `audit_order` tinyint(4) UNSIGNED ZEROFILL NOT NULL DEFAULT 0 COMMENT '审批顺序' AFTER `audit_type`;
  8. ALTER TABLE `zh_stage_audit`
  9. ADD COLUMN `audit_type` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '审批类型(1个人,2会签,3或签)' AFTER `is_old`;