Move the auth_user method to the User model.

The auth_user belongs to the User, didn't
make any sense to leave that in the database
model.