From 976c5e9121c0aa0a26ca6d2362a4a918c7186dc4 Mon Sep 17 00:00:00 2001
From: Sarah Hoffmann <lonvia@denofr.de>
Date: Mon, 1 Mar 2021 16:09:17 +0100
Subject: [PATCH] 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.
---
 lib-sql/tables.sql | 7 +++++++
 1 file changed, 7 insertions(+)

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,
-- 
2.45.1