Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-spatial.sql @ 3961:f5912365619c
Adapted the spatial schema for DEMs and the DgmSqlConverter.
flys-backend/trunk@5632 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Fri, 28 Sep 2012 08:37:08 +0000 |
| parents | 89ada0b9083f |
| children | eecd1ebba128 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql Thu Sep 27 17:45:49 2012 +0000 +++ b/flys-backend/doc/schema/oracle-spatial.sql Fri Sep 28 08:37:08 2012 +0000 @@ -158,9 +158,9 @@ name VARCHAR(64), lower NUMBER(19,5), upper NUMBER(19,5), - year_from NUMBER(38), - year_to NUMBER(38), - projection VARCHAR(32), + year_from VARCHAR(32) NOT NULL, + year_to VARCHAR(32) NOT NULL, + projection VARCHAR(32) NOT NULL, elevation_state VARCHAR(32), format VARCHAR(32), border_break BOOLEAN NOT NULL DEFAULT FALSE,