From 3d771a7fab9c5571374842e5cc5d07bf525f4778 Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc" <kop@karlpinc.com>
Date: Thu, 30 Nov 2023 14:31:14 -0600
Subject: [PATCH] Fix max lifespan constraint
---
db/schemas/sokwedb/tables/create/biography.m4 | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/db/schemas/sokwedb/tables/create/biography.m4 b/db/schemas/sokwedb/tables/create/biography.m4
index 6eda546..b019697 100644
--- a/db/schemas/sokwedb/tables/create/biography.m4
+++ b/db/schemas/sokwedb/tables/create/biography.m4
@@ -95,9 +95,9 @@ CREATE TABLE biography (
CHECK (birthdate <= entrydate)
CONSTRAINT "DepartDate may not be before EntryDate"
CHECK (entrydate <= departdate)
- CONSTRAINT "The time between BDMin and DepartDate may not be more than sdb_max_lifespan years"
+ CONSTRAINT "BDMin and DepartDate may not be more than sdb_max_lifespan years apart"
CHECK (bdmin
- <= departdate - 'sdb_max_lifespan sdb_max_lifespan_units'::interval)
+ >= departdate - 'sdb_max_lifespan sdb_max_lifespan_units'::interval)
);
grant_priv(`BIOGRAPHY')
--
2.34.1