Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-spatial.sql @ 5854:249b8766a178
Schema change: new column 'waterbody' for floodmaps and importer
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Fri, 26 Apr 2013 16:50:14 +0200 |
| parents | 5aa05a7a34b7 |
| children | 6a63456b99d9 |
comparison
equal
deleted
inserted
replaced
| 5853:774d25915eb1 | 5854:249b8766a178 |
|---|---|
| 236 kind int NOT NULL REFERENCES floodmap_kinds(id), | 236 kind int NOT NULL REFERENCES floodmap_kinds(id), |
| 237 diff FLOAT8, | 237 diff FLOAT8, |
| 238 count int, | 238 count int, |
| 239 area FLOAT8, | 239 area FLOAT8, |
| 240 perimeter FLOAT8, | 240 perimeter FLOAT8, |
| 241 waterbody varchar(64), | |
| 241 path VARCHAR(256), | 242 path VARCHAR(256), |
| 242 source varchar(64) | 243 source varchar(64) |
| 243 ); | 244 ); |
| 244 SELECT AddGeometryColumn('floodmaps', 'geom', 31467, 'MULTIPOLYGON', 2); | 245 SELECT AddGeometryColumn('floodmaps', 'geom', 31467, 'MULTIPOLYGON', 2); |
| 245 ALTER TABLE floodmaps DROP CONSTRAINT enforce_geotype_geom; | 246 ALTER TABLE floodmaps DROP CONSTRAINT enforce_geotype_geom; |