Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-drop-spatial.sql @ 5379:61bf64b102bc mapgenfix
Merge with default branch
| author | Christian Lins <christian.lins@intevation.de> |
|---|---|
| date | Fri, 22 Mar 2013 11:25:54 +0100 |
| parents | d4fdd98a04f7 |
| children | 91f5908c472a |
comparison
equal
deleted
inserted
replaced
| 5175:cfc5540a4eec | 5379:61bf64b102bc |
|---|---|
| 6 DROP TABLE river_axes_km; | 6 DROP TABLE river_axes_km; |
| 7 DROP SEQUENCE RIVER_AXES_KM_ID_SEQ; | 7 DROP SEQUENCE RIVER_AXES_KM_ID_SEQ; |
| 8 | 8 |
| 9 DROP TABLE cross_section_tracks; | 9 DROP TABLE cross_section_tracks; |
| 10 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; | 10 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; |
| 11 | |
| 12 DROP TABLE lines; | |
| 13 DROP SEQUENCE LINES_ID_SEQ; | |
| 14 | 11 |
| 15 DROP TABLE buildings; | 12 DROP TABLE buildings; |
| 16 DROP SEQUENCE BUILDINGS_ID_SEQ; | 13 DROP SEQUENCE BUILDINGS_ID_SEQ; |
| 17 | 14 |
| 18 DROP TABLE fixpoints; | 15 DROP TABLE fixpoints; |
| 22 DROP SEQUENCE FLOODPLAIN_ID_SEQ; | 19 DROP SEQUENCE FLOODPLAIN_ID_SEQ; |
| 23 | 20 |
| 24 DROP TABLE dem; | 21 DROP TABLE dem; |
| 25 DROP SEQUENCE DEM_ID_SEQ; | 22 DROP SEQUENCE DEM_ID_SEQ; |
| 26 | 23 |
| 27 DROP TABLE catchment; | 24 DROP TABLE hws_points; |
| 28 DROP SEQUENCE CATCHMENT_ID_SEQ; | 25 DROP SEQUENCE HWS_POINTS_ID_SEQ; |
| 29 | 26 |
| 30 DROP TABLE hws; | 27 DROP TABLE hws_lines; |
| 31 DROP SEQUENCE HWS_ID_SEQ; | 28 DROP SEQUENCE HWS_LINES_ID_SEQ; |
| 32 | 29 |
| 33 DROP TABLE floodmaps; | 30 DROP TABLE floodmaps; |
| 34 DROP SEQUENCE FLOODMAPS_ID_SEQ; | 31 DROP SEQUENCE FLOODMAPS_ID_SEQ; |
| 35 | 32 |
| 36 DROP TABLE hydr_boundaries; | 33 DROP TABLE hydr_boundaries; |
| 40 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; | 37 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; |
| 41 | 38 |
| 42 DROP TABLE gauge_location; | 39 DROP TABLE gauge_location; |
| 43 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; | 40 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; |
| 44 | 41 |
| 42 DROP TABLE fed_states; | |
| 43 DROP TABLE hws_kinds; | |
| 44 DROP TABLE sobek_kinds; | |
| 45 DROP TABLE sectie_kinds; | |
| 46 DROP TABLE boundary_kinds; | |
| 47 DROP TABLE axis_kinds; | |
| 48 | |
| 45 COMMIT; | 49 COMMIT; |