Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial.sql @ 3951:89ada0b9083f
Modified the schema for DGMs; added converter for CSV to SQL for DGM information.
flys-backend/trunk@5604 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 27 Sep 2012 07:24:07 +0000 |
| parents | c37effda3655 |
| children | f5912365619c |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Mon Sep 24 10:02:36 2012 +0000 +++ b/flys-backend/doc/schema/oracle-spatial.sql Thu Sep 27 07:24:07 2012 +0000 @@ -155,10 +155,18 @@ ID NUMBER PRIMARY KEY NOT NULL, river_id NUMBER(38), -- XXX Should we use the ranges table instead? - lower NUMBER(19,5), - upper NUMBER(19,5), - path VARCHAR(256), - UNIQUE (river_id, lower, upper) + name VARCHAR(64), + lower NUMBER(19,5), + upper NUMBER(19,5), + year_from NUMBER(38), + year_to NUMBER(38), + projection VARCHAR(32), + elevation_state VARCHAR(32), + format VARCHAR(32), + border_break BOOLEAN NOT NULL DEFAULT FALSE, + resolution VARCHAR(16), + description VARCHAR(256), + path VARCHAR(256) ); CREATE OR REPLACE TRIGGER dem_trigger BEFORE INSERT ON dem FOR each ROW BEGIN