activiti.oracle.upgradestep.50.to.51.history.sql 493 B

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