activiti.h2.upgradestep.514.to.515.engine.sql 1018 B

1234567891011121314151617181920212223242526272829303132333435363738
  1. alter table ACT_RU_TASK
  2. add CATEGORY_ varchar(255);
  3. alter table ACT_RU_EXECUTION drop constraint ACT_UNIQ_RU_BUS_KEY;
  4. alter table ACT_RE_DEPLOYMENT
  5. add TENANT_ID_ varchar(255) default '';
  6. alter table ACT_RE_PROCDEF
  7. add TENANT_ID_ varchar(255) default '';
  8. alter table ACT_RU_EXECUTION
  9. add TENANT_ID_ varchar(255) default '';
  10. alter table ACT_RU_TASK
  11. add TENANT_ID_ varchar(255) default '';
  12. alter table ACT_RU_JOB
  13. add TENANT_ID_ varchar(255) default '';
  14. alter table ACT_RE_MODEL
  15. add TENANT_ID_ varchar(255) default '';
  16. alter table ACT_RU_EVENT_SUBSCR
  17. add TENANT_ID_ varchar(255) default '';
  18. alter table ACT_RU_EVENT_SUBSCR
  19. add PROC_DEF_ID_ varchar(64);
  20. alter table ACT_RE_PROCDEF
  21. drop constraint ACT_UNIQ_PROCDEF;
  22. alter table ACT_RE_PROCDEF
  23. add constraint ACT_UNIQ_PROCDEF
  24. unique (KEY_,VERSION_, TENANT_ID_);
  25. update ACT_GE_PROPERTY set VALUE_ = '5.15' where NAME_ = 'schema.version';