Initial design first config
updates to sql, unit tests, partial classes