--- a/flys-backend/doc/schema/oracle-drop-spatial.sql	Thu May 03 14:19:52 2012 +0000
+++ b/flys-backend/doc/schema/oracle-drop-spatial.sql	Fri May 04 06:58:00 2012 +0000
@@ -1,63 +1,68 @@
+DROP TRIGGER river_axes_trigger;
 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 TRIGGER river_axes_km_trigger;
 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 TRIGGER cross_section_tracks_trigger;
 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 TRIGGER lines_trigger;
 DROP TABLE lines;
 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'LINES';
-DROP TRIGGER lines_trigger;
 DROP SEQUENCE LINES_ID_SEQ;
 
+DROP TRIGGER buildings_trigger;
 DROP TABLE buildings;
 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS';
-DROP TRIGGER buildings_trigger;
 DROP SEQUENCE BUILDINGS_ID_SEQ;
 
+DROP TRIGGER fixpoints_trigger;
 DROP TABLE fixpoints;
 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS';
-DROP TRIGGER fixpoints_trigger;
 DROP SEQUENCE FIXPOINTS_ID_SEQ;
 
+DROP TRIGGER floodplain_trigger;
 DROP TABLE floodplain;
 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN';
-DROP TRIGGER floodplain_trigger;
 DROP SEQUENCE FLOODPLAIN_ID_SEQ;
 
+DROP TRIGGER dem_trigger;
 DROP TABLE dem;
-DROP TRIGGER dem_trigger;
 DROP SEQUENCE DEM_ID_SEQ;
 
+DROP TRIGGER catchment_trigger;
 DROP TABLE catchment;
 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT';
-DROP TRIGGER catchment_trigger;
 DROP SEQUENCE CATCHMENT_ID_SEQ;
 
+DROP TRIGGER hws_trigger;
 DROP TABLE hws;
 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS';
-DROP TRIGGER hws_trigger;
 DROP SEQUENCE HWS_ID_SEQ;
 
+DROP TRIGGER floodmaps_trigger;
 DROP TABLE floodmaps;
 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS';
-DROP TRIGGER floodmaps_trigger;
 DROP SEQUENCE FLOODMAPS_ID_SEQ;
 
+DROP TRIGGER hydr_boundaries_trigger;
 DROP TABLE hydr_boundaries;
-DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'hydr_boundaries';
-DROP TRIGGER hydr_boundaries_trigger;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES';
 DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ;
 
+DROP TRIGGER hydr_boundaries_poly_trigger;
 DROP TABLE hydr_boundaries_poly;
-DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'hydr_boundaries_poly';
-DROP TRIGGER hydr_boundaries_poly_trigger;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES_POLY';
 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ;
+
+DROP TRIGGER gauge_location_trigger;
+DROP TABLE gauge_location;
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'GAUGE_LOCATION';
+DROP SEQUENCE GAUGE_LOCATION_ID_SEQ;