| 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,    LONG_ bigint,    TEXT_ varchar(4000),    TEXT2_ varchar(4000),    primary key (ID_)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;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_ varchar(64);	alter table ACT_HI_ACTINST	add CALL_PROC_INST_ID_ varchar(64);alter table ACT_HI_DETAIL	MODIFY PROC_INST_ID_ varchar(64) null;alter table ACT_HI_DETAIL	MODIFY EXECUTION_ID_ varchar(64) null;	create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
 |