# HG changeset patch # User Tom Gottfried # Date 1363271570 -3600 # Node ID 08b3109c637b2d24082dcf5d1d032be92125ffb4 # Parent 71a24278322c606a1f7dc7bcaf87b2d5b78645e4 fixed spatial schema for hydraulic boundaries diff -r 71a24278322c -r 08b3109c637b flys-backend/doc/schema/postgresql-spatial.sql --- 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');