Core/Player: Implemented account wide mounts

Closes #17369

2 files changed, 69 insertions, 0 deletions

diff --git a/sql/updates/auth/6.x/2016_10_01_00_auth.sql b/sql/updates/auth/6.x/2016_10_01_00_auth.sql
new file mode 100644
index 00000000000..de3ddcc1d2c
--- /dev/null
+++ b/sql/updates/auth/6.x/2016_10_01_00_auth.sql
@@ -0,0 +1,10 @@
+--
+-- Table structure for table `battlenet_account_mounts`
+--
+DROP TABLE IF EXISTS `battlenet_account_mounts`;
+CREATE TABLE `battlenet_account_mounts` (
+  `battlenetAccountId` int(10) unsigned NOT NULL,
+  `mountSpellId` int(10) unsigned NOT NULL,
+  `flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`battlenetAccountId`,`mountSpellId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/world/6.x/2016_10_00_00_world.sql b/sql/updates/world/6.x/2016_10_00_00_world.sql
new file mode 100644
index 00000000000..2a51293f498
--- /dev/null
+++ b/sql/updates/world/6.x/2016_10_00_00_world.sql
@@ -0,0 +1,59 @@
+DROP TABLE IF EXISTS `mount_definitions`;
+CREATE TABLE `mount_definitions`(
+  `spellId` int(10) unsigned NOT NULL,
+  `otherFactionSpellId` int(10) unsigned NOT NULL,
+  PRIMARY KEY (`spellId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+DELETE FROM `mount_definitions`;
+INSERT INTO `mount_definitions` (`spellId`,`otherFactionSpellId`) VALUES
+(17229,64658),
+(23509,23510),
+(23510,23509),
+(55531,60424),
+(59785,59788),
+(59788,59785),
+(59797,59799),
+(59799,59797),
+(60114,60116),
+(60116,60114),
+(60118,60119),
+(60119,60118),
+(60424,55531),
+(61229,61230),
+(61230,61229),
+(61425,61447),
+(61447,61425),
+(61465,61467),
+(61467,61465),
+(61469,61470),
+(61470,61469),
+(61996,61997),
+(61997,61996),
+(64658,17229),
+(66087,66088),
+(66088,66087),
+(66090,66091),
+(66091,66090),
+(90621,93644),
+(92231,92232),
+(92232,92231),
+(93644,90621),
+(107516,107517),
+(107517,107516),
+(118737,130985),
+(130985,118737),
+(135416,135418),
+(135418,135416),
+(136163,136164),
+(136164,136163),
+(140249,140250),
+(140250,140249),
+(142266,142478),
+(142478,142266),
+(171625,171842),
+(171626,171839),
+(171839,171626),
+(171842,171625),
+(179244,179245),
+(179245,179244);