Mercurial > dive4elements > river
diff 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 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop.sql Wed Mar 13 11:26:59 2013 +0100 +++ b/flys-backend/doc/schema/oracle-drop.sql Wed Mar 13 11:48:01 2013 +0100 @@ -29,6 +29,7 @@ ALTER TABLE wst_columns DROP CONSTRAINT cWstColumnsWsts; ALTER TABLE wst_q_ranges DROP CONSTRAINT cWstQRangesRanges; ALTER TABLE wsts DROP CONSTRAINT cWstsRivers; +ALTER TABLE wsts DROP CONSTRAINT cWstsWstKinds; DROP TABLE annotation_types; DROP TABLE annotations; DROP TABLE attributes; @@ -57,6 +58,7 @@ DROP TABLE wst_columns; DROP TABLE wst_q_ranges; DROP TABLE wsts; +DROP TABLE wst_kinds; DROP SEQUENCE ANNOTATION_TYPES_ID_SEQ; DROP SEQUENCE ANNOTATIONS_ID_SEQ; DROP SEQUENCE ATTRIBUTES_ID_SEQ;