| 123456789101112131415161718192021222324252627 | 
							- alter table ACT_RU_IDENTITYLINK 
 
- add PROC_DEF_ID_ varchar(64);
 
- create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
 
- create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
 
- alter table ACT_RU_IDENTITYLINK
 
-     add constraint ACT_FK_ATHRZ_PROCEDEF 
 
-     foreign key (PROC_DEF_ID_) 
 
-     references ACT_RE_PROCDEF (ID_);
 
-     
 
- alter table ACT_RU_EXECUTION 
 
- 	add CACHED_ENT_STATE_ integer;
 
- update ACT_RU_EXECUTION set CACHED_ENT_STATE_ = 7;
 
- alter table ACT_RE_PROCDEF 
 
-   alter column KEY_ set not null;
 
- alter table ACT_RE_PROCDEF
 
-   alter column VERSION_ set not null;
 
- Call Sysproc.admin_cmd ('REORG TABLE ACT_RE_PROCDEF');
 
- alter table ACT_RE_PROCDEF
 
-     add constraint ACT_UNIQ_PROCDEF
 
-     unique (KEY_,VERSION_);
 
 
  |