Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial.sql @ 5623:0aaed46a88be
Schema change: Allow longer strings in fixpoints.hpgp
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 09 Apr 2013 19:07:20 +0200 |
| parents | 5f91881124ba |
| children | b5553164fabf |
comparison
equal
deleted
inserted
replaced
| 5622:b28a6d05e969 | 5623:0aaed46a88be |
|---|---|
| 115 GEOM MDSYS.SDO_GEOMETRY, | 115 GEOM MDSYS.SDO_GEOMETRY, |
| 116 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, | 116 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, |
| 117 x NUMBER(38,11), | 117 x NUMBER(38,11), |
| 118 y NUMBER(38,11), | 118 y NUMBER(38,11), |
| 119 km NUMBER(38,11) NOT NULL, | 119 km NUMBER(38,11) NOT NULL, |
| 120 HPGP VARCHAR2(255), | 120 HPGP VARCHAR(64), |
| 121 name VARCHAR(64), | 121 name VARCHAR(64), |
| 122 path VARCHAR(256), | 122 path VARCHAR(256), |
| 123 ID NUMBER PRIMARY KEY NOT NULL | 123 ID NUMBER PRIMARY KEY NOT NULL |
| 124 ); | 124 ); |
| 125 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('fixpoints', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',3282450,3912240,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5248260,6100130,0.001)), 31467); | 125 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('fixpoints', 'GEOM', MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',3282450,3912240,0.001),MDSYS.SDO_DIM_ELEMENT('Y',5248260,6100130,0.001)), 31467); |