Revert "Modified migrations and schema to use better constraints"

This reverts commit 567af9ce056aa127eaab1429065fb266549ee6c2.
Require email address (unique + index), remove password column, require
password_digest