Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-migrate-dami.sql @ 5121:e4cc9aebfcf1 dami
sensible constraints for dem-table
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 27 Feb 2013 19:44:08 +0100 |
| parents | df090e461c30 |
| children |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-migrate-dami.sql Wed Feb 27 17:35:17 2013 +0100 +++ b/flys-backend/doc/schema/postgresql-migrate-dami.sql Wed Feb 27 19:44:08 2013 +0100 @@ -118,6 +118,10 @@ ALTER TABLE hydr_boundaries ADD COLUMN sobek INT REFERENCES sobek_kinds(id); ALTER TABLE hydr_boundaries ADD FOREIGN KEY (kind) REFERENCES boundary_kinds(id); ALTER TABLE dem ADD COLUMN srid INT NOT NULL; +ALTER TABLE dem ALTER COLUMN year_from DROP NOT NULL; +ALTER TABLE dem ALTER COLUMN year_to DROP NOT NULL; +ALTER TABLE dem ALTER COLUMN projection DROP NOT NULL; +ALTER TABLE dem ALTER COLUMN path SET NOT NULL; COMMIT;