Page History

...

After upgrade run the 'migrateCustRequestRole' service to copy the current data to the new table (from OldSalaryStep to SalaryStep).

R1738588 "Improved CMS tree: more functionality and faster for large trees" https://issues.apache.org/jira/browse/OFBIZ-4502

This added the fromDate, and thru Date fields to the WebSitePathAlias entity, fromDate is a PK field.

It was said in the JIRA that "To migrate existing path aliases the following SQL statements can be used:"

BEGIN;

UPDATE web_site_path_alias SET from_date=w.created_stamp FROM web_site_path_alias w WHERE w.path_alias=web_site_path_alias.path_alias;

ALTER TABLE web_site_path_alias

    DROP CONSTRAINT pk_web_site_path_alias,

    ADD CONSTRAINT pk_web_site_path_alias PRIMARY KEY (web_site_id, path_alias, from_date);

COMMIT;

I quickly tried this in EntitySQLProcessor it does not work. We need instead to provide a migrateWebSitePathAlias migrating service.