Mercurial > dive4elements > river

comparison backend/doc/schema/oracle-drop.sql @ 5838:5aa05a7a34b7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Rename modules to more fitting names.
author Sascha L. Teichmann <teichmann@intevation.de>
date Thu, 25 Apr 2013 15:23:37 +0200
parents flys-backend/doc/schema/oracle-drop.sql@dac7723fb502
children 0711ce5ca701
comparison
equal deleted inserted replaced
5837:d9901a08d0a6 5838:5aa05a7a34b7
1 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsRanges;
2 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsEdges;
3 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsPositions;
4 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsAttributes;
5 ALTER TABLE annotations DROP CONSTRAINT cAnnotationsTypes;
6 ALTER TABLE cross_section_lines DROP CONSTRAINT cQPSLinesCrossSections;
7 ALTER TABLE cross_section_points DROP CONSTRAINT cQPSPointsCrossSectionLines;
8 ALTER TABLE cross_sections DROP CONSTRAINT cCrossSectionsRivers;
9 ALTER TABLE cross_sections DROP CONSTRAINT cCrossSectionsTimeIntervals;
10 ALTER TABLE discharge_tables DROP CONSTRAINT cDischargeTablesTime_intervals;
11 ALTER TABLE discharge_tables DROP CONSTRAINT cDischargeTablesGauges;
12 ALTER TABLE gauges DROP CONSTRAINT cGaugesRivers;
13 ALTER TABLE gauges DROP CONSTRAINT cGaugesRanges;
14 ALTER TABLE hyk_entries DROP CONSTRAINT cHykEntriesHyks;
15 ALTER TABLE hyk_flow_zones DROP CONSTRAINT cHykFlowZonesHykFormations;
16 ALTER TABLE hyk_flow_zones DROP CONSTRAINT cHykFlowZonesHykFlowZoneTypes;
17 ALTER TABLE hyks DROP CONSTRAINT cHyksRivers;
18 ALTER TABLE hyk_formations DROP CONSTRAINT cHykFormationsHykEntries;
19 ALTER TABLE main_values DROP CONSTRAINT cMainValuesTimeIntervals;
20 ALTER TABLE main_values DROP CONSTRAINT cMainValuesGauges;
21 ALTER TABLE main_values DROP CONSTRAINT cMainValuesNamedMainValues;
22 ALTER TABLE named_main_values DROP CONSTRAINT cNamedMainValuesMainValueTypes;
23 ALTER TABLE ranges DROP CONSTRAINT cRangesRivers;
24 ALTER TABLE rivers DROP CONSTRAINT cRiversUnits;
25 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstColums;
26 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstQRanges;
27 ALTER TABLE wst_column_values DROP CONSTRAINT cWstColumnValuesWstColumns;
28 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsTime_intervals;
29 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts;
30 ALTER TABLE wst_q_ranges DROP CONSTRAINT cWstQRangesRanges;
31 ALTER TABLE wsts DROP CONSTRAINT cWstsRivers;
32 ALTER TABLE wsts DROP CONSTRAINT cWstsWstKinds;
33 DROP TABLE annotation_types;
34 DROP TABLE annotations;
35 DROP TABLE attributes;
36 DROP TABLE cross_section_lines;
37 DROP TABLE cross_section_points;
38 DROP TABLE cross_sections;
39 DROP TABLE discharge_table_values;
40 DROP TABLE discharge_tables;
41 DROP TABLE edges;
42 DROP TABLE gauges;
43 DROP TABLE hyk_entries;
44 DROP TABLE hyk_flow_zone_types;
45 DROP TABLE hyk_flow_zones;
46 DROP TABLE hyk_formations;
47 DROP TABLE hyks;
48 DROP TABLE main_value_types;
49 DROP TABLE main_values;
50 DROP TABLE named_main_values;
51 DROP TABLE positions;
52 DROP TABLE ranges;
53 DROP TABLE rivers;
54 DROP TABLE time_intervals;
55 DROP TABLE units;
56 DROP TABLE wst_column_q_ranges;
57 DROP TABLE wst_column_values;
58 DROP TABLE wst_columns;
59 DROP TABLE wst_q_ranges;
60 DROP TABLE wsts;
61 DROP TABLE wst_kinds;
62 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ;
63 DROP SEQUENCE ANNOTATIONS_ID_SEQ;
64 DROP SEQUENCE ATTRIBUTES_ID_SEQ;
65 DROP SEQUENCE CROSS_SECTION_LINES_ID_SEQ;
66 DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
67 DROP SEQUENCE CROSS_SECTIONS_ID_SEQ;
68 DROP SEQUENCE DISCHARGE_TABLE_VALUES_ID_SEQ;
69 DROP SEQUENCE DISCHARGE_TABLES_ID_SEQ;
70 DROP SEQUENCE EDGES_ID_SEQ;
71 DROP SEQUENCE GAUGES_ID_SEQ;
72 DROP SEQUENCE HYK_ENTRIES_ID_SEQ;
73 DROP SEQUENCE HYK_FLOW_ZONE_TYPES_ID_SEQ;
74 DROP SEQUENCE HYK_FLOW_ZONES_ID_SEQ;
75 DROP SEQUENCE HYK_FORMATIONS_ID_SEQ;
76 DROP SEQUENCE HYKS_ID_SEQ;
77 DROP SEQUENCE MAIN_VALUE_TYPES_ID_SEQ;
78 DROP SEQUENCE MAIN_VALUES_ID_SEQ;
79 DROP SEQUENCE NAMED_MAIN_VALUES_ID_SEQ;
80 DROP SEQUENCE POSITIONS_ID_SEQ;
81 DROP SEQUENCE RANGES_ID_SEQ;
82 DROP SEQUENCE RIVERS_ID_SEQ;
83 DROP SEQUENCE TIME_INTERVALS_ID_SEQ;
84 DROP SEQUENCE UNITS_ID_SEQ;
85 DROP SEQUENCE WST_COLUMN_Q_RANGES_ID_SEQ;
86 DROP SEQUENCE WST_COLUMN_VALUES_ID_SEQ;
87 DROP SEQUENCE WST_COLUMNS_ID_SEQ;
88 DROP SEQUENCE WST_Q_RANGES_ID_SEQ;
89 DROP SEQUENCE WSTS_ID_SEQ;
90 DROP VIEW wst_value_table;
91 DROP VIEW wst_w_values ;
92 DROP VIEW wst_q_values;
93 DROP VIEW official_lines;
94 DROP VIEW q_main_values;
95 DROP VIEW official_q_values;
96 DROP VIEW wst_ranges;
http://dive4elements.wald.intevation.org