Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-drop-minfo.sql @ 2809:f283212966e8
Finished work on MINFO bed heights (single).
flys-backend/trunk@4221 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 12 Apr 2012 10:42:46 +0000 |
| parents | 5ac1db5156be |
| children | a36a5407acbf |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop-minfo.sql Wed Apr 11 13:12:52 2012 +0000 +++ b/flys-backend/doc/schema/oracle-drop-minfo.sql Thu Apr 12 10:42:46 2012 +0000 @@ -1,6 +1,7 @@ SET AUTOCOMMIT ON; ALTER TABLE elevation_model DROP CONSTRAINT fk_unit; +ALTER TABLE bed_height_single DROP CONSTRAINT fk_bed_single_river_id; ALTER TABLE bed_height_single DROP CONSTRAINT fk_type; ALTER TABLE bed_height_single DROP CONSTRAINT fk_location_system; ALTER TABLE bed_height_single DROP CONSTRAINT fk_cur_elevation_model; @@ -8,10 +9,9 @@ ALTER TABLE bed_height_single DROP CONSTRAINT fk_range; ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent; ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent; -ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_type; -ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_cur_elevation_model; -ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_old_elevation_model; -ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_range; +ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model; +ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model; +ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range; DROP TABLE bed_height_type; DROP TABLE location_system;