From 96847b79e1864baaba07f817b212a7f94db2b1f7 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 27 May 2026 19:59:47 +0000 Subject: [PATCH] Fix so FOLLOWS.CommID is validated against COMM_IDS --- db/schemas/sokwedb/tables/create/follows.m4 | 1 + 1 file changed, 1 insertion(+) diff --git a/db/schemas/sokwedb/tables/create/follows.m4 b/db/schemas/sokwedb/tables/create/follows.m4 index 212a8b5..3eea529 100644 --- a/db/schemas/sokwedb/tables/create/follows.m4 +++ b/db/schemas/sokwedb/tables/create/follows.m4 @@ -44,6 +44,7 @@ CREATE TABLE follows ( key_column(`FOLLOWS', `FID', INTEGER) ,animid_type_column(`focal', `Focal', `NOT NULL') ,commid TEXT NOT NULL + REFERENCES comm_ids ,date DATE NOT NULL CONSTRAINT "The FOLLOWS.Date must not be before sdb_min_follow_date" CHECK(date >= 'sdb_min_follow_date') -- 2.34.1