From cc95d7ebbe573e5c9e7eddf924ac67d2838a5685 Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
Date: Sat, 4 Oct 2014 00:48:04 +0200
Subject: Core/Authserver: Updated battle.net structures to 6.0.2.18973

---
 sql/base/auth_database.sql                 | 14 +++++---------
 sql/updates/auth/2014_10_04_00_auth_6x.sql |  8 ++++++++
 2 files changed, 13 insertions(+), 9 deletions(-)
 create mode 100644 sql/updates/auth/2014_10_04_00_auth_6x.sql

(limited to 'sql')

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index e5f45f9ff5c..d743e393618 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -216,15 +216,11 @@ CREATE TABLE `battlenet_components` (
 LOCK TABLES `battlenet_components` WRITE;
 /*!40000 ALTER TABLE `battlenet_components` DISABLE KEYS */;
 INSERT INTO `battlenet_components` VALUES
-('Bnet','Cmp1',3),
-('Bnet','Win',26487),
-('Bnet','Wn64',26487),
-('Tool','Win',2736),
-('WoW','base',15595),
-('WoW','enGB',15595),
-('WoW','enUS',15595),
-('WoW','Win',15595),
-('WoW','Wn64',15595);
+('Bnet','Win',37165),
+('Bnet','Wn64',37165),
+('WoW','base',18973),
+('WoWB','Win',18973),
+('WoWB','Wn64',18973);
 /*!40000 ALTER TABLE `battlenet_components` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/auth/2014_10_04_00_auth_6x.sql b/sql/updates/auth/2014_10_04_00_auth_6x.sql
new file mode 100644
index 00000000000..61731b408b6
--- /dev/null
+++ b/sql/updates/auth/2014_10_04_00_auth_6x.sql
@@ -0,0 +1,8 @@
+DELETE FROM `battlenet_components` WHERE `Build`=18973 AND `Program`!='Bnet';
+DELETE FROM `battlenet_components` WHERE `Build`=37165 AND `Program`='Bnet';
+INSERT INTO `battlenet_components` VALUES
+('Bnet','Win',37165),
+('Bnet','Wn64',37165),
+('WoW','base',18973),
+('WoWB','Win',18973),
+('WoWB','Wn64',18973);
-- 
cgit v1.2.3