# HG changeset patch
# User Bjoern Schilberg <bjoern@intevation.de>
# Date 1319459585 0
# Node ID b8e01307c138e75c1c631133a04da5eb175a5d0b
# Parent  cf8dcfaeb756577cc32b3ffee55560ec42897331
Adjusted geometry type for floodplain and hws in AddGeometryColumn.


flys-backend/trunk@3062 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r cf8dcfaeb756 -r b8e01307c138 flys-backend/ChangeLog
--- 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:
diff -r cf8dcfaeb756 -r b8e01307c138 flys-backend/doc/schema/postgresql-spatial.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');