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
898 B
32 lines
898 B
create table ACT_HI_VARINST ( |
|
ID_ varchar(64) not null, |
|
PROC_INST_ID_ varchar(64), |
|
EXECUTION_ID_ varchar(64), |
|
TASK_ID_ varchar(64), |
|
NAME_ varchar(255) not null, |
|
VAR_TYPE_ varchar(100), |
|
REV_ integer, |
|
BYTEARRAY_ID_ varchar(64), |
|
DOUBLE_ double precision, |
|
LONG_ bigint, |
|
TEXT_ varchar(4000), |
|
TEXT2_ varchar(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 column TASK_ID_ varchar(64); |
|
|
|
alter table ACT_HI_ACTINST |
|
add column CALL_PROC_INST_ID_ varchar(64); |
|
|
|
alter table ACT_HI_DETAIL |
|
alter column PROC_INST_ID_ drop not null; |
|
|
|
alter table ACT_HI_DETAIL |
|
alter column EXECUTION_ID_ drop not null; |
|
|
|
create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_); |