Mercurial > gemma

changeset 42:47f1ffdc6ef4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Cleanup rb_lb.
author Tom Gottfried <tom@intevation.de>
date Mon, 07 May 2018 22:18:00 +0200
parents dd858a74b4e9
children e84ff54eb8e9
files wamos.sql
diffstat 1 files changed, 2 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- 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