Josiah / JJsGeonamesBundle

GeoNames.org geographical data and associated functionality
18 stars 15 forks source link

Does not work with sqlite #10

Closed masseelch closed 6 years ago

masseelch commented 6 years ago

This bundle does not work with sqlite. I am running my tests in a gitlab-ci pipeline in a sqlite database. When trying to create the schema with php bin/console d:s:c --env=test i get the error:

SQLSTATE[HY000]: General error: 1 index geoname_id already exists' while executing DDL: CREATE INDEX geoname_id ON geo_state (geoname_id)

Both the State-Entity and the City-Entity have the same Index-name and sqlite cannot handle that. If there won't break something, i am happy to submit a PR to rename one of the indexes.