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.
17 lines
505 B
17 lines
505 B
3 years ago
|
alter table ACT_HI_TASKINST
|
||
|
|
add CLAIM_TIME_ TIMESTAMP(6);
|
||
|
|
|
||
|
|
alter table ACT_HI_TASKINST
|
||
|
|
add FORM_KEY_ NVARCHAR2(255);
|
||
|
|
|
||
|
|
alter table ACT_RU_IDENTITYLINK
|
||
|
|
add PROC_INST_ID_ NVARCHAR2(64);
|
||
|
|
|
||
|
|
create index ACT_IDX_IDL_PROCINST on ACT_RU_IDENTITYLINK(PROC_INST_ID_);
|
||
|
|
alter table ACT_RU_IDENTITYLINK
|
||
|
|
add constraint ACT_FK_IDL_PROCINST
|
||
|
|
foreign key (PROC_INST_ID_)
|
||
|
|
references ACT_RU_EXECUTION (ID_);
|
||
|
|
|
||
|
|
create index ACT_IDX_HI_ACT_INST_EXEC on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_);
|
||
|
|
|