sync up with database initialization changes for test profile; initial API tests
sync up with database initialization changes for test profile; initial API tests
updates to support retailtosubscription testing
tests for filter based on API and roles first draft completed (except for bulk)
removed path dependencies from sql files and scripts