From: Sarah Hoffmann <lonvia@denofr.de>
Date: Mon, 1 Mar 2021 15:09:17 +0000 (+0100)
Subject: introduce table for in-database properties
X-Git-Tag: v3.7.0~25^2~8
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/976c5e9121c0aa0a26ca6d2362a4a918c7186dc4?hp=db663dd92f1d2cc1b34f1260ce6c190abcd50c76

introduce table for in-database properties

Adds a simple table where settings for the database can be
saved. This is useful for state that must not change after
import.
---

diff --git a/lib-sql/tables.sql b/lib-sql/tables.sql
index d15e42c4..ce11c410 100644
--- a/lib-sql/tables.sql
+++ b/lib-sql/tables.sql
@@ -36,6 +36,13 @@ GRANT SELECT ON new_query_log TO "{www-user}" ;
 
 GRANT SELECT ON TABLE country_name TO "{www-user}";
 
+DROP TABLE IF EXISTS nominatim_properties;
+CREATE TABLE nominatim_properties (
+    property TEXT,
+    value TEXT
+);
+GRANT SELECT ON TABLE nominatim_properties TO "{www-user}";
+
 drop table IF EXISTS word;
 CREATE TABLE word (
   word_id INTEGER,