Mercurial > dive4elements > river
changeset 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 (2011-10-24) |
parents | cf8dcfaeb756 |
children | 2e18e12fac11 |
files | flys-backend/ChangeLog flys-backend/doc/schema/postgresql-spatial.sql |
diffstat | 2 files changed, 7 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/ChangeLog Wed Oct 19 09:46:19 2011 +0000 +++ b/flys-backend/ChangeLog Mon Oct 24 12:33:05 2011 +0000 @@ -1,3 +1,8 @@ +2011-10-24 Bjoern Schilberg <bjoern.schilberg@intevation.de> + + * doc/schema/postgresql-spatial.sql: + Adjusted geometry type for floodplain and hws in AddGeometryColumn. + 2011-10-19 Bjoern Schilberg <bjoern.schilberg@intevation.de> * doc/schema/oracle.sql:
--- 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');