changeset 2836:6b541d85c5cf

Added missing river_id column to sediment_yield relation. flys-backend/trunk@4268 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Wed, 18 Apr 2012 12:53:45 +0000
parents 8649e4ed01ec
children 8b910e3277b0
files flys-backend/ChangeLog flys-backend/doc/schema/oracle-drop-minfo.sql flys-backend/doc/schema/oracle-minfo.sql
diffstat 3 files changed, 9 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- 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,
--- 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;
--- 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)

http://dive4elements.wald.intevation.org