aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql28
-rw-r--r--sql/updates/auth/master/2025_11_18_00_auth.sql23
-rw-r--r--sql/updates/auth/master/2025_11_19_00_auth.sql23
3 files changed, 69 insertions, 5 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 2f4aaa1c384..51904bee814 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1341,7 +1341,21 @@ INSERT INTO `build_auth_key` VALUES
(64395,'Mac','x64','WoWC',0xB9EE0DED365A0D1ADCC780CF91708136),
(64395,'Win','A64','WoW',0x3084B511A81DBD956D09C74BE18E6C12),
(64395,'Win','x64','WoW',0x927C362C2B951B50D63F203C88BBB4BD),
-(64395,'Win','x64','WoWC',0xB00C9B95D14079E04B937B0DED2C1247);
+(64395,'Win','x64','WoWC',0xB00C9B95D14079E04B937B0DED2C1247),
+(64484,'Mac','A64','WoW',0x208FD6C24C40FDA62A4B3314E4E25336),
+(64484,'Mac','A64','WoWC',0xD2D29647DE175101CEF35C10D671BF94),
+(64484,'Mac','x64','WoW',0x3B2D2B6D9CE0957F7307E4D8E649B1B0),
+(64484,'Mac','x64','WoWC',0x7F843C10B9FE9A3F2C200E8DDEF7CFAD),
+(64484,'Win','A64','WoW',0x0D7B806EF0D5640724866D8842590992),
+(64484,'Win','x64','WoW',0x2DD6D7583BB976AF101585B572C4CC41),
+(64484,'Win','x64','WoWC',0x21F23079D5EA654F8D21B80C93DD1A34),
+(64502,'Mac','A64','WoW',0x9F782C29580703ECF3148E3E78B3B45B),
+(64502,'Mac','A64','WoWC',0x17168E59E27ECE41AAD719777413668F),
+(64502,'Mac','x64','WoW',0xDA795FF3960DE8212AD6C97C4619BFD0),
+(64502,'Mac','x64','WoWC',0x6DCE3BA9C0ACF638AE599680200483AE),
+(64502,'Win','A64','WoW',0x51DF09ABE30D38142EB5942ED774301B),
+(64502,'Win','x64','WoW',0x54D307CF2BC84E50E94C2D3A95CD6D7B),
+(64502,'Win','x64','WoWC',0xA968CFA8B0558F433B3E483E844FBFC3);
/*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1756,7 +1770,9 @@ INSERT INTO `build_info` VALUES
(63906,11,2,5,NULL),
(64154,11,2,5,NULL),
(64270,11,2,5,NULL),
-(64395,11,2,5,NULL);
+(64395,11,2,5,NULL),
+(64484,11,2,5,NULL),
+(64502,11,2,5,NULL);
/*!40000 ALTER TABLE `build_info` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3369,7 +3385,7 @@ CREATE TABLE `realmlist` (
`timezone` tinyint unsigned NOT NULL DEFAULT '0',
`allowedSecurityLevel` tinyint unsigned NOT NULL DEFAULT '0',
`population` float NOT NULL DEFAULT '0',
- `gamebuild` int unsigned NOT NULL DEFAULT '64395',
+ `gamebuild` int unsigned NOT NULL DEFAULT '64502',
`Region` tinyint unsigned NOT NULL DEFAULT '1',
`Battlegroup` tinyint unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
@@ -3384,7 +3400,7 @@ CREATE TABLE `realmlist` (
LOCK TABLES `realmlist` WRITE;
/*!40000 ALTER TABLE `realmlist` DISABLE KEYS */;
INSERT INTO `realmlist` VALUES
-(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,64395,1,1);
+(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,64502,1,1);
/*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3912,7 +3928,9 @@ INSERT INTO `updates` VALUES
('2025_10_29_00_auth.sql','CA6DC3F6A070AD894AB0DF2B21168D1BD7445A38','ARCHIVED','2025-10-29 06:57:00',0),
('2025_10_30_00_auth.sql','BEBD6BC06B857C182BAD8A0DCAAF5B6AFEA2DFE7','RELEASED','2025-10-30 18:24:07',0),
('2025_11_07_00_auth.sql','496BAF87666950FDBA459CC72472AAB4CBD71D40','RELEASED','2025-11-07 09:46:17',0),
-('2025_11_15_00_auth.sql','744E145E7EFBADDAF0BAC00F6FC84A1FE79EDFCA','RELEASED','2025-11-15 12:09:00',0);
+('2025_11_15_00_auth.sql','744E145E7EFBADDAF0BAC00F6FC84A1FE79EDFCA','RELEASED','2025-11-15 12:09:00',0),
+('2025_11_18_00_auth.sql','AAE3FEB4363A16253C7ADF8CF5973E3694C5BC52','RELEASED','2025-11-18 20:09:47',0),
+('2025_11_19_00_auth.sql','2E89C66714539C9713B9ADD3F7697730A426C795','RELEASED','2025-11-19 08:20:00',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
diff --git a/sql/updates/auth/master/2025_11_18_00_auth.sql b/sql/updates/auth/master/2025_11_18_00_auth.sql
new file mode 100644
index 00000000000..c212a264df3
--- /dev/null
+++ b/sql/updates/auth/master/2025_11_18_00_auth.sql
@@ -0,0 +1,23 @@
+DELETE FROM `build_info` WHERE `build` IN (64484);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
+(64484,11,2,5,NULL);
+
+DELETE FROM `build_auth_key` WHERE `build`=64484 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=64484 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=64484 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=64484 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=64484 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=64484 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=64484 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
+INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
+(64484,'Mac','A64','WoW',0x208FD6C24C40FDA62A4B3314E4E25336),
+(64484,'Mac','A64','WoWC',0xD2D29647DE175101CEF35C10D671BF94),
+(64484,'Mac','x64','WoW',0x3B2D2B6D9CE0957F7307E4D8E649B1B0),
+(64484,'Mac','x64','WoWC',0x7F843C10B9FE9A3F2C200E8DDEF7CFAD),
+(64484,'Win','A64','WoW',0x0D7B806EF0D5640724866D8842590992),
+(64484,'Win','x64','WoW',0x2DD6D7583BB976AF101585B572C4CC41),
+(64484,'Win','x64','WoWC',0x21F23079D5EA654F8D21B80C93DD1A34);
+
+UPDATE `realmlist` SET `gamebuild`=64484 WHERE `gamebuild`=64395;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '64484';
diff --git a/sql/updates/auth/master/2025_11_19_00_auth.sql b/sql/updates/auth/master/2025_11_19_00_auth.sql
new file mode 100644
index 00000000000..9f835567a7c
--- /dev/null
+++ b/sql/updates/auth/master/2025_11_19_00_auth.sql
@@ -0,0 +1,23 @@
+DELETE FROM `build_info` WHERE `build` IN (64502);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
+(64502,11,2,5,NULL);
+
+DELETE FROM `build_auth_key` WHERE `build`=64502 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=64502 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=64502 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=64502 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=64502 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=64502 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=64502 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
+INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
+(64502,'Mac','A64','WoW',0x9F782C29580703ECF3148E3E78B3B45B),
+(64502,'Mac','A64','WoWC',0x17168E59E27ECE41AAD719777413668F),
+(64502,'Mac','x64','WoW',0xDA795FF3960DE8212AD6C97C4619BFD0),
+(64502,'Mac','x64','WoWC',0x6DCE3BA9C0ACF638AE599680200483AE),
+(64502,'Win','A64','WoW',0x51DF09ABE30D38142EB5942ED774301B),
+(64502,'Win','x64','WoW',0x54D307CF2BC84E50E94C2D3A95CD6D7B),
+(64502,'Win','x64','WoWC',0xA968CFA8B0558F433B3E483E844FBFC3);
+
+UPDATE `realmlist` SET `gamebuild`=64502 WHERE `gamebuild`=64484;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '64502';