Mercurial > dive4elements > river

annotate backend/doc/schema/oracle-drop.sql @ 6061:e9a76ffa0f9a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use maxOverlap to get the correct gauge for the MainValues Previously just the first matching gauge was taken even if it's range ended with the minimum value. This code is clearly intended to get one gauge for one range so the best match should be taken.
author Andre Heinecke <aheinecke@intevation.de>
date Wed, 22 May 2013 18:10:48 +0200
parents 5aa05a7a34b7
children 0711ce5ca701
rev   line source
2856
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
1 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsRanges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
2 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsEdges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
3 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsPositions;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
4 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsAttributes;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
5 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsTypes;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
6 ALTER TABLE cross_section_lines DROP CONSTRAINT cQPSLinesCrossSections;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
7 ALTER TABLE cross_section_points DROP CONSTRAINT cQPSPointsCrossSectionLines;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
8 ALTER TABLE cross_sections DROP CONSTRAINT cCrossSectionsRivers;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
9 ALTER TABLE cross_sections DROP CONSTRAINT cCrossSectionsTimeIntervals;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
10 ALTER TABLE discharge_tables DROP CONSTRAINT cDischargeTablesTime_intervals;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
11 ALTER TABLE discharge_tables DROP CONSTRAINT cDischargeTablesGauges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
12 ALTER TABLE gauges DROP CONSTRAINT cGaugesRivers;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
13 ALTER TABLE gauges DROP CONSTRAINT cGaugesRanges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
14 ALTER TABLE hyk_entries DROP CONSTRAINT cHykEntriesHyks;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
15 ALTER TABLE hyk_flow_zones DROP CONSTRAINT cHykFlowZonesHykFormations;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
16 ALTER TABLE hyk_flow_zones DROP CONSTRAINT cHykFlowZonesHykFlowZoneTypes;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
17 ALTER TABLE hyks DROP CONSTRAINT cHyksRivers;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
18 ALTER TABLE hyk_formations DROP CONSTRAINT cHykFormationsHykEntries;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19 ALTER TABLE main_values DROP CONSTRAINT cMainValuesTimeIntervals;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
20 ALTER TABLE main_values DROP CONSTRAINT cMainValuesGauges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
21 ALTER TABLE main_values DROP CONSTRAINT cMainValuesNamedMainValues;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
22 ALTER TABLE named_main_values DROP CONSTRAINT cNamedMainValuesMainValueTypes;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
23 ALTER TABLE ranges DROP CONSTRAINT cRangesRivers;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
24 ALTER TABLE rivers DROP CONSTRAINT cRiversUnits;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
25 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstColums;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
26 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstQRanges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
27 ALTER TABLE wst_column_values DROP CONSTRAINT cWstColumnValuesWstColumns;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
28 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsTime_intervals;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
29 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
30 ALTER TABLE wst_q_ranges DROP CONSTRAINT cWstQRangesRanges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
31 ALTER TABLE wsts DROP CONSTRAINT cWstsRivers;
5271
dac7723fb502 added missing lookup tables to drop-scripts
Tom Gottfried <tom@intevation.de>
parents: 5101
diff changeset
32 ALTER TABLE wsts DROP CONSTRAINT cWstsWstKinds;
2856
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
33 DROP TABLE annotation_types;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
34 DROP TABLE annotations;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
35 DROP TABLE attributes;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
36 DROP TABLE cross_section_lines;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
37 DROP TABLE cross_section_points;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
38 DROP TABLE cross_sections;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
39 DROP TABLE discharge_table_values;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
40 DROP TABLE discharge_tables;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
41 DROP TABLE edges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
42 DROP TABLE gauges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
43 DROP TABLE hyk_entries;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
44 DROP TABLE hyk_flow_zone_types;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
45 DROP TABLE hyk_flow_zones;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
46 DROP TABLE hyk_formations;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
47 DROP TABLE hyks;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
48 DROP TABLE main_value_types;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
49 DROP TABLE main_values;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
50 DROP TABLE named_main_values;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
51 DROP TABLE positions;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
52 DROP TABLE ranges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
53 DROP TABLE rivers;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
54 DROP TABLE time_intervals;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
55 DROP TABLE units;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
56 DROP TABLE wst_column_q_ranges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
57 DROP TABLE wst_column_values;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
58 DROP TABLE wst_columns;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
59 DROP TABLE wst_q_ranges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
60 DROP TABLE wsts;
5271
dac7723fb502 added missing lookup tables to drop-scripts
Tom Gottfried <tom@intevation.de>
parents: 5101
diff changeset
61 DROP TABLE wst_kinds;
2856
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
62 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
63 DROP SEQUENCE ANNOTATIONS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
64 DROP SEQUENCE ATTRIBUTES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
65 DROP SEQUENCE CROSS_SECTION_LINES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
66 DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
67 DROP SEQUENCE CROSS_SECTIONS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
68 DROP SEQUENCE DISCHARGE_TABLE_VALUES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
69 DROP SEQUENCE DISCHARGE_TABLES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
70 DROP SEQUENCE EDGES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
71 DROP SEQUENCE GAUGES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
72 DROP SEQUENCE HYK_ENTRIES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
73 DROP SEQUENCE HYK_FLOW_ZONE_TYPES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
74 DROP SEQUENCE HYK_FLOW_ZONES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
75 DROP SEQUENCE HYK_FORMATIONS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
76 DROP SEQUENCE HYKS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
77 DROP SEQUENCE MAIN_VALUE_TYPES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
78 DROP SEQUENCE MAIN_VALUES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
79 DROP SEQUENCE NAMED_MAIN_VALUES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
80 DROP SEQUENCE POSITIONS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
81 DROP SEQUENCE RANGES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
82 DROP SEQUENCE RIVERS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
83 DROP SEQUENCE TIME_INTERVALS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
84 DROP SEQUENCE UNITS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
85 DROP SEQUENCE WST_COLUMN_Q_RANGES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
86 DROP SEQUENCE WST_COLUMN_VALUES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
87 DROP SEQUENCE WST_COLUMNS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
88 DROP SEQUENCE WST_Q_RANGES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
89 DROP SEQUENCE WSTS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
90 DROP VIEW wst_value_table;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
91 DROP VIEW wst_w_values ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
92 DROP VIEW wst_q_values;
5101
f57b096df75a added missing DROP VIEW todrop script
Tom Gottfried <tom@intevation.de>
parents: 2856
diff changeset
93 DROP VIEW official_lines;
f57b096df75a added missing DROP VIEW todrop script
Tom Gottfried <tom@intevation.de>
parents: 2856
diff changeset
94 DROP VIEW q_main_values;
f57b096df75a added missing DROP VIEW todrop script
Tom Gottfried <tom@intevation.de>
parents: 2856
diff changeset
95 DROP VIEW official_q_values;
f57b096df75a added missing DROP VIEW todrop script
Tom Gottfried <tom@intevation.de>
parents: 2856
diff changeset
96 DROP VIEW wst_ranges;
http://dive4elements.wald.intevation.org