diff schema/gemma.sql @ 2147:b66cfcde8ff7

Print templates: Stubbed endpoints under /api/templates/print/{name}
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 08 Feb 2019 11:02:05 +0100
parents 3f58809d2beb
children 5fdeb41f3ed4
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Feb 07 17:45:00 2019 +0100
+++ b/schema/gemma.sql	Fri Feb 08 11:02:05 2019 +0100
@@ -188,13 +188,13 @@
     CREATE TRIGGER templates_date_info BEFORE UPDATE ON templates
         FOR EACH ROW EXECUTE PROCEDURE update_date_info()
 
-    CREATE TABLE user_templates (
-        username varchar NOT NULL
-            REFERENCES internal.user_profiles
-                ON DELETE CASCADE ON UPDATE CASCADE,
-        template_name varchar NOT NULL REFERENCES templates ON DELETE CASCADE,
-        PRIMARY KEY (username, template_name)
-    )
+    -- CREATE TABLE user_templates (
+    --    username varchar NOT NULL
+    --        REFERENCES internal.user_profiles
+    --            ON DELETE CASCADE ON UPDATE CASCADE,
+    --    template_name varchar NOT NULL REFERENCES templates ON DELETE CASCADE,
+    --    PRIMARY KEY (username, template_name)
+    --)
 ;
 ALTER TABLE internal.user_profiles ADD
     country char(2) NOT NULL REFERENCES users.responsibility_areas;