From 5f87c99333dcaf71c09fc3200284e4ff519bcef6 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 10 Jun 2026 22:15:11 +0000 Subject: [PATCH] Fix FID + Time unique index --- db/schemas/sokwedb/indexes/create/locations_b.m4 | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/db/schemas/sokwedb/indexes/create/locations_b.m4 b/db/schemas/sokwedb/indexes/create/locations_b.m4 index 8cb5f68..a56ebf8 100644 --- a/db/schemas/sokwedb/indexes/create/locations_b.m4 +++ b/db/schemas/sokwedb/indexes/create/locations_b.m4 @@ -32,9 +32,8 @@ CREATE UNIQUE INDEX IF NOT EXISTS CREATE UNIQUE INDEX IF NOT EXISTS "On LOCATIONS_B, FID + Time must be unique" ON locations_b - (date, focal, time) - WHERE date IS NOT NULL - AND focal IS NOT NULL; + (fid, time) + WHERE fid IS NOT NULL; CREATE INDEX IF NOT EXISTS locations_b_fid ON locations_b (fid) -- 2.34.1