Mercurial > dive4elements > river
view backend/doc/schema/postgresql-drop-spatial.sql @ 8978:b5600453bb8f
SINFO Calculations: do not produce result rows if some input data has missing values.
Also check for years of waterlevels in flow depth development calculation.
author | gernotbelger |
---|---|
date | Thu, 05 Apr 2018 11:57:54 +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;