aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
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/updates/auth
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/updates/auth')
-rw-r--r--sql/updates/auth/2015_08_26_00_auth.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/auth/2015_08_26_00_auth.sql b/sql/updates/auth/2015_08_26_00_auth.sql
new file mode 100644
index 00000000000..e01f9c50a24
--- /dev/null
+++ b/sql/updates/auth/2015_08_26_00_auth.sql
@@ -0,0 +1,8 @@
+DROP TABLE IF EXISTS `battlenet_account_toys`;
+
+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;