Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
3950:82e931f88137 | 3951:89ada0b9083f |
---|---|
102 CREATE SEQUENCE DEM_ID_SEQ; | 102 CREATE SEQUENCE DEM_ID_SEQ; |
103 CREATE TABLE dem ( | 103 CREATE TABLE dem ( |
104 id int PRIMARY KEY NOT NULL, | 104 id int PRIMARY KEY NOT NULL, |
105 river_id int REFERENCES rivers(id), | 105 river_id int REFERENCES rivers(id), |
106 -- XXX Should we use the ranges table instead? | 106 -- XXX Should we use the ranges table instead? |
107 lower NUMERIC, | 107 name VARCHAR(64), |
108 upper NUMERIC, | 108 lower NUMERIC, |
109 path VARCHAR(256), | 109 upper NUMERIC, |
110 UNIQUE (river_id, lower, upper) | 110 year_from int, |
111 year_to int, | |
112 projection VARCHAR(32), | |
113 elevation_state VARCHAR(32), | |
114 format VARCHAR(32), | |
115 border_break BOOLEAN NOT NULL DEFAULT FALSE, | |
116 resolution VARCHAR(16), | |
117 description VARCHAR(256), | |
118 path VARCHAR(256) | |
111 ); | 119 ); |
112 ALTER TABLE dem ALTER COLUMN id SET DEFAULT NEXTVAL('DEM_ID_SEQ'); | 120 ALTER TABLE dem ALTER COLUMN id SET DEFAULT NEXTVAL('DEM_ID_SEQ'); |
113 | 121 |
114 | 122 |
115 -- Hydrologie/Einzugsgebiete/EZG.shp | 123 -- Hydrologie/Einzugsgebiete/EZG.shp |