Calculation/sql/update.sql

CREATE TABLE `zh_shenpi_group`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `tid` int NULL COMMENT '标段id',
  `sp_type` tinyint(4) NULL COMMENT '审批流程类型',
  `name` varchar(255) NULL COMMENT '审批组名称',
  `is_select` tinyint(1) NULL DEFAULT 0 COMMENT '默认审批组',
  `change_type` json NULL COMMENT '变更模块json',
  `create_time` datetime NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT = '审批流程组表';

ALTER TABLE `zh_shenpi_audit`
ADD COLUMN `sp_group` int(11) NULL DEFAULT 0 COMMENT '审批组id' AFTER `audit_order`;

ALTER TABLE `zh_change`
ADD COLUMN `sp_group` int(11) NULL DEFAULT 0 COMMENT '固定审批组id' AFTER `delimit`;