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;

http://dive4elements.wald.intevation.org