activiti.postgres.upgradestep.50.to.51.history.sql 468 B

1234567891011121314151617
  1. create table ACT_HI_TASKINST (
  2. ID_ varchar(64) not null,
  3. PROC_DEF_ID_ varchar(64),
  4. TASK_DEF_KEY_ varchar(255),
  5. PROC_INST_ID_ varchar(64),
  6. EXECUTION_ID_ varchar(64),
  7. NAME_ varchar(255),
  8. DESCRIPTION_ varchar(255),
  9. ASSIGNEE_ varchar(64),
  10. START_TIME_ timestamp not null,
  11. END_TIME_ timestamp,
  12. DURATION_ bigint,
  13. DELETE_REASON_ varchar(255),
  14. primary key (ID_)
  15. );
  16. alter table ACT_HI_DETAIL add column TASK_ID_ varchar(64);