Mercurial > dive4elements > river

comparison backend/doc/schema/postgresql-drop-spatial.sql @ 8944:c7b200fe343b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Cascade clause added
author mschaefer
date Tue, 13 Mar 2018 09:43:48 +0100
parents cc53aae06303
children
comparison
equal deleted inserted replaced
8943:71b17f731762 8944:c7b200fe343b
1 BEGIN; 1 BEGIN;
2 2
3 DROP TABLE river_axes; 3 DROP TABLE axis_kinds CASCADE;
4 DROP TABLE river_axes CASCADE;
4 DROP SEQUENCE RIVER_AXES_ID_SEQ; 5 DROP SEQUENCE RIVER_AXES_ID_SEQ;
5 6 DROP TABLE river_axes_km CASCADE;
6 DROP TABLE river_axes_km;
7 DROP SEQUENCE RIVER_AXES_KM_ID_SEQ; 7 DROP SEQUENCE RIVER_AXES_KM_ID_SEQ;
8 8 DROP TABLE cross_section_track_kinds CASCADE;
9 DROP TABLE cross_section_tracks; 9 DROP TABLE cross_section_tracks CASCADE;
10 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; 10 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
11 11 DROP TABLE building_kinds CASCADE;
12 DROP TABLE buildings; 12 DROP TABLE buildings CASCADE;
13 DROP SEQUENCE BUILDINGS_ID_SEQ; 13 DROP SEQUENCE BUILDINGS_ID_SEQ;
14 14 DROP TABLE fixpoints CASCADE;
15 DROP TABLE fixpoints;
16 DROP SEQUENCE FIXPOINTS_ID_SEQ; 15 DROP SEQUENCE FIXPOINTS_ID_SEQ;
17 16 DROP TABLE floodplain_kinds CASCADE;
18 DROP TABLE floodplain; 17 DROP TABLE floodplain CASCADE;
19 DROP SEQUENCE FLOODPLAIN_ID_SEQ; 18 DROP SEQUENCE FLOODPLAIN_ID_SEQ;
20 19 DROP TABLE dem CASCADE;
21 DROP TABLE dem;
22 DROP SEQUENCE DEM_ID_SEQ; 20 DROP SEQUENCE DEM_ID_SEQ;
23 21 DROP TABLE hws_kinds CASCADE;
24 DROP TABLE hws_points; 22 DROP TABLE fed_states CASCADE;
23 DROP TABLE hws_lines CASCADE;
24 DROP SEQUENCE HWS_LINES_ID_SEQ;
25 DROP TABLE hws_points CASCADE;
25 DROP SEQUENCE HWS_POINTS_ID_SEQ; 26 DROP SEQUENCE HWS_POINTS_ID_SEQ;
26 27 DROP TABLE floodmap_kinds CASCADE;
27 DROP TABLE hws_lines; 28 DROP TABLE floodmaps CASCADE;
28 DROP SEQUENCE HWS_LINES_ID_SEQ;
29
30 DROP TABLE floodmaps;
31 DROP SEQUENCE FLOODMAPS_ID_SEQ; 29 DROP SEQUENCE FLOODMAPS_ID_SEQ;
32 30 DROP TABLE sectie_kinds CASCADE;
33 DROP TABLE hydr_boundaries; 31 DROP TABLE sobek_kinds CASCADE;
32 DROP TABLE boundary_kinds CASCADE;
33 DROP TABLE hydr_boundaries CASCADE;
34 DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ; 34 DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ;
35 35 DROP TABLE hydr_boundaries_poly CASCADE;
36 DROP TABLE hydr_boundaries_poly;
37 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; 36 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ;
38 37 DROP TABLE jetty_kinds CASCADE;
39 DROP TABLE fed_states; 38 DROP TABLE jetties CASCADE;
40 DROP TABLE hws_kinds; 39 DROP SEQUENCE JETTIES_ID_SEQ;
41 DROP TABLE sobek_kinds; 40 DROP TABLE flood_marks CASCADE;
42 DROP TABLE sectie_kinds; 41 DROP SEQUENCE FLOOD_MARKS_ID_SEQ;
43 DROP TABLE boundary_kinds;
44 DROP TABLE axis_kinds;
45 DROP TABLE building_kinds;
46 42
47 COMMIT; 43 COMMIT;
http://dive4elements.wald.intevation.org