Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-drop-spatial.sql @ 3948:883dd49d5e74
Adapted PostgreSQL spatial schema.
flys-backend/trunk@5585 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Mon, 24 Sep 2012 09:13:29 +0000 |
| parents | |
| children | 28f992c0f937 |
comparison
equal
deleted
inserted
replaced
| 3947:371e38af6f79 | 3948:883dd49d5e74 |
|---|---|
| 1 BEGIN; | |
| 2 | |
| 3 DROP TABLE river_axes; | |
| 4 DROP SEQUENCE RIVER_AXES_ID_SEQ; | |
| 5 | |
| 6 DROP TABLE river_axes_km; | |
| 7 DROP SEQUENCE RIVER_AXES_KM_ID_SEQ; | |
| 8 | |
| 9 DROP TABLE cross_section_tracks; | |
| 10 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; | |
| 11 | |
| 12 DROP TABLE lines; | |
| 13 DROP SEQUENCE LINES_ID_SEQ; | |
| 14 | |
| 15 DROP TABLE buildings; | |
| 16 DROP SEQUENCE BUILDINGS_ID_SEQ; | |
| 17 | |
| 18 DROP TABLE fixpoints; | |
| 19 DROP SEQUENCE FIXPOINTS_ID_SEQ; | |
| 20 | |
| 21 DROP TABLE floodplain; | |
| 22 DROP SEQUENCE FLOODPLAIN_ID_SEQ; | |
| 23 | |
| 24 DROP TABLE dem; | |
| 25 DROP SEQUENCE DEM_ID_SEQ; | |
| 26 | |
| 27 DROP TABLE catchment; | |
| 28 DROP SEQUENCE CATCHMENT_ID_SEQ; | |
| 29 | |
| 30 DROP TABLE hws; | |
| 31 DROP SEQUENCE HWS_ID_SEQ; | |
| 32 | |
| 33 DROP TABLE floodmaps; | |
| 34 DROP SEQUENCE FLOODMAPS_ID_SEQ; | |
| 35 | |
| 36 DROP TABLE hydr_boundaries; | |
| 37 DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ; | |
| 38 | |
| 39 DROP TABLE hydr_boundaries_poly; | |
| 40 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; | |
| 41 | |
| 42 DROP TABLE gauge_location; | |
| 43 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; | |
| 44 | |
| 45 COMMIT; |