diff options
| author | Shauren <shauren.trinity@gmail.com> | 2025-09-09 14:07:09 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2025-09-09 14:12:20 +0200 |
| commit | 1113338d79cb55574ef33f5f60798de61613c871 (patch) | |
| tree | 9956fe72b519658e8911c184cb2bb660d3d0d7cd /sql/updates | |
| parent | 60ef8a085dfacc4e382fd86c19baceb7a40b6f8f (diff) | |
DB: Add index to quest_tracker
Closes #31241
(cherry picked from commit f9a6d912891294e2b13f18356784f1d94a743586)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/master/2025_09_09_00_characters.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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); |