org.flowable.db.upgrade.flowable.oracle.upgradestep.511.to.512.history.sql Maven / Gradle / Ivy
alter table ACT_HI_TASKINST
add CLAIM_TIME_ TIMESTAMP(6);
alter table ACT_HI_TASKINST
add FORM_KEY_ NVARCHAR2(255);
alter table ACT_RU_IDENTITYLINK
add PROC_INST_ID_ NVARCHAR2(64);
create index ACT_IDX_IDL_PROCINST on ACT_RU_IDENTITYLINK(PROC_INST_ID_);
alter table ACT_RU_IDENTITYLINK
add constraint ACT_FK_IDL_PROCINST
foreign key (PROC_INST_ID_)
references ACT_RU_EXECUTION (ID_);
create index ACT_IDX_HI_ACT_INST_EXEC on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_);