Use same database setup logic in tests and production

During #392 I found out that deletion triggers never got registered in the database.
However, tests relied on them still worked because they relied on separately implemented database construction logic (which correctly set up the `after_create` triggers _before_ creating the database tables).
This would have been caught much earlier if tests and production had shared the same logic for constructing the tables and triggers.