# HG changeset patch
# User Ingo Weinzierl <ingo.weinzierl@intevation.de>
# Date 1335433479 0
# Node ID c36106f15ac9875fb72b3ca288e3d94984818edb
# Parent  e7a1d78b66d814efb63753396f827793ce215912
Added missing constraint to relation 'waterlevel_difference'.

flys-backend/trunk@4303 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r e7a1d78b66d8 -r c36106f15ac9 flys-backend/ChangeLog
--- a/flys-backend/ChangeLog	Wed Apr 25 06:47:53 2012 +0000
+++ b/flys-backend/ChangeLog	Thu Apr 26 09:44:39 2012 +0000
@@ -1,3 +1,10 @@
+2012-04-26  Ingo Weinzierl <ingo@intevation.de>
+
+	* doc/schema/oracle-minfo.sql,
+	  doc/schema/oracle-drop-minfo.sql: Added a missing constraint to
+	  'waterlevel_difference' relation. Remove that constraint in
+	  oracle-drop-minfo.sql.
+
 2012-04-25  Felix Wolfsteller <felix@intevation.de>
 
 	  * src/main/java/de/intevation/flys/model/WaterlevelDifferenceValue.java:
diff -r e7a1d78b66d8 -r c36106f15ac9 flys-backend/doc/schema/oracle-drop-minfo.sql
--- a/flys-backend/doc/schema/oracle-drop-minfo.sql	Wed Apr 25 06:47:53 2012 +0000
+++ b/flys-backend/doc/schema/oracle-drop-minfo.sql	Thu Apr 26 09:44:39 2012 +0000
@@ -36,6 +36,7 @@
 ALTER TABLE waterlevel_q_range DROP CONSTRAINT fk_wqr_waterlevel_id;
 ALTER TABLE waterlevel_values DROP CONSTRAINT fk_wv_waterlevel_q_range_id;
 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_river_id;
+ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_unit_id;
 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id;
 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id;
 
diff -r e7a1d78b66d8 -r c36106f15ac9 flys-backend/doc/schema/oracle-minfo.sql
--- a/flys-backend/doc/schema/oracle-minfo.sql	Wed Apr 25 06:47:53 2012 +0000
+++ b/flys-backend/doc/schema/oracle-minfo.sql	Thu Apr 26 09:44:39 2012 +0000
@@ -321,10 +321,11 @@
 CREATE TABLE waterlevel_difference (
     id          NUMBER(38,0) NOT NULL,
     river_id    NUMBER(38,0) NOT NULL,
-    unit        NUMBER(38,0) NOT NULL,
+    unit_id     NUMBER(38,0) NOT NULL,
     description VARCHAR(256),
     PRIMARY KEY (id),
-    CONSTRAINT fk_wd_river_id FOREIGN KEY (river_id) REFERENCES rivers (id)
+    CONSTRAINT fk_wd_river_id FOREIGN KEY (river_id) REFERENCES rivers (id),
+    CONSTRAINT fk_wd_unit_id FOREIGN KEY (unit_id) REFERENCES units(id)
 );