From 132d784f4b10c5fc5eec4f57fe47b12b0a1a4b1d Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Mon, 6 Oct 2025 22:38:43 +0000 Subject: [PATCH] There can be at most one arrival per event --- db/schemas/sokwedb/indexes/create/arrivals.m4 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/schemas/sokwedb/indexes/create/arrivals.m4 b/db/schemas/sokwedb/indexes/create/arrivals.m4 index ce1a567..3472c1e 100644 --- a/db/schemas/sokwedb/indexes/create/arrivals.m4 +++ b/db/schemas/sokwedb/indexes/create/arrivals.m4 @@ -21,7 +21,7 @@ include(`copyright.m4')dnl include(`constants.m4')dnl include(`indexmacros.m4')dnl -CREATE INDEX IF NOT EXISTS arrivals_eid ON arrivals +CREATE UNIQUE INDEX IF NOT EXISTS arrivals_eid ON arrivals (eid); CREATE INDEX IF NOT EXISTS arrivals_cycle ON arrivals (cycle); -- 2.34.1