From 1113338d79cb55574ef33f5f60798de61613c871 Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
Date: Tue, 9 Sep 2025 14:07:09 +0200
Subject: DB: Add index to quest_tracker

Closes #31241

(cherry picked from commit f9a6d912891294e2b13f18356784f1d94a743586)
---
 sql/updates/characters/master/2025_09_09_00_characters.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql/updates/characters/master/2025_09_09_00_characters.sql

(limited to 'sql/updates')

diff --git a/sql/updates/characters/master/2025_09_09_00_characters.sql b/sql/updates/characters/master/2025_09_09_00_characters.sql
new file mode 100644
index 00000000000..dab74f06fb7
--- /dev/null
+++ b/sql/updates/characters/master/2025_09_09_00_characters.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `quest_tracker`
+  DROP PRIMARY KEY,
+  ADD UNIQUE INDEX `idx_latest_quest_for_character`(`id`, `character_guid`, `quest_accept_time` DESC);
-- 
cgit v1.2.3