Mercurial > dive4elements > river
annotate flys-backend/doc/schema/oracle-drop.sql @ 5692:d2c6d4ca6841
Add print url to relase script
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Mon, 15 Apr 2013 10:33:59 +0200 |
parents | dac7723fb502 |
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; |
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; |
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
60 DROP TABLE wsts; |
5271
dac7723fb502
added missing lookup tables to drop-scripts
Tom Gottfried <tom@intevation.de>
parents:
5101
diff
changeset
|
61 DROP TABLE wst_kinds; |
2856
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
62 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
|
63 DROP SEQUENCE ANNOTATIONS_ID_SEQ; |
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
64 DROP SEQUENCE ATTRIBUTES_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_SECTION_LINES_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_POINTS_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_SECTIONS_ID_SEQ; |
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
68 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
|
69 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
|
70 DROP SEQUENCE EDGES_ID_SEQ; |
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
71 DROP SEQUENCE GAUGES_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_ENTRIES_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_FLOW_ZONE_TYPES_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_ZONES_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_FORMATIONS_ID_SEQ; |
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
76 DROP SEQUENCE HYKS_ID_SEQ; |
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
77 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
|
78 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
|
79 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
|
80 DROP SEQUENCE POSITIONS_ID_SEQ; |
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
81 DROP SEQUENCE RANGES_ID_SEQ; |
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
82 DROP SEQUENCE RIVERS_ID_SEQ; |
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
83 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
|
84 DROP SEQUENCE UNITS_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_COLUMN_Q_RANGES_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_VALUES_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_COLUMNS_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_Q_RANGES_ID_SEQ; |
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
89 DROP SEQUENCE WSTS_ID_SEQ; |
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
90 DROP VIEW wst_value_table; |
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
91 DROP VIEW wst_w_values ; |
85185b5c464e
Added SQL file to drop WINFO specific db schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
92 DROP VIEW wst_q_values; |
5101
f57b096df75a
added missing DROP VIEW todrop script
Tom Gottfried <tom@intevation.de>
parents:
2856
diff
changeset
|
93 DROP VIEW official_lines; |
f57b096df75a
added missing DROP VIEW todrop script
Tom Gottfried <tom@intevation.de>
parents:
2856
diff
changeset
|
94 DROP VIEW q_main_values; |
f57b096df75a
added missing DROP VIEW todrop script
Tom Gottfried <tom@intevation.de>
parents:
2856
diff
changeset
|
95 DROP VIEW official_q_values; |
f57b096df75a
added missing DROP VIEW todrop script
Tom Gottfried <tom@intevation.de>
parents:
2856
diff
changeset
|
96 DROP VIEW wst_ranges; |