first pass on new sql database structure
removing unused auth scheme properties