ingo@2862: DROP TRIGGER river_axes_trigger;
ingo@2854: DROP TABLE river_axes;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES';
ingo@2854: DROP SEQUENCE RIVER_AXES_ID_SEQ;
ingo@2854: 
ingo@2862: DROP TRIGGER river_axes_km_trigger;
ingo@2854: DROP TABLE river_axes_km;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES_KM';
ingo@2854: DROP SEQUENCE RIVER_AXES_KM_ID_SEQ;
ingo@2854: 
ingo@2862: DROP TRIGGER cross_section_tracks_trigger;
ingo@2854: DROP TABLE cross_section_tracks;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CROSS_SECTION_TRACKS';
ingo@2854: DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
ingo@2854: 
ingo@2862: DROP TRIGGER buildings_trigger;
ingo@2854: DROP TABLE buildings;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS';
ingo@2854: DROP SEQUENCE BUILDINGS_ID_SEQ;
ingo@2854: 
ingo@2862: DROP TRIGGER fixpoints_trigger;
ingo@2854: DROP TABLE fixpoints;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS';
ingo@2854: DROP SEQUENCE FIXPOINTS_ID_SEQ;
ingo@2854: 
ingo@2862: DROP TRIGGER floodplain_trigger;
ingo@2854: DROP TABLE floodplain;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN';
ingo@2854: DROP SEQUENCE FLOODPLAIN_ID_SEQ;
ingo@2854: 
ingo@2862: DROP TRIGGER dem_trigger;
ingo@2854: DROP TABLE dem;
ingo@2854: DROP SEQUENCE DEM_ID_SEQ;
ingo@2854: 
ingo@2862: DROP TRIGGER catchment_trigger;
ingo@2854: DROP TABLE catchment;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT';
ingo@2854: DROP SEQUENCE CATCHMENT_ID_SEQ;
ingo@2854: 
aheinecke@5034: DROP TRIGGER hws_lines_trigger;
aheinecke@5034: DROP TABLE hws_lines;
aheinecke@5034: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_LINES';
aheinecke@5034: DROP SEQUENCE HWS_LINES_ID_SEQ;
aheinecke@5034: 
aheinecke@5034: DROP TRIGGER hws_points_trigger;
aheinecke@5034: DROP TABLE hws_points;
aheinecke@5034: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_POINTS';
aheinecke@5034: DROP SEQUENCE HWS_POINTS_ID_SEQ;
ingo@2854: 
ingo@2862: DROP TRIGGER floodmaps_trigger;
ingo@2854: DROP TABLE floodmaps;
ingo@2854: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS';
ingo@2854: DROP SEQUENCE FLOODMAPS_ID_SEQ;
ingo@2861: 
ingo@2862: DROP TRIGGER hydr_boundaries_trigger;
ingo@2861: DROP TABLE hydr_boundaries;
ingo@2862: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES';
ingo@2861: DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ;
ingo@2861: 
ingo@2862: DROP TRIGGER hydr_boundaries_poly_trigger;
ingo@2861: DROP TABLE hydr_boundaries_poly;
ingo@2862: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES_POLY';
ingo@2861: DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ;
ingo@2862: 
ingo@2862: DROP TRIGGER gauge_location_trigger;
ingo@2862: DROP TABLE gauge_location;
ingo@2862: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'GAUGE_LOCATION';
ingo@2862: DROP SEQUENCE GAUGE_LOCATION_ID_SEQ;
aheinecke@5034: 
tom@5409: DROP TRIGGER jetties_trigger;
tom@5409: DROP TABLE jetties;
tom@5409: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'JETTIES';
tom@5409: DROP SEQUENCE JETTIES_ID_SEQ;
tom@5409: 
tom@5409: DROP TRIGGER flood_marks_trigger;
tom@5409: DROP TABLE flood_marks;
tom@5409: DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOOD_MARKS';
tom@5409: DROP SEQUENCE FLOOD_MARKS_ID_SEQ;
tom@5409: 
aheinecke@5034: DROP TABLE hws_kinds;
aheinecke@5034: DROP TABLE sectie_kinds;
aheinecke@5034: DROP TABLE sobek_kinds;
aheinecke@5034: DROP TABLE fed_states;
aheinecke@5146: DROP TABLE axis_kinds;
aheinecke@5034: DROP TABLE boundary_kinds;
tom@5271: DROP TABLE cross_section_track_kinds;
tom@5271: DROP TABLE floodplain_kinds;
aheinecke@5408: DROP TABLE building_kinds;