view flys-backend/doc/schema/oracle-drop.sql @ 4377:512a3af69e18

Extract common generator method from FixLongitudinalSectionGenerator The extracted methods and code can be reused for generating charts for bed differences if fixanalysis data is loaded via the datacache.
author Björn Ricks <bjoern.ricks@intevation.de>
date Fri, 02 Nov 2012 15:47:15 +0100
parents 85185b5c464e
children f57b096df75a
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;
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 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;

http://dive4elements.wald.intevation.org