# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1525725072 -7200
# Node ID dcc3b1134b24ce8cfad165cc425fe08fd4499999
# Parent  e84ff54eb8e9b943442cb8fd2f20acff7857c70d
Multiple riverbed materials per bottleneck possible.

diff -r e84ff54eb8e9 -r dcc3b1134b24 wamos.sql
--- a/wamos.sql	Mon May 07 22:21:17 2018 +0200
+++ b/wamos.sql	Mon May 07 22:31:12 2018 +0200
@@ -95,8 +95,6 @@
        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
        revisiting_time smallint NOT NULL,
        surtyp varchar NOT NULL REFERENCES survey_types,
        -- XXX: Not an attribut of sounding result?
@@ -114,6 +112,14 @@
 CREATE TRIGGER bottleneck_date_info BEFORE UPDATE ON bottlenecks
        FOR EACH ROW EXECUTE PROCEDURE update_date_info();
 
+CREATE TABLE bottlenecks_riverbed_materials (
+       bottleneck_id varchar REFERENCES bottlenecks,
+       riverbed varchar REFERENCES riverbed_materials,
+       -- XXX: should be 'natsur' according to IENC Encoding Guide M.4.3
+       PRIMARY KEY (bottleneck_id, riverbed)
+       );
+
+
 CREATE TABLE vertical_references (
        vertical_reference varchar PRIMARY KEY
        );