Mercurial > gemma

changeset 95:c79fd71ebe06

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Comment out some rather spurious attributes.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Jun 2018 20:52:03 +0200
parents 611dc09dbcd8
children d036e1bd5f00
files wamos.sql
diffstat 1 files changed, 4 insertions(+), 4 deletions(-) [+]
line wrap: on
line diff
--- 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,