view backend/doc/schema/oracle-drop.sql @ 6103:4bbf2ef9bdd8

Themes: Reunited the small parts of default and second theme to default.xml and second.xml again to have valid XML. This is a bit of a pity because the small parts had a better understandable structure. To generate the overview use: $ xsltproc \ contrib/themes2html.xsl \ doc/conf/themes.xml \ > themes.xhtml To make this work you have to create a symlink in conf to itself: $ (cd doc/conf && ln -s . conf) TODO: We have to introduce a EntityResolver in the server code to make the inclusion independent of the current working dir of the server.
author Sascha L. Teichmann <teichmann@intevation.de>
date Sat, 25 May 2013 20:55:11 +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