updated sql schema added some testing statements