Mercurial > dive4elements > river
view flys-backend/doc/schema/postgresql-drop-spatial.sql @ 4866:acfd48384835
Changed data field names in fix analsis to ld_from, ld_to, ld step.
* Changed names in state model.
* Changed data fields in artifact.
* Use RangeAccess to get location/distance data.
author | Raimund Renkert <rrenkert@intevation.de> |
---|---|
date | Fri, 25 Jan 2013 11:53:04 +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;