From 347d041960cbb749a5bf03d05aa578e4b8e72aa3 Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc kop@karlpinc.com" <kop@karlpinc.com>
Date: Sat, 1 Mar 2025 00:05:27 +0000
Subject: [PATCH] Add lower limit for FOLLOWS.Date
---
db/schemas/sokwedb/tables/create/follows.m4 | 2 ++
doc/src/tables/follows.m4 | 4 +++-
include/limits.m4 | 3 +++
3 files changed, 8 insertions(+), 1 deletion(-)
diff --git a/db/schemas/sokwedb/tables/create/follows.m4 b/db/schemas/sokwedb/tables/create/follows.m4
index 36bb144..44203c4 100644
--- a/db/schemas/sokwedb/tables/create/follows.m4
+++ b/db/schemas/sokwedb/tables/create/follows.m4
@@ -45,6 +45,8 @@ CREATE TABLE follows (
,animid_type_column(`focal', `Focal', `NOT NULL')
,community TEXT NOT NULL
,date DATE NOT NULL
+ CONSTRAINT "The FOLLOWS.Date must not be before sdb_min_follow_date"
+ CHECK(date >= 'sdb_min_follow_date')
,notes TEXT NOT NULL
emptytext_check(`Notes')
);
diff --git a/doc/src/tables/follows.m4 b/doc/src/tables/follows.m4
index 7f979cf..b35d7bf 100644
--- a/doc/src/tables/follows.m4
+++ b/doc/src/tables/follows.m4
@@ -92,7 +92,9 @@ Date
.. |FOLLOWS.Date_summary| replace::
The date the follow was conducted.
-|FOLLOWS.Date_summary| |notnull|
+|FOLLOWS.Date_summary|
+This date may not be before ``sdb_min_follow_date``.
+|notnull|
.. _FOLLOWS.Notes:
diff --git a/include/limits.m4 b/include/limits.m4
index 275fab0..6e1b2e0 100644
--- a/include/limits.m4
+++ b/include/limits.m4
@@ -56,6 +56,9 @@ dnl
dnl Administration related
dnl
+dnl The earliest possible FOLLOWS.Date
+define(`sdb_min_follow_date', `1960-07-14')
+
dnl The earliest possible BIOGRAPHY_LOG.DateOfUpdate
define(`sdb_first_biography_log_date', `2013-07-01')
--
2.34.1