Mercurial > dive4elements > river
view backend/doc/schema/postgresql-drop-spatial.sql @ 9655:1f57381b3bb5
Importer (s/u-info) extensions: uniform formatting of from-to series names,
warning instead of cancelling in case of missing tkh column values,
detecting, logging and skipping columns with wrong unit
author | mschaefer |
---|---|
date | Mon, 23 Mar 2020 15:16:35 +0100 |
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;