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, |