Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-drop-spatial.sql @ 8466:cc53aae06303
Gauge locations are obsolete since a long time.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 05 Nov 2014 13:04:53 +0100 |
| parents | 765944ca6df0 |
| children |
comparison
equal
deleted
inserted
replaced
| 8465:2772a0fc7400 | 8466:cc53aae06303 |
|---|---|
| 55 DROP TRIGGER hydr_boundaries_poly_trigger; | 55 DROP TRIGGER hydr_boundaries_poly_trigger; |
| 56 DROP TABLE hydr_boundaries_poly PURGE; | 56 DROP TABLE hydr_boundaries_poly PURGE; |
| 57 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES_POLY'; | 57 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES_POLY'; |
| 58 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; | 58 DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; |
| 59 | 59 |
| 60 DROP TRIGGER gauge_location_trigger; | |
| 61 DROP TABLE gauge_location PURGE; | |
| 62 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'GAUGE_LOCATION'; | |
| 63 DROP SEQUENCE GAUGE_LOCATION_ID_SEQ; | |
| 64 | |
| 65 DROP TRIGGER jetties_trigger; | 60 DROP TRIGGER jetties_trigger; |
| 66 DROP TABLE jetties PURGE; | 61 DROP TABLE jetties PURGE; |
| 67 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'JETTIES'; | 62 DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'JETTIES'; |
| 68 DROP SEQUENCE JETTIES_ID_SEQ; | 63 DROP SEQUENCE JETTIES_ID_SEQ; |
| 69 | 64 |