From 7e495f20a711a0c0b7fda3fc9b1640722b0a2812 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sat, 12 Apr 2025 18:32:29 +0000 Subject: [PATCH] New macro for columns named AnimID but are not required to be foreign keys --- db/include/tablemacros.m4 | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/db/include/tablemacros.m4 b/db/include/tablemacros.m4 index 0cbf280..05de965 100644 --- a/db/include/tablemacros.m4 +++ b/db/include/tablemacros.m4 @@ -125,6 +125,14 @@ define(`animid_type_column', ` CONSTRAINT "$2 must be a BIOGRAPHY_DATA.AnimID value" REFERENCES biography_data(animid)')dnl +dnl An AnimID column that does not have to reference BIOGRAPHY_DATA.AnimID. +changequote([,]) +define([not_animid_column], + [animid TEXT NOT NULL + trimmedofspaces_check(`AnimID') + emptytext_check(`AnimID')]) +changequote(`,')dnl See above. + -- -- Constraints -- -- 2.34.1