diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/master/2016_12_09_00_characters.sql | 10 |
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`; |