# HG changeset patch
# User Alain Mazy <am@orthanc.team>
# Date 1761643751 -3600
# Node ID 502f8cbd533e12b33e6ed97c42863b8c67c30765
# Parent  7de5b2b090723973b1fb7c149d98bc1746688f71
Test DicomIdentifiersIndexGroupElementValue

diff -r 7de5b2b09072 -r 502f8cbd533e NEWS
--- a/NEWS	Fri Oct 17 14:44:26 2025 +0200
+++ b/NEWS	Tue Oct 28 10:29:11 2025 +0100
@@ -1,6 +1,8 @@
 Pending changes in the mainline
 ===============================
 
+TODO: finalize DicomIdentifiersIndex (upgrade from existing DB)
+
 General
 -------
 
diff -r 7de5b2b09072 -r 502f8cbd533e OrthancServer/Sources/Database/PrepareDatabase.sql
--- a/OrthancServer/Sources/Database/PrepareDatabase.sql	Fri Oct 17 14:44:26 2025 +0200
+++ b/OrthancServer/Sources/Database/PrepareDatabase.sql	Tue Oct 28 10:29:11 2025 +0100
@@ -107,9 +107,11 @@
 
 -- The 3 following indexes were added in Orthanc 0.8.5 (database v5)
 CREATE INDEX DicomIdentifiersIndex1 ON DicomIdentifiers(id);
-CREATE INDEX DicomIdentifiersIndex2 ON DicomIdentifiers(tagGroup, tagElement);
+-- CREATE INDEX DicomIdentifiersIndex2 ON DicomIdentifiers(tagGroup, tagElement);  -- disabled in 1.12.10
 CREATE INDEX DicomIdentifiersIndexValues ON DicomIdentifiers(value COLLATE BINARY);
 
+CREATE INDEX DicomIdentifiersIndexGroupElementValue ON DicomIdentifiers(tagGroup, tagElement, value); -- added in 1.12.10
+
 CREATE INDEX ChangesIndex ON Changes(internalId);