Mercurial > dive4elements > river
diff backend/doc/schema/oracle-drop-spatial.sql @ 6632:97145ec4e33c double-precision
Schema changes: fixed typos, syntax errors and missing or obsolete statements in Oracle schema
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 22 Jul 2013 18:06:23 +0200 |
| parents | 5aa05a7a34b7 |
| children | 765944ca6df0 |
line wrap: on
line diff
--- a/backend/doc/schema/oracle-drop-spatial.sql Mon Jul 22 16:57:56 2013 +0200 +++ b/backend/doc/schema/oracle-drop-spatial.sql Mon Jul 22 18:06:23 2013 +0200 @@ -32,11 +32,6 @@ DROP TABLE dem; DROP SEQUENCE DEM_ID_SEQ; -DROP TRIGGER catchment_trigger; -DROP TABLE catchment; -DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT'; -DROP SEQUENCE CATCHMENT_ID_SEQ; - DROP TRIGGER hws_lines_trigger; DROP TABLE hws_lines; DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_LINES'; @@ -85,4 +80,6 @@ DROP TABLE boundary_kinds; DROP TABLE cross_section_track_kinds; DROP TABLE floodplain_kinds; +DROP TABLE floodmap_kinds; DROP TABLE building_kinds; +DROP TABLE jetty_kinds;