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); |