Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 2807:5ac1db5156be
Some oracle db schema adaptions specific to bed heights in MINFO.
flys-backend/trunk@4215 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 11 Apr 2012 13:09:46 +0000 |
| parents | a55b7b35cc3a |
| children | f283212966e8 |
comparison
equal
deleted
inserted
replaced
| 2806:33f40b23edd8 | 2807:5ac1db5156be |
|---|---|
| 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_type; | 4 ALTER TABLE bed_height_single DROP CONSTRAINT fk_type; |
| 5 ALTER TABLE bed_height_single DROP CONSTRAINT fk_location_system; | |
| 5 ALTER TABLE bed_height_single DROP CONSTRAINT fk_cur_elevation_model; | 6 ALTER TABLE bed_height_single DROP CONSTRAINT fk_cur_elevation_model; |
| 6 ALTER TABLE bed_height_single DROP CONSTRAINT fk_old_elevation_model; | 7 ALTER TABLE bed_height_single DROP CONSTRAINT fk_old_elevation_model; |
| 7 ALTER TABLE bed_height_single DROP CONSTRAINT fk_range; | 8 ALTER TABLE bed_height_single DROP CONSTRAINT fk_range; |
| 8 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent; | 9 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent; |
| 9 ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent; | 10 ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent; |