changeset 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 d17e3106c910
children da3101abc9da
files flys-backend/doc/schema/oracle-drop-spatial.sql flys-backend/doc/schema/oracle-drop.sql
diffstat 2 files changed, 4 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop-spatial.sql	Wed Mar 13 11:26:59 2013 +0100
+++ b/flys-backend/doc/schema/oracle-drop-spatial.sql	Wed Mar 13 11:48:01 2013 +0100
@@ -73,3 +73,5 @@
 DROP TABLE fed_states;
 DROP TABLE axis_kinds;
 DROP TABLE boundary_kinds;
+DROP TABLE cross_section_track_kinds;
+DROP TABLE floodplain_kinds;
--- 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