2 files changed, 54 insertions, 0 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 27a9f4be522..4abfe487c20 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -168,6 +168,56 @@ LOCK TABLES `autobroadcast` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `battle_pets`
+--
+
+DROP TABLE IF EXISTS `battle_pets`;
+CREATE TABLE `battle_pets` (
+  `guid` bigint(20) NOT NULL,
+  `battlenetAccountId` int(10) NOT NULL,
+  `species` int(10) NOT NULL,
+  `breed` smallint(5) NOT NULL,
+  `level` smallint(5) NOT NULL DEFAULT '1',
+  `exp` smallint(5) NOT NULL DEFAULT '0',
+  `health` int(10) NOT NULL DEFAULT '1',
+  `quality` tinyint(3) NOT NULL DEFAULT '0',
+  `flags` smallint(5) NOT NULL DEFAULT '0',
+  `name` varchar(12) NOT NULL,
+  PRIMARY KEY (`guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `battle_pets`
+--
+
+LOCK TABLES `battle_pets` WRITE;
+/*!40000 ALTER TABLE `battle_pets` DISABLE KEYS */;
+/*!40000 ALTER TABLE `battle_pets` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `battle_pet_slots`
+--
+
+DROP TABLE IF EXISTS `battle_pet_slots`;
+CREATE TABLE `battle_pet_slots` (
+  `id` tinyint(3) NOT NULL,
+  `battlenetAccountId` int(10) NOT NULL,
+  `battlePetGuid` bigint(20) NOT NULL,
+  `locked` tinyint(3) NOT NULL DEFAULT '1',
+  PRIMARY KEY (`id`,`battlenetAccountId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `battle_pet_slots`
+--
+
+LOCK TABLES `battle_pet_slots` WRITE;
+/*!40000 ALTER TABLE `battle_pet_slots` DISABLE KEYS */;
+/*!40000 ALTER TABLE `battle_pet_slots` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `battlenet_account_bans`
 --
 
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 57db40a7ee4..50195e9bda7 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2523,6 +2523,10 @@ CREATE TABLE `item_instance` (
   `transmogrification` int(10) unsigned NOT NULL DEFAULT '0',
   `upgradeId` int(10) unsigned NOT NULL DEFAULT '0',
   `enchantIllusion` int(10) unsigned NOT NULL DEFAULT '0',
+  `battlePetSpeciesId` int(10) unsigned NOT NULL DEFAULT '0',
+  `battlePetBreedData` int(10) unsigned NOT NULL DEFAULT '0',
+  `battlePetLevel` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `battlePetDisplayId` int(10) unsigned NOT NULL DEFAULT '0',
   `bonusListIDs` text,
   PRIMARY KEY (`guid`),
   KEY `idx_owner_guid` (`owner_guid`)