Mercurial > dive4elements > river

annotate backend/doc/schema/postgresql-drop-spatial.sql @ 9415:9744ce3c3853

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Rework of fixanalysis computation and dWt and WQ facets. Got rid of strange remapping and bitshifting code by explicitely saving the column information and using it in the facets. The facets also put the valid station range into their xml-metadata
author gernotbelger
date Thu, 16 Aug 2018 16:27:53 +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