✨ Add OAuth authentication and user account features

Implement Google and GitHub sign-in options, user account deletion, and
attach avatars from OAuth providers. Update routes and migrations for
new user attributes.