From 452cae0c0b343597c3e6721fd5aa57fd787a06c9 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 10 Jul 2016 14:41:18 +0200 Subject: Core/Items: Fixed saving gem bonuses --- sql/updates/characters/2016_xx_xx_xx_characters_legion_09.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/characters/2016_xx_xx_xx_characters_legion_09.sql (limited to 'sql') diff --git a/sql/updates/characters/2016_xx_xx_xx_characters_legion_09.sql b/sql/updates/characters/2016_xx_xx_xx_characters_legion_09.sql new file mode 100644 index 00000000000..993f227ce30 --- /dev/null +++ b/sql/updates/characters/2016_xx_xx_xx_characters_legion_09.sql @@ -0,0 +1,7 @@ +ALTER TABLE `item_instance_gems` + ADD `gemBonuses1` TEXT AFTER `gemItemId1`, + ADD `gemContext1` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `gemBonuses1`, + ADD `gemBonuses2` TEXT AFTER `gemItemId2`, + ADD `gemContext2` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `gemBonuses2`, + ADD `gemBonuses3` TEXT AFTER `gemItemId3`, + ADD `gemContext3` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `gemBonuses3`; -- cgit v1.2.3