Mercurial > dive4elements > river
changeset 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 | c5187ab9f571 |
| children | 1d95391d056b |
| files | flys-backend/doc/schema/oracle-spatial-migrate-dami.sql flys-backend/doc/schema/oracle-spatial.sql |
| diffstat | 2 files changed, 13 insertions(+), 8 deletions(-) [+] |
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);
--- a/flys-backend/doc/schema/oracle-spatial.sql Thu Feb 21 09:46:40 2013 +0100 +++ b/flys-backend/doc/schema/oracle-spatial.sql Thu Feb 21 12:36:30 2013 +0100 @@ -294,7 +294,9 @@ GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, name VARCHAR(255), - kind NUMBER(38), + kind NUMBER(38) REFERENCES boundary_kinds(id), + sectie NUMBER(38) REFERENCES sectie_kinds(id), + sobek NUMBER(38) REFERENCES sobek_kinds(id), path VARCHAR(256), id NUMBER PRIMARY KEY NOT NULL ); @@ -311,7 +313,9 @@ GEOM MDSYS.SDO_GEOMETRY, river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, name VARCHAR(255), - kind NUMBER(38), + kind NUMBER(38) REFERENCES boundary_kinds(id), + sectie NUMBER(38) REFERENCES sectie_kinds(id), + sobek NUMBER(38) REFERENCES sobek_kinds(id), path VARCHAR(256), id NUMBER PRIMARY KEY NOT NULL );