db.upgrade-scripts.sqlserver.bpms-6.1-to-6.2.sql Maven / Gradle / Ivy
ALTER TABLE ProcessInstanceLog ADD correlationKey varchar(255);
ALTER TABLE TaskEvent ADD message varchar(255);
ALTER TABLE AuditTaskImpl ADD workItemId numeric(19,0);
UPDATE AuditTaskImpl SET workItemId = (SELECT workItemId FROM Task WHERE Task.id = AuditTaskImpl.taskId);
create index IDX_PInstLog_correlation on ProcessInstanceLog(correlationKey);