From e8b1faa1562c85a9e7d63af68d750cd574c0e396 Mon Sep 17 00:00:00 2001 From: horn Date: Wed, 9 Sep 2015 14:52:32 +0200 Subject: Core/BattlePets: Basics for Battle Pets --- sql/base/auth_database.sql | 50 ++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 50 insertions(+) (limited to 'sql/base/auth_database.sql') 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 @@ -167,6 +167,56 @@ LOCK TABLES `autobroadcast` WRITE; /*!40000 ALTER TABLE `autobroadcast` ENABLE KEYS */; 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` -- -- cgit v1.2.3