Mercurial > dive4elements > river
view flys-backend/doc/schema/postgresql-drop-spatial.sql @ 5128:a020100ee6a1
SCHEME CHANGE: Merge branch dami into default.
A summary on the scheme changes:
HWS and Lines tables are dropped and will be replaced by HWS_Lines and
HWS_Points.
The catchment table removed and will be replaced
by a WMS Service.
Hydr_boundaries has an added reference to boundary_kind sectie_kind
and sobek_kind objects.
Dem has a new column srid.
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Thu, 28 Feb 2013 11:48:17 +0100 |
parents | 3d8000616ed5 |
children | d4fdd98a04f7 |
line wrap: on
line source
BEGIN; DROP TABLE river_axes; DROP SEQUENCE RIVER_AXES_ID_SEQ; DROP TABLE river_axes_km; DROP SEQUENCE RIVER_AXES_KM_ID_SEQ; DROP TABLE cross_section_tracks; DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; DROP TABLE buildings; DROP SEQUENCE BUILDINGS_ID_SEQ; DROP TABLE fixpoints; DROP SEQUENCE FIXPOINTS_ID_SEQ; DROP TABLE floodplain; DROP SEQUENCE FLOODPLAIN_ID_SEQ; DROP TABLE dem; DROP SEQUENCE DEM_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 gauge_location; DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; DROP TABLE fed_states; DROP TABLE hws_kinds; DROP TABLE sobek_kinds; DROP TABLE sectie_kinds; DROP TABLE boundary_kinds; COMMIT;