refactoring the sql creating functions
add and verify email tests