Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 5206:8667f629d238
SCHEME CHANGE: Add measurement_station to oracle table and rename comment column
Comment is a reserved keyword in oracle. This also fixes a typo in the table
name of time_intervals.
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Fri, 08 Mar 2013 15:16:00 +0100 |
| parents | cc8fc6b29649 |
| children | 6dd354e7abfc |
comparison
equal
deleted
inserted
replaced
| 5205:31fd42400c84 | 5206:8667f629d238 |
|---|---|
| 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 DROP CONSTRAINT fk_sqr_river_id; |
| 44 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; | 44 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; |
| 45 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id; | |
| 46 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id; | |
| 47 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id; | |
| 48 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id; | |
| 45 | 49 |
| 46 DROP TABLE bed_height_type; | 50 DROP TABLE bed_height_type; |
| 47 DROP TABLE location_system; | 51 DROP TABLE location_system; |
| 48 DROP TABLE elevation_model; | 52 DROP TABLE elevation_model; |
| 49 DROP TABLE bed_height_single; | 53 DROP TABLE bed_height_single; |
| 67 DROP TABLE waterlevel_q_range; | 71 DROP TABLE waterlevel_q_range; |
| 68 DROP TABLE waterlevel_values; | 72 DROP TABLE waterlevel_values; |
| 69 DROP TABLE waterlevel_difference; | 73 DROP TABLE waterlevel_difference; |
| 70 DROP TABLE waterlevel_difference_column; | 74 DROP TABLE waterlevel_difference_column; |
| 71 DROP TABLE waterlevel_difference_values; | 75 DROP TABLE waterlevel_difference_values; |
| 76 DROP TABLE measurement_station; | |
| 72 DROP TABLE sq_relation_value; | 77 DROP TABLE sq_relation_value; |
| 73 DROP TABLE sq_relation; | 78 DROP TABLE sq_relation; |
| 74 | 79 |
| 75 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; | 80 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; |
| 76 DROP SEQUENCE LOCATION_SYSTEM_SEQ; | 81 DROP SEQUENCE LOCATION_SYSTEM_SEQ; |