aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2016-07-10 14:41:18 +0200
committerShauren <shauren.trinity@gmail.com>2016-07-10 14:41:18 +0200
commit452cae0c0b343597c3e6721fd5aa57fd787a06c9 (patch)
tree6c736a54f8cc17fb1d0fe8abcc93b679d1c097e3 /sql
parentee2abfba9102ca4acce334de00a0bca0ae5c624c (diff)
Core/Items: Fixed saving gem bonuses
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/characters/2016_xx_xx_xx_characters_legion_09.sql7
1 files changed, 7 insertions, 0 deletions
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`;