Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-drop-spatial.sql @ 2854:89b097c8ebd7
Added an SQL file to drop the spatial schema.
flys-backend/trunk@4314 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Fri, 27 Apr 2012 06:43:04 +0000 |
| parents | |
| children | b0132e1b9719 |
comparison
equal
deleted
inserted
replaced
| 2853:bd9e76e0b55d | 2854:89b097c8ebd7 |
|---|---|
| 1 DROP TABLE river_axes; | |
| 2 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES'; | |
| 3 DROP TRIGGER river_axes_trigger; | |
| 4 DROP SEQUENCE RIVER_AXES_ID_SEQ; | |
| 5 | |
| 6 DROP TABLE river_axes_km; | |
| 7 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES_KM'; | |
| 8 DROP TRIGGER river_axes_km_trigger; | |
| 9 DROP SEQUENCE RIVER_AXES_KM_ID_SEQ; | |
| 10 | |
| 11 DROP TABLE cross_section_tracks; | |
| 12 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CROSS_SECTION_TRACKS'; | |
| 13 DROP TRIGGER cross_section_tracks_trigger; | |
| 14 DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; | |
| 15 | |
| 16 DROP TABLE lines; | |
| 17 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'LINES'; | |
| 18 DROP TRIGGER lines_trigger; | |
| 19 DROP SEQUENCE LINES_ID_SEQ; | |
| 20 | |
| 21 DROP TABLE buildings; | |
| 22 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS'; | |
| 23 DROP TRIGGER buildings_trigger; | |
| 24 DROP SEQUENCE BUILDINGS_ID_SEQ; | |
| 25 | |
| 26 DROP TABLE fixpoints; | |
| 27 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS'; | |
| 28 DROP TRIGGER fixpoints_trigger; | |
| 29 DROP SEQUENCE FIXPOINTS_ID_SEQ; | |
| 30 | |
| 31 DROP TABLE floodplain; | |
| 32 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN'; | |
| 33 DROP TRIGGER floodplain_trigger; | |
| 34 DROP SEQUENCE FLOODPLAIN_ID_SEQ; | |
| 35 | |
| 36 DROP TABLE dem; | |
| 37 DROP TRIGGER dem_trigger; | |
| 38 DROP SEQUENCE DEM_ID_SEQ; | |
| 39 | |
| 40 DROP TABLE catchment; | |
| 41 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT'; | |
| 42 DROP TRIGGER catchment_trigger; | |
| 43 DROP SEQUENCE CATCHMENT_ID_SEQ; | |
| 44 | |
| 45 DROP TABLE hws; | |
| 46 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS'; | |
| 47 DROP TRIGGER hws_trigger; | |
| 48 DROP SEQUENCE HWS_ID_SEQ; | |
| 49 | |
| 50 DROP TABLE floodmaps; | |
| 51 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS'; | |
| 52 DROP TRIGGER floodmaps_trigger; | |
| 53 DROP SEQUENCE FLOODMAPS_ID_SEQ; |