view flys-backend/doc/schema/oracle-drop-spatial.sql @ 3961:f5912365619c

Adapted the spatial schema for DEMs and the DgmSqlConverter. flys-backend/trunk@5632 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Fri, 28 Sep 2012 08:37:08 +0000
parents 998f1a7dcfde
children 96d330bc40d0
line wrap: on
line source
DROP TRIGGER river_axes_trigger;
DROP TABLE river_axes;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES';
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 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 SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;

DROP TRIGGER lines_trigger;
DROP TABLE lines;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'LINES';
DROP SEQUENCE LINES_ID_SEQ;

DROP TRIGGER buildings_trigger;
DROP TABLE buildings;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS';
DROP SEQUENCE BUILDINGS_ID_SEQ;

DROP TRIGGER fixpoints_trigger;
DROP TABLE fixpoints;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS';
DROP SEQUENCE FIXPOINTS_ID_SEQ;

DROP TRIGGER floodplain_trigger;
DROP TABLE floodplain;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN';
DROP SEQUENCE FLOODPLAIN_ID_SEQ;

DROP TRIGGER dem_trigger;
DROP TABLE dem;
DROP SEQUENCE DEM_ID_SEQ;

DROP TRIGGER catchment_trigger;
DROP TABLE catchment;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT';
DROP SEQUENCE CATCHMENT_ID_SEQ;

DROP TRIGGER hws_trigger;
DROP TABLE hws;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS';
DROP SEQUENCE HWS_ID_SEQ;

DROP TRIGGER floodmaps_trigger;
DROP TABLE floodmaps;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS';
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 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 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;

http://dive4elements.wald.intevation.org