Mercurial > dive4elements > river

annotate backend/doc/schema/postgresql-drop-spatial.sql @ 9535:3fa8551c3d1b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed error in bundu bzws missing volume calculation for mean bed height; added various additional output columns (field bed height, field flow depth etc.)
author mschaefer
date Fri, 12 Oct 2018 18:49:38 +0200
parents c7b200fe343b
children
rev   line source
3948
883dd49d5e74 Adapted PostgreSQL spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
1 BEGIN;
883dd49d5e74 Adapted PostgreSQL spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
2
8944
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
3 DROP TABLE axis_kinds CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
4 DROP TABLE river_axes CASCADE;
3948
883dd49d5e74 Adapted PostgreSQL spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
5 DROP SEQUENCE RIVER_AXES_ID_SEQ;
8944
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
6 DROP TABLE river_axes_km CASCADE;
3948
883dd49d5e74 Adapted PostgreSQL spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
7 DROP SEQUENCE RIVER_AXES_KM_ID_SEQ;
8944
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
8 DROP TABLE cross_section_track_kinds CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
9 DROP TABLE cross_section_tracks CASCADE;
3948
883dd49d5e74 Adapted PostgreSQL spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
10 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
8944
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
11 DROP TABLE building_kinds CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
12 DROP TABLE buildings CASCADE;
3948
883dd49d5e74 Adapted PostgreSQL spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
13 DROP SEQUENCE BUILDINGS_ID_SEQ;
8944
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
14 DROP TABLE fixpoints CASCADE;
3948
883dd49d5e74 Adapted PostgreSQL spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
15 DROP SEQUENCE FIXPOINTS_ID_SEQ;
8944
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
16 DROP TABLE floodplain_kinds CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
17 DROP TABLE floodplain CASCADE;
3948
883dd49d5e74 Adapted PostgreSQL spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
18 DROP SEQUENCE FLOODPLAIN_ID_SEQ;
8944
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
19 DROP TABLE dem CASCADE;
3948
883dd49d5e74 Adapted PostgreSQL spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
20 DROP SEQUENCE DEM_ID_SEQ;
8944
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
21 DROP TABLE hws_kinds CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
22 DROP TABLE fed_states CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
23 DROP TABLE hws_lines CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
24 DROP SEQUENCE HWS_LINES_ID_SEQ;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
25 DROP TABLE hws_points CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
26 DROP SEQUENCE HWS_POINTS_ID_SEQ;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
27 DROP TABLE floodmap_kinds CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
28 DROP TABLE floodmaps CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
29 DROP SEQUENCE FLOODMAPS_ID_SEQ;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
30 DROP TABLE sectie_kinds CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
31 DROP TABLE sobek_kinds CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
32 DROP TABLE boundary_kinds CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
33 DROP TABLE hydr_boundaries CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
34 DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
35 DROP TABLE hydr_boundaries_poly CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
36 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
37 DROP TABLE jetty_kinds CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
38 DROP TABLE jetties CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
39 DROP SEQUENCE JETTIES_ID_SEQ;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
40 DROP TABLE flood_marks CASCADE;
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
41 DROP SEQUENCE FLOOD_MARKS_ID_SEQ;
3948
883dd49d5e74 Adapted PostgreSQL spatial schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
42
8944
c7b200fe343b Cascade clause added
mschaefer
parents: 8466
diff changeset
43 COMMIT;
http://dive4elements.wald.intevation.org