From fd990f804e841438fc340267cadfe2bf4f72d35f Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 5 Jun 2026 16:33:01 +0000 Subject: [PATCH] Index the swelling sources on SWELLING_STATES --- db/schemas/sokwedb/indexes/create/swelling_states.m4 | 4 ++++ db/schemas/sokwedb/indexes/drop/swelling_states.m4 | 2 ++ 2 files changed, 6 insertions(+) diff --git a/db/schemas/sokwedb/indexes/create/swelling_states.m4 b/db/schemas/sokwedb/indexes/create/swelling_states.m4 index 66c366d..0357459 100644 --- a/db/schemas/sokwedb/indexes/create/swelling_states.m4 +++ b/db/schemas/sokwedb/indexes/create/swelling_states.m4 @@ -25,5 +25,9 @@ CREATE INDEX IF NOT EXISTS swelling_states_date ON swelling_states (date); CREATE INDEX IF NOT EXISTS swelling_states_animid ON swelling_states (animid); +CREATE INDEX IF NOT EXISTS swelling_states_swellingminsource ON swelling_states + (swellingminsource); +CREATE INDEX IF NOT EXISTS swelling_states_swellingmaxsource ON swelling_states + (swellingmaxsource); diff --git a/db/schemas/sokwedb/indexes/drop/swelling_states.m4 b/db/schemas/sokwedb/indexes/drop/swelling_states.m4 index 42fac38..b6d0f22 100644 --- a/db/schemas/sokwedb/indexes/drop/swelling_states.m4 +++ b/db/schemas/sokwedb/indexes/drop/swelling_states.m4 @@ -23,5 +23,7 @@ include(`indexmacros.m4')dnl DROP INDEX IF EXISTS swelling_states_date; DROP INDEX IF EXISTS swelling_states_animid; +DROP INDEX IF EXISTS swelling_states_swellingminsource; +DROP INDEX IF EXISTS swelling_states_swellingmaxsource; -- 2.34.1