From 97a3f52d4caffdf7eb516050d400bf6b3f958836 Mon Sep 17 00:00:00 2001 From: MitchesD Date: Fri, 2 Oct 2015 13:00:56 +0200 Subject: DB/Auth: corrected base auth database dump --- sql/base/auth_database.sql | 50 ++++++++++++++++++++++++++-------------------- 1 file changed, 28 insertions(+), 22 deletions(-) (limited to 'sql/base') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 4abfe487c20..99a850ad9e1 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -167,11 +167,38 @@ LOCK TABLES `autobroadcast` WRITE; /*!40000 ALTER TABLE `autobroadcast` ENABLE KEYS */; UNLOCK TABLES; +-- +-- Table structure for table `battle_pet_slots` +-- + +DROP TABLE IF EXISTS `battle_pet_slots`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- 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 `battle_pets` -- DROP TABLE IF EXISTS `battle_pets`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `battle_pets` ( `guid` bigint(20) NOT NULL, `battlenetAccountId` int(10) NOT NULL, @@ -185,6 +212,7 @@ CREATE TABLE `battle_pets` ( `name` varchar(12) NOT NULL, PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `battle_pets` @@ -195,28 +223,6 @@ LOCK TABLES `battle_pets` WRITE; /*!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