changeset 6045:2d16f4a0bdcc

Schema change: there is only one bed height per station at a given point in time
author Tom Gottfried <tom@intevation.de>
date Thu, 16 May 2013 18:03:39 +0200
parents d12f920bbf00
children 4493ef20d357
files backend/doc/schema/oracle-minfo.sql backend/doc/schema/postgresql-minfo.sql
diffstat 2 files changed, 2 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/backend/doc/schema/oracle-minfo.sql	Thu May 16 16:14:28 2013 +0200
+++ b/backend/doc/schema/oracle-minfo.sql	Thu May 16 18:03:39 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
 );
 
--- a/backend/doc/schema/postgresql-minfo.sql	Thu May 16 16:14:28 2013 +0200
+++ b/backend/doc/schema/postgresql-minfo.sql	Thu May 16 18:03:39 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
 );
 

http://dive4elements.wald.intevation.org