aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2020-12-13 18:38:31 +0100
committerShauren <shauren.trinity@gmail.com>2020-12-13 18:38:31 +0100
commit93f2affbf2f70c619cdc41b073dd19827df20448 (patch)
treebe8a2ec3e25ad3109feb8450660d52eb2955789b /sql/updates/characters
parent015666b0442ac2d4f34874da068f31f58d2580e9 (diff)
Core/Corpses: Fixed client crashes with player corpses
Closes #25714
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/master/2020_12_13_00_characters.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/characters/master/2020_12_13_00_characters.sql b/sql/updates/characters/master/2020_12_13_00_characters.sql
new file mode 100644
index 00000000000..e0a3bb433e8
--- /dev/null
+++ b/sql/updates/characters/master/2020_12_13_00_characters.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `corpse` ADD `class` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `race`;
+
+UPDATE `corpse` SET `class`=(SELECT c.`class` FROM `characters` c WHERE c.`guid`=`guid`);