Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 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 | daba3f895eb3 |
| children | 6be2bf2492f9 |
comparison
equal
deleted
inserted
replaced
| 2835:8649e4ed01ec | 2836:6b541d85c5cf |
|---|---|
| 27 ALTER TABLE flow_velocity_measure_values DROP CONSTRAINT fk_fvmv_measurements_id; | 27 ALTER TABLE flow_velocity_measure_values DROP CONSTRAINT fk_fvmv_measurements_id; |
| 28 ALTER TABLE grain_fraction DROP CONSTRAINT fk_gf_unit_id; | 28 ALTER TABLE grain_fraction DROP CONSTRAINT fk_gf_unit_id; |
| 29 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id; | 29 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id; |
| 30 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id; | 30 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id; |
| 31 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id; | 31 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id; |
| 32 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_river_id; | |
| 32 ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_id; | 33 ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_id; |
| 33 | 34 |
| 34 DROP TABLE bed_height_type; | 35 DROP TABLE bed_height_type; |
| 35 DROP TABLE location_system; | 36 DROP TABLE location_system; |
| 36 DROP TABLE elevation_model; | 37 DROP TABLE elevation_model; |