Fix database migrations

Everything should be drop if exists and create if not exists. We don't use this pattern everywhere, and it causes issues for people with partial migrations or if they did any manual database changes as advice to fix issues.