From 922f309303f62855b5dce1fed294058ec0acf48d Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 18 Jun 2026 19:07:55 +0000 Subject: [PATCH] Fix so WATCHES.Type can have values other than sdb_follow --- db/schemas/sokwedb/tables/create/watches.m4 | 8 ++++++-- doc/src/tables/watches.m4 | 5 +++++ 2 files changed, 11 insertions(+), 2 deletions(-) diff --git a/db/schemas/sokwedb/tables/create/watches.m4 b/db/schemas/sokwedb/tables/create/watches.m4 index 34670e5..a705e58 100644 --- a/db/schemas/sokwedb/tables/create/watches.m4 +++ b/db/schemas/sokwedb/tables/create/watches.m4 @@ -49,8 +49,12 @@ CREATE TABLE watches ( CONSTRAINT "The WATCHES.Date must not be before sdb_min_follow_date" CHECK(date >= 'sdb_min_follow_date') ,type TEXT NOT NULL - CONSTRAINT "Watches.Type must be one of: sdb_follow" - CHECK (type = 'sdb_follow') + CONSTRAINT "Watches.Type must be one of: sdb_attendance, sdb_follow, sdb_ag_scan, sdb_location, sdb_pantgrunt" + CHECK (type = 'sdb_attendance' + OR type = 'sdb_follow' + OR type = 'sdb_ag_scan' + OR type = 'sdb_location' + OR type = 'sdb_pantgrunt') ,notes TEXT NOT NULL notonlyspaces_check(`Notes') ); diff --git a/doc/src/tables/watches.m4 b/doc/src/tables/watches.m4 index 29f2771..067bbd9 100644 --- a/doc/src/tables/watches.m4 +++ b/doc/src/tables/watches.m4 @@ -337,9 +337,14 @@ One of the following values: ``sdb_follow`` (Follow) +``sdb_ag_scan`` (Attendance Groom Scan) + ``sdb_location`` (Location) Only used when there is no follow to use. +``sdb_pantgrunt`` (Pantgrunt) + Only used when there is no follow to use. + See :ref:`overview of the WATCHES table `, above, for more information. -- 2.34.1