org.flowable.db.upgrade.flowable.mssql.upgradestep.510.to.511.history.sql Maven / Gradle / Ivy
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_);