# HG changeset patch
# User Ingo Weinzierl <ingo.weinzierl@intevation.de>
# Date 1335508984 0
# Node ID 89b097c8ebd7e1c3177d7c5233c79b53a015888b
# Parent  bd9e76e0b55dd4c413f0886d60afd297c68e058b
Added an SQL file to drop the spatial schema.

flys-backend/trunk@4314 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r bd9e76e0b55d -r 89b097c8ebd7 flys-backend/ChangeLog
--- a/flys-backend/ChangeLog	Fri Apr 27 06:39:12 2012 +0000
+++ b/flys-backend/ChangeLog	Fri Apr 27 06:43:04 2012 +0000
@@ -1,3 +1,8 @@
+2012-04-27  Ingo Weinzierl <ingo@intevation.de>
+
+	* doc/schema/oracle-drop-spatial.sql: New statements to drop the whole
+	  spatial schema.
+
 2012-04-27  Ingo Weinzierl <ingo@intevation.de>
 
 	* contrib/shpimporter/lines.py,
diff -r bd9e76e0b55d -r 89b097c8ebd7 flys-backend/doc/schema/oracle-drop-spatial.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/flys-backend/doc/schema/oracle-drop-spatial.sql	Fri Apr 27 06:43:04 2012 +0000
@@ -0,0 +1,53 @@
+DROP TABLE river_axes;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES';
+DROP TRIGGER river_axes_trigger;
+DROP SEQUENCE RIVER_AXES_ID_SEQ;
+
+DROP TABLE river_axes_km;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES_KM';
+DROP TRIGGER river_axes_km_trigger;
+DROP SEQUENCE RIVER_AXES_KM_ID_SEQ;
+
+DROP TABLE cross_section_tracks;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CROSS_SECTION_TRACKS';
+DROP TRIGGER cross_section_tracks_trigger;
+DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
+
+DROP TABLE lines;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'LINES';
+DROP TRIGGER lines_trigger;
+DROP SEQUENCE LINES_ID_SEQ;
+
+DROP TABLE buildings;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS';
+DROP TRIGGER buildings_trigger;
+DROP SEQUENCE BUILDINGS_ID_SEQ;
+
+DROP TABLE fixpoints;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS';
+DROP TRIGGER fixpoints_trigger;
+DROP SEQUENCE FIXPOINTS_ID_SEQ;
+
+DROP TABLE floodplain;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN';
+DROP TRIGGER floodplain_trigger;
+DROP SEQUENCE FLOODPLAIN_ID_SEQ;
+
+DROP TABLE dem;
+DROP TRIGGER dem_trigger;
+DROP SEQUENCE DEM_ID_SEQ;
+
+DROP TABLE catchment;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT';
+DROP TRIGGER catchment_trigger;
+DROP SEQUENCE CATCHMENT_ID_SEQ;
+
+DROP TABLE hws;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS';
+DROP TRIGGER hws_trigger;
+DROP SEQUENCE HWS_ID_SEQ;
+
+DROP TABLE floodmaps;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS';
+DROP TRIGGER floodmaps_trigger;
+DROP SEQUENCE FLOODMAPS_ID_SEQ;