Revise migration constraints and remove users

 - New migration to drop the users table
 - Revised migrations to have a few more constraints
 - Researched putting uniqueness validations in the migrations
   -> would work if we indexed columns; too much complexity for now