updated sql, removed unused files