aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
authorMitchesD <majklprofik@seznam.cz>2015-08-26 11:12:35 +0200
committerMitchesD <majklprofik@seznam.cz>2015-08-26 11:15:00 +0200
commit614b5832ba96b4c5905ece5490a7b5d18c2f710b (patch)
tree454e71dfcab1da90490466dfebd69a115950866d /sql/base
parentca5c5221ba8376d152a4c8216afd922924475802 (diff)
Core/Player: implemented Toybox
* now you can use all the things in toybox - add new toys, set them as favorite and use them
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/auth_database.sql26
1 files changed, 25 insertions, 1 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 0a7528d4ca8..54ebdf24e15 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -194,6 +194,30 @@ LOCK TABLES `battlenet_account_bans` WRITE;
UNLOCK TABLES;
--
+-- Table structure for table `battlenet_account_toys`
+--
+
+DROP TABLE IF EXISTS `battlenet_account_toys`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `battlenet_account_toys` (
+ `accountId` int(10) unsigned NOT NULL,
+ `itemId` int(11) NOT NULL DEFAULT '0',
+ `isFavourite` tinyint(1) DEFAULT '0',
+ PRIMARY KEY (`accountId`,`itemId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `battlenet_account_toys`
+--
+
+LOCK TABLES `battlenet_account_toys` WRITE;
+/*!40000 ALTER TABLE `battlenet_account_toys` DISABLE KEYS */;
+/*!40000 ALTER TABLE `battlenet_account_toys` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
-- Table structure for table `battlenet_accounts`
--
@@ -671,4 +695,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2015-07-13 23:49:27
+-- Dump completed on 2015-08-25 22:49:45