Update phinx

Closes #1774 (closed)

What does this MR do?

Updates robmorgan/phinx to 0.16.1. I had to make some minor changes to the migrations because the new version of phinx has some breaking changes.

The only actual change in the database is that the columns foodsaver_id and achievement_id in fs_foodsaver_has_achievement are made unsigned and non-null to be compliant with the foreign keys.

How confident are you it won't break things if deployed?

should be ok if the pipeline passes

Links to related issues

How to test

Screenshots (if applicable)

Checklist

• added a test, or explain why one is not needed/possible...
• no unrelated changes
• asked someone for a code review
• set a "for:" label to indicate who will be affected by this change
• set the "API change" label if changes in the API are not backward compatible
• added to the next milestone (see https://gitlab.com/foodsharing-dev/foodsharing/-/milestones, unless it has a "for:Dev" label)
• added an entry to CHANGELOG.md
• added a short text in the release notes to /release-notes/YYYY-MM.md
• Once your MR has been merged, you are responsible to create a testing issue in the Beta Testing forum: https://foodsharing.de/region?bid=734&sub=forum. Please change the MRs label to "state:Beta testing".
  • Consider writing a detailed description in German.
  • Describe in a few sentences, what should be tested from a user perspective.
  • Also mention different settings (e.g. different browsers, roles, ...) how this change can be tested.
  • Be aware, that also non technical people should understand.

Closes #1774 (closed)