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