Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-drop-spatial.sql @ 5409:8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 25 Mar 2013 17:51:33 +0100 |
| parents | 91f5908c472a |
| children |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop-spatial.sql Mon Mar 25 17:01:07 2013 +0100 +++ b/flys-backend/doc/schema/oracle-drop-spatial.sql Mon Mar 25 17:51:33 2013 +0100 @@ -67,6 +67,16 @@ DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'GAUGE_LOCATION'; DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; +DROP TRIGGER jetties_trigger; +DROP TABLE jetties; +DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'JETTIES'; +DROP SEQUENCE JETTIES_ID_SEQ; + +DROP TRIGGER flood_marks_trigger; +DROP TABLE flood_marks; +DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOOD_MARKS'; +DROP SEQUENCE FLOOD_MARKS_ID_SEQ; + DROP TABLE hws_kinds; DROP TABLE sectie_kinds; DROP TABLE sobek_kinds;