Mercurial > dive4elements > river

annotate backend/doc/schema/oracle-drop.sql @ 6933:468d9ebda4ce

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Datacage: Add dc:all-state-successors() to enable predicates like dc:contains(dc:all-state-successors($artifact-name, $current-state-id), 'state.winfo.calculation_mode') which recursively collects all successor state ids an check for containment.
author Sascha L. Teichmann <teichmann@intevation.de>
date Tue, 27 Aug 2013 19:14:12 +0200
parents 0711ce5ca701
children 97145ec4e33c
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;
6300
0711ce5ca701 Backend: Modified schema for a better model of official lines.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
60 DROP TABLE official_lines;
2856
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
61 DROP TABLE wsts;
5271
dac7723fb502 added missing lookup tables to drop-scripts
Tom Gottfried <tom@intevation.de>
parents: 5101
diff changeset
62 DROP TABLE wst_kinds;
2856
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
63 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
64 DROP SEQUENCE ANNOTATIONS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
65 DROP SEQUENCE ATTRIBUTES_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_LINES_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_SECTION_POINTS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
68 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
69 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
70 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
71 DROP SEQUENCE EDGES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
72 DROP SEQUENCE GAUGES_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_ENTRIES_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_ZONE_TYPES_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_FLOW_ZONES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
76 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
77 DROP SEQUENCE HYKS_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_VALUE_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 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 NAMED_MAIN_VALUES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
81 DROP SEQUENCE POSITIONS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
82 DROP SEQUENCE RANGES_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
83 DROP SEQUENCE RIVERS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
84 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
85 DROP SEQUENCE UNITS_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_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 WST_COLUMN_VALUES_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_COLUMNS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
89 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
90 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
91 DROP SEQUENCE WSTS_ID_SEQ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
92 DROP VIEW wst_value_table;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
93 DROP VIEW wst_w_values ;
85185b5c464e Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
94 DROP VIEW wst_q_values;
5101
f57b096df75a added missing DROP VIEW todrop script
Tom Gottfried <tom@intevation.de>
parents: 2856
diff changeset
95 DROP VIEW wst_ranges;
http://dive4elements.wald.intevation.org