update.sql 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. CREATE TABLE `zh_shenpi_group` (
  2. `id` int NOT NULL AUTO_INCREMENT,
  3. `tid` int NULL COMMENT '标段id',
  4. `sp_type` tinyint(4) NULL COMMENT '审批流程类型',
  5. `name` varchar(255) NULL COMMENT '审批组名称',
  6. `is_select` tinyint(1) NULL DEFAULT 0 COMMENT '默认审批组',
  7. `change_type` json NULL COMMENT '变更模块json',
  8. `create_time` datetime NULL COMMENT '创建时间',
  9. PRIMARY KEY (`id`)
  10. ) ENGINE = InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT = '审批流程组表';
  11. ALTER TABLE `zh_shenpi_audit`
  12. ADD COLUMN `sp_group` int(11) NULL DEFAULT 0 COMMENT '审批组id' AFTER `audit_order`;
  13. ALTER TABLE `zh_change`
  14. ADD COLUMN `sp_group` int(11) NULL DEFAULT 0 COMMENT '固定审批组id' AFTER `delimit`;
  15. ALTER TABLE `zh_change_project_audit`
  16. ADD COLUMN `audit_type` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '审批类型(1个人,2会签,3或签)' AFTER `opinion`,
  17. ADD COLUMN `audit_order` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '审批顺序' AFTER `audit_type`;
  18. ALTER TABLE `zh_change_project`
  19. ADD COLUMN `sp_group` int(11) NULL DEFAULT 0 COMMENT '固定审批组id' AFTER `content`;
  20. ALTER TABLE `zh_change_apply_audit`
  21. ADD COLUMN `audit_type` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '审批类型(1个人,2会签,3或签)' AFTER `opinion`,
  22. ADD COLUMN `audit_order` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '审批顺序' AFTER `audit_type`;
  23. ALTER TABLE `zh_change_apply`
  24. ADD COLUMN `sp_group` int(11) NULL DEFAULT 0 COMMENT '固定审批组id' AFTER `decimal`;
  25. ALTER TABLE `zh_change_plan_audit`
  26. ADD COLUMN `audit_type` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '审批类型(1个人,2会签,3或签)' AFTER `opinion`,
  27. ADD COLUMN `audit_order` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '审批顺序' AFTER `audit_type`;
  28. ALTER TABLE `zh_change_plan`
  29. ADD COLUMN `sp_group` int(11) NULL DEFAULT 0 COMMENT '固定审批组id' AFTER `decimal`;
  30. ALTER TABLE `zh_stage`
  31. ADD COLUMN `final_auditor_str` varchar(50) NOT NULL DEFAULT '' COMMENT '终审人相关' AFTER `pre_negative_qc_tp`;
  32. ALTER TABLE `zh_global_log`
  33. ADD COLUMN `memo` varchar(255) NOT NULL DEFAULT '' AFTER `run_time`;