db.upgrade-scripts.sybase.jbpm-6.5-to-7.0.sql Maven / Gradle / Ivy
alter table RequestInfo add priority int;
ALTER TABLE ProcessInstanceLog ADD processType int;
update ProcessInstanceLog set processType = 1;
update RequestInfo set priority = 5;
create table CaseIdInfo (
id bigint identity not null,
caseIdPrefix varchar(255) null,
currentValue bigint null,
primary key (id)
) lock datarows;
create table CaseRoleAssignmentLog (
id bigint identity not null,
caseId varchar(255) null,
entityId varchar(255) null,
processInstanceId bigint not null,
roleName varchar(255) null,
type int not null,
primary key (id)
) lock datarows;
alter table CaseIdInfo
add constraint UK_CaseIdInfo_1 unique (caseIdPrefix);
ALTER TABLE NodeInstanceLog ADD COLUMN referenceId bigint null;
ALTER TABLE NodeInstanceLog ADD COLUMN nodeContainerId varchar(255) null;
ALTER TABLE RequestInfo ADD COLUMN processInstanceId bigint null;
ALTER TABLE AuditTaskImpl ADD COLUMN lastModificationDate datetime;
update AuditTaskImpl ati set lastModificationDate = (
select max(logTime) from TaskEvent where taskId=ati.taskId group by taskId
);
create table CaseFileDataLog (
id bigint identity not null,
caseDefId varchar(255) null,
caseId varchar(255) null,
itemName varchar(255) null,
itemType varchar(255) null,
itemValue varchar(255) null,
lastModified datetime null,
lastModifiedBy varchar(255) null,
primary key (id)
) lock datarows;
create table ExecutionErrorInfo (
id bigint identity not null,
ERROR_ACK tinyint null,
ERROR_ACK_AT datetime null,
ERROR_ACK_BY varchar(255) null,
ACTIVITY_ID bigint null,
ACTIVITY_NAME varchar(255) null,
DEPLOYMENT_ID varchar(255) null,
ERROR_INFO text null,
ERROR_DATE datetime null,
ERROR_ID varchar(255) null,
ERROR_MSG varchar(255) null,
JOB_ID bigint null,
PROCESS_ID varchar(255) null,
PROCESS_INST_ID bigint null,
ERROR_TYPE varchar(255) null,
primary key (id)
) lock datarows;