# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1536244037 -7200
# Node ID e78bdbb6cac829a125abf7bdd2aee01cb57975a9
# Parent  642df1164acabe0f5aa544495cd673f0a850f249
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.

diff -r 642df1164aca -r e78bdbb6cac8 schema/gemma.sql
--- a/schema/gemma.sql	Thu Sep 06 16:15:38 2018 +0200
+++ b/schema/gemma.sql	Thu Sep 06 16:27:17 2018 +0200
@@ -204,7 +204,6 @@
         location isrs PRIMARY KEY CHECK(
             (location).orc SIMILAR TO 'G[[:digit:]]{4}'
             AND CAST(substring((location).orc from 2 for 4) AS int) < 2048),
-        function_code varchar(10) NOT NULL, -- XXX: What is this really for?
         objname varchar NOT NULL,
         is_left boolean, -- XXX: Or reference position_codes?
         geom geography(POINT, 4326) NOT NULL,
diff -r 642df1164aca -r e78bdbb6cac8 schema/tap_tests_data.sql
--- 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,