Core/Items: Fixed item level increases of gems with bonuses that give them scaling stat distribution

1 files changed, 10 insertions, 0 deletions

diff --git a/sql/updates/characters/master/2016_12_09_00_characters.sql b/sql/updates/characters/master/2016_12_09_00_characters.sql
new file mode 100644
index 00000000000..5cf06fde71c
--- /dev/null
+++ b/sql/updates/characters/master/2016_12_09_00_characters.sql
@@ -0,0 +1,10 @@
+ALTER TABLE `item_instance_gems`
+  CHANGE `gemItemId1` `gemItemId1` int(10) unsigned NOT NULL DEFAULT '0',
+  CHANGE `gemBonuses1` `gemBonuses1` text,
+  ADD `gemScalingLevel1` int(10) unsigned NOT NULL DEFAULT '0' AFTER `gemContext1`,
+  CHANGE `gemItemId2` `gemItemId2` int(10) unsigned NOT NULL DEFAULT '0',
+  CHANGE `gemBonuses2` `gemBonuses2` text,
+  ADD `gemScalingLevel2` int(10) unsigned NOT NULL DEFAULT '0' AFTER `gemBonuses2`,
+  CHANGE `gemItemId3` `gemItemId3` int(10) unsigned NOT NULL DEFAULT 0,
+  CHANGE `gemBonuses3` `gemBonuses3` text,
+  ADD `gemScalingLevel3` int(10) unsigned NOT NULL DEFAULT '0' AFTER `gemContext3`;