add migration to add new derived_names column

diff --git a/nominatim/tools/migration.py b/nominatim/tools/migration.py
index dc6dfecabd811f1bad1faa4eb923323565611e8b..997aa044f67629f15ffa9bcc62f073629fb58a68 100644 (file)
--- a/nominatim/tools/migration.py
+++ b/nominatim/tools/migration.py
@@ -271,3 +271,12 @@ def add_step_column_for_tiger(conn, **_):
                          SET step = CASE WHEN interpolationtype = 'all'
                                          THEN 1 ELSE 2 END
                     """)
                          SET step = CASE WHEN interpolationtype = 'all'
                                          THEN 1 ELSE 2 END
                     """)

+
+
+@_migration(4, 0, 99, 4)
+def add_derived_name_column_for_country_names(conn, **_):
+    """ Add a new column 'derived_name' which in the future takes the
+        country names as imported from OSM data.
+    """
+    with conn.cursor() as cur:
+        cur.execute("ALTER TABLE country_name ADD COLUMN derived_name public.HSTORE")

diff --git a/nominatim/version.py b/nominatim/version.py
index 289af9346ef3c7957ca6c7873c54172759c090bb..232cf6b679c32f86b9d276911c6e01cc568a036f 100644 (file)
--- a/nominatim/version.py
+++ b/nominatim/version.py
@@ -24,7 +24,7 @@ Version information for Nominatim.
 # patch level when cherry-picking the commit with the migration.
 #
 # Released versions always have a database patch level of 0.
 # patch level when cherry-picking the commit with the migration.
 #
 # Released versions always have a database patch level of 0.

-NOMINATIM_VERSION = (4, 0, 99, 4)
+NOMINATIM_VERSION = (4, 0, 99, 5)

 
 POSTGRESQL_REQUIRED_VERSION = (9, 5)
 POSTGIS_REQUIRED_VERSION = (2, 2)
 
 POSTGRESQL_REQUIRED_VERSION = (9, 5)
 POSTGIS_REQUIRED_VERSION = (2, 2)