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; |