update ddl and dml files for postgres

[MiConnell]

drop tables-add if exist for safer drops make sure all create statements have corresponding drop statements

happy to hear your thoughts on this, this is only minimally tested but I noticed that running the drop script didn't drop everything so I went ahead and updated all the scripts