Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-spatial.sql @ 5182:8aac391871f9
SCHEME CHANGE: Hydr.Boundaries are now three dimensional multilinestrings
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Thu, 07 Mar 2013 10:53:44 +0100 |
| parents | a9658d43b621 |
| children | 908848b74d7e |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql Thu Mar 07 10:44:27 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Thu Mar 07 10:53:44 2013 +0100 @@ -255,7 +255,7 @@ sobek int REFERENCES sobek_kinds(id), path VARCHAR(256) ); -SELECT AddGeometryColumn('hydr_boundaries','geom',31467,'LINESTRING',3); +SELECT AddGeometryColumn('hydr_boundaries','geom',31467,'MULTILINESTRING',3); ALTER TABLE hydr_boundaries ALTER COLUMN id SET DEFAULT NEXTVAL('HYDR_BOUNDARIES_ID_SEQ');