Mercurial > dive4elements > river

annotate flys-backend/doc/schema/oracle-drop.sql @ 4837:9e25c7523485

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
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;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
32 DROP TABLE annotation_types;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
33 DROP TABLE annotations;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
34 DROP TABLE attributes;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
35 DROP TABLE cross_section_lines;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
36 DROP TABLE cross_section_points;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
37 DROP TABLE cross_sections;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
38 DROP TABLE discharge_table_values;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
39 DROP TABLE discharge_tables;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
40 DROP TABLE edges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
41 DROP TABLE gauges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
42 DROP TABLE hyk_entries;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
43 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
44 DROP TABLE hyk_flow_zones;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
45 DROP TABLE hyk_formations;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
46 DROP TABLE hyks;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
47 DROP TABLE main_value_types;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
48 DROP TABLE main_values;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
49 DROP TABLE named_main_values;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
50 DROP TABLE positions;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
51 DROP TABLE ranges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
52 DROP TABLE rivers;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
53 DROP TABLE time_intervals;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
54 DROP TABLE units;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
55 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
56 DROP TABLE wst_column_values;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
57 DROP TABLE wst_columns;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
58 DROP TABLE wst_q_ranges;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
59 DROP TABLE wsts;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
60 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
61 DROP SEQUENCE ANNOTATIONS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
62 DROP SEQUENCE ATTRIBUTES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
63 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
64 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
65 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
66 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
67 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
68 DROP SEQUENCE EDGES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
69 DROP SEQUENCE GAUGES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
70 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
71 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
72 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
73 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
74 DROP SEQUENCE HYKS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
75 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
76 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
77 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
78 DROP SEQUENCE POSITIONS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
79 DROP SEQUENCE RANGES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
80 DROP SEQUENCE RIVERS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
81 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
82 DROP SEQUENCE UNITS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
83 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
84 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
85 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
86 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
87 DROP SEQUENCE WSTS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
88 DROP VIEW wst_value_table;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
89 DROP VIEW wst_w_values ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
90 DROP VIEW wst_q_values;
http://dive4elements.wald.intevation.org