1 files changed, 21 insertions, 0 deletions
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;