All Downloads are FREE. Search and download functionalities are using the official Maven repository.
Please wait. This can take some minutes ...
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.jbpm-6.5-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);