updated db schema and changed script to reflect changes