Mercurial > gemma

diff schema/tap_tests_data.sql @ 580:e78bdbb6cac8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove worthless attribute According to RIS-Index Encoding Guide, section I.3.4 Waterway Gauge, the function code of a gauge is always 'wtwgag'. There is no point in storing the same value with every record.
author Tom Gottfried <tom@intevation.de>
date Thu, 06 Sep 2018 16:27:17 +0200
parents 642df1164aca
children 6590208e3ee1
line wrap: on
line diff
--- a/schema/tap_tests_data.sql	Thu Sep 06 16:15:38 2018 +0200
+++ b/schema/tap_tests_data.sql	Thu Sep 06 16:27:17 2018 +0200
@@ -20,10 +20,9 @@
 INSERT INTO limiting_factors VALUES ('depth'), ('width');
 
 INSERT INTO waterway.gauges (
-    location, function_code, objname, geom, zero_point, source_organization)
+    location, objname, geom, zero_point, source_organization)
     VALUES (
         ('AT', 'XXX', '00001', 'G0001', 1)::isrs,
-        'xxx',
         'testgauge',
         ST_geomfromtext('POINT(0 0)', 4326),
         0,