Mercurial > dive4elements > river
view flys-backend/doc/schema/oracle-drop-spatial.sql @ 4380:19754e5227c8
Add facets for fixanalysis data from the datacage
Add facets for fixanalysis data from the datacage to the bed difference height
year, bed difference year and bed difference epoch output modes.
author | Björn Ricks <bjoern.ricks@intevation.de> |
---|---|
date | Fri, 02 Nov 2012 15:54:41 +0100 |
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;