Cleanup the database

• Fix a lot of incorrect nullable columns to be not null
• Fix columns not using bigint while they should in production (since the ids are bigint)
• Fix missing foreign keys
• Add missing unique index for users_roles
• Remove unused database columns
• Add missing nullify/destroy/deleteall dependent actions.

Closes #434 (closed)