# HG changeset patch # User Andre Heinecke # Date 1364202762 -3600 # Node ID e65fee5ea98a1401a2a6d03bcd3f0ef9ac14dddf # Parent d449b502602bcaa5b709d16f4955af45e0632324 Rename station to km to be in line with the rest diff -r d449b502602b -r e65fee5ea98a flys-backend/doc/schema/oracle-spatial.sql --- a/flys-backend/doc/schema/oracle-spatial.sql Mon Mar 25 10:16:34 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial.sql Mon Mar 25 10:12:42 2013 +0100 @@ -93,7 +93,7 @@ GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, kind_id NUMBER(38) REFERENCES building_kinds(id) NOT NULL DEFAULT 0, - station NUMBER(38,11) NOT NULL, + km NUMBER(38,11) NOT NULL, name VARCHAR2(255), -- The layername description VARCHAR(256), -- Name taken from attributes path VARCHAR(256), diff -r d449b502602b -r e65fee5ea98a flys-backend/doc/schema/postgresql-spatial.sql --- a/flys-backend/doc/schema/postgresql-spatial.sql Mon Mar 25 10:16:34 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Mon Mar 25 10:12:42 2013 +0100 @@ -70,9 +70,9 @@ CREATE TABLE buildings ( id int PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id) ON DELETE CASCADE, - description VARCHAR(256) -- Name taken from attributes, + description VARCHAR(256), -- Name taken from attributes, name VARCHAR(256), -- The layername - station FLOAT8, + km FLOAT8, kind_id int REFERENCES building_kinds(id) NOT NULL DEFAULT 0, path VARCHAR(256) );