moved few drop statements to resolve dependencies
fixed some error msg and linting issues in tests
added migration to drop old views and clear stale privileges