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;

http://dive4elements.wald.intevation.org