Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-spatial.sql @ 5303:08b3109c637b
fixed spatial schema for hydraulic boundaries
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 14 Mar 2013 15:32:50 +0100 |
| parents | 3dc4c2798212 |
| children | aa407dfb9949 |
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');