Mercurial > dive4elements > river

annotate backend/doc/schema/oracle-drop.sql @ 9763:ce7c67445cbb 3.2.x

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
No more hacks for getting description in case of official lines In case the name contained one and only one number, that number had been returned as description because in that case, the name matched WQ.NUMBERS_PATTERN.
author Tom Gottfried <tom@intevation.de>
date Fri, 11 Nov 2022 18:12:26 +0100
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