Drop test database before running tests.

To ensure tests run with a clean state - no stale data, indexes etc.

Also enabled `autocreate_indexes` for tests so that the model defined
indexes are created.