Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 3329:cc8fc6b29649
Store sq relations into database after parsing.
flys-backend/trunk@4647 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 13 Jun 2012 08:12:00 +0000 |
| parents | a2a33eff93aa |
| children | 8667f629d238 |
comparison
equal
deleted
inserted
replaced
| 3328:a41f279a66e2 | 3329:cc8fc6b29649 |
|---|---|
| 38 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_river_id; | 38 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_river_id; |
| 39 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_unit_id; | 39 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_unit_id; |
| 40 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id; | 40 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id; |
| 41 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id; | 41 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id; |
| 42 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id; | 42 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id; |
| 43 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id; | |
| 43 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; | 44 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; |
| 44 | 45 |
| 45 DROP TABLE bed_height_type; | 46 DROP TABLE bed_height_type; |
| 46 DROP TABLE location_system; | 47 DROP TABLE location_system; |
| 47 DROP TABLE elevation_model; | 48 DROP TABLE elevation_model; |
| 66 DROP TABLE waterlevel_q_range; | 67 DROP TABLE waterlevel_q_range; |
| 67 DROP TABLE waterlevel_values; | 68 DROP TABLE waterlevel_values; |
| 68 DROP TABLE waterlevel_difference; | 69 DROP TABLE waterlevel_difference; |
| 69 DROP TABLE waterlevel_difference_column; | 70 DROP TABLE waterlevel_difference_column; |
| 70 DROP TABLE waterlevel_difference_values; | 71 DROP TABLE waterlevel_difference_values; |
| 72 DROP TABLE sq_relation_value; | |
| 71 DROP TABLE sq_relation; | 73 DROP TABLE sq_relation; |
| 72 DROP TABLE sq_relation_value; | |
| 73 | 74 |
| 74 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; | 75 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; |
| 75 DROP SEQUENCE LOCATION_SYSTEM_SEQ; | 76 DROP SEQUENCE LOCATION_SYSTEM_SEQ; |
| 76 DROP SEQUENCE ELEVATION_MODEL_SEQ; | 77 DROP SEQUENCE ELEVATION_MODEL_SEQ; |
| 77 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; | 78 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; |