Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5028:a5f438895a38 dami
SCHEMA CHANGE: removed catchements from schema and geo-importer (obsolete)
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Tue, 19 Feb 2013 19:24:36 +0100 |
| parents | 808718c6de97 |
| children | 2837b11cdb13 |
comparison
equal
deleted
inserted
replaced
| 5026:bdef4c74d675 | 5028:a5f438895a38 |
|---|---|
| 101 description VARCHAR(256), | 101 description VARCHAR(256), |
| 102 path VARCHAR(256) | 102 path VARCHAR(256) |
| 103 ); | 103 ); |
| 104 ALTER TABLE dem ALTER COLUMN id SET DEFAULT NEXTVAL('DEM_ID_SEQ'); | 104 ALTER TABLE dem ALTER COLUMN id SET DEFAULT NEXTVAL('DEM_ID_SEQ'); |
| 105 | 105 |
| 106 | |
| 107 -- Hydrologie/Einzugsgebiete/EZG.shp | |
| 108 CREATE SEQUENCE CATCHMENT_ID_SEQ; | |
| 109 CREATE TABLE catchment ( | |
| 110 id int PRIMARY KEY NOT NULL, | |
| 111 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | |
| 112 area FLOAT8, | |
| 113 name VARCHAR(256), | |
| 114 path VARCHAR(256) | |
| 115 ); | |
| 116 SELECT AddGeometryColumn('catchment','geom',31467,'POLYGON',2); | |
| 117 ALTER TABLE catchment ALTER COLUMN id SET DEFAULT NEXTVAL('CATCHMENT_ID_SEQ'); | |
| 118 | 106 |
| 119 -- Static lookup tables for Hochwasserschutzanlagen | 107 -- Static lookup tables for Hochwasserschutzanlagen |
| 120 CREATE TABLE hws_kinds ( | 108 CREATE TABLE hws_kinds ( |
| 121 id int PRIMARY KEY NOT NULL, | 109 id int PRIMARY KEY NOT NULL, |
| 122 kind VARCHAR(64) NOT NULL | 110 kind VARCHAR(64) NOT NULL |