All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.activiti.db.upgrade.activiti.oracle.upgradestep.53.to.54.history.sql Maven / Gradle / Ivy

There is a newer version: 3.0.Beta
Show newest version
alter table ACT_HI_DETAIL 
add DUE_DATE_ TIMESTAMP(6);

alter table ACT_HI_TASKINST 
add DUE_DATE_ TIMESTAMP(6);

create table ACT_HI_COMMENT (
    ID_ NVARCHAR2(64) not null,
    TIME_ TIMESTAMP(6) not null,
    USER_ID_ NVARCHAR2(255),
    TASK_ID_ NVARCHAR2(64),
    PROC_INST_ID_ NVARCHAR2(64),
    MESSAGE_ NVARCHAR2(255),
    primary key (ID_)
);

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




© 2015 - 2024 Weber Informatics LLC | Privacy Policy