Mercurial > dive4elements > river
view flys-backend/doc/schema/oracle-drop-spatial.sql @ 2861:b0132e1b9719
Added further shape importers and added the option to reproject shapes during the import process.
flys-backend/trunk@4342 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Thu, 03 May 2012 14:19:52 +0000 |
parents | 89b097c8ebd7 |
children | 998f1a7dcfde |
line wrap: on
line source
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; DROP TABLE hydr_boundaries; DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'hydr_boundaries'; DROP TRIGGER hydr_boundaries_trigger; DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ; DROP TABLE hydr_boundaries_poly; DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'hydr_boundaries_poly'; DROP TRIGGER hydr_boundaries_poly_trigger; DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ;