Mercurial > dive4elements > river
diff backend/doc/schema/postgresql-drop-spatial.sql @ 8945:4a6b6a3c279c
Merge
author | mschaefer |
---|---|
date | Tue, 13 Mar 2018 09:55:53 +0100 |
parents | c7b200fe343b |
children |
line wrap: on
line diff
--- a/backend/doc/schema/postgresql-drop-spatial.sql Fri Mar 09 18:47:06 2018 +0100 +++ b/backend/doc/schema/postgresql-drop-spatial.sql Tue Mar 13 09:55:53 2018 +0100 @@ -1,47 +1,43 @@ BEGIN; -DROP TABLE river_axes; +DROP TABLE axis_kinds CASCADE; +DROP TABLE river_axes CASCADE; DROP SEQUENCE RIVER_AXES_ID_SEQ; - -DROP TABLE river_axes_km; +DROP TABLE river_axes_km CASCADE; DROP SEQUENCE RIVER_AXES_KM_ID_SEQ; - -DROP TABLE cross_section_tracks; +DROP TABLE cross_section_track_kinds CASCADE; +DROP TABLE cross_section_tracks CASCADE; DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; - -DROP TABLE buildings; +DROP TABLE building_kinds CASCADE; +DROP TABLE buildings CASCADE; DROP SEQUENCE BUILDINGS_ID_SEQ; - -DROP TABLE fixpoints; +DROP TABLE fixpoints CASCADE; DROP SEQUENCE FIXPOINTS_ID_SEQ; - -DROP TABLE floodplain; +DROP TABLE floodplain_kinds CASCADE; +DROP TABLE floodplain CASCADE; DROP SEQUENCE FLOODPLAIN_ID_SEQ; - -DROP TABLE dem; +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; -DROP TABLE hws_points; -DROP SEQUENCE HWS_POINTS_ID_SEQ; - -DROP TABLE hws_lines; -DROP SEQUENCE HWS_LINES_ID_SEQ; - -DROP TABLE floodmaps; -DROP SEQUENCE FLOODMAPS_ID_SEQ; - -DROP TABLE hydr_boundaries; -DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ; - -DROP TABLE hydr_boundaries_poly; -DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; - -DROP TABLE fed_states; -DROP TABLE hws_kinds; -DROP TABLE sobek_kinds; -DROP TABLE sectie_kinds; -DROP TABLE boundary_kinds; -DROP TABLE axis_kinds; -DROP TABLE building_kinds; - -COMMIT; +COMMIT; \ No newline at end of file