diff flys-backend/doc/schema/oracle-drop-spatial.sql @ 5540:25c2505df28f

Merged
author Christian Lins <christian.lins@intevation.de>
date Wed, 03 Apr 2013 16:00:21 +0200
parents 8b29a94ebdd8
children
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop-spatial.sql	Wed Apr 03 15:59:01 2013 +0200
+++ b/flys-backend/doc/schema/oracle-drop-spatial.sql	Wed Apr 03 16:00:21 2013 +0200
@@ -67,6 +67,16 @@
 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'GAUGE_LOCATION';
 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ;
 
+DROP TRIGGER jetties_trigger;
+DROP TABLE jetties;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'JETTIES';
+DROP SEQUENCE JETTIES_ID_SEQ;
+
+DROP TRIGGER flood_marks_trigger;
+DROP TABLE flood_marks;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOOD_MARKS';
+DROP SEQUENCE FLOOD_MARKS_ID_SEQ;
+
 DROP TABLE hws_kinds;
 DROP TABLE sectie_kinds;
 DROP TABLE sobek_kinds;
@@ -75,3 +85,4 @@
 DROP TABLE boundary_kinds;
 DROP TABLE cross_section_track_kinds;
 DROP TABLE floodplain_kinds;
+DROP TABLE building_kinds;

http://dive4elements.wald.intevation.org