Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial.sql @ 2365:60532f75396b
Adapted 'lines' relation and made lines queryable for a given river.
flys-backend/trunk@3219 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 10 Nov 2011 13:35:31 +0000 |
| parents | c4f090a00178 |
| children | a3c02addd1fa |
comparison
equal
deleted
inserted
replaced
| 2364:efe19e669092 | 2365:60532f75396b |
|---|---|
| 58 CREATE SEQUENCE LINES_ID_SEQ; | 58 CREATE SEQUENCE LINES_ID_SEQ; |
| 59 CREATE TABLE lines ( | 59 CREATE TABLE lines ( |
| 60 OGR_FID NUMBER(38), | 60 OGR_FID NUMBER(38), |
| 61 GEOM MDSYS.SDO_GEOMETRY, | 61 GEOM MDSYS.SDO_GEOMETRY, |
| 62 river_id NUMBER(38), | 62 river_id NUMBER(38), |
| 63 kind NUMBER(38) DEFAULT 0 NOT NULL, | 63 kind VARCHAR2(16) NOT NULL, |
| 64 z NUMBER(38,12) DEFAULT 0, | 64 z NUMBER(38,12) DEFAULT 0, |
| 65 ID NUMBER PRIMARY KEY NOT NULL | 65 ID NUMBER PRIMARY KEY NOT NULL |
| 66 ); | 66 ); |
| 67 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('lines', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',2457864.326387,2634771.191263,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5297459.306295,5586961.449130,0.001),MDSYS.SDO_DIM_ELEMENT('Z',-100000,100000,0.002)), 31466); | 67 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('lines', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',2457864.326387,2634771.191263,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5297459.306295,5586961.449130,0.001),MDSYS.SDO_DIM_ELEMENT('Z',-100000,100000,0.002)), 31466); |
| 68 CREATE OR REPLACE TRIGGER lines_trigger BEFORE INSERT ON lines FOR each ROW | 68 CREATE OR REPLACE TRIGGER lines_trigger BEFORE INSERT ON lines FOR each ROW |