Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
6631:9aa1c946b87d | 6632:97145ec4e33c |
---|---|
29 DROP SEQUENCE FLOODPLAIN_ID_SEQ; | 29 DROP SEQUENCE FLOODPLAIN_ID_SEQ; |
30 | 30 |
31 DROP TRIGGER dem_trigger; | 31 DROP TRIGGER dem_trigger; |
32 DROP TABLE dem; | 32 DROP TABLE dem; |
33 DROP SEQUENCE DEM_ID_SEQ; | 33 DROP SEQUENCE DEM_ID_SEQ; |
34 | |
35 DROP TRIGGER catchment_trigger; | |
36 DROP TABLE catchment; | |
37 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT'; | |
38 DROP SEQUENCE CATCHMENT_ID_SEQ; | |
39 | 34 |
40 DROP TRIGGER hws_lines_trigger; | 35 DROP TRIGGER hws_lines_trigger; |
41 DROP TABLE hws_lines; | 36 DROP TABLE hws_lines; |
42 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_LINES'; | 37 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_LINES'; |
43 DROP SEQUENCE HWS_LINES_ID_SEQ; | 38 DROP SEQUENCE HWS_LINES_ID_SEQ; |
83 DROP TABLE fed_states; | 78 DROP TABLE fed_states; |
84 DROP TABLE axis_kinds; | 79 DROP TABLE axis_kinds; |
85 DROP TABLE boundary_kinds; | 80 DROP TABLE boundary_kinds; |
86 DROP TABLE cross_section_track_kinds; | 81 DROP TABLE cross_section_track_kinds; |
87 DROP TABLE floodplain_kinds; | 82 DROP TABLE floodplain_kinds; |
83 DROP TABLE floodmap_kinds; | |
88 DROP TABLE building_kinds; | 84 DROP TABLE building_kinds; |
85 DROP TABLE jetty_kinds; |