Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 2355:cf8dcfaeb756 | 2356:b8e01307c138 |
|---|---|
| 79 CREATE SEQUENCE FLOODPLAIN_ID_SEQ; | 79 CREATE SEQUENCE FLOODPLAIN_ID_SEQ; |
| 80 CREATE TABLE floodplain ( | 80 CREATE TABLE floodplain ( |
| 81 id int PRIMARY KEY NOT NULL, | 81 id int PRIMARY KEY NOT NULL, |
| 82 river_id int REFERENCES rivers(id) | 82 river_id int REFERENCES rivers(id) |
| 83 ); | 83 ); |
| 84 SELECT AddGeometryColumn('floodplain', 'geom', 31466, 'MULTIPOLYGON', 2); | 84 SELECT AddGeometryColumn('floodplain', 'geom', 31466, 'POLYGON', 2); |
| 85 ALTER TABLE floodplain ALTER COLUMN id SET DEFAULT NEXTVAL('FLOODPLAIN_ID_SEQ'); | 85 ALTER TABLE floodplain ALTER COLUMN id SET DEFAULT NEXTVAL('FLOODPLAIN_ID_SEQ'); |
| 86 | 86 |
| 87 | 87 |
| 88 -- Geodaesie/Hoehenmodelle/* | 88 -- Geodaesie/Hoehenmodelle/* |
| 89 CREATE SEQUENCE DEM_ID_SEQ; | 89 CREATE SEQUENCE DEM_ID_SEQ; |
| 118 oid int, | 118 oid int, |
| 119 river_id int REFERENCES rivers(id), | 119 river_id int REFERENCES rivers(id), |
| 120 hws_facility VARCHAR(256), | 120 hws_facility VARCHAR(256), |
| 121 typ VARCHAR(256) | 121 typ VARCHAR(256) |
| 122 ); | 122 ); |
| 123 SELECT AddGeometryColumn('hws','geom',31466,'MULTILINESTRING',2); | 123 SELECT AddGeometryColumn('hws','geom',31466,'LINESTRING',2); |
| 124 ALTER TABLE hw ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_ID_SEQ'); | 124 ALTER TABLE hw ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_ID_SEQ'); |
| 125 | 125 |
| 126 | 126 |
| 127 END; | 127 END; |