Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop.sql @ 2856:85185b5c464e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added SQL file to drop WINFO specific db schema. flys-backend/trunk@4316 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Fri, 27 Apr 2012 07:19:49 +0000
parents
children f57b096df75a
comparison
equal deleted inserted replaced
2855:9c2424073be0 2856:85185b5c464e
1 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsRanges;
2 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsEdges;
3 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsPositions;
4 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsAttributes;
5 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsTypes;
6 ALTER TABLE cross_section_lines DROP CONSTRAINT cQPSLinesCrossSections;
7 ALTER TABLE cross_section_points DROP CONSTRAINT cQPSPointsCrossSectionLines;
8 ALTER TABLE cross_sections DROP CONSTRAINT cCrossSectionsRivers;
9 ALTER TABLE cross_sections DROP CONSTRAINT cCrossSectionsTimeIntervals;
10 ALTER TABLE discharge_tables DROP CONSTRAINT cDischargeTablesTime_intervals;
11 ALTER TABLE discharge_tables DROP CONSTRAINT cDischargeTablesGauges;
12 ALTER TABLE gauges DROP CONSTRAINT cGaugesRivers;
13 ALTER TABLE gauges DROP CONSTRAINT cGaugesRanges;
14 ALTER TABLE hyk_entries DROP CONSTRAINT cHykEntriesHyks;
15 ALTER TABLE hyk_flow_zones DROP CONSTRAINT cHykFlowZonesHykFormations;
16 ALTER TABLE hyk_flow_zones DROP CONSTRAINT cHykFlowZonesHykFlowZoneTypes;
17 ALTER TABLE hyks DROP CONSTRAINT cHyksRivers;
18 ALTER TABLE hyk_formations DROP CONSTRAINT cHykFormationsHykEntries;
19 ALTER TABLE main_values DROP CONSTRAINT cMainValuesTimeIntervals;
20 ALTER TABLE main_values DROP CONSTRAINT cMainValuesGauges;
21 ALTER TABLE main_values DROP CONSTRAINT cMainValuesNamedMainValues;
22 ALTER TABLE named_main_values DROP CONSTRAINT cNamedMainValuesMainValueTypes;
23 ALTER TABLE ranges DROP CONSTRAINT cRangesRivers;
24 ALTER TABLE rivers DROP CONSTRAINT cRiversUnits;
25 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstColums;
26 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstQRanges;
27 ALTER TABLE wst_column_values DROP CONSTRAINT cWstColumnValuesWstColumns;
28 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsTime_intervals;
29 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts;
30 ALTER TABLE wst_q_ranges DROP CONSTRAINT cWstQRangesRanges;
31 ALTER TABLE wsts DROP CONSTRAINT cWstsRivers;
32 DROP TABLE annotation_types;
33 DROP TABLE annotations;
34 DROP TABLE attributes;
35 DROP TABLE cross_section_lines;
36 DROP TABLE cross_section_points;
37 DROP TABLE cross_sections;
38 DROP TABLE discharge_table_values;
39 DROP TABLE discharge_tables;
40 DROP TABLE edges;
41 DROP TABLE gauges;
42 DROP TABLE hyk_entries;
43 DROP TABLE hyk_flow_zone_types;
44 DROP TABLE hyk_flow_zones;
45 DROP TABLE hyk_formations;
46 DROP TABLE hyks;
47 DROP TABLE main_value_types;
48 DROP TABLE main_values;
49 DROP TABLE named_main_values;
50 DROP TABLE positions;
51 DROP TABLE ranges;
52 DROP TABLE rivers;
53 DROP TABLE time_intervals;
54 DROP TABLE units;
55 DROP TABLE wst_column_q_ranges;
56 DROP TABLE wst_column_values;
57 DROP TABLE wst_columns;
58 DROP TABLE wst_q_ranges;
59 DROP TABLE wsts;
60 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ;
61 DROP SEQUENCE ANNOTATIONS_ID_SEQ;
62 DROP SEQUENCE ATTRIBUTES_ID_SEQ;
63 DROP SEQUENCE CROSS_SECTION_LINES_ID_SEQ;
64 DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
65 DROP SEQUENCE CROSS_SECTIONS_ID_SEQ;
66 DROP SEQUENCE DISCHARGE_TABLE_VALUES_ID_SEQ;
67 DROP SEQUENCE DISCHARGE_TABLES_ID_SEQ;
68 DROP SEQUENCE EDGES_ID_SEQ;
69 DROP SEQUENCE GAUGES_ID_SEQ;
70 DROP SEQUENCE HYK_ENTRIES_ID_SEQ;
71 DROP SEQUENCE HYK_FLOW_ZONE_TYPES_ID_SEQ;
72 DROP SEQUENCE HYK_FLOW_ZONES_ID_SEQ;
73 DROP SEQUENCE HYK_FORMATIONS_ID_SEQ;
74 DROP SEQUENCE HYKS_ID_SEQ;
75 DROP SEQUENCE MAIN_VALUE_TYPES_ID_SEQ;
76 DROP SEQUENCE MAIN_VALUES_ID_SEQ;
77 DROP SEQUENCE NAMED_MAIN_VALUES_ID_SEQ;
78 DROP SEQUENCE POSITIONS_ID_SEQ;
79 DROP SEQUENCE RANGES_ID_SEQ;
80 DROP SEQUENCE RIVERS_ID_SEQ;
81 DROP SEQUENCE TIME_INTERVALS_ID_SEQ;
82 DROP SEQUENCE UNITS_ID_SEQ;
83 DROP SEQUENCE WST_COLUMN_Q_RANGES_ID_SEQ;
84 DROP SEQUENCE WST_COLUMN_VALUES_ID_SEQ;
85 DROP SEQUENCE WST_COLUMNS_ID_SEQ;
86 DROP SEQUENCE WST_Q_RANGES_ID_SEQ;
87 DROP SEQUENCE WSTS_ID_SEQ;
88 DROP VIEW wst_value_table;
89 DROP VIEW wst_w_values ;
90 DROP VIEW wst_q_values;
http://dive4elements.wald.intevation.org