Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 5120:d49b3baa30d0 | 5121:e4cc9aebfcf1 |
|---|---|
| 116 ALTER TABLE hydr_boundaries_poly ADD FOREIGN KEY (kind) REFERENCES boundary_kinds(id); | 116 ALTER TABLE hydr_boundaries_poly ADD FOREIGN KEY (kind) REFERENCES boundary_kinds(id); |
| 117 ALTER TABLE hydr_boundaries ADD COLUMN sectie INT REFERENCES sectie_kinds(id); | 117 ALTER TABLE hydr_boundaries ADD COLUMN sectie INT REFERENCES sectie_kinds(id); |
| 118 ALTER TABLE hydr_boundaries ADD COLUMN sobek INT REFERENCES sobek_kinds(id); | 118 ALTER TABLE hydr_boundaries ADD COLUMN sobek INT REFERENCES sobek_kinds(id); |
| 119 ALTER TABLE hydr_boundaries ADD FOREIGN KEY (kind) REFERENCES boundary_kinds(id); | 119 ALTER TABLE hydr_boundaries ADD FOREIGN KEY (kind) REFERENCES boundary_kinds(id); |
| 120 ALTER TABLE dem ADD COLUMN srid INT NOT NULL; | 120 ALTER TABLE dem ADD COLUMN srid INT NOT NULL; |
| 121 ALTER TABLE dem ALTER COLUMN year_from DROP NOT NULL; | |
| 122 ALTER TABLE dem ALTER COLUMN year_to DROP NOT NULL; | |
| 123 ALTER TABLE dem ALTER COLUMN projection DROP NOT NULL; | |
| 124 ALTER TABLE dem ALTER COLUMN path SET NOT NULL; | |
| 121 | 125 |
| 122 COMMIT; | 126 COMMIT; |
| 123 | 127 |