From ff7a3170dfd52f8bf4c17690090067b4bcc8ccb4 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 2 Oct 2025 23:10:28 +0000 Subject: [PATCH] Make comm_ids.CommID unique when ignoring case --- db/schemas/codes/indexes/create/comm_ids.m4 | 3 +++ db/schemas/codes/indexes/drop/comm_ids.m4 | 1 + doc/src/code_tables.m4 | 2 +- 3 files changed, 5 insertions(+), 1 deletion(-) diff --git a/db/schemas/codes/indexes/create/comm_ids.m4 b/db/schemas/codes/indexes/create/comm_ids.m4 index bb3a23a..250116d 100644 --- a/db/schemas/codes/indexes/create/comm_ids.m4 +++ b/db/schemas/codes/indexes/create/comm_ids.m4 @@ -21,5 +21,8 @@ include(`copyright.m4')dnl include(`constants.m4')dnl include(`indexmacros.m4')dnl +CREATE UNIQUE INDEX IF NOT EXISTS comm_ids_commid_uniquenocase ON comm_ids + (sdb_case_equivalence(commid)); + CREATE UNIQUE INDEX IF NOT EXISTS comm_ids_name ON comm_ids (name); diff --git a/db/schemas/codes/indexes/drop/comm_ids.m4 b/db/schemas/codes/indexes/drop/comm_ids.m4 index 7792ab7..5c68ecc 100644 --- a/db/schemas/codes/indexes/drop/comm_ids.m4 +++ b/db/schemas/codes/indexes/drop/comm_ids.m4 @@ -21,4 +21,5 @@ include(`copyright.m4')dnl include(`constants.m4')dnl include(`macros.m4')dnl +DROP INDEX IF EXISTS comm_ids_commid_uniquenocase; DROP INDEX IF EXISTS comm_ids_name; diff --git a/doc/src/code_tables.m4 b/doc/src/code_tables.m4 index 3fd4663..74dfc65 100644 --- a/doc/src/code_tables.m4 +++ b/doc/src/code_tables.m4 @@ -61,7 +61,7 @@ CommID (Community IDentifier) .. |COMM_IDS.CommID_summary| replace:: A short sequence of characters which identify a community. -|COMM_IDS.CommID_summary| |keycol| +|COMM_IDS.CommID_summary| |caseuniquekeycol| .. _COMM_IDS.Name: -- 2.34.1