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

http://dive4elements.wald.intevation.org