Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-spatial.sql @ 5854:249b8766a178
Schema change: new column 'waterbody' for floodmaps and importer
author | Tom Gottfried <tom.gottfried@intevation.de> |
---|---|
date | Fri, 26 Apr 2013 16:50:14 +0200 |
parents | 5aa05a7a34b7 |
children | 6a63456b99d9 |
comparison
equal
deleted
inserted
replaced
5853:774d25915eb1 | 5854:249b8766a178 |
---|---|
317 kind NUMBER NOT NULL REFERENCES floodmap_kinds(id), | 317 kind NUMBER NOT NULL REFERENCES floodmap_kinds(id), |
318 diff NUMBER(19,5), | 318 diff NUMBER(19,5), |
319 count NUMBER(38), | 319 count NUMBER(38), |
320 area NUMBER(19,5), | 320 area NUMBER(19,5), |
321 perimeter NUMBER(19,5), | 321 perimeter NUMBER(19,5), |
322 waterbody VARCHAR(64), | |
322 path VARCHAR(256), | 323 path VARCHAR(256), |
323 source varchar(64), | 324 source varchar(64), |
324 id NUMBER PRIMARY KEY NOT NULL | 325 id NUMBER PRIMARY KEY NOT NULL |
325 ); | 326 ); |
326 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('floodmaps', '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); | 327 INSERT INTO USER_SDO_GEOM_METADATA VALUES ('floodmaps', '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); |