# HG changeset patch # User Ingo Weinzierl # Date 1335445262 0 # Node ID 875a87b8489f21c29d130e5d9524d7de00678a5e # Parent acb8d08f59a26862b3bfaa3c80907f3dcb96e546 Repaired broken oracle spatial schema. flys-backend/trunk@4310 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r acb8d08f59a2 -r 875a87b8489f flys-backend/ChangeLog --- a/flys-backend/ChangeLog Thu Apr 26 09:48:49 2012 +0000 +++ b/flys-backend/ChangeLog Thu Apr 26 13:01:02 2012 +0000 @@ -1,3 +1,7 @@ +2012-04-26 Ingo Weinzierl + + * doc/schema/oracle-spatial.sql: Repaired broken schema. + 2012-04-26 Ingo Weinzierl * src/main/java/de/intevation/flys/importer/Config.java: Added a config diff -r acb8d08f59a2 -r 875a87b8489f flys-backend/doc/schema/oracle-spatial.sql --- 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'); -/