diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 14 | ||||
| -rw-r--r-- | sql/updates/auth/2014_10_04_00_auth_6x.sql | 8 |
2 files changed, 13 insertions, 9 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index fc762f35c03..47ef5ec9c8b 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -242,15 +242,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); |