aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
authorMitchesD <majklprofik@seznam.cz>2015-09-09 16:15:32 +0200
committerMitchesD <majklprofik@seznam.cz>2015-09-09 16:15:32 +0200
commit8e6886cecd5700facd95d52d3fbd4a2689d81d5f (patch)
treebedeb266d1114666983e6b7ce947e87d65446308 /sql/updates/characters
parente0fcb410b4d08119b7e72f154d7eed8cd2bd1e0f (diff)
parente8b1faa1562c85a9e7d63af68d750cd574c0e396 (diff)
Merge pull request #15139 from horn/6.x
Core/BattlePets: Basics for Battle Pets
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/2015_09_09_00_characters.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/characters/2015_09_09_00_characters.sql b/sql/updates/characters/2015_09_09_00_characters.sql
new file mode 100644
index 00000000000..d6ceca53f38
--- /dev/null
+++ b/sql/updates/characters/2015_09_09_00_characters.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `item_instance`
+ ADD `battlePetSpeciesId` int(10) unsigned NOT NULL DEFAULT '0' AFTER `enchantIllusion`,
+ ADD `battlePetBreedData` int(10) unsigned NOT NULL DEFAULT '0' AFTER `battlePetSpeciesId`,
+ ADD `battlePetLevel` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `battlePetBreedData`,
+ ADD `battlePetDisplayId` int(10) unsigned NOT NULL DEFAULT '0' AFTER `battlePetLevel`;