added a uniqueness constraint on the user accounts table and added an active boolean field