all tests are passing, new sql scripts, and ProfileService refactoring