Acceptance criteria
- The database migration copies the existing tracking data of donations to the new tracking table.
Implementation details
- Create a migration that adds the new entity table and adds the tracking_id property to the donation (spenden) table
- Create a script that reads existing donations and their tracking information, creating new entries in the tracking table as needed (each campaign/keyword combination should be unique) and updating the donation. Don't do this in the migration because you need to query and modify the 7Mio+ donations in batches. Test the script in the test environment with the full production data set.