Modified Alfresco Activity Patch

--
-- Title:      Upgraded Activiti tables to 5.10 version
-- Database:   MySQL
-- Since:      V4.1 Schema 5115
-- Author:     Frederik Heremans
--
-- Please contact support@alfresco.com if you need assistance with the upgrade.
--
-- Upgraded Activiti tables to 5.10 version

--
-- Upgrade scripts for 5.8 to 5.9
--

UPDATE ACT_RE_PROCDEF SET REV_ = 1;
UPDATE ACT_RE_PROCDEF SET SUSPENSION_STATE_ = 1;
UPDATE ACT_RU_EXECUTION SET SUSPENSION_STATE_ = 1;

UPDATE ACT_RU_EXECUTION SET IS_EVENT_SCOPE_ = 0;

UPDATE ACT_GE_BYTEARRAY SET GENERATED_ = 0;

--
-- Upgrade scripts for 5.9 to 5.10
--

UPDATE ACT_RU_EXECUTION SET CACHED_ENT_STATE_ = 7;

--
-- Update engine properties table
--
UPDATE ACT_GE_PROPERTY SET VALUE_ = '5.10' WHERE NAME_ = 'schema.version';
UPDATE ACT_GE_PROPERTY SET VALUE_ = 'create(5.7) upgrade(5.10)' WHERE NAME_ = 'schema.history';

--
-- Record script finish
--
DELETE FROM alf_applied_patch WHERE id = 'patch.db-V4.2-upgrade-to-activiti-5.10';
INSERT INTO alf_applied_patch (id, description, fixes_from_schema, fixes_to_schema, applied_to_schema, target_schema, applied_on_date, applied_to_server, was_executed, succeeded, report) VALUES ('patch.db-V4.2-upgrade-to-activiti-5.10', 'Manually executed script upgrade V4.2: Upgraded Activiti tables to 5.10 version', 0, 5111, -1, 5112, NULL, 'UNKNOWN', 1, 1, 'Script completed');