Mercurial > dive4elements > river
changeset 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 | bd9e76e0b55d |
| children | 9c2424073be0 |
| files | flys-backend/ChangeLog flys-backend/doc/schema/oracle-drop-spatial.sql |
| diffstat | 2 files changed, 58 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/ChangeLog Fri Apr 27 06:39:12 2012 +0000 +++ b/flys-backend/ChangeLog Fri Apr 27 06:43:04 2012 +0000 @@ -1,3 +1,8 @@ +2012-04-27 Ingo Weinzierl <ingo@intevation.de> + + * doc/schema/oracle-drop-spatial.sql: New statements to drop the whole + spatial schema. + 2012-04-27 Ingo Weinzierl <ingo@intevation.de> * contrib/shpimporter/lines.py,
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/flys-backend/doc/schema/oracle-drop-spatial.sql Fri Apr 27 06:43:04 2012 +0000 @@ -0,0 +1,53 @@ +DROP TABLE river_axes; +DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES'; +DROP TRIGGER river_axes_trigger; +DROP SEQUENCE RIVER_AXES_ID_SEQ; + +DROP TABLE river_axes_km; +DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES_KM'; +DROP TRIGGER river_axes_km_trigger; +DROP SEQUENCE RIVER_AXES_KM_ID_SEQ; + +DROP TABLE cross_section_tracks; +DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CROSS_SECTION_TRACKS'; +DROP TRIGGER cross_section_tracks_trigger; +DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; + +DROP TABLE lines; +DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'LINES'; +DROP TRIGGER lines_trigger; +DROP SEQUENCE LINES_ID_SEQ; + +DROP TABLE buildings; +DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS'; +DROP TRIGGER buildings_trigger; +DROP SEQUENCE BUILDINGS_ID_SEQ; + +DROP TABLE fixpoints; +DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS'; +DROP TRIGGER fixpoints_trigger; +DROP SEQUENCE FIXPOINTS_ID_SEQ; + +DROP TABLE floodplain; +DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN'; +DROP TRIGGER floodplain_trigger; +DROP SEQUENCE FLOODPLAIN_ID_SEQ; + +DROP TABLE dem; +DROP TRIGGER dem_trigger; +DROP SEQUENCE DEM_ID_SEQ; + +DROP TABLE catchment; +DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT'; +DROP TRIGGER catchment_trigger; +DROP SEQUENCE CATCHMENT_ID_SEQ; + +DROP TABLE hws; +DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS'; +DROP TRIGGER hws_trigger; +DROP SEQUENCE HWS_ID_SEQ; + +DROP TABLE floodmaps; +DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS'; +DROP TRIGGER floodmaps_trigger; +DROP SEQUENCE FLOODMAPS_ID_SEQ;