Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial.sql @ 5354:555a99dff849
Jetties are two dimensional
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Wed, 20 Mar 2013 17:58:45 +0100 |
| parents | aa407dfb9949 |
| children | 59f9760e8b7f |
comparison
equal
deleted
inserted
replaced
| 5353:d086ce6c13d3 | 5354:555a99dff849 |
|---|---|
| 392 path VARCHAR(256), | 392 path VARCHAR(256), |
| 393 kind_id NUMBER(38) REFERENCES jetty_kinds(id), | 393 kind_id NUMBER(38) REFERENCES jetty_kinds(id), |
| 394 km NUMBER(7,3), | 394 km NUMBER(7,3), |
| 395 z NUMBER(38,12) | 395 z NUMBER(38,12) |
| 396 ); | 396 ); |
| 397 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('jetties', '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); | 397 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('jetties', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',3282450,3912240,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5248260,6100130,0.001)), 31467); |
| 398 CREATE OR REPLACE TRIGGER jetties_trigger BEFORE INSERT ON jetties FOR EACH ROW | 398 CREATE OR REPLACE TRIGGER jetties_trigger BEFORE INSERT ON jetties FOR EACH ROW |
| 399 BEGIN | 399 BEGIN |
| 400 SELECT JETTIES_ID_SEQ.nextval INTO :new.id FROM dual; | 400 SELECT JETTIES_ID_SEQ.nextval INTO :new.id FROM dual; |
| 401 END; | 401 END; |
| 402 / | 402 / |