You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
19 lines
556 B
19 lines
556 B
alter table ACT_RU_IDENTITYLINK |
|
add PROC_DEF_ID_ nvarchar(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_ int; |
|
|
|
update ACT_RU_EXECUTION set CACHED_ENT_STATE_ = 7; |
|
|
|
alter table ACT_RE_PROCDEF |
|
add constraint ACT_UNIQ_PROCDEF |
|
unique (KEY_,VERSION_); |