Mercurial > dive4elements > river
changeset 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 | acb8d08f59a2 |
| children | bd9e76e0b55d |
| files | flys-backend/ChangeLog flys-backend/doc/schema/oracle-spatial.sql |
| diffstat | 2 files changed, 5 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- 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 <ingo@intevation.de> + + * doc/schema/oracle-spatial.sql: Repaired broken schema. + 2012-04-26 Ingo Weinzierl <ingo@intevation.de> * src/main/java/de/intevation/flys/importer/Config.java: Added a config
--- 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'); -/