tests for duplicate/email when account verification is false
fix broken indexes