Mercurial > dive4elements > river
changeset 8944:c7b200fe343b
Cascade clause added
| author | mschaefer |
|---|---|
| date | Tue, 13 Mar 2018 09:43:48 +0100 |
| parents | 71b17f731762 |
| children | 4a6b6a3c279c |
| files | backend/doc/schema/postgresql-drop-spatial.sql |
| diffstat | 1 files changed, 33 insertions(+), 37 deletions(-) [+] |
line wrap: on
line diff
--- a/backend/doc/schema/postgresql-drop-spatial.sql Tue Mar 13 09:42:41 2018 +0100 +++ b/backend/doc/schema/postgresql-drop-spatial.sql Tue Mar 13 09:43:48 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