Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-spatial.sql @ 3951:89ada0b9083f
Modified the schema for DGMs; added converter for CSV to SQL for DGM information.
flys-backend/trunk@5604 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 27 Sep 2012 07:24:07 +0000 |
| parents | 82e931f88137 |
| children | f5912365619c |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql Mon Sep 24 10:02:36 2012 +0000 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Thu Sep 27 07:24:07 2012 +0000 @@ -104,10 +104,18 @@ id int PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id), -- XXX Should we use the ranges table instead? - lower NUMERIC, - upper NUMERIC, - path VARCHAR(256), - UNIQUE (river_id, lower, upper) + name VARCHAR(64), + lower NUMERIC, + upper NUMERIC, + year_from int, + year_to int, + projection VARCHAR(32), + elevation_state VARCHAR(32), + format VARCHAR(32), + border_break BOOLEAN NOT NULL DEFAULT FALSE, + resolution VARCHAR(16), + description VARCHAR(256), + path VARCHAR(256) ); ALTER TABLE dem ALTER COLUMN id SET DEFAULT NEXTVAL('DEM_ID_SEQ');