Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 2808:b57c95094b68 | 2809:f283212966e8 |
|---|---|
| 1 SET AUTOCOMMIT ON; | 1 SET AUTOCOMMIT ON; |
| 2 | 2 |
| 3 ALTER TABLE elevation_model DROP CONSTRAINT fk_unit; | 3 ALTER TABLE elevation_model DROP CONSTRAINT fk_unit; |
| 4 ALTER TABLE bed_height_single DROP CONSTRAINT fk_bed_single_river_id; | |
| 4 ALTER TABLE bed_height_single DROP CONSTRAINT fk_type; | 5 ALTER TABLE bed_height_single DROP CONSTRAINT fk_type; |
| 5 ALTER TABLE bed_height_single DROP CONSTRAINT fk_location_system; | 6 ALTER TABLE bed_height_single DROP CONSTRAINT fk_location_system; |
| 6 ALTER TABLE bed_height_single DROP CONSTRAINT fk_cur_elevation_model; | 7 ALTER TABLE bed_height_single DROP CONSTRAINT fk_cur_elevation_model; |
| 7 ALTER TABLE bed_height_single DROP CONSTRAINT fk_old_elevation_model; | 8 ALTER TABLE bed_height_single DROP CONSTRAINT fk_old_elevation_model; |
| 8 ALTER TABLE bed_height_single DROP CONSTRAINT fk_range; | 9 ALTER TABLE bed_height_single DROP CONSTRAINT fk_range; |
| 9 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent; | 10 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent; |
| 10 ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent; | 11 ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent; |
| 11 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_type; | 12 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model; |
| 12 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_cur_elevation_model; | 13 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model; |
| 13 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_old_elevation_model; | 14 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range; |
| 14 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_range; | |
| 15 | 15 |
| 16 DROP TABLE bed_height_type; | 16 DROP TABLE bed_height_type; |
| 17 DROP TABLE location_system; | 17 DROP TABLE location_system; |
| 18 DROP TABLE elevation_model; | 18 DROP TABLE elevation_model; |
| 19 DROP TABLE bed_height_single; | 19 DROP TABLE bed_height_single; |