From c34754f93b9d7aa42745b98cd9c2120a6f59655a Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sat, 6 Jun 2026 21:28:58 +0000 Subject: [PATCH] Invoke animid_column() macro with parenthesis --- db/schemas/sokwedb/tables/create/non_brec_sighting_sources.m4 | 2 +- db/schemas/sokwedb/tables/create/sightings.m4 | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/db/schemas/sokwedb/tables/create/non_brec_sighting_sources.m4 b/db/schemas/sokwedb/tables/create/non_brec_sighting_sources.m4 index 0951f05..52e6ff3 100644 --- a/db/schemas/sokwedb/tables/create/non_brec_sighting_sources.m4 +++ b/db/schemas/sokwedb/tables/create/non_brec_sighting_sources.m4 @@ -28,7 +28,7 @@ CREATE TABLE non_brec_sighting_sources ( ,source TEXT NOT NULL REFERENCES sighting_records ,date DATE NOT NULL - ,animid_column + ,animid_column() ,commid TEXT NOT NULL CONSTRAINT "CommID must be a COMM_IDS.CommID value" REFERENCES comm_ids diff --git a/db/schemas/sokwedb/tables/create/sightings.m4 b/db/schemas/sokwedb/tables/create/sightings.m4 index aec2c41..72c6b30 100644 --- a/db/schemas/sokwedb/tables/create/sightings.m4 +++ b/db/schemas/sokwedb/tables/create/sightings.m4 @@ -28,7 +28,7 @@ CREATE TABLE sightings ( ,date DATE NOT NULL CONSTRAINT "Date cannot be before sdb_min_follow_date" CHECK (date >= 'sdb_min_follow_date') - ,animid_column + ,animid_column() ,commid TEXT NOT NULL CONSTRAINT "CommID must be a COMM_IDS.CommID value" REFERENCES comm_ids -- 2.34.1