Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-spatial.sql @ 2356:b8e01307c138
Adjusted geometry type for floodplain and hws in AddGeometryColumn.
flys-backend/trunk@3062 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Bjoern Schilberg <bjoern@intevation.de> |
|---|---|
| date | Mon, 24 Oct 2011 12:33:05 +0000 |
| parents | c4f090a00178 |
| children | a8f408fdf58c |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql Wed Oct 19 09:46:19 2011 +0000 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Mon Oct 24 12:33:05 2011 +0000 @@ -81,7 +81,7 @@ id int PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id) ); -SELECT AddGeometryColumn('floodplain', 'geom', 31466, 'MULTIPOLYGON', 2); +SELECT AddGeometryColumn('floodplain', 'geom', 31466, 'POLYGON', 2); ALTER TABLE floodplain ALTER COLUMN id SET DEFAULT NEXTVAL('FLOODPLAIN_ID_SEQ'); @@ -120,7 +120,7 @@ hws_facility VARCHAR(256), typ VARCHAR(256) ); -SELECT AddGeometryColumn('hws','geom',31466,'MULTILINESTRING',2); +SELECT AddGeometryColumn('hws','geom',31466,'LINESTRING',2); ALTER TABLE hw ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_ID_SEQ');