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