org.flowable.db.upgrade.flowable.db2.upgradestep.511.to.512.history.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of flowable-engine Show documentation

There is a newer version: 7.0.1

alter table ACT_HI_TASKINST
	add CLAIM_TIME_ timestamp;

alter table ACT_HI_TASKINST
  add FORM_KEY_ varchar(255);

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

alter table ACT_RU_IDENTITYLINK
  add PROC_INST_ID_ varchar(64);

alter table ACT_RU_IDENTITYLINK
    add constraint ACT_FK_IDL_PROCINST
    foreign key (PROC_INST_ID_) 
    references ACT_RU_EXECUTION (ID_); 
    
    
Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_IDENTITYLINK');    

create index ACT_IDX_HI_ACT_INST_EXEC on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_);