Mercurial > dive4elements > river
diff 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 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql Tue Feb 19 14:59:44 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Tue Feb 19 19:24:36 2013 +0100 @@ -104,18 +104,6 @@ ALTER TABLE dem ALTER COLUMN id SET DEFAULT NEXTVAL('DEM_ID_SEQ'); --- Hydrologie/Einzugsgebiete/EZG.shp -CREATE SEQUENCE CATCHMENT_ID_SEQ; -CREATE TABLE catchment ( - id int PRIMARY KEY NOT NULL, - river_id int REFERENCES rivers(id) ON DELETE CASCADE, - area FLOAT8, - name VARCHAR(256), - path VARCHAR(256) -); -SELECT AddGeometryColumn('catchment','geom',31467,'POLYGON',2); -ALTER TABLE catchment ALTER COLUMN id SET DEFAULT NEXTVAL('CATCHMENT_ID_SEQ'); - -- Static lookup tables for Hochwasserschutzanlagen CREATE TABLE hws_kinds ( id int PRIMARY KEY NOT NULL,