Mercurial > dive4elements > river
view backend/doc/schema/oracle-drop.sql @ 5854:249b8766a178
Schema change: new column 'waterbody' for floodmaps and importer
author | Tom Gottfried <tom.gottfried@intevation.de> |
---|---|
date | Fri, 26 Apr 2013 16:50:14 +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;