• Home
• org.ow2.petals.activiti
• activiti-engine
• 5.18.0-PETALS-1
• source code
• activiti.db2.upgradestep.514.to.515.history.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

alter table ACT_HI_TASKINST
    add CATEGORY_ varchar(255);
    
Call Sysproc.admin_cmd ('REORG TABLE ACT_HI_TASKINST');    
    
drop index ACT_UNIQ_HI_BUS_KEY;

alter table ACT_HI_VARINST
    add CREATE_TIME_ timestamp; 
    
alter table ACT_HI_VARINST
    add LAST_UPDATED_TIME_ timestamp; 

-- 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_HI_PROCINST drop colum UNI_BUSINESS_KEY;
-- alter table ACT_HI_PROCINST drop colum UNI_PROC_DEF_ID;
-- Call Sysproc.admin_cmd ('REORG TABLE ACT_HI_PROCINST'); 


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

alter table ACT_HI_ACTINST alter column ASSIGNEE_ SET DATA TYPE varchar(255);

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