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.
32 lines
909 B
32 lines
909 B
create table ACT_HI_VARINST ( |
|
ID_ nvarchar(64) not null, |
|
PROC_INST_ID_ nvarchar(64), |
|
EXECUTION_ID_ nvarchar(64), |
|
TASK_ID_ nvarchar(64), |
|
NAME_ nvarchar(255) not null, |
|
VAR_TYPE_ nvarchar(100), |
|
REV_ int, |
|
BYTEARRAY_ID_ nvarchar(64), |
|
DOUBLE_ double precision, |
|
LONG_ numeric(19,0), |
|
TEXT_ nvarchar(4000), |
|
TEXT2_ nvarchar(4000), |
|
primary key (ID_) |
|
); |
|
|
|
create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_); |
|
create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_); |
|
|
|
alter table ACT_HI_ACTINST |
|
add TASK_ID_ nvarchar(64); |
|
|
|
alter table ACT_HI_ACTINST |
|
add CALL_PROC_INST_ID_ nvarchar(64); |
|
|
|
alter table ACT_HI_DETAIL |
|
alter column PROC_INST_ID_ nvarchar(64) null; |
|
|
|
alter table ACT_HI_DETAIL |
|
alter column EXECUTION_ID_ nvarchar(64) null; |
|
|
|
create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_); |