view backend/doc/schema/postgresql-drop-spatial.sql @ 9415:9744ce3c3853

Rework of fixanalysis computation and dWt and WQ facets. Got rid of strange remapping and bitshifting code by explicitely saving the column information and using it in the facets. The facets also put the valid station range into their xml-metadata
author gernotbelger
date Thu, 16 Aug 2018 16:27:53 +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