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