# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1525723990 -7200
# Node ID dd858a74b4e9eb5403922fd2214e6f5aca09cb81
# Parent  535e57373a93891b746afd557d9f3536e58f91f7
Set columns referencing countries next to each other.

diff -r 535e57373a93 -r dd858a74b4e9 wamos.sql
--- a/wamos.sql	Mon May 07 09:29:58 2018 +0200
+++ b/wamos.sql	Mon May 07 22:13:10 2018 +0200
@@ -94,9 +94,9 @@
        rb_lb varchar, -- XXX: Why two data in one attribute? Why not:
        rb char(2) NOT NULL REFERENCES countries,
        lb char(2) NOT NULL REFERENCES countries,
+       responsible_country char(2) NOT NULL REFERENCES countries,
        riverbed varchar NOT NULL REFERENCES riverbed_materials,
        -- XXX: should be 'natsur' according to IENC Encoding Guide M.4.3
-       responsible_country char(2) NOT NULL REFERENCES countries,
        revisiting_time smallint NOT NULL,
        surtyp varchar NOT NULL REFERENCES survey_types,
        -- XXX: Not an attribut of sounding result?