Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-drop-spatial.sql @ 5540:25c2505df28f
Merged
| author | Christian Lins <christian.lins@intevation.de> |
|---|---|
| date | Wed, 03 Apr 2013 16:00:21 +0200 |
| parents | 8b29a94ebdd8 |
| children |
comparison
equal
deleted
inserted
replaced
| 5539:8d0af912351c | 5540:25c2505df28f |
|---|---|
| 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; |
| 75 DROP TABLE boundary_kinds; | 85 DROP TABLE boundary_kinds; |
| 76 DROP TABLE cross_section_track_kinds; | 86 DROP TABLE cross_section_track_kinds; |
| 77 DROP TABLE floodplain_kinds; | 87 DROP TABLE floodplain_kinds; |
| 88 DROP TABLE building_kinds; |