db.upgrade-scripts.sqlserver.bpms-6.2-to-6.3.sql Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of jbpm-installer

There is a newer version: 7.74.1.Final

create table TaskVariableImpl (
    id numeric(19,0) identity not null,
    modificationDate datetime,
    name varchar(255),
    processId varchar(255),
    processInstanceId numeric(19,0),
    taskId numeric(19,0),
    type int,
    value varchar(4000),
    primary key (id)
);

create table QueryDefinitionStore (
    id numeric(19,0) identity not null,
    qExpression text,
    qName varchar(255),
    qSource varchar(255),
    qTarget varchar(255),
    primary key (id)
);

alter table QueryDefinitionStore 
        add constraint UK_4ry5gt77jvq0orfttsoghta2j unique (qName);
        
create index IDX_VInstLog_pInstId on VariableInstanceLog(processInstanceId);
create index IDX_VInstLog_varId on VariableInstanceLog(variableId);
create index IDX_VInstLog_pId on VariableInstanceLog(processId);

create index IDX_NInstLog_pInstId on NodeInstanceLog(processInstanceId);
create index IDX_NInstLog_nodeType on NodeInstanceLog(nodeType);
create index IDX_NInstLog_pId on NodeInstanceLog(processId);