Mercurial > gemma
changeset 42:47f1ffdc6ef4
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