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
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');
 
 

http://dive4elements.wald.intevation.org