changeset 5711:06f3a36a83b6

Merged.
author Sascha L. Teichmann <teichmann@intevation.de>
date Mon, 15 Apr 2013 16:29:54 +0200
parents 4fd0c250779c (current diff) e89d922df8ae (diff)
children 84e02b3f7a4f
files
diffstat 2 files changed, 2 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-minfo.sql	Mon Apr 15 16:29:25 2013 +0200
+++ b/flys-backend/doc/schema/oracle-minfo.sql	Mon Apr 15 16:29:54 2013 +0200
@@ -207,6 +207,7 @@
     main_channel            NUMBER(38,3) NOT NULL,
     shear_stress            NUMBER(38,3) NOT NULL,
     PRIMARY KEY(id),
+    UNIQUE (station, flow_velocity_model_id),
     CONSTRAINT fk_fvv_flow_velocity_model_id FOREIGN KEY (flow_velocity_model_id) REFERENCES flow_velocity_model(id) ON DELETE CASCADE
 );
 
--- a/flys-backend/doc/schema/postgresql-minfo.sql	Mon Apr 15 16:29:25 2013 +0200
+++ b/flys-backend/doc/schema/postgresql-minfo.sql	Mon Apr 15 16:29:54 2013 +0200
@@ -207,6 +207,7 @@
     main_channel            NUMERIC NOT NULL,
     shear_stress            NUMERIC NOT NULL,
     PRIMARY KEY(id),
+    UNIQUE (station, flow_velocity_model_id),
     CONSTRAINT fk_fvv_flow_velocity_model_id FOREIGN KEY (flow_velocity_model_id) REFERENCES flow_velocity_model(id) ON DELETE CASCADE
 );
 

http://dive4elements.wald.intevation.org