Mercurial > dive4elements > river

comparison backend/doc/schema/oracle-drop.sql @ 7352:c6825778de1f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged double-precision branch.
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 16 Oct 2013 13:03:13 +0200
parents 765944ca6df0
children cfafe5764509
comparison
equal deleted inserted replaced
7350:760ea7f08455 7352:c6825778de1f
18 ALTER TABLE hyk_formations DROP CONSTRAINT cHykFormationsHykEntries; 18 ALTER TABLE hyk_formations DROP CONSTRAINT cHykFormationsHykEntries;
19 ALTER TABLE main_values DROP CONSTRAINT cMainValuesTimeIntervals; 19 ALTER TABLE main_values DROP CONSTRAINT cMainValuesTimeIntervals;
20 ALTER TABLE main_values DROP CONSTRAINT cMainValuesGauges; 20 ALTER TABLE main_values DROP CONSTRAINT cMainValuesGauges;
21 ALTER TABLE main_values DROP CONSTRAINT cMainValuesNamedMainValues; 21 ALTER TABLE main_values DROP CONSTRAINT cMainValuesNamedMainValues;
22 ALTER TABLE named_main_values DROP CONSTRAINT cNamedMainValuesMainValueTypes; 22 ALTER TABLE named_main_values DROP CONSTRAINT cNamedMainValuesMainValueTypes;
23 ALTER TABLE official_lines DROP CONSTRAINT cOffLinesNamedMainValues;
24 ALTER TABLE official_lines DROP CONSTRAINT cOffLinesWstColumns;
23 ALTER TABLE ranges DROP CONSTRAINT cRangesRivers; 25 ALTER TABLE ranges DROP CONSTRAINT cRangesRivers;
24 ALTER TABLE rivers DROP CONSTRAINT cRiversUnits; 26 ALTER TABLE rivers DROP CONSTRAINT cRiversUnits;
25 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstColums; 27 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstColums;
26 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstQRanges; 28 ALTER TABLE wst_column_q_ranges DROP CONSTRAINT cWstColumnQRangesWstQRanges;
27 ALTER TABLE wst_column_values DROP CONSTRAINT cWstColumnValuesWstColumns; 29 ALTER TABLE wst_column_values DROP CONSTRAINT cWstColumnValuesWstColumns;
28 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsTime_intervals; 30 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsTime_intervals;
29 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts; 31 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts;
30 ALTER TABLE wst_q_ranges DROP CONSTRAINT cWstQRangesRanges; 32 ALTER TABLE wst_q_ranges DROP CONSTRAINT cWstQRangesRanges;
31 ALTER TABLE wsts DROP CONSTRAINT cWstsRivers; 33 ALTER TABLE wsts DROP CONSTRAINT cWstsRivers;
32 ALTER TABLE wsts DROP CONSTRAINT cWstsWstKinds; 34 ALTER TABLE wsts DROP CONSTRAINT cWstsWstKinds;
33 DROP TABLE annotation_types; 35 DROP TABLE annotation_types PURGE;
34 DROP TABLE annotations; 36 DROP TABLE annotations PURGE;
35 DROP TABLE attributes; 37 DROP TABLE attributes PURGE;
36 DROP TABLE cross_section_lines; 38 DROP TABLE cross_section_lines PURGE;
37 DROP TABLE cross_section_points; 39 DROP TABLE cross_section_points PURGE;
38 DROP TABLE cross_sections; 40 DROP TABLE cross_sections PURGE;
39 DROP TABLE discharge_table_values; 41 DROP TABLE discharge_table_values PURGE;
40 DROP TABLE discharge_tables; 42 DROP TABLE discharge_tables PURGE;
41 DROP TABLE edges; 43 DROP TABLE edges PURGE;
42 DROP TABLE gauges; 44 DROP TABLE gauges PURGE;
43 DROP TABLE hyk_entries; 45 DROP TABLE hyk_entries PURGE;
44 DROP TABLE hyk_flow_zone_types; 46 DROP TABLE hyk_flow_zone_types PURGE;
45 DROP TABLE hyk_flow_zones; 47 DROP TABLE hyk_flow_zones PURGE;
46 DROP TABLE hyk_formations; 48 DROP TABLE hyk_formations PURGE;
47 DROP TABLE hyks; 49 DROP TABLE hyks PURGE;
48 DROP TABLE main_value_types; 50 DROP TABLE main_value_types PURGE;
49 DROP TABLE main_values; 51 DROP TABLE main_values PURGE;
50 DROP TABLE named_main_values; 52 DROP TABLE named_main_values PURGE;
51 DROP TABLE positions; 53 DROP TABLE positions PURGE;
52 DROP TABLE ranges; 54 DROP TABLE ranges PURGE;
53 DROP TABLE rivers; 55 DROP TABLE rivers PURGE;
54 DROP TABLE time_intervals; 56 DROP TABLE time_intervals PURGE;
55 DROP TABLE units; 57 DROP TABLE units PURGE;
56 DROP TABLE wst_column_q_ranges; 58 DROP TABLE wst_column_q_ranges PURGE;
57 DROP TABLE wst_column_values; 59 DROP TABLE wst_column_values PURGE;
58 DROP TABLE wst_columns; 60 DROP TABLE wst_columns PURGE;
59 DROP TABLE wst_q_ranges; 61 DROP TABLE wst_q_ranges PURGE;
60 DROP TABLE official_lines; 62 DROP TABLE official_lines PURGE;
61 DROP TABLE wsts; 63 DROP TABLE wsts PURGE;
62 DROP TABLE wst_kinds; 64 DROP TABLE wst_kinds PURGE;
63 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ; 65 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ;
64 DROP SEQUENCE ANNOTATIONS_ID_SEQ; 66 DROP SEQUENCE ANNOTATIONS_ID_SEQ;
65 DROP SEQUENCE ATTRIBUTES_ID_SEQ; 67 DROP SEQUENCE ATTRIBUTES_ID_SEQ;
66 DROP SEQUENCE CROSS_SECTION_LINES_ID_SEQ; 68 DROP SEQUENCE CROSS_SECTION_LINES_ID_SEQ;
67 DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ; 69 DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
http://dive4elements.wald.intevation.org