Add database-level support for banning and soft-deleting users

TODO:
- Allow users to delete their account.
- Allow admins to delete accounts.
- Allow moderators and admins to ban accounts.
- Allow admins to unban and restore accounts.