Mercurial > gemma

changeset 41:dd858a74b4e9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Set columns referencing countries next to each other.
author Tom Gottfried <tom@intevation.de>
date Mon, 07 May 2018 22:13:10 +0200
parents 535e57373a93
children 47f1ffdc6ef4
files wamos.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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?