covid-vaccine-spotter icon indicating copy to clipboard operation
covid-vaccine-spotter copied to clipboard

Published 20 hours ago • verified publisher icon GUI

Fix invalid db migration

Open strategist333 opened this issue 4 years ago • 1 comments

country_grid_25km appears to be a typo: it was never created prior to the migration in 20210408224048_convert_materialized_views.js and appears not to be currently used.

This change prevents the bootstrap_db from failing with

migration failed with error: CREATE TABLE country_grid_25km_real (LIKE country_grid_25km INCLUDING ALL) - relation "country_grid_25km" does not exist

For convenience, the db/structure.sql is also updated.

strategist333 avatar Apr 11 '21 22:04 strategist333

The migrations seem to assume the structure is already created, but the bootstrap doesn't initialize the structure. I fixed it here as well

https://github.com/GUI/covid-vaccine-spotter/pull/137

chrismcmacken avatar Apr 16 '21 18:04 chrismcmacken