Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-spatial.sql @ 5886:6a63456b99d9
Schema change, importer, i18n: additional field for federal state stations
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Tue, 30 Apr 2013 19:27:15 +0200 |
| parents | 249b8766a178 |
| children | 97145ec4e33c |
comparison
equal
deleted
inserted
replaced
| 5885:09d9c14145a3 | 5886:6a63456b99d9 |
|---|---|
| 33 CREATE TABLE river_axes_km( | 33 CREATE TABLE river_axes_km( |
| 34 OGR_FID NUMBER(38), | 34 OGR_FID NUMBER(38), |
| 35 GEOM MDSYS.SDO_GEOMETRY, | 35 GEOM MDSYS.SDO_GEOMETRY, |
| 36 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, | 36 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, |
| 37 km NUMBER(7,3) NOT NULL, | 37 km NUMBER(7,3) NOT NULL, |
| 38 fedstate_km NUMBER(7,3), | |
| 38 name VARCHAR(64), | 39 name VARCHAR(64), |
| 39 path VARCHAR(256), | 40 path VARCHAR(256), |
| 40 ID NUMBER PRIMARY KEY NOT NULL | 41 ID NUMBER PRIMARY KEY NOT NULL |
| 41 ); | 42 ); |
| 42 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('river_axes_km', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',3282450,3912240,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5248260,6100130,0.001)), 31467); | 43 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('river_axes_km', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',3282450,3912240,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5248260,6100130,0.001)), 31467); |