| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849 | 
							- # MySQL < 5.6.4 does not support timestamps/dates with millisecond precision.
 
- # This upgrade file lacks the necessary upgrades that are done on a 5.6.4+ installation
 
- # to get millisecond precision.
 
- alter table ACT_RU_TASK 
 
-     add CATEGORY_ varchar(255);
 
-     
 
- alter table ACT_RU_EXECUTION drop foreign key ACT_FK_EXE_PROCDEF;  	
 
- alter table ACT_RU_EXECUTION drop index ACT_UNIQ_RU_BUS_KEY;  
 
- alter table ACT_RU_EXECUTION
 
-     add constraint ACT_FK_EXE_PROCDEF 
 
-     foreign key (PROC_DEF_ID_) 
 
-     references ACT_RE_PROCDEF (ID_);
 
-     
 
- alter table ACT_RE_DEPLOYMENT 
 
-     add TENANT_ID_ varchar(255) default ''; 
 
-     
 
- alter table ACT_RE_PROCDEF 
 
-     add TENANT_ID_ varchar(255) default '';     
 
-     
 
- alter table ACT_RU_EXECUTION
 
-     add TENANT_ID_ varchar(255) default '';    
 
-     
 
- alter table ACT_RU_TASK
 
-     add TENANT_ID_ varchar(255) default '';  
 
-     
 
- alter table ACT_RU_JOB
 
-     add TENANT_ID_ varchar(255) default '';   
 
-     
 
- alter table ACT_RE_MODEL
 
-     add TENANT_ID_ varchar(255) default '';  
 
-     
 
- alter table ACT_RU_EVENT_SUBSCR
 
-    add TENANT_ID_ varchar(255) default ''; 
 
-    
 
- alter table ACT_RU_EVENT_SUBSCR
 
-    add PROC_DEF_ID_ varchar(64);           
 
-     
 
- alter table ACT_RE_PROCDEF
 
-     drop index ACT_UNIQ_PROCDEF;
 
-     
 
- alter table ACT_RE_PROCDEF
 
-     add constraint ACT_UNIQ_PROCDEF
 
-     unique (KEY_,VERSION_, TENANT_ID_);      
 
- update ACT_GE_PROPERTY set VALUE_ = '5.15' where NAME_ = 'schema.version';
 
 
  |