• Home
• org.jbpm
• jbpm-installer
• 7.21.0.Final
• source code
• bpms-6.4-to-7.0.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.upgrade-scripts.oracle.bpms-6.4-to-7.0.sql Maven / Gradle / Ivy

alter table RequestInfo add priority number(10,0);
alter table ProcessInstanceLog add processType number(10,0);

update ProcessInstanceLog set processType = 1;
update RequestInfo set priority = 5;

create table CaseIdInfo (
    id number(19,0) not null,
    caseIdPrefix varchar2(255 char),
    currentValue number(19,0),
    primary key (id)
);

create table CaseRoleAssignmentLog (
    id number(19,0) not null,
    caseId varchar2(255 char),
    entityId varchar2(255 char),
    processInstanceId number(19,0) not null,
    roleName varchar2(255 char),
    type number(10,0) not null,
    primary key (id)
);

alter table CaseIdInfo 
    add constraint UK_CaseIdInfo_1 unique (caseIdPrefix);

create sequence CASE_ID_INFO_ID_SEQ;

create sequence CASE_ROLE_ASSIGN_LOG_ID_SEQ;

ALTER TABLE NodeInstanceLog ADD referenceId number(19,0);
ALTER TABLE NodeInstanceLog ADD nodeContainerId varchar2(255 char);

ALTER TABLE RequestInfo ADD processInstanceId number(19,0);

ALTER TABLE AuditTaskImpl ADD lastModificationDate timestamp;
update AuditTaskImpl ati set lastModificationDate = (
    select max(logTime) from TaskEvent where taskId=ati.taskId group by taskId
);

create table CaseFileDataLog (
    id number(19,0) not null,
    caseDefId varchar2(255 char),
    caseId varchar2(255 char),
    itemName varchar2(255 char),
    itemType varchar2(255 char),
    itemValue varchar2(255 char),
    lastModified timestamp,
    lastModifiedBy varchar2(255 char),
    primary key (id)
);

create table ExecutionErrorInfo (
    id number(19,0) not null,
    ERROR_ACK number(5,0),
    ERROR_ACK_AT timestamp,
    ERROR_ACK_BY varchar2(255 char),
    ACTIVITY_ID number(19,0),
    ACTIVITY_NAME varchar2(255 char),
    DEPLOYMENT_ID varchar2(255 char),
    ERROR_INFO clob,
    ERROR_DATE timestamp,
    ERROR_ID varchar2(255 char),
    ERROR_MSG varchar2(255 char),
    INIT_ACTIVITY_ID number(19,0),
    JOB_ID number(19,0),
    PROCESS_ID varchar2(255 char),
    PROCESS_INST_ID number(19,0),
    ERROR_TYPE varchar2(255 char),
    primary key (id)
);

create sequence CASE_FILE_DATA_LOG_ID_SEQ;

create sequence EXEC_ERROR_INFO_ID_SEQ;

create index IDX_ErrorInfo_pInstId on ExecutionErrorInfo(PROCESS_INST_ID);
create index IDX_ErrorInfo_errorAck on ExecutionErrorInfo(ERROR_ACK);

alter table ProcessInstanceLog add sla_due_date timestamp;
alter table ProcessInstanceLog add slaCompliance number(10,0);
ALTER TABLE NodeInstanceLog ADD sla_due_date timestamp;
ALTER TABLE NodeInstanceLog ADD slaCompliance number(10,0);