Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-drop-spatial.sql @ 4930:28f992c0f937 dami
SCHEMA CHANGES: Add tables for Hochwasserschutzanlagen
This adds the first draft of Hochwasserschutzanlagen tables
hws_points and hws_lines which replace the old hws table and
also lookup tables fed_states and hws_kinds.
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Mon, 28 Jan 2013 17:42:18 +0100 |
| parents | 883dd49d5e74 |
| children | 929ec3ed7dc2 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-drop-spatial.sql Mon Jan 28 12:45:41 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-drop-spatial.sql Mon Jan 28 17:42:18 2013 +0100 @@ -27,8 +27,14 @@ DROP TABLE catchment; DROP SEQUENCE CATCHMENT_ID_SEQ; -DROP TABLE hws; -DROP SEQUENCE HWS_ID_SEQ; +--DROP TABLE hws; +--DROP SEQUENCE HWS_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; @@ -42,4 +48,7 @@ DROP TABLE gauge_location; DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; +DROP TABLE fed_states; +DROP TABLE hws_kinds; + COMMIT;