[fix] fixed drop scripts to reflect latest database schema
[fix] added fields to insert statements