Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5182:8aac391871f9
SCHEME CHANGE: Hydr.Boundaries are now three dimensional multilinestrings
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Thu, 07 Mar 2013 10:53:44 +0100 |
| parents | a9658d43b621 |
| children | 908848b74d7e |
comparison
equal
deleted
inserted
replaced
| 5181:9d36ddf7dbd3 | 5182:8aac391871f9 |
|---|---|
| 253 kind int REFERENCES boundary_kinds(id), | 253 kind int REFERENCES boundary_kinds(id), |
| 254 sectie int REFERENCES sectie_kinds(id), | 254 sectie int REFERENCES sectie_kinds(id), |
| 255 sobek int REFERENCES sobek_kinds(id), | 255 sobek int REFERENCES sobek_kinds(id), |
| 256 path VARCHAR(256) | 256 path VARCHAR(256) |
| 257 ); | 257 ); |
| 258 SELECT AddGeometryColumn('hydr_boundaries','geom',31467,'LINESTRING',3); | 258 SELECT AddGeometryColumn('hydr_boundaries','geom',31467,'MULTILINESTRING',3); |
| 259 ALTER TABLE hydr_boundaries ALTER COLUMN id SET DEFAULT NEXTVAL('HYDR_BOUNDARIES_ID_SEQ'); | 259 ALTER TABLE hydr_boundaries ALTER COLUMN id SET DEFAULT NEXTVAL('HYDR_BOUNDARIES_ID_SEQ'); |
| 260 | 260 |
| 261 | 261 |
| 262 CREATE SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; | 262 CREATE SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ; |
| 263 CREATE TABLE hydr_boundaries_poly ( | 263 CREATE TABLE hydr_boundaries_poly ( |