ingo@3948: BEGIN;
ingo@3948: 
mschaefer@8944: DROP TABLE axis_kinds CASCADE;
mschaefer@8944: DROP TABLE river_axes CASCADE;
ingo@3948: DROP SEQUENCE RIVER_AXES_ID_SEQ;
mschaefer@8944: DROP TABLE river_axes_km CASCADE;
ingo@3948: DROP SEQUENCE RIVER_AXES_KM_ID_SEQ;
mschaefer@8944: DROP TABLE cross_section_track_kinds CASCADE;
mschaefer@8944: DROP TABLE cross_section_tracks CASCADE;
ingo@3948: DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
mschaefer@8944: DROP TABLE building_kinds CASCADE;
mschaefer@8944: DROP TABLE buildings CASCADE;
ingo@3948: DROP SEQUENCE BUILDINGS_ID_SEQ;
mschaefer@8944: DROP TABLE fixpoints CASCADE;
ingo@3948: DROP SEQUENCE FIXPOINTS_ID_SEQ;
mschaefer@8944: DROP TABLE floodplain_kinds CASCADE;
mschaefer@8944: DROP TABLE floodplain CASCADE;
ingo@3948: DROP SEQUENCE FLOODPLAIN_ID_SEQ;
mschaefer@8944: DROP TABLE dem CASCADE;
ingo@3948: DROP SEQUENCE DEM_ID_SEQ;
mschaefer@8944: DROP TABLE hws_kinds CASCADE;
mschaefer@8944: DROP TABLE fed_states CASCADE;
mschaefer@8944: DROP TABLE hws_lines CASCADE;
mschaefer@8944: DROP SEQUENCE HWS_LINES_ID_SEQ;
mschaefer@8944: DROP TABLE hws_points CASCADE;
mschaefer@8944: DROP SEQUENCE HWS_POINTS_ID_SEQ;
mschaefer@8944: DROP TABLE floodmap_kinds CASCADE;
mschaefer@8944: DROP TABLE floodmaps CASCADE;
mschaefer@8944: DROP SEQUENCE FLOODMAPS_ID_SEQ;
mschaefer@8944: DROP TABLE sectie_kinds CASCADE;
mschaefer@8944: DROP TABLE sobek_kinds CASCADE;
mschaefer@8944: DROP TABLE boundary_kinds CASCADE;
mschaefer@8944: DROP TABLE hydr_boundaries CASCADE;
mschaefer@8944: DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ;
mschaefer@8944: DROP TABLE hydr_boundaries_poly CASCADE;
mschaefer@8944: DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ;
mschaefer@8944: DROP TABLE jetty_kinds CASCADE;
mschaefer@8944: DROP TABLE jetties CASCADE;
mschaefer@8944: DROP SEQUENCE JETTIES_ID_SEQ;
mschaefer@8944: DROP TABLE flood_marks CASCADE;
mschaefer@8944: DROP SEQUENCE FLOOD_MARKS_ID_SEQ;
ingo@3948: 
mschaefer@8944: COMMIT;