Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 2805:a55b7b35cc3a
First things for MINFO specific database schema.
flys-backend/trunk@4210 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 11 Apr 2012 09:23:10 +0000 |
| parents | |
| children | 5ac1db5156be |
comparison
equal
deleted
inserted
replaced
| 2804:68d1661a57cf | 2805:a55b7b35cc3a |
|---|---|
| 1 SET AUTOCOMMIT ON; | |
| 2 | |
| 3 ALTER TABLE elevation_model DROP CONSTRAINT fk_unit; | |
| 4 ALTER TABLE bed_height_single DROP CONSTRAINT fk_type; | |
| 5 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_range; | |
| 8 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 DROP CONSTRAINT fk_type; | |
| 11 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_cur_elevation_model; | |
| 12 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_old_elevation_model; | |
| 13 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_range; | |
| 14 | |
| 15 DROP TABLE bed_height_type; | |
| 16 DROP TABLE location_system; | |
| 17 DROP TABLE elevation_model; | |
| 18 DROP TABLE bed_height_single; | |
| 19 DROP TABLE bed_height_single_values; | |
| 20 DROP TABLE bed_height_epoch_values; | |
| 21 DROP TABLE bed_height_epoch; | |
| 22 | |
| 23 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; | |
| 24 DROP SEQUENCE LOCATION_SYSTEM_SEQ; | |
| 25 DROP SEQUENCE ELEVATION_MODEL_SEQ; | |
| 26 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; | |
| 27 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ; | |
| 28 DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ; | |
| 29 DROP SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ; | |
| 30 |