Mercurial > dive4elements > river
changeset 4953:a72e90fc45ed dami
SCHEMA CHANGE: extended hydr_boundaries tables
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Fri, 01 Feb 2013 10:41:12 +0100 |
parents | 5a0225ddae2b |
children | 1a218a0bcfcf |
files | flys-backend/doc/schema/postgresql-spatial.sql |
diffstat | 1 files changed, 6 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql Fri Feb 01 10:38:26 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Fri Feb 01 10:41:12 2013 +0100 @@ -241,13 +241,14 @@ ALTER TABLE floodmaps ADD CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) = 'POLYGON'::text OR geometrytype(geom) = 'MULTIPOLYGON'::text); ALTER TABLE floodmaps ALTER COLUMN id SET DEFAULT NEXTVAL('FLOODMAPS_ID_SEQ'); - CREATE SEQUENCE HYDR_BOUNDARIES_ID_SEQ; CREATE TABLE hydr_boundaries ( id int PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id), name VARCHAR(255), - kind int, + kind int, -- 1 BfG / 2 Land / 3 Sonstige + sectie int, -- 1 stromführend / 2 stromspeichernd + sobek int, -- 1 Flussschlauch / 2 Uferbank / 3 Überflutungsbereich path VARCHAR(256) ); SELECT AddGeometryColumn('hydr_boundaries','geom',31467,'LINESTRING',3); @@ -259,7 +260,9 @@ id int PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id), name VARCHAR(255), - kind int, + kind int, -- 1 BfG / 2 Land / 3 Sonstige + sectie int, -- 1 Flussschlauch / 2 Uferbank / 3 Überflutungsbereich + sobek int, -- 1 stromführend / 2 stromspeichernd path VARCHAR(256) ); SELECT AddGeometryColumn('hydr_boundaries_poly','geom',31467,'POLYGON',3);