diff schema/tap_tests_data.sql @ 2230:4374d942b23d

Remove debris and associate templates to country While the original idea was to associate templates to users, managed by a waterway admin per country, the new intention was to share templates between users per country. Just removing any constraints on readability and management of the templates did not fulfill this idea.
author Tom Gottfried <tom@intevation.de>
date Wed, 13 Feb 2019 10:52:14 +0100
parents b66cfcde8ff7
children 99274fed6f3d
line wrap: on
line diff
--- a/schema/tap_tests_data.sql	Wed Feb 13 08:00:26 2019 +0100
+++ b/schema/tap_tests_data.sql	Wed Feb 13 10:52:14 2019 +0100
@@ -88,10 +88,8 @@
     'testriver'
 );
 
-INSERT INTO users.templates (template_name, template_data)
-    VALUES ('AT', '\x'), ('RO', '\x');
---INSERT INTO users.user_templates
---    VALUES ('test_user_at', 'AT'), ('test_user_ro', 'RO');
+INSERT INTO users.templates (template_name, country, template_data)
+    VALUES ('AT', 'AT', '\x'), ('RO', 'RO', '\x');
 
 WITH
 job AS (