schema

added schema diagram and updated a minor bug in the createscripts file.