annotate backend/doc/schema/oracle-drop.sql @ 9405:34cd4faf43f4

minMax queries
author gernotbelger
date Wed, 15 Aug 2018 14:34:23 +0200 (2018-08-15)
parents cfafe5764509
children
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;
6632
97145ec4e33c Schema changes: fixed typos, syntax errors and missing or obsolete statements in Oracle schema
Tom Gottfried <tom@intevation.de>
parents: 6300
diff changeset
23 ALTER TABLE official_lines DROP CONSTRAINT cOffLinesNamedMainValues;
97145ec4e33c Schema changes: fixed typos, syntax errors and missing or obsolete statements in Oracle schema
Tom Gottfried <tom@intevation.de>
parents: 6300
diff changeset
24 ALTER TABLE official_lines DROP CONSTRAINT cOffLinesWstColumns;
2856
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
25 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
26 ALTER TABLE rivers DROP CONSTRAINT cRiversUnits;
8683
cfafe5764509 (issue 1796) Scheme change! Add model for seddb_name lookup table.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 6652
diff changeset
27 ALTER TABLE rivers DROP CONSTRAINT cRiversSeddbNames;
2856
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
28 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
29 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
30 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
31 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
32 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
33 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
34 ALTER TABLE wsts DROP CONSTRAINT cWstsRivers;
5271
dac7723fb502 added missing lookup tables to drop-scripts
Tom Gottfried <tom@intevation.de>
parents: 5101
diff changeset
35 ALTER TABLE wsts DROP CONSTRAINT cWstsWstKinds;
6652
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
36 DROP TABLE annotation_types PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
37 DROP TABLE annotations PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
38 DROP TABLE attributes PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
39 DROP TABLE cross_section_lines PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
40 DROP TABLE cross_section_points PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
41 DROP TABLE cross_sections PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
42 DROP TABLE discharge_table_values PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
43 DROP TABLE discharge_tables PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
44 DROP TABLE edges PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
45 DROP TABLE gauges PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
46 DROP TABLE hyk_entries PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
47 DROP TABLE hyk_flow_zone_types PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
48 DROP TABLE hyk_flow_zones PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
49 DROP TABLE hyk_formations PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
50 DROP TABLE hyks PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
51 DROP TABLE main_value_types PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
52 DROP TABLE main_values PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
53 DROP TABLE named_main_values PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
54 DROP TABLE positions PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
55 DROP TABLE ranges PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
56 DROP TABLE rivers PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
57 DROP TABLE time_intervals PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
58 DROP TABLE units PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
59 DROP TABLE wst_column_q_ranges PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
60 DROP TABLE wst_column_values PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
61 DROP TABLE wst_columns PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
62 DROP TABLE wst_q_ranges PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
63 DROP TABLE official_lines PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
64 DROP TABLE wsts PURGE;
765944ca6df0 Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents: 6632
diff changeset
65 DROP TABLE wst_kinds PURGE;
8683
cfafe5764509 (issue 1796) Scheme change! Add model for seddb_name lookup table.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 6652
diff changeset
66 DROP TABLE seddb_names PURGE;
2856
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
67 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
68 DROP SEQUENCE ANNOTATIONS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
69 DROP SEQUENCE ATTRIBUTES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
70 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
71 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
72 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
73 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
74 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
75 DROP SEQUENCE EDGES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
76 DROP SEQUENCE GAUGES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
77 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
78 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
79 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
80 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
81 DROP SEQUENCE HYKS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
82 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
83 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
84 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
85 DROP SEQUENCE POSITIONS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
86 DROP SEQUENCE 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 RIVERS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
88 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
89 DROP SEQUENCE UNITS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
90 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
91 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
92 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
93 DROP SEQUENCE WST_Q_RANGES_ID_SEQ;
6300
0711ce5ca701 Backend: Modified schema for a better model of official lines.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
94 DROP SEQUENCE OFFICIAL_LINES_ID_SEQ;
2856
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
95 DROP SEQUENCE WSTS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
96 DROP VIEW wst_value_table;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
97 DROP VIEW wst_w_values ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
98 DROP VIEW wst_q_values;
5101
f57b096df75a added missing DROP VIEW todrop script
Tom Gottfried <tom@intevation.de>
parents: 2856
diff changeset
99 DROP VIEW wst_ranges;

http://dive4elements.wald.intevation.org