From dde620c402daf4ea8d132fb72a77eabc22f7a6d0 Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
Date: Mon, 28 Mar 2016 17:12:57 +0200
Subject: Core: Updated to 6.2.4

* Rewrite bnetserver for new authentication protocol
---
 sql/updates/auth/2016_03_28_00_auth.sql | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 sql/updates/auth/2016_03_28_00_auth.sql

(limited to 'sql/updates')

diff --git a/sql/updates/auth/2016_03_28_00_auth.sql b/sql/updates/auth/2016_03_28_00_auth.sql
new file mode 100644
index 00000000000..2adcb9bce4c
--- /dev/null
+++ b/sql/updates/auth/2016_03_28_00_auth.sql
@@ -0,0 +1,21 @@
+DROP TABLE IF EXISTS `battlenet_components`;
+DROP TABLE IF EXISTS `battlenet_modules`;
+
+DROP TABLE IF EXISTS `account_last_played_character`;
+CREATE TABLE `account_last_played_character` (
+  `accountId` int(10) unsigned NOT NULL,
+  `region` tinyint(3) unsigned NOT NULL,
+  `battlegroup` tinyint(3) unsigned NOT NULL,
+  `realmId` int(10) unsigned,
+  `characterName` varchar(12),
+  `characterGUID` bigint(20) unsigned,
+  `lastPlayedTime` int(10) unsigned,
+  PRIMARY KEY(`accountId`,`region`,`battlegroup`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+ALTER TABLE `battlenet_accounts`
+  DROP `s`,
+  DROP `v`,
+  DROP `sessionKey`;
+
+UPDATE `realmlist` SET `gamebuild`=21355 WHERE `gamebuild`=20726;
-- 
cgit v1.2.3