Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-drop-spatial.sql @ 4999:929ec3ed7dc2 dami
SCHEMA_CHANGE: Add lookup tables for sectie / sobek and boundary_kind
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Fri, 15 Feb 2013 12:38:25 +0100 |
| parents | 28f992c0f937 |
| children | 3d8000616ed5 |
comparison
equal
deleted
inserted
replaced
| 4998:ab5d8f73a982 | 4999:929ec3ed7dc2 |
|---|---|
| 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; | |
| 31 --DROP SEQUENCE HWS_ID_SEQ; | |
| 32 | |
| 33 DROP TABLE hws_points; | 30 DROP TABLE hws_points; |
| 34 DROP SEQUENCE HWS_POINTS_ID_SEQ; | 31 DROP SEQUENCE HWS_POINTS_ID_SEQ; |
| 35 | 32 |
| 36 DROP TABLE hws_lines; | 33 DROP TABLE hws_lines; |
| 37 DROP SEQUENCE HWS_LINES_ID_SEQ; | 34 DROP SEQUENCE HWS_LINES_ID_SEQ; |
| 48 DROP TABLE gauge_location; | 45 DROP TABLE gauge_location; |
| 49 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; | 46 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; |
| 50 | 47 |
| 51 DROP TABLE fed_states; | 48 DROP TABLE fed_states; |
| 52 DROP TABLE hws_kinds; | 49 DROP TABLE hws_kinds; |
| 50 DROP TABLE sobek_kinds; | |
| 51 DROP TABLE sectie_kinds; | |
| 52 DROP TABLE boundary_kinds; | |
| 53 | 53 |
| 54 COMMIT; | 54 COMMIT; |