THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
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.