activiti.db2.upgradestep.511.to.512.history.sql 538 B

1234567891011121314151617181920
  1. alter table ACT_HI_TASKINST
  2. add CLAIM_TIME_ timestamp;
  3. alter table ACT_HI_TASKINST
  4. add FORM_KEY_ varchar(255);
  5. Call Sysproc.admin_cmd ('REORG TABLE ACT_HI_TASKINST');
  6. alter table ACT_RU_IDENTITYLINK
  7. add PROC_INST_ID_ varchar(64);
  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. Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_IDENTITYLINK');
  13. create index ACT_IDX_HI_ACT_INST_EXEC on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_);