db.upgrade-scripts.mysqlinnodb.jbpm-6.2-to-6.3.sql Maven / Gradle / Ivy
ALTER TABLE ProcessInstanceLog ADD COLUMN correlationKey VARCHAR(255);
ALTER TABLE TaskEvent ADD COLUMN message varchar(255);
ALTER TABLE AuditTaskImpl ADD COLUMN workItemId bigint;
UPDATE AuditTaskImpl a SET workItemId = (SELECT workItemId FROM Task WHERE id = a.taskId);
CREATE index IDX_PInstLog_correlation ON ProcessInstanceLog(correlationKey);