Mercurial > dive4elements > river
view flys-backend/doc/schema/oracle-drop.sql @ 4837:9e25c7523485
Fixed calculation of effective width in MINFO SQ relation.
* Get all (including empty datasets) from db.
* Filter empty datasets when processing data of the same date.
* Added debug outputs.
author | Raimund Renkert <rrenkert@intevation.de> |
---|---|
date | Wed, 23 Jan 2013 11:14:41 +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;