Mercurial > gemma
changeset 2076:0e006077bbfa
Add missing NOT NULL constraints
Nullable columns in a pure m:n-table are worthless.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 30 Jan 2019 17:26:51 +0100 |
parents | 515bdc765565 |
children | e9aaf6808682 |
files | schema/gemma.sql |
diffstat | 1 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/gemma.sql Wed Jan 30 17:25:59 2019 +0100 +++ b/schema/gemma.sql Wed Jan 30 17:26:51 2019 +0100 @@ -469,8 +469,8 @@ FOR EACH ROW EXECUTE PROCEDURE update_date_info() CREATE TABLE bottlenecks_riverbed_materials ( - bottleneck_id int REFERENCES bottlenecks(id), - riverbed varchar REFERENCES riverbed_materials, + bottleneck_id int NOT NULL REFERENCES bottlenecks(id), + riverbed varchar NOT NULL REFERENCES riverbed_materials, -- XXX: should be 'natsur' according to IENC Encoding Guide M.4.3 PRIMARY KEY (bottleneck_id, riverbed) )