changeset 2849:c36106f15ac9

Added missing constraint to relation 'waterlevel_difference'. flys-backend/trunk@4303 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Thu, 26 Apr 2012 09:44:39 +0000 (2012-04-26)
parents e7a1d78b66d8
children a1402c16152f
files flys-backend/ChangeLog flys-backend/doc/schema/oracle-drop-minfo.sql flys-backend/doc/schema/oracle-minfo.sql
diffstat 3 files changed, 11 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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:
--- 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;
 
--- 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)
 );
 
 

http://dive4elements.wald.intevation.org