Mercurial > dive4elements > river
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)