diff options
| author | Meji <alvaro.megias@outlook.com> | 2025-01-04 18:08:09 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-01-04 18:08:09 +0100 |
| commit | c9099c87567ead635811ef71b990ae7f19103509 (patch) | |
| tree | 55d41c16c0d5f06e045b7f10e9f3d22a2edecdd1 /sql/updates/characters | |
| parent | 6f326d5b361e34fd017cd561f927466ec26dd31c (diff) | |
Core/Misc: Implemented spawn tracking (#30247)
Diffstat (limited to 'sql/updates/characters')
| -rw-r--r-- | sql/updates/characters/master/2025_01_04_00_characters.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/characters/master/2025_01_04_00_characters.sql b/sql/updates/characters/master/2025_01_04_00_characters.sql new file mode 100644 index 00000000000..5c6240f6344 --- /dev/null +++ b/sql/updates/characters/master/2025_01_04_00_characters.sql @@ -0,0 +1,8 @@ +DROP TABLE IF EXISTS `character_queststatus_objectives_spawn_tracking`; +CREATE TABLE `character_queststatus_objectives_spawn_tracking` ( + `guid` BIGINT UNSIGNED NOT NULL, + `quest` INT UNSIGNED NOT NULL, + `objective` TINYINT UNSIGNED NOT NULL DEFAULT '0', + `spawnTrackingId` INT UNSIGNED NOT NULL, + PRIMARY KEY (`guid`,`quest`,`objective`,`spawnTrackingId`) +) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |