From aac5aa2e4924b6fa56a076e3b7a7fc7914c4fd7c Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Mon, 15 Jun 2026 03:14:07 +0000 Subject: [PATCH] Index EVENTS on date+focal+type Some EVENTS.Type values (ad-hoc pantgrunt observations) will not necessarily be unique per-individual per-day. --- db/schemas/sokwedb/indexes/create/watches.m4 | 2 ++ db/schemas/sokwedb/indexes/drop/watches.m4 | 1 + 2 files changed, 3 insertions(+) diff --git a/db/schemas/sokwedb/indexes/create/watches.m4 b/db/schemas/sokwedb/indexes/create/watches.m4 index 07e324d..9054145 100644 --- a/db/schemas/sokwedb/indexes/create/watches.m4 +++ b/db/schemas/sokwedb/indexes/create/watches.m4 @@ -27,6 +27,8 @@ CREATE UNIQUE INDEX IF NOT EXISTS (date, focal) WHERE type = 'sdb_follow'; +CREATE INDEX IF NOT EXISTS watches_date_focal_type ON watches + (date, focal, type); CREATE INDEX IF NOT EXISTS watches_focal ON watches (focal); CREATE INDEX IF NOT EXISTS watches_commid ON watches diff --git a/db/schemas/sokwedb/indexes/drop/watches.m4 b/db/schemas/sokwedb/indexes/drop/watches.m4 index 85dd39d..db7cd34 100644 --- a/db/schemas/sokwedb/indexes/drop/watches.m4 +++ b/db/schemas/sokwedb/indexes/drop/watches.m4 @@ -25,6 +25,7 @@ include(`indexmacros.m4')dnl DROP INDEX IF EXISTS "On WATCHES where (Type)=(sdb_follow), Date + Focal must be unique"; +DROP INDEX IF EXISTS watches_date_focal_type; DROP INDEX IF EXISTS watches_focal; DROP INDEX IF EXISTS watches_commid; DROP INDEX IF EXISTS watches_type; -- 2.34.1