Core/Items: Set and save item context field

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/characters/master/2017_05_08_00_characters.sql b/sql/updates/characters/master/2017_05_08_00_characters.sql
new file mode 100644
index 00000000000..819912fa362
--- /dev/null
+++ b/sql/updates/characters/master/2017_05_08_00_characters.sql
@@ -0,0 +1,7 @@
+ALTER TABLE `item_instance` ADD `context` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `battlePetDisplayId`;
+
+ALTER TABLE `character_void_storage` ADD `context` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `artifactKnowledgeLevel`;
+
+ALTER TABLE `item_loot_items`
+  ADD `context` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `rnd_suffix`,
+  ADD `bonus_list_ids` text COMMENT 'Space separated list of bonus list ids' AFTER `context`;