# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1525724280 -7200
# Node ID 47f1ffdc6ef4fb6ee6941199e48bf25dc126a601
# Parent  dd858a74b4e9eb5403922fd2214e6f5aca09cb81
Cleanup rb_lb.

diff -r dd858a74b4e9 -r 47f1ffdc6ef4 wamos.sql
--- a/wamos.sql	Mon May 07 22:13:10 2018 +0200
+++ b/wamos.sql	Mon May 07 22:18:00 2018 +0200
@@ -91,9 +91,8 @@
        objnam varchar UNIQUE NOT NULL,
        nobjnm varchar UNIQUE,
        stretch isrsrange NOT NULL,
-       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,
+       rb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface
+       lb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface
        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