# HG changeset patch
# User Ingo Weinzierl <ingo.weinzierl@intevation.de>
# Date 1334753625 0
# Node ID 6b541d85c5cff5f6e1ad2279d3670138a25727e4
# Parent  8649e4ed01ecfc4786d609a1ff14b3e9489f0dda
Added missing river_id column to sediment_yield relation.

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

diff -r 8649e4ed01ec -r 6b541d85c5cf flys-backend/ChangeLog
--- a/flys-backend/ChangeLog	Wed Apr 18 12:29:05 2012 +0000
+++ b/flys-backend/ChangeLog	Wed Apr 18 12:53:45 2012 +0000
@@ -1,3 +1,9 @@
+2012-04-18  Ingo Weinzierl <ingo@intevation.de>
+
+	* doc/schema/oracle-minfo.sql,
+	  doc/schema/oracle-drop-minfo.sql: Added missing river_id column to
+	  sediment_yield relation.
+
 2012-04-18  Ingo Weinzierl <ingo@intevation.de>
 
 	* src/main/java/de/intevation/flys/model/Floodmaps.java,
diff -r 8649e4ed01ec -r 6b541d85c5cf flys-backend/doc/schema/oracle-drop-minfo.sql
--- a/flys-backend/doc/schema/oracle-drop-minfo.sql	Wed Apr 18 12:29:05 2012 +0000
+++ b/flys-backend/doc/schema/oracle-drop-minfo.sql	Wed Apr 18 12:53:45 2012 +0000
@@ -29,6 +29,7 @@
 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id;
 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id;
 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id;
+ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_river_id;
 ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_id;
 
 DROP TABLE bed_height_type;
diff -r 8649e4ed01ec -r 6b541d85c5cf flys-backend/doc/schema/oracle-minfo.sql
--- a/flys-backend/doc/schema/oracle-minfo.sql	Wed Apr 18 12:29:05 2012 +0000
+++ b/flys-backend/doc/schema/oracle-minfo.sql	Wed Apr 18 12:53:45 2012 +0000
@@ -255,10 +255,12 @@
 
 CREATE TABLE sediment_yield (
     id                  NUMBER(38,0) NOT NULL,
+    river_id            NUMBER(38,0) NOT NULL,
     grain_fraction_id   NUMBER(38,0),
     unit_id             NUMBER(38,0) NOT NULL,
     time_interval_id    NUMBER(38,0) NOT NULL,
     PRIMARY KEY (id),
+    CONSTRAINT fk_sy_river_id FOREIGN KEY (river_id) REFERENCES rivers(id),
     CONSTRAINT fk_sy_grain_fraction_id FOREIGN KEY (grain_fraction_id) REFERENCES grain_fraction(id),
     CONSTRAINT fk_sy_unit_id FOREIGN KEY (unit_id) REFERENCES units(id),
     CONSTRAINT fk_sy_time_interval_id FOREIGN KEY (time_interval_id) REFERENCES time_intervals(id)