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 | |
| parent | 60ef8a085dfacc4e382fd86c19baceb7a40b6f8f (diff) | |
DB: Add index to quest_tracker
Closes #31241
(cherry picked from commit f9a6d912891294e2b13f18356784f1d94a743586)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/characters/master/2025_09_09_00_characters.sql | 3 |
2 files changed, 6 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index ae3b94c4056..f7459ab4aa2 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -3547,7 +3547,7 @@ CREATE TABLE `quest_tracker` ( `completed_by_gm` tinyint(1) NOT NULL DEFAULT '0', `core_hash` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `core_revision` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', - PRIMARY KEY (`id`,`character_guid`) + UNIQUE KEY `idx_latest_quest_for_character` (`id`,`character_guid`,`quest_accept_time` DESC) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3823,7 +3823,8 @@ INSERT INTO `updates` VALUES ('2025_07_21_00_characters.sql','056A99B9AA90186E5B3177BF54C86607B6518BE9','ARCHIVED','2025-07-21 22:51:05',0), ('2025_08_13_00_characters.sql','0A559553A1DD9FC973AB01C3B1A9284B07CFBB36','ARCHIVED','2025-08-12 20:17:45',0), ('2025_08_16_00_characters.sql','8DF6284B6C7BEDAB599F7E4802FF8BCD80613A92','ARCHIVED','2025-08-16 14:58:22',0), -('2025_08_19_00_characters.sql','EC197D88883CDA2B885675FE096DD56CCB143608','RELEASED','2025-08-19 01:03:26',0); +('2025_08_19_00_characters.sql','EC197D88883CDA2B885675FE096DD56CCB143608','RELEASED','2025-08-19 01:03:26',0), +('2025_09_09_00_characters.sql','CF3F0738623248620204175B049AAF0833262222','RELEASED','2025-09-09 14:11:21',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; 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); |