comparison flys-backend/doc/schema/oracle-spatial.sql @ 5391:e65fee5ea98a

Rename station to km to be in line with the rest
author Andre Heinecke <aheinecke@intevation.de>
date Mon, 25 Mar 2013 10:12:42 +0100
parents 2da74705c29d
children 91f5908c472a
comparison
equal deleted inserted replaced
5390:d449b502602b 5391:e65fee5ea98a
91 CREATE TABLE buildings( 91 CREATE TABLE buildings(
92 OGR_FID NUMBER(38), 92 OGR_FID NUMBER(38),
93 GEOM MDSYS.SDO_GEOMETRY, 93 GEOM MDSYS.SDO_GEOMETRY,
94 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, 94 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE,
95 kind_id NUMBER(38) REFERENCES building_kinds(id) NOT NULL DEFAULT 0, 95 kind_id NUMBER(38) REFERENCES building_kinds(id) NOT NULL DEFAULT 0,
96 station NUMBER(38,11) NOT NULL, 96 km NUMBER(38,11) NOT NULL,
97 name VARCHAR2(255), -- The layername 97 name VARCHAR2(255), -- The layername
98 description VARCHAR(256), -- Name taken from attributes 98 description VARCHAR(256), -- Name taken from attributes
99 path VARCHAR(256), 99 path VARCHAR(256),
100 ID NUMBER PRIMARY KEY NOT NULL 100 ID NUMBER PRIMARY KEY NOT NULL
101 ); 101 );

http://dive4elements.wald.intevation.org