Mercurial > dive4elements > river
comparison backend/doc/schema/oracle-spatial.sql @ 9717:6824c447f5b0 3.2.x
Ensure pseudo-boolean values in hws_lines.official
NULL values lead to a null pointer in HWSFactory and the semantic of the
column is clearly boolean. See also rev. aef987124822 for a related fix
in the importer.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 22 Mar 2021 18:14:47 +0100 |
| parents | cc53aae06303 |
| children |
comparison
equal
deleted
inserted
replaced
| 9716:c3afc0274bba | 9717:6824c447f5b0 |
|---|---|
| 221 kind_id NUMBER(2) DEFAULT 2 REFERENCES hws_kinds(id), | 221 kind_id NUMBER(2) DEFAULT 2 REFERENCES hws_kinds(id), |
| 222 fed_state_id NUMBER(2) REFERENCES fed_states(id), | 222 fed_state_id NUMBER(2) REFERENCES fed_states(id), |
| 223 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, | 223 river_id NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE, |
| 224 name VARCHAR(256), | 224 name VARCHAR(256), |
| 225 path VARCHAR(256), | 225 path VARCHAR(256), |
| 226 official NUMBER DEFAULT 0, | 226 official NUMBER(1) DEFAULT 0 NOT NULL CHECK(official IN(0,1)), |
| 227 agency VARCHAR(256), | 227 agency VARCHAR(256), |
| 228 range VARCHAR(256), | 228 range VARCHAR(256), |
| 229 shore_side NUMBER DEFAULT 0, | 229 shore_side NUMBER DEFAULT 0, |
| 230 source VARCHAR(256), | 230 source VARCHAR(256), |
| 231 status_date TIMESTAMP, | 231 status_date TIMESTAMP, |