Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 5408:91f5908c472a | 5409:8b29a94ebdd8 |
|---|---|
| 65 DROP TRIGGER gauge_location_trigger; | 65 DROP TRIGGER gauge_location_trigger; |
| 66 DROP TABLE gauge_location; | 66 DROP TABLE gauge_location; |
| 67 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'GAUGE_LOCATION'; | 67 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'GAUGE_LOCATION'; |
| 68 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; | 68 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; |
| 69 | 69 |
| 70 DROP TRIGGER jetties_trigger; | |
| 71 DROP TABLE jetties; | |
| 72 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'JETTIES'; | |
| 73 DROP SEQUENCE JETTIES_ID_SEQ; | |
| 74 | |
| 75 DROP TRIGGER flood_marks_trigger; | |
| 76 DROP TABLE flood_marks; | |
| 77 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOOD_MARKS'; | |
| 78 DROP SEQUENCE FLOOD_MARKS_ID_SEQ; | |
| 79 | |
| 70 DROP TABLE hws_kinds; | 80 DROP TABLE hws_kinds; |
| 71 DROP TABLE sectie_kinds; | 81 DROP TABLE sectie_kinds; |
| 72 DROP TABLE sobek_kinds; | 82 DROP TABLE sobek_kinds; |
| 73 DROP TABLE fed_states; | 83 DROP TABLE fed_states; |
| 74 DROP TABLE axis_kinds; | 84 DROP TABLE axis_kinds; |