implemented the schema in postgresql
appended the existing schema file with the schema dump from postgres