Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial_idx.sql @ 5028:a5f438895a38 dami
SCHEMA CHANGE: removed catchements from schema and geo-importer (obsolete)
author | Tom Gottfried <tom.gottfried@intevation.de> |
---|---|
date | Tue, 19 Feb 2013 19:24:36 +0100 |
parents | eecd1ebba128 |
children | 57a845da72bd |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial_idx.sql Tue Feb 19 14:59:44 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial_idx.sql Tue Feb 19 19:24:36 2013 +0100 @@ -1,4 +1,3 @@ -CREATE INDEX catchment_spatial_idx ON catchment(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=multipolygon'); CREATE INDEX river_axes_km_spatial_idx ON river_axes_km(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=point'); CREATE INDEX buildings_spatial_idx ON buildings(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=LINE'); CREATE INDEX fixpoints_spatial_idx ON fixpoints(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');