Mercurial > dive4elements > river
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; |