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;

http://dive4elements.wald.intevation.org