org.flowable.db.upgrade.flowable.postgres.upgradestep.50.to.51.history.sql Maven / Gradle / Ivy
create table ACT_HI_TASKINST (
ID_ varchar(64) not null,
PROC_DEF_ID_ varchar(64),
TASK_DEF_KEY_ varchar(255),
PROC_INST_ID_ varchar(64),
EXECUTION_ID_ varchar(64),
NAME_ varchar(255),
DESCRIPTION_ varchar(255),
ASSIGNEE_ varchar(64),
START_TIME_ timestamp not null,
END_TIME_ timestamp,
DURATION_ bigint,
DELETE_REASON_ varchar(255),
primary key (ID_)
);
alter table ACT_HI_DETAIL add column TASK_ID_ varchar(64);