 /** 03.08.2012 */
+/** NOTE: Need to change the "CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('TABLE', '<SCHEMA>', NULL);"-Statement - replace <SCHEMA> in Line 67 */ 
 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_REVALIDATE_DB_OBJECTS('TABLE', 'FOX_UPDT', NULL);
alter table ACT_RE_PROCDEF 
    add constraint ACT_UNIQ_PROCDEF
    unique (KEY_,VERSION_);

    
create table ACT_HI_PROCVARIABLE (

    REV_ = REV_ + 1
where NAME_ = 'historyLevel' and VALUE_ >= 2;

CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('TABLE', '<SCHEMA>', NULL);
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_PROCDEF 
    add constraint ACT_UNIQ_PROCDEF
    unique (KEY_,VERSION_);

alter table ACT_RU_IDENTITYLINK
    add constraint ACT_FK_ATHRZ_PROCEDEF 
