TDB 1005.23021 - 2023/02/03TDB1005.23021

8 files changed, 1 insertions, 54 deletions

diff --git a/sql/updates/auth/master/2022_12_21_00_auth.sql b/sql/updates/auth/master/2022_12_21_00_auth.sql
deleted file mode 100644
index 22b06004f51..00000000000
--- a/sql/updates/auth/master/2022_12_21_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=47213;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(47213,10,0,2,NULL,NULL,'23C50D88CEAC0A8696ADDE8DD244D4A2',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=47213 WHERE `gamebuild`=47187;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '47213';
diff --git a/sql/updates/auth/master/2022_12_22_00_auth.sql b/sql/updates/auth/master/2022_12_22_00_auth.sql
deleted file mode 100644
index 3516d88b5c7..00000000000
--- a/sql/updates/auth/master/2022_12_22_00_auth.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=775;
-DELETE FROM `rbac_permissions` WHERE `id`=775;
-
-INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
-(775,'Command: modify currency');
-
-INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
-(197,775);
diff --git a/sql/updates/auth/master/2023_01_17_00_auth.sql b/sql/updates/auth/master/2023_01_17_00_auth.sql
deleted file mode 100644
index b1bb4b298b5..00000000000
--- a/sql/updates/auth/master/2023_01_17_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=47631;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(47631,10,0,2,NULL,NULL,'F986AB91D0AEB20822EFB72F4256713C',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=47631 WHERE `gamebuild`=47213;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '47631';
diff --git a/sql/updates/auth/master/2023_01_28_00_auth.sql b/sql/updates/auth/master/2023_01_28_00_auth.sql
deleted file mode 100644
index ac8e0126865..00000000000
--- a/sql/updates/auth/master/2023_01_28_00_auth.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (47777,47799,47825,47849);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(47777,10,0,5,NULL,NULL,'A88C04915AB9E035A104E55C4DCF5F9F',NULL,NULL,NULL),
-(47799,10,0,5,NULL,NULL,'7364EB093C23DB2CDC9513D5A7B4933E',NULL,NULL,NULL),
-(47825,10,0,5,NULL,NULL,'82A3B94E5E727AF3A208B471FF2054C0',NULL,NULL,NULL),
-(47849,10,0,5,NULL,NULL,'DD8BBE2087A28C0AF4984CBE23A1C707',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=47849 WHERE `gamebuild`=47631;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '47849';
diff --git a/sql/updates/auth/master/2023_01_28_01_auth.sql b/sql/updates/auth/master/2023_01_28_01_auth.sql
deleted file mode 100644
index 7e37f45abda..00000000000
--- a/sql/updates/auth/master/2023_01_28_01_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=47871;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(47871,10,0,5,NULL,NULL,'8E4F7D30EE4982B02B3B3F8837C2C4F2',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=47871 WHERE `gamebuild`=47849;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '47871';
diff --git a/sql/updates/auth/master/2023_02_01_00_auth.sql b/sql/updates/auth/master/2023_02_01_00_auth.sql
deleted file mode 100644
index 878ffc32480..00000000000
--- a/sql/updates/auth/master/2023_02_01_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=47884;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(47884,10,0,5,NULL,NULL,'2B7A002BC359F2C31104BC2DE04302BF',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=47884 WHERE `gamebuild`=47871;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '47884';
diff --git a/sql/updates/auth/master/2023_02_02_00_auth.sql b/sql/updates/auth/master/2023_02_02_00_auth.sql
deleted file mode 100644
index 5893c999a19..00000000000
--- a/sql/updates/auth/master/2023_02_02_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=47936;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(47936,10,0,5,NULL,NULL,'833D30D8FBC43B3FAE99CD3898D70849',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=47936 WHERE `gamebuild`=47884;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '47936';
diff --git a/sql/updates/auth/master/2022_12_20_00_auth.sql b/sql/updates/auth/master/2023_02_03_00_auth.sql
index 36ae1aeddab..be4f170bd17 100644
--- a/sql/updates/auth/master/2022_12_20_00_auth.sql
+++ b/sql/updates/auth/master/2023_02_03_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 1002.22121 auth
+-- TDB 1005.23021 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/auth', 'ARCHIVED');