Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial.sql @ 2852:875a87b8489f
Repaired broken oracle spatial schema.
flys-backend/trunk@4310 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 26 Apr 2012 13:01:02 +0000 |
| parents | cdc084071c14 |
| children | b0132e1b9719 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Thu Apr 26 09:48:49 2012 +0000 +++ b/flys-backend/doc/schema/oracle-spatial.sql Thu Apr 26 13:01:02 2012 +0000 @@ -211,5 +211,5 @@ BEGIN SELECT FLOODMAPS_ID_SEQ.nextval INTO :new.id FROM dual; END; +/ CREATE INDEX floodmaps_spatial_idx ON floodmaps(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON'); -/