Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 4887:1f6e544f7a7f | 4930:28f992c0f937 |
|---|---|
| 25 DROP SEQUENCE DEM_ID_SEQ; | 25 DROP SEQUENCE DEM_ID_SEQ; |
| 26 | 26 |
| 27 DROP TABLE catchment; | 27 DROP TABLE catchment; |
| 28 DROP SEQUENCE CATCHMENT_ID_SEQ; | 28 DROP SEQUENCE CATCHMENT_ID_SEQ; |
| 29 | 29 |
| 30 DROP TABLE hws; | 30 --DROP TABLE hws; |
| 31 DROP SEQUENCE HWS_ID_SEQ; | 31 --DROP SEQUENCE HWS_ID_SEQ; |
| 32 | |
| 33 DROP TABLE hws_points; | |
| 34 DROP SEQUENCE HWS_POINTS_ID_SEQ; | |
| 35 | |
| 36 DROP TABLE hws_lines; | |
| 37 DROP SEQUENCE HWS_LINES_ID_SEQ; | |
| 32 | 38 |
| 33 DROP TABLE floodmaps; | 39 DROP TABLE floodmaps; |
| 34 DROP SEQUENCE FLOODMAPS_ID_SEQ; | 40 DROP SEQUENCE FLOODMAPS_ID_SEQ; |
| 35 | 41 |
| 36 DROP TABLE hydr_boundaries; | 42 DROP TABLE hydr_boundaries; |
| 40 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; | 46 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; |
| 41 | 47 |
| 42 DROP TABLE gauge_location; | 48 DROP TABLE gauge_location; |
| 43 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; | 49 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; |
| 44 | 50 |
| 51 DROP TABLE fed_states; | |
| 52 DROP TABLE hws_kinds; | |
| 53 | |
| 45 COMMIT; | 54 COMMIT; |