activiti.postgres.upgradestep.514.to.515.engine.sql 1.0 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. alter table ACT_RU_TASK
  2. add CATEGORY_ varchar(255);
  3. alter table ACT_RU_EXECUTION drop constraint act_ru_execution_proc_def_id__business_key__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';