org.flowable.db.upgrade.flowable.mssql.upgradestep.53.to.54.history.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of flowable-engine Show documentation

There is a newer version: 7.0.1

alter table ACT_HI_DETAIL 
add DUE_DATE_ datetime;

alter table ACT_HI_TASKINST 
add DUE_DATE_ datetime;

create table ACT_HI_COMMENT (
    ID_ nvarchar(64) not null,
    TIME_ datetime not null,
    USER_ID_ nvarchar(255),
    TASK_ID_ nvarchar(64),
    PROC_INST_ID_ nvarchar(64),
    MESSAGE_ nvarchar(255),
    primary key (ID_)
);

create table ACT_HI_ATTACHMENT (
    ID_ nvarchar(64) not null,
    REV_ integer,
    NAME_ nvarchar(255),
    DESCRIPTION_ nvarchar(255),
    TYPE_ nvarchar(255),
    TASK_ID_ nvarchar(64),
    PROC_INST_ID_ nvarchar(64),
    URL_ nvarchar(255),
    CONTENT_ID_ nvarchar(64),
    primary key (ID_)
);