Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 2851:acb8d08f59a2 | 2852:875a87b8489f |
|---|---|
| 209 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('floodmaps', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',3282450,3912240,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5248260,6100130,0.001),MDSYS.SDO_DIM_ELEMENT('Z',-100000,100000,0.002)), 31467); | 209 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('floodmaps', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',3282450,3912240,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5248260,6100130,0.001),MDSYS.SDO_DIM_ELEMENT('Z',-100000,100000,0.002)), 31467); |
| 210 CREATE OR REPLACE TRIGGER floodmaps_trigger BEFORE INSERT ON floodmaps FOR each ROW | 210 CREATE OR REPLACE TRIGGER floodmaps_trigger BEFORE INSERT ON floodmaps FOR each ROW |
| 211 BEGIN | 211 BEGIN |
| 212 SELECT FLOODMAPS_ID_SEQ.nextval INTO :new.id FROM dual; | 212 SELECT FLOODMAPS_ID_SEQ.nextval INTO :new.id FROM dual; |
| 213 END; | 213 END; |
| 214 / | |
| 214 CREATE INDEX floodmaps_spatial_idx ON floodmaps(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON'); | 215 CREATE INDEX floodmaps_spatial_idx ON floodmaps(GEOM) indextype IS MDSYS.SPATIAL_INDEX parameters ('LAYER_GTYPE=MULTIPOLYGON'); |
| 215 / |