| 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_);
 |