updated utility methods. changed db schema, updated script to reflect new schema