cd-work-flow-service/jeecg-boot/jeecg-boot-module-activiti/db/upgrade/activiti.db2.upgradestep.510.to.511.history.sql

create table ACT_HI_VARINST (
    ID_ varchar(64) not null,
    PROC_INST_ID_ varchar(64),
    EXECUTION_ID_ varchar(64),
    TASK_ID_ varchar(64),
    NAME_ varchar(255) not null,
    VAR_TYPE_ varchar(100),
    REV_ integer,
    BYTEARRAY_ID_ varchar(64),
    DOUBLE_ double precision,
    LONG_ bigint,
    TEXT_ varchar(4000),
    TEXT2_ varchar(4000),
    primary key (ID_)
);

create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);

Call Sysproc.admin_cmd ('REORG TABLE ACT_HI_VARINST');

alter table ACT_HI_ACTINST
	add TASK_ID_ varchar(64);
	
alter table ACT_HI_ACTINST
	add CALL_PROC_INST_ID_ varchar(64);

alter table ACT_HI_DETAIL
	alter column PROC_INST_ID_ DROP NOT NULL;

alter table ACT_HI_DETAIL
	alter column EXECUTION_ID_ DROP NOT NULL;
	
Call Sysproc.admin_cmd ('REORG TABLE ACT_HI_DETAIL');

create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);