changes to table schemas. made changes to script to reflect database schemas.