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

Assignee

Tim Anderson

Reporter

Tim Anderson

Labels

None

Components

Fix versions

Affects versions

Priority

Minor
Configure