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); |