activiti.db2.upgradestep.5151.to.516.engine.sql 764 B

12345678910111213141516171819202122232425262728
  1. alter table ACT_RU_TASK
  2. add FORM_KEY_ varchar(255);
  3. Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_TASK');
  4. alter table ACT_RU_EXECUTION
  5. add NAME_ varchar(255);
  6. Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_EXECUTION');
  7. create table ACT_EVT_LOG (
  8. LOG_NR_ bigint not null GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
  9. TYPE_ varchar(64),
  10. PROC_DEF_ID_ varchar(64),
  11. PROC_INST_ID_ varchar(64),
  12. EXECUTION_ID_ varchar(64),
  13. TASK_ID_ varchar(64),
  14. TIME_STAMP_ timestamp not null,
  15. USER_ID_ varchar(255),
  16. DATA_ BLOB,
  17. LOCK_OWNER_ varchar(255),
  18. LOCK_TIME_ timestamp,
  19. IS_PROCESSED_ integer default 0,
  20. primary key (LOG_NR_)
  21. );
  22. update ACT_GE_PROPERTY set VALUE_ = '5.16' where NAME_ = 'schema.version';