aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql6
-rw-r--r--sql/updates/auth/2014_06_08_01_auth_account_434.sql3
2 files changed, 3 insertions, 6 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 6dca9aa1e14..3ccbadbbda0 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -216,18 +216,12 @@ LOCK TABLES `battlenet_components` WRITE;
/*!40000 ALTER TABLE `battlenet_components` DISABLE KEYS */;
INSERT INTO `battlenet_components` VALUES
('Bnet','Cmp1',3),
-('Bnet','Win',21719),
('Bnet','Win',26487),
('Bnet','Wn64',26487),
-('Tool','Win',1569),
('Tool','Win',2736),
-('WoW','base',12340),
('WoW','base',15595),
-('WoW','enGB',12340),
('WoW','enGB',15595),
-('WoW','enUS',12340),
('WoW','enUS',15595),
-('WoW','Win',12340),
('WoW','Win',15595),
('WoW','Wn64',15595);
/*!40000 ALTER TABLE `battlenet_components` ENABLE KEYS */;
diff --git a/sql/updates/auth/2014_06_08_01_auth_account_434.sql b/sql/updates/auth/2014_06_08_01_auth_account_434.sql
new file mode 100644
index 00000000000..dc05a98d17b
--- /dev/null
+++ b/sql/updates/auth/2014_06_08_01_auth_account_434.sql
@@ -0,0 +1,3 @@
+DELETE FROM `battlenet_components` WHERE `Program`='WoW' AND `Build`=12340;
+DELETE FROM `battlenet_components` WHERE `Program`='Tool' AND `Build`=1569;
+DELETE FROM `battlenet_components` WHERE `Program`='Bnet' AND `Build`=21719;