Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial.sql @ 5115:c4b28de753de dami
removed unnecessary NOT NULL constraints from dem-table
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 27 Feb 2013 15:26:47 +0100 |
| parents | 0fd7720e5c7f |
| children | e4cc9aebfcf1 |
comparison
equal
deleted
inserted
replaced
| 5114:3003c45f8a00 | 5115:c4b28de753de |
|---|---|
| 130 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, | 130 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, |
| 131 -- XXX Should we use the ranges table instead? | 131 -- XXX Should we use the ranges table instead? |
| 132 name VARCHAR(64), | 132 name VARCHAR(64), |
| 133 lower NUMBER(19,5), | 133 lower NUMBER(19,5), |
| 134 upper NUMBER(19,5), | 134 upper NUMBER(19,5), |
| 135 year_from VARCHAR(32) NOT NULL, | 135 year_from VARCHAR(32), |
| 136 year_to VARCHAR(32) NOT NULL, | 136 year_to VARCHAR(32), |
| 137 projection VARCHAR(32) NOT NULL, | 137 projection VARCHAR(32), |
| 138 elevation_state VARCHAR(32), | 138 elevation_state VARCHAR(32), |
| 139 srid NUMBER NOT NULL, | 139 srid NUMBER NOT NULL, |
| 140 format VARCHAR(32), | 140 format VARCHAR(32), |
| 141 border_break NUMBER(1) DEFAULT 0 NOT NULL, | 141 border_break NUMBER(1) DEFAULT 0 NOT NULL, |
| 142 resolution VARCHAR(16), | 142 resolution VARCHAR(16), |