org.flowable.variable.service.db.create.flowable.gbase8s.create.variable.history.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of db-migration-flowable

db-migration 使用 Liquibase 支持 Flowable 工作流。

There is a newer version: 7.0.1.1

create table ACT_HI_VARINST (
    ID_ VARCHAR(64) not null,
    REV_ INTEGER default 1,
    PROC_INST_ID_ VARCHAR(64),
    EXECUTION_ID_ VARCHAR(64),
    TASK_ID_ VARCHAR(64),
    NAME_ VARCHAR(255) not null,
    VAR_TYPE_ VARCHAR(100),
    SCOPE_ID_ VARCHAR(255),
    SUB_SCOPE_ID_ VARCHAR(255),
    SCOPE_TYPE_ VARCHAR(255),
    BYTEARRAY_ID_ VARCHAR(64),
    DOUBLE_ DECIMAL(28,10),
    LONG_ DECIMAL(19,0),
    TEXT_ VARCHAR(2000),
    TEXT2_ VARCHAR(2000),
    META_INFO_ VARCHAR(2000),
    CREATE_TIME_ TIMESTAMP(6),
    LAST_UPDATED_TIME_ TIMESTAMP(6),
    primary key (ID_)
);

create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
create index ACT_IDX_HI_VAR_SCOPE_ID_TYPE on ACT_HI_VARINST(SCOPE_ID_, SCOPE_TYPE_);
create index ACT_IDX_HI_VAR_SUB_ID_TYPE on ACT_HI_VARINST(SUB_SCOPE_ID_, SCOPE_TYPE_);