view flys-backend/doc/schema/postgresql-drop-spatial.sql @ 4437:dd8a63002fb8

Only put current Km to the context if it is a valid km Don't set the current km to the invalid value.
author Björn Ricks <bjoern.ricks@intevation.de>
date Tue, 06 Nov 2012 15:51:43 +0100
parents 883dd49d5e74
children 28f992c0f937
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 lines;
DROP SEQUENCE LINES_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 catchment;
DROP SEQUENCE CATCHMENT_ID_SEQ;

DROP TABLE hws;
DROP SEQUENCE HWS_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;

COMMIT;

http://dive4elements.wald.intevation.org