Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial-migrate-dami.sql @ 5078:0fd7720e5c7f dami
Oracle Schema, add overlooked sectie and sobek fields
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Thu, 21 Feb 2013 12:36:30 +0100 |
| parents | bdef4c74d675 |
| children | 5ba502e78e05 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial-migrate-dami.sql Thu Feb 21 09:46:40 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial-migrate-dami.sql Thu Feb 21 12:36:30 2013 +0100 @@ -112,9 +112,10 @@ ); -- Altrications -ALTER TABLE dem ADD COLUMN srid NUMBER NOT NULL; -ALTER TABLE hydr_boundaries_poly ADD COLUMN sectie INT REFERENCES sectie_kinds(id); -ALTER TABLE hydr_boundaries_poly ADD COLUMN sobek INT REFERENCES sobek_kinds(id); -ALTER TABLE hydr_boundaries ADD COLUMN sectie INT REFERENCES sectie_kinds(id); -ALTER TABLE hydr_boundaries ADD COLUMN sobek INT REFERENCES sobek_kinds(id); -ALTER TABLE hydr_boundaries ADD COLUMN kind INT REFERENCES boundary_kinds(id); +ALTER TABLE dem ADD srid NUMBER NOT NULL; +ALTER TABLE hydr_boundaries_poly ADD sectie NUMBER REFERENCES sectie_kinds(id); +ALTER TABLE hydr_boundaries_poly ADD sobek NUMBER REFERENCES sobek_kinds(id); +ALTER TABLE hydr_boundaries ADD sectie NUMBER REFERENCES sectie_kinds(id); +ALTER TABLE hydr_boundaries ADD sobek NUMBER REFERENCES sobek_kinds(id); +ALTER TABLE hydr_boundaries ADD kind NUMBER REFERENCES boundary_kinds(id); +ALTER TABLE hydr_boundaries_poly ADD kind NUMBER REFERENCES boundary_kinds(id);