# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1527879123 -7200
# Node ID c79fd71ebe06e5693fb6bbbfaa56a99ea2b0f105
# Parent  611dc09dbcd8aec28d6caddcf6498b63b21a131b
Comment out some rather spurious attributes.

diff -r 611dc09dbcd8 -r c79fd71ebe06 wamos.sql
--- a/wamos.sql	Fri Jun 01 20:43:06 2018 +0200
+++ b/wamos.sql	Fri Jun 01 20:52:03 2018 +0200
@@ -170,7 +170,7 @@
        sender varchar NOT NULL, -- "from" attribute from DRC
        language_code varchar NOT NULL REFERENCES language_codes,
        date_issue timestamp with time zone NOT NULL,
-       reference_code varchar(4) NOT NULL REFERENCES depth_references,
+       -- reference_code varchar(4) NOT NULL REFERENCES depth_references,
        -- XXX: Always ZPG?
        water_level double precision NOT NULL,
        predicted boolean NOT NULL,
@@ -305,13 +305,13 @@
        responsible_country char(2) NOT NULL REFERENCES countries,
        revisiting_time smallint NOT NULL,
        limiting varchar NOT NULL REFERENCES limiting_factors,
-       surtyp varchar NOT NULL REFERENCES survey_types,
+       -- surtyp varchar NOT NULL REFERENCES survey_types,
        -- XXX: Also an attribut of sounding result?
-       coverage varchar REFERENCES coverage_types,
+       -- coverage varchar REFERENCES coverage_types,
        -- XXX: Also an attribut of sounding result?
        -- CHECK allowed combinations of surtyp and coverage or
        -- different model approach?
-       depth_reference char(3) NOT NULL REFERENCES depth_references,
+       -- depth_reference char(3) NOT NULL REFERENCES depth_references,
        -- XXX: Also an attribut of sounding result?
        date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
        source_organization varchar NOT NULL,