view backend/doc/schema/postgresql-drop-spatial.sql @ 9129:28eec75415d8

Handle case where no default bedheights are defined for a given river
author gernotbelger
date Wed, 06 Jun 2018 14:15:58 +0200
parents c7b200fe343b
children
line wrap: on
line source
BEGIN;

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

COMMIT;

http://dive4elements.wald.intevation.org