activiti.oracle.upgradestep.5151.to.516.engine.sql 649 B

1234567891011121314151617181920212223242526
  1. alter table ACT_RU_TASK
  2. add FORM_KEY_ NVARCHAR2(255);
  3. alter table ACT_RU_EXECUTION
  4. add NAME_ NVARCHAR2(255);
  5. create table ACT_EVT_LOG (
  6. LOG_NR_ NUMBER(19),
  7. TYPE_ NVARCHAR2(64),
  8. PROC_DEF_ID_ NVARCHAR2(64),
  9. PROC_INST_ID_ NVARCHAR2(64),
  10. EXECUTION_ID_ NVARCHAR2(64),
  11. TASK_ID_ NVARCHAR2(64),
  12. TIME_STAMP_ TIMESTAMP(6) not null,
  13. USER_ID_ NVARCHAR2(255),
  14. DATA_ BLOB,
  15. LOCK_OWNER_ NVARCHAR2(255),
  16. LOCK_TIME_ TIMESTAMP(6) null,
  17. IS_PROCESSED_ NUMBER(3) default 0,
  18. primary key (LOG_NR_)
  19. );
  20. create sequence act_evt_log_seq;
  21. update ACT_GE_PROPERTY set VALUE_ = '5.16' where NAME_ = 'schema.version';