Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql-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 |
|---|---|
| 175 kind_id int REFERENCES hws_kinds(id) DEFAULT 2, | 175 kind_id int REFERENCES hws_kinds(id) DEFAULT 2, |
| 176 fed_state_id int REFERENCES fed_states(id), | 176 fed_state_id int REFERENCES fed_states(id), |
| 177 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 177 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |
| 178 name VARCHAR(256), | 178 name VARCHAR(256), |
| 179 path VARCHAR(256), | 179 path VARCHAR(256), |
| 180 official INT DEFAULT 0, | 180 official INT DEFAULT 0 NOT NULL CHECK(official IN(0,1)), |
| 181 agency VARCHAR(256), | 181 agency VARCHAR(256), |
| 182 range VARCHAR(256), | 182 range VARCHAR(256), |
| 183 shore_side INT DEFAULT 0, | 183 shore_side INT DEFAULT 0, |
| 184 source VARCHAR(256), | 184 source VARCHAR(256), |
| 185 status_date TIMESTAMP, | 185 status_date TIMESTAMP, |