org.activiti.db.upgrade.activiti.db2.upgradestep.514.to.515.engine.sql Maven / Gradle / Ivy

Go to download
alter table ACT_RU_TASK 
    add CATEGORY_ varchar(255);

Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_TASK');
        
drop index ACT_UNIQ_RU_BUS_KEY;

-- DB2 *cannot* drop columns. Yes, this is 2013.
-- This means that for DB2 the columns will remain as they are (they won't be used)
-- alter table ACT_RU_EXECUTION drop colum UNI_BUSINESS_KEY;
-- alter table ACT_RU_EXECUTION drop colum UNI_PROC_DEF_ID;

Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_EXECUTION');

alter table ACT_RE_DEPLOYMENT 
    add TENANT_ID_ varchar(255) default '';
    
Call Sysproc.admin_cmd ('REORG TABLE ACT_RE_DEPLOYMENT');

alter table ACT_RE_PROCDEF 
    add TENANT_ID_ varchar(255) not null default '';
    
Call Sysproc.admin_cmd ('REORG TABLE ACT_RE_PROCDEF');

alter table ACT_RU_EXECUTION
    add TENANT_ID_ varchar(255) default '';
    
Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_EXECUTION');  

alter table ACT_RU_TASK
    add TENANT_ID_ varchar(255) default '';
    
Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_TASK');   

alter table ACT_RU_JOB
    add TENANT_ID_ varchar(255) default '';
    
Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_JOB');  

alter table ACT_RE_MODEL
    add TENANT_ID_ varchar(255) default '';
    
Call Sysproc.admin_cmd ('REORG TABLE ACT_RE_MODEL');  

alter table ACT_RU_EVENT_SUBSCR
   add TENANT_ID_ varchar(255) default '';  
   
alter table ACT_RU_EVENT_SUBSCR
   add PROC_DEF_ID_ varchar(64);      
   
Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_EVENT_SUBSCR');     

alter table ACT_RE_PROCDEF
    drop unique ACT_UNIQ_PROCDEF;
    
alter table ACT_RE_PROCDEF
    add constraint ACT_UNIQ_PROCDEF
    unique (KEY_,VERSION_, TENANT_ID_);  
    
Call Sysproc.admin_cmd ('REORG TABLE ACT_RE_PROCDEF');

update ACT_GE_PROPERTY set VALUE_ = '5.15' where NAME_ = 'schema.version';