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`;