diff schema/gemma.sql @ 1547:d4b7a6d054cd

Add table to store import configuration.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 10 Dec 2018 15:55:10 +0100
parents 6ad1f431bc85
children 056a86b24be2
line wrap: on
line diff
--- a/schema/gemma.sql	Mon Dec 10 15:31:27 2018 +0100
+++ b/schema/gemma.sql	Mon Dec 10 15:55:10 2018 +0100
@@ -541,6 +541,17 @@
       waterway.sounding_results
       GROUP BY bottleneck_id) sr ON sr.bottleneck_id = bn.bottleneck_id
     ORDER BY objnam
+
+    CREATE TABLE import_configuration (
+        id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
+        username varchar NOT NULL
+            REFERENCES internal.user_profiles(username)
+                ON DELETE CASCADE
+                ON UPDATE CASCADE,
+        kind varchar NOT NULL,
+        cron varchar,
+        url  varchar
+    )
 ;
 
 -- Configure primary keys for geoserver views