Purge migrations and update schema

There are a lot of migrations which can no longer be applied. We should purge the migrations and update the schema with the current state of production. Here we should also add limits as those are present in MySQL but not in SQLite. This would ensure that production errors with the database are more likely to also show in development.

For the timing of this, this needs to be synced to occur after a release to production and this has been confirmed to be stable. The last few migrations can be kept.