Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5158:a9658d43b621
added missing constraints in schema (mostly for Oracle)
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 01 Mar 2013 13:28:45 +0100 |
| parents | d4fdd98a04f7 |
| children | 8aac391871f9 |
comparison
equal
deleted
inserted
replaced
| 5155:6b19902baf31 | 5158:a9658d43b621 |
|---|---|
| 105 elevation_state VARCHAR(32), | 105 elevation_state VARCHAR(32), |
| 106 format VARCHAR(32), | 106 format VARCHAR(32), |
| 107 border_break BOOLEAN NOT NULL DEFAULT FALSE, | 107 border_break BOOLEAN NOT NULL DEFAULT FALSE, |
| 108 resolution VARCHAR(16), | 108 resolution VARCHAR(16), |
| 109 description VARCHAR(256), | 109 description VARCHAR(256), |
| 110 path VARCHAR(256) NOT NULL | 110 path VARCHAR(256) NOT NULL UNIQUE |
| 111 ); | 111 ); |
| 112 ALTER TABLE dem ALTER COLUMN id SET DEFAULT NEXTVAL('DEM_ID_SEQ'); | 112 ALTER TABLE dem ALTER COLUMN id SET DEFAULT NEXTVAL('DEM_ID_SEQ'); |
| 113 | 113 |
| 114 | 114 |
| 115 -- Static lookup tables for Hochwasserschutzanlagen | 115 -- Static lookup tables for Hochwasserschutzanlagen |