activiti.oracle.upgradestep.511.to.512.history.sql 505 B

1234567891011121314151617
  1. alter table ACT_HI_TASKINST
  2. add CLAIM_TIME_ TIMESTAMP(6);
  3. alter table ACT_HI_TASKINST
  4. add FORM_KEY_ NVARCHAR2(255);
  5. alter table ACT_RU_IDENTITYLINK
  6. add PROC_INST_ID_ NVARCHAR2(64);
  7. create index ACT_IDX_IDL_PROCINST on ACT_RU_IDENTITYLINK(PROC_INST_ID_);
  8. alter table ACT_RU_IDENTITYLINK
  9. add constraint ACT_FK_IDL_PROCINST
  10. foreign key (PROC_INST_ID_)
  11. references ACT_RU_EXECUTION (ID_);
  12. create index ACT_IDX_HI_ACT_INST_EXEC on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_);