Mercurial > gemma

diff schema/tap_tests_data.sql @ 211:e7826710d9c4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Make responsibility area mandatory Each waterway administrator has to have a responsibility area assigned, which is now ensured by referencing the respective table instead of countries directly.
author Tom Gottfried <tom@intevation.de>
date Mon, 23 Jul 2018 16:45:27 +0200
parents 88d21c29cf04
children 57dfab80973c
line wrap: on
line diff
--- a/schema/tap_tests_data.sql	Mon Jul 23 16:40:21 2018 +0200
+++ b/schema/tap_tests_data.sql	Mon Jul 23 16:45:27 2018 +0200
@@ -5,7 +5,8 @@
 INSERT INTO countries VALUES ('AT'), ('RO');
 
 INSERT INTO users.responsibility_areas VALUES
-    ('AT', ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326));
+    ('AT', ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326)),
+    ('RO', ST_geomfromtext('MULTIPOLYGON(((1 0, 1 1, 2 1, 2 0, 1 0)))', 4326));
 
 SELECT sys_admin.create_user(
     'waterway_user', 'user_at', 'user_at', 'AT', NULL, 'xxx');