aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2014-10-04 00:48:04 +0200
committerShauren <shauren.trinity@gmail.com>2014-10-04 19:13:54 +0200
commitcc95d7ebbe573e5c9e7eddf924ac67d2838a5685 (patch)
tree48d323d0b542b84008b80bb21d33f4361cdce13a /sql
parent973df92043a53f309b54eb667f3e6c70d3e86bf3 (diff)
Core/Authserver: Updated battle.net structures to 6.0.2.18973
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql14
-rw-r--r--sql/updates/auth/2014_10_04_00_auth_6x.sql8
2 files changed, 13 insertions, 9 deletions
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);