comparison flys-backend/doc/schema/oracle-drop.sql @ 5271:dac7723fb502

added missing lookup tables to drop-scripts
author Tom Gottfried <tom@intevation.de>
date Wed, 13 Mar 2013 11:48:01 +0100
parents f57b096df75a
children
comparison
equal deleted inserted replaced
5270:d17e3106c910 5271:dac7723fb502
27 ALTER TABLE wst_column_values DROP CONSTRAINT cWstColumnValuesWstColumns; 27 ALTER TABLE wst_column_values DROP CONSTRAINT cWstColumnValuesWstColumns;
28 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsTime_intervals; 28 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsTime_intervals;
29 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts; 29 ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts;
30 ALTER TABLE wst_q_ranges DROP CONSTRAINT cWstQRangesRanges; 30 ALTER TABLE wst_q_ranges DROP CONSTRAINT cWstQRangesRanges;
31 ALTER TABLE wsts DROP CONSTRAINT cWstsRivers; 31 ALTER TABLE wsts DROP CONSTRAINT cWstsRivers;
32 ALTER TABLE wsts DROP CONSTRAINT cWstsWstKinds;
32 DROP TABLE annotation_types; 33 DROP TABLE annotation_types;
33 DROP TABLE annotations; 34 DROP TABLE annotations;
34 DROP TABLE attributes; 35 DROP TABLE attributes;
35 DROP TABLE cross_section_lines; 36 DROP TABLE cross_section_lines;
36 DROP TABLE cross_section_points; 37 DROP TABLE cross_section_points;
55 DROP TABLE wst_column_q_ranges; 56 DROP TABLE wst_column_q_ranges;
56 DROP TABLE wst_column_values; 57 DROP TABLE wst_column_values;
57 DROP TABLE wst_columns; 58 DROP TABLE wst_columns;
58 DROP TABLE wst_q_ranges; 59 DROP TABLE wst_q_ranges;
59 DROP TABLE wsts; 60 DROP TABLE wsts;
61 DROP TABLE wst_kinds;
60 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ; 62 DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ;
61 DROP SEQUENCE ANNOTATIONS_ID_SEQ; 63 DROP SEQUENCE ANNOTATIONS_ID_SEQ;
62 DROP SEQUENCE ATTRIBUTES_ID_SEQ; 64 DROP SEQUENCE ATTRIBUTES_ID_SEQ;
63 DROP SEQUENCE CROSS_SECTION_LINES_ID_SEQ; 65 DROP SEQUENCE CROSS_SECTION_LINES_ID_SEQ;
64 DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ; 66 DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;

http://dive4elements.wald.intevation.org