Mercurial > dive4elements > river
annotate flys-backend/doc/schema/oracle-drop.sql @ 4837:9e25c7523485
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; |