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 |