Mercurial > gemma

changeset 2076:0e006077bbfa

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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)
     )