Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
5077:c5187ab9f571 | 5078:0fd7720e5c7f |
---|---|
110 z_target NUMBER(19,5), | 110 z_target NUMBER(19,5), |
111 rated_level NUMBER(19,5) | 111 rated_level NUMBER(19,5) |
112 ); | 112 ); |
113 | 113 |
114 -- Altrications | 114 -- Altrications |
115 ALTER TABLE dem ADD COLUMN srid NUMBER NOT NULL; | 115 ALTER TABLE dem ADD srid NUMBER NOT NULL; |
116 ALTER TABLE hydr_boundaries_poly ADD COLUMN sectie INT REFERENCES sectie_kinds(id); | 116 ALTER TABLE hydr_boundaries_poly ADD sectie NUMBER REFERENCES sectie_kinds(id); |
117 ALTER TABLE hydr_boundaries_poly ADD COLUMN sobek INT REFERENCES sobek_kinds(id); | 117 ALTER TABLE hydr_boundaries_poly ADD sobek NUMBER REFERENCES sobek_kinds(id); |
118 ALTER TABLE hydr_boundaries ADD COLUMN sectie INT REFERENCES sectie_kinds(id); | 118 ALTER TABLE hydr_boundaries ADD sectie NUMBER REFERENCES sectie_kinds(id); |
119 ALTER TABLE hydr_boundaries ADD COLUMN sobek INT REFERENCES sobek_kinds(id); | 119 ALTER TABLE hydr_boundaries ADD sobek NUMBER REFERENCES sobek_kinds(id); |
120 ALTER TABLE hydr_boundaries ADD COLUMN kind INT REFERENCES boundary_kinds(id); | 120 ALTER TABLE hydr_boundaries ADD kind NUMBER REFERENCES boundary_kinds(id); |
121 ALTER TABLE hydr_boundaries_poly ADD kind NUMBER REFERENCES boundary_kinds(id); |