Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5315:aa407dfb9949
removed unique constraint to allow one dem to be used by several rivers
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 14 Mar 2013 18:04:36 +0100 |
| parents | 08b3109c637b |
| children | 7b35f2c070c3 |
comparison
equal
deleted
inserted
replaced
| 5314:ac2746f3e75f | 5315:aa407dfb9949 |
|---|---|
| 119 elevation_state VARCHAR(32), | 119 elevation_state VARCHAR(32), |
| 120 format VARCHAR(32), | 120 format VARCHAR(32), |
| 121 border_break BOOLEAN NOT NULL DEFAULT FALSE, | 121 border_break BOOLEAN NOT NULL DEFAULT FALSE, |
| 122 resolution VARCHAR(16), | 122 resolution VARCHAR(16), |
| 123 description VARCHAR(256), | 123 description VARCHAR(256), |
| 124 path VARCHAR(256) NOT NULL UNIQUE | 124 path VARCHAR(256) NOT NULL |
| 125 ); | 125 ); |
| 126 ALTER TABLE dem ALTER COLUMN id SET DEFAULT NEXTVAL('DEM_ID_SEQ'); | 126 ALTER TABLE dem ALTER COLUMN id SET DEFAULT NEXTVAL('DEM_ID_SEQ'); |
| 127 | 127 |
| 128 | 128 |
| 129 -- Static lookup tables for Hochwasserschutzanlagen | 129 -- Static lookup tables for Hochwasserschutzanlagen |