auth-service/dcuc-auth-service/src/main/resources/config/mysql/V4_3_0032__AddAuthSubTask.sql

CREATE TABLE T_AUTH_SUB_TASK_TYPE
(
    ID             VARCHAR(32) NOT NULL COMMENT 'ID 主键id',
    TASK_TYPE_NAME VARCHAR(128) COMMENT 'TASK_TYPE_NAME 任务类型名称',
    TASK_TYPE_CODE VARCHAR(32) COMMENT 'TASK_TYPE_CODE 任务类型编码',
    DELETED        VARCHAR(5) DEFAULT '0' COMMENT 'DELETED 是否删除',
    CREATE_USER    VARCHAR(32) COMMENT 'CREATE_USER 创建人',
    CREATE_TIME    DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT 'CREATE_TIME 创建时间',
    UPDATE_USER    VARCHAR(32) COMMENT 'UPDATE_USER 更新人',
    UPDATE_TIME    DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'UPDATE_TIME 更新时间',
    DELETE_USER    VARCHAR(32) COMMENT 'DELETE_USER 删除人',
    DELETE_TIME    DATETIME COMMENT 'DELETE_TIME 删除时间',
    PRIMARY KEY (ID)
) COMMENT = '任务类型 ';

ALTER TABLE T_AUTH_SUB_TASK_TYPE
    ADD INDEX T_AUTH_S_T_INX_T_CODE (TASK_TYPE_CODE);

UPDATE T_AUTH_SUB_TASK_TYPE SET CREATE_TIME = now() WHERE CREATE_TIME IS NULL;
alter table t_auth_sub_task_type modify TASK_TYPE_CODE varchar(50) null comment 'TASK_TYPE_CODE 任务类型编码';
alter table t_auth_sub_task_type add PARENT_ID varchar(32) null comment '父级id';
alter table t_auth_sub_task_type add PARENT_CODE varchar(50) null comment '父级id';

INSERT INTO t_auth_menu_info (ID, NAME, CODE, APP_ID, PARENT_ID, URL, SHOW_MODE, IS_ACTIVE, SEQ, CREATE_TIME, CREATOR, MODIFIED_TIME, MODIFIER, REMARK, IS_SYSTEM, IS_HIDE, RESOURCE_TYPE) VALUES ('fca158d1b47d4d5d8e5ed8a5c6db1342', '主体环境要素管理', 'QXGL_SQGL_ZTGL_ZTHJYSGL', '00000000000000000000000000000000', '836d3a356a264300832841aa97b945e0', null, '1', '1', 4, null, null, null, null, null, '0', '0', null);

CREATE TABLE T_AUTH_APPROVAL_RESULT(
       ID VARCHAR(32) NOT NULL   COMMENT 'ID 主键id' ,
       PROCESS_INST_ID VARCHAR(64)    COMMENT 'PROCESS_INST_ID 流程实例id' ,
       OPEN_ID DATETIME    COMMENT 'OPEN_ID 流程发起人标识' ,
       USER_NAME VARCHAR(32)    COMMENT 'USER_NAME 发起人姓名' ,
       UPDATED_TIME DATETIME    COMMENT 'END_FLAG 审批结果标识 “1”表示审批通过； “2”表示审批不通过' ,
       TASK_ID VARCHAR(32)    COMMENT 'TASK_ID 任务编号' ,
       PROCESS_DEF_ID VARCHAR(64)    COMMENT 'PROCESS_DEF_ID 流程定义id' ,
       BUSINESS_KEY VARCHAR(64)    COMMENT 'BUSINESS_KEY 业务标识' ,
       APPLY_TYPE VARCHAR(32)    COMMENT 'APPLY_TYPE 申请类型' ,
       DELETED VARCHAR(32)   DEFAULT '0' COMMENT 'DELETED 是否删除' ,
       CREATE_USER VARCHAR(32)    COMMENT 'CREATE_USER' ,
       CREATE_TIME VARCHAR(32)    COMMENT 'CREATE_TIME' ,
       UPDATE_USER VARCHAR(32)    COMMENT 'UPDATE_USER' ,
       UPDATE_TIME VARCHAR(32)    COMMENT 'UPDATE_TIME' ,
       DELETE_USER VARCHAR(32)    COMMENT 'DELETE_USER' ,
       DELETE_TIME VARCHAR(32)    COMMENT 'DELETE_TIME' ,
       PRIMARY KEY (ID)
) COMMENT = '审批结果表 ';

alter table t_auth_approval_result modify TASK_ID varchar(50) null comment 'TASK_ID 任务编号';
alter table t_auth_approval_result add TASK_ID_DATE varchar(20) null;

ALTER TABLE T_AUTH_APPROVAL_RESULT ADD INDEX t_auth_a_r_inx_psid(PROCESS_INST_ID);

alter table t_auth_approval_result
    change UPDATED_TIME END_FLAG varchar(5) null comment 'END_FLAG 审批结果标识 “1”表示审批通过； “2”表示审批不通过';

alter table t_auth_approval_result
    modify OPEN_ID varchar(32) null comment 'OPEN_ID 流程发起人标识';

alter table t_auth_approval_result
    modify CREATE_TIME DATETIME null comment 'CREATE_TIME';

alter table t_auth_approval_result
    modify UPDATE_TIME DATETIME null comment 'UPDATE_TIME';

alter table t_auth_approval_result
    modify DELETE_TIME DATETIME null comment 'DELETE_TIME';