view backend/doc/schema/oracle-drop.sql @ 6061:e9a76ffa0f9a

Use maxOverlap to get the correct gauge for the MainValues Previously just the first matching gauge was taken even if it's range ended with the minimum value. This code is clearly intended to get one gauge for one range so the best match should be taken.
author Andre Heinecke <aheinecke@intevation.de>
date Wed, 22 May 2013 18:10:48 +0200
parents 5aa05a7a34b7
children 0711ce5ca701
line wrap: on
line source
ALTER TABLE annotations DROP CONSTRAINT cAnnotationsRanges;
ALTER TABLE annotations DROP CONSTRAINT cAnnotationsEdges;
ALTER TABLE annotations DROP CONSTRAINT cAnnotationsPositions;
ALTER TABLE annotations DROP CONSTRAINT cAnnotationsAttributes;
ALTER TABLE annotations DROP CONSTRAINT cAnnotationsTypes;
ALTER TABLE cross_section_lines DROP CONSTRAINT cQPSLinesCrossSections;
ALTER TABLE cross_section_points DROP CONSTRAINT cQPSPointsCrossSectionLines;
ALTER TABLE cross_sections DROP CONSTRAINT cCrossSectionsRivers;
ALTER TABLE cross_sections DROP CONSTRAINT cCrossSectionsTimeIntervals;
ALTER TABLE discharge_tables DROP CONSTRAINT cDischargeTablesTime_intervals;
ALTER TABLE discharge_tables DROP CONSTRAINT cDischargeTablesGauges;
ALTER TABLE gauges DROP CONSTRAINT cGaugesRivers;
ALTER TABLE gauges DROP CONSTRAINT cGaugesRanges;
ALTER TABLE hyk_entries DROP CONSTRAINT cHykEntriesHyks;
ALTER TABLE hyk_flow_zones DROP CONSTRAINT cHykFlowZonesHykFormations;
ALTER TABLE hyk_flow_zones DROP CONSTRAINT cHykFlowZonesHykFlowZoneTypes;
ALTER TABLE hyks DROP CONSTRAINT cHyksRivers;
ALTER TABLE hyk_formations DROP CONSTRAINT cHykFormationsHykEntries;
ALTER TABLE main_values DROP CONSTRAINT cMainValuesTimeIntervals;
ALTER TABLE main_values DROP CONSTRAINT cMainValuesGauges;
ALTER TABLE main_values DROP CONSTRAINT cMainValuesNamedMainValues;
ALTER TABLE named_main_values DROP CONSTRAINT cNamedMainValuesMainValueTypes;
ALTER TABLE ranges DROP CONSTRAINT cRangesRivers;
ALTER TABLE rivers DROP CONSTRAINT cRiversUnits;
ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstColums;
ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstQRanges;
ALTER TABLE wst_column_values DROP CONSTRAINT cWstColumnValuesWstColumns;
ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsTime_intervals;
ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts;
ALTER TABLE wst_q_ranges DROP CONSTRAINT cWstQRangesRanges;
ALTER TABLE wsts DROP CONSTRAINT cWstsRivers;
ALTER TABLE wsts DROP CONSTRAINT cWstsWstKinds;
DROP TABLE annotation_types;
DROP TABLE annotations;
DROP TABLE attributes;
DROP TABLE cross_section_lines;
DROP TABLE cross_section_points;
DROP TABLE cross_sections;
DROP TABLE discharge_table_values;
DROP TABLE discharge_tables;
DROP TABLE edges;
DROP TABLE gauges;
DROP TABLE hyk_entries;
DROP TABLE hyk_flow_zone_types;
DROP TABLE hyk_flow_zones;
DROP TABLE hyk_formations;
DROP TABLE hyks;
DROP TABLE main_value_types;
DROP TABLE main_values;
DROP TABLE named_main_values;
DROP TABLE positions;
DROP TABLE ranges;
DROP TABLE rivers;
DROP TABLE time_intervals;
DROP TABLE units;
DROP TABLE wst_column_q_ranges;
DROP TABLE wst_column_values;
DROP TABLE wst_columns;
DROP TABLE wst_q_ranges;
DROP TABLE wsts;
DROP TABLE wst_kinds;
DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ;
DROP SEQUENCE ANNOTATIONS_ID_SEQ;
DROP SEQUENCE ATTRIBUTES_ID_SEQ;
DROP SEQUENCE CROSS_SECTION_LINES_ID_SEQ;
DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
DROP SEQUENCE CROSS_SECTIONS_ID_SEQ;
DROP SEQUENCE DISCHARGE_TABLE_VALUES_ID_SEQ;
DROP SEQUENCE DISCHARGE_TABLES_ID_SEQ;
DROP SEQUENCE EDGES_ID_SEQ;
DROP SEQUENCE GAUGES_ID_SEQ;
DROP SEQUENCE HYK_ENTRIES_ID_SEQ;
DROP SEQUENCE HYK_FLOW_ZONE_TYPES_ID_SEQ;
DROP SEQUENCE HYK_FLOW_ZONES_ID_SEQ;
DROP SEQUENCE HYK_FORMATIONS_ID_SEQ;
DROP SEQUENCE HYKS_ID_SEQ;
DROP SEQUENCE MAIN_VALUE_TYPES_ID_SEQ;
DROP SEQUENCE MAIN_VALUES_ID_SEQ;
DROP SEQUENCE NAMED_MAIN_VALUES_ID_SEQ;
DROP SEQUENCE POSITIONS_ID_SEQ;
DROP SEQUENCE RANGES_ID_SEQ;
DROP SEQUENCE RIVERS_ID_SEQ;
DROP SEQUENCE TIME_INTERVALS_ID_SEQ;
DROP SEQUENCE UNITS_ID_SEQ;
DROP SEQUENCE WST_COLUMN_Q_RANGES_ID_SEQ;
DROP SEQUENCE WST_COLUMN_VALUES_ID_SEQ;
DROP SEQUENCE WST_COLUMNS_ID_SEQ;
DROP SEQUENCE WST_Q_RANGES_ID_SEQ;
DROP SEQUENCE WSTS_ID_SEQ;
DROP VIEW wst_value_table;
DROP VIEW wst_w_values ;
DROP VIEW wst_q_values;
DROP VIEW official_lines;
DROP VIEW q_main_values;
DROP VIEW official_q_values;
DROP VIEW wst_ranges;

http://dive4elements.wald.intevation.org