# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1368720275 -7200
# Node ID 4493ef20d35721f582f0f0d3a0744656de0cd02e
# Parent  2d16f4a0bdccb6f55e6ce9e784a7123ece31720f# Parent  477d2d18452eb9b217ea531f65aa378d8dbd04f2
merged

diff -r 477d2d18452e -r 4493ef20d357 backend/doc/schema/oracle-minfo.sql
--- a/backend/doc/schema/oracle-minfo.sql	Thu May 16 17:58:16 2013 +0200
+++ b/backend/doc/schema/oracle-minfo.sql	Thu May 16 18:04:35 2013 +0200
@@ -92,6 +92,7 @@
     sounding_width          NUMBER(38,2),
     width                   NUMBER(38,2),
     PRIMARY KEY(id),
+    UNIQUE (station, bed_height_single_id),
     CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id) ON DELETE CASCADE
 );
 
diff -r 477d2d18452e -r 4493ef20d357 backend/doc/schema/postgresql-minfo.sql
--- a/backend/doc/schema/postgresql-minfo.sql	Thu May 16 17:58:16 2013 +0200
+++ b/backend/doc/schema/postgresql-minfo.sql	Thu May 16 18:04:35 2013 +0200
@@ -92,6 +92,7 @@
     sounding_width          NUMERIC,
     width                   NUMERIC,
     PRIMARY KEY(id),
+    UNIQUE (station, bed_height_single_id),
     CONSTRAINT fk_bed_single_values_parent FOREIGN KEY (bed_height_single_id) REFERENCES bed_height_single(id) ON DELETE CASCADE
 );