1.8 to 1.9 migration of act.customerNote -> act.customerCommunicationNote failed to migrate reason

Description

The migrate_1.8-to-1.9.sql script incorrectly migrated act.customerNote to act.customerCommunicationNote.
It renames the 'category' node to 'reason' when it should be actually assigning it to the reason column of acts.

To correct this:
1. The acts.reason column should be updated for act.customerCommunicationNote acts where there is an act_details reason row, but only if users haven't subsequently changed the reason column
2. the act_details reason row should be deleted for act.customerCommunicationNote acts, if it exists

Environment

None

Status

Assignee

Tim Anderson

Reporter

Tim Anderson

Labels

None

Components

Fix versions

Affects versions

Priority

Minor
Configure