SQL: Updated battlenet_components to current build

2 files changed, 34 insertions, 3 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index bed40c618b2..caeba7ec348 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -243,11 +243,23 @@ CREATE TABLE `battlenet_components` (
 LOCK TABLES `battlenet_components` WRITE;
 /*!40000 ALTER TABLE `battlenet_components` DISABLE KEYS */;
 INSERT INTO `battlenet_components` VALUES
+('Bnet','Mc64',37165),
 ('Bnet','Win',37165),
 ('Bnet','Wn64',37165),
-('WoW','base',18973),
-('WoWB','Win',18973),
-('WoWB','Wn64',18973);
+('WoW','base',19057),
+('WoW','deDE',0),
+('WoW','enGB',0),
+('WoW','enUS',0),
+('WoW','esES',0),
+('WoW','esMX',0),
+('WoW','frFR',0),
+('WoW','koKR',0),
+('WoW','Mc64',19116),
+('WoW','ruRU',0),
+('WoW','Win',19116),
+('WoW','Wn64',19116),
+('WoW','zhCN',0),
+('WoW','zhTW',0);
 /*!40000 ALTER TABLE `battlenet_components` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/auth/2014_11_04_00_auth.sql b/sql/updates/auth/2014_11_04_00_auth.sql
new file mode 100644
index 00000000000..5214034fd21
--- /dev/null
+++ b/sql/updates/auth/2014_11_04_00_auth.sql
@@ -0,0 +1,19 @@
+TRUNCATE `battlenet_components`;
+INSERT INTO `battlenet_components` VALUES
+('Bnet','Mc64',37165),
+('Bnet','Win',37165),
+('Bnet','Wn64',37165),
+('WoW','base',19057),
+('WoW','deDE',0),
+('WoW','enGB',0),
+('WoW','enUS',0),
+('WoW','esES',0),
+('WoW','esMX',0),
+('WoW','frFR',0),
+('WoW','koKR',0),
+('WoW','Mc64',19116),
+('WoW','ruRU',0),
+('WoW','Win',19116),
+('WoW','Wn64',19116),
+('WoW','zhCN',0),
+('WoW','zhTW',0);