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 d15e42c445eebf71d5cbc1d0b005ee4f1ad3a6bc..ce11c4105c4a8463f9ac96570648c7f29a200a35 100644 (file)
--- 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}";
 
 
 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,
 drop table IF EXISTS word;
 CREATE TABLE word (
   word_id INTEGER,