Mercurial > dive4elements > river
changeset 5303:08b3109c637b
fixed spatial schema for hydraulic boundaries
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 14 Mar 2013 15:32:50 +0100 |
| parents | 71a24278322c |
| children | ffa5eaad3a7b |
| files | flys-backend/doc/schema/postgresql-spatial.sql |
| diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql Thu Mar 14 15:31:29 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Thu Mar 14 15:32:50 2013 +0100 @@ -286,7 +286,7 @@ sobek int REFERENCES sobek_kinds(id), path VARCHAR(256) ); -SELECT AddGeometryColumn('hydr_boundaries_poly','geom',31467,'POLYGON',3); +SELECT AddGeometryColumn('hydr_boundaries_poly','geom',31467,'MULTIPOLYGON',3); ALTER TABLE hydr_boundaries_poly ALTER COLUMN id SET DEFAULT NEXTVAL('HYDR_BOUNDARIES_POLY_ID_SEQ');