From: Sarah Hoffmann <lonvia@denofr.de>
Date: Thu, 24 Feb 2022 19:49:39 +0000 (+0100)
Subject: add migration to add new derived_names column
X-Git-Tag: v4.1.0~76^2
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/54253946549dbb4d0b04b35830a811a6abe61549?hp=-c

add migration to add new derived_names column
---

54253946549dbb4d0b04b35830a811a6abe61549
diff --git a/nominatim/tools/migration.py b/nominatim/tools/migration.py
index dc6dfeca..997aa044 100644
--- 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
                     """)
+
+
+@_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 289af934..232cf6b6 100644
--- 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.
-NOMINATIM_VERSION = (4, 0, 99, 4)
+NOMINATIM_VERSION = (4, 0, 99, 5)
 
 POSTGRESQL_REQUIRED_VERSION = (9, 5)
 POSTGIS_REQUIRED_VERSION = (2, 2)