Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial_idx.sql @ 5409:8b29a94ebdd8
SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 25 Mar 2013 17:51:33 +0100 |
| parents | 7b35f2c070c3 |
| children |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial_idx.sql Mon Mar 25 17:01:07 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial_idx.sql Mon Mar 25 17:51:33 2013 +0100 @@ -22,3 +22,4 @@ CREATE INDEX jetties_idx ON jetties(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT'); +CREATE INDEX flood_marks_idx ON flood_marks(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=POINT');