activiti.postgres.upgradestep.511.to.512.history.sql 510 B

12345678910111213141516171819
  1. alter table ACT_HI_TASKINST
  2. add column CLAIM_TIME_ timestamp;
  3. alter table ACT_HI_TASKINST
  4. add column FORM_KEY_ varchar(255);
  5. alter table ACT_RU_IDENTITYLINK
  6. add PROC_INST_ID_ varchar(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_);