| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162 | 
							- alter table ACT_RE_PROCDEF
 
-     modify KEY_ not null;
 
- alter table ACT_RE_PROCDEF
 
-     modify VERSION_ not null;
 
-     
 
- alter table ACT_RE_DEPLOYMENT 
 
-     add CATEGORY_ NVARCHAR2(255);
 
-     
 
- alter table ACT_RE_PROCDEF
 
-     add DESCRIPTION_ NVARCHAR2(2000);
 
-     
 
- alter table ACT_RU_TASK
 
-     add SUSPENSION_STATE_ INTEGER;
 
-     
 
- update ACT_RU_TASK set SUSPENSION_STATE_ = 1; 
 
- alter table ACT_RU_EXECUTION
 
-     add constraint ACT_FK_EXE_PROCDEF 
 
-     foreign key (PROC_DEF_ID_) 
 
-     references ACT_RE_PROCDEF (ID_);    
 
- create table ACT_RE_MODEL (
 
-     ID_ NVARCHAR2(64) not null,
 
-     REV_ INTEGER,
 
-     NAME_ NVARCHAR2(255),
 
-     KEY_ NVARCHAR2(255),
 
-     CATEGORY_ NVARCHAR2(255),
 
-     CREATE_TIME_ TIMESTAMP(6),
 
-     LAST_UPDATE_TIME_ TIMESTAMP(6),
 
-     VERSION_ INTEGER,
 
-     META_INFO_ NVARCHAR2(2000),
 
-     DEPLOYMENT_ID_ NVARCHAR2(64),
 
-     EDITOR_SOURCE_VALUE_ID_ NVARCHAR2(64),
 
-     EDITOR_SOURCE_EXTRA_VALUE_ID_ NVARCHAR2(64),
 
-     primary key (ID_)
 
- );
 
- create index ACT_IDX_MODEL_SOURCE on ACT_RE_MODEL(EDITOR_SOURCE_VALUE_ID_);
 
- alter table ACT_RE_MODEL 
 
-     add constraint ACT_FK_MODEL_SOURCE 
 
-     foreign key (EDITOR_SOURCE_VALUE_ID_) 
 
-     references ACT_GE_BYTEARRAY (ID_);
 
- create index ACT_IDX_MODEL_SOURCE_EXTRA on ACT_RE_MODEL(EDITOR_SOURCE_EXTRA_VALUE_ID_);
 
- alter table ACT_RE_MODEL 
 
-     add constraint ACT_FK_MODEL_SOURCE_EXTRA 
 
-     foreign key (EDITOR_SOURCE_EXTRA_VALUE_ID_) 
 
-     references ACT_GE_BYTEARRAY (ID_);
 
-     
 
- create index ACT_IDX_MODEL_DEPLOYMENT on ACT_RE_MODEL(DEPLOYMENT_ID_);    
 
- alter table ACT_RE_MODEL 
 
-     add constraint ACT_FK_MODEL_DEPLOYMENT 
 
-     foreign key (DEPLOYMENT_ID_) 
 
-     references ACT_RE_DEPLOYMENT (ID_);        
 
- delete from ACT_GE_PROPERTY where NAME_ = 'historyLevel';
 
- alter table ACT_RU_JOB
 
-     add PROC_DEF_ID_ NVARCHAR2(64);
 
- update ACT_GE_PROPERTY set VALUE_ = '5.11' where NAME_ = 'schema.version';
 
 
  |