Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-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 | 8b29a94ebdd8 |
line wrap: on
line diff
--- 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) );