From 552aa8529b6f2c8233d06c9f5791fea7f51b8a1d Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 2 Oct 2025 23:15:15 +0000 Subject: [PATCH] Make COMM_IDS.Name unique when ignoring case --- db/schemas/codes/indexes/create/comm_ids.m4 | 4 ++-- db/schemas/codes/indexes/drop/comm_ids.m4 | 2 +- doc/src/code_tables.m4 | 2 +- 3 files changed, 4 insertions(+), 4 deletions(-) diff --git a/db/schemas/codes/indexes/create/comm_ids.m4 b/db/schemas/codes/indexes/create/comm_ids.m4 index 250116d..73dc00e 100644 --- a/db/schemas/codes/indexes/create/comm_ids.m4 +++ b/db/schemas/codes/indexes/create/comm_ids.m4 @@ -24,5 +24,5 @@ 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); +CREATE UNIQUE INDEX IF NOT EXISTS comm_ids_name_uniquenocase ON comm_ids + (sdb_case_equivalence(name)); diff --git a/db/schemas/codes/indexes/drop/comm_ids.m4 b/db/schemas/codes/indexes/drop/comm_ids.m4 index 5c68ecc..e91c21b 100644 --- a/db/schemas/codes/indexes/drop/comm_ids.m4 +++ b/db/schemas/codes/indexes/drop/comm_ids.m4 @@ -22,4 +22,4 @@ include(`constants.m4')dnl include(`macros.m4')dnl DROP INDEX IF EXISTS comm_ids_commid_uniquenocase; -DROP INDEX IF EXISTS comm_ids_name; +DROP INDEX IF EXISTS comm_ids_name_uniquenocase; diff --git a/doc/src/code_tables.m4 b/doc/src/code_tables.m4 index 74dfc65..c2e5870 100644 --- a/doc/src/code_tables.m4 +++ b/doc/src/code_tables.m4 @@ -72,7 +72,7 @@ Name .. |COMM_IDS.Name_summary| replace:: The name of the community. -|COMM_IDS.Name_summary| |unique| |emptytext| |notnull| +|COMM_IDS.Name_summary| |uniquenocase| |emptytext| |notnull| .. _COMM_IDS.Notes: -- 2.34.1