Mercurial > gemma

comparison schema/tap_tests_data.sql @ 2381:99274fed6f3d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Validate country and hectometre in ISRS code
author Tom Gottfried <tom@intevation.de>
date Fri, 22 Feb 2019 18:02:23 +0100
parents 4374d942b23d
children 8481e6266691
comparison
equal deleted inserted replaced
2380:5f300bd7316f 2381:99274fed6f3d
14 14
15 -- 15 --
16 -- Test data used in *_tests.sql scripts 16 -- Test data used in *_tests.sql scripts
17 -- 17 --
18 18
19 INSERT INTO countries VALUES ('AT'), ('RO'); 19 INSERT INTO countries VALUES ('AT'), ('RO'), ('DE');
20 20
21 INSERT INTO users.responsibility_areas VALUES 21 INSERT INTO users.responsibility_areas VALUES
22 ('AT', ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326)), 22 ('AT', ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326)),
23 ('RO', ST_geomfromtext('MULTIPOLYGON(((1 0, 1 1, 2 1, 2 0, 1 0)))', 4326)); 23 ('RO', ST_geomfromtext('MULTIPOLYGON(((1 0, 1 1, 2 1, 2 0, 1 0)))', 4326));
24 24