| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162 | 
							- 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';
 
 
  |