TDB 920.22031 - 2022/03/06TDB920.22031

10 files changed, 1 insertions, 59 deletions

diff --git a/sql/updates/auth/master/2020_08_11_00_auth.sql b/sql/updates/auth/master/2020_08_11_00_auth.sql
deleted file mode 100644
index 16296ac7c90..00000000000
--- a/sql/updates/auth/master/2020_08_11_00_auth.sql
+++ /dev/null
@@ -1,5 +0,0 @@
--- 
-DELETE FROM `rbac_permissions` WHERE `id`=705;
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=705;
-DELETE FROM `rbac_account_permissions` WHERE `permissionId`=705;
-DELETE FROM `rbac_default_permissions` WHERE `permissionId`=705;
diff --git a/sql/updates/auth/master/2020_09_06_00_auth.sql b/sql/updates/auth/master/2020_09_06_00_auth.sql
deleted file mode 100644
index d04bdf6f4fe..00000000000
--- a/sql/updates/auth/master/2020_09_06_00_auth.sql
+++ /dev/null
@@ -1,8 +0,0 @@
--- 
-UPDATE `account` SET `salt`=UNHEX(CONCAT(MD5(RAND()),MD5(RAND()))), `verifier`=UNHEX(CONCAT(MD5(RAND()),MD5(RAND()))) WHERE `salt` IS NULL OR `verifier` IS NULL;
-ALTER TABLE `account`
-    DROP COLUMN `s`,
-    DROP COLUMN `v`,
-    DROP COLUMN `sha_pass_hash`,
-    MODIFY COLUMN `salt` BINARY(32) NOT NULL,
-    MODIFY COLUMN `verifier` BINARY(32) NOT NULL;
diff --git a/sql/updates/auth/master/2020_09_17_00_auth.sql b/sql/updates/auth/master/2020_09_17_00_auth.sql
deleted file mode 100644
index 9cc01ed837e..00000000000
--- a/sql/updates/auth/master/2020_09_17_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- 
-DELETE FROM `rbac_permissions` WHERE `id`= 880;
-INSERT INTO `rbac_permissions` (`id`,`name`) VALUES (880, 'Command: pdump copy');
diff --git a/sql/updates/auth/master/2022_01_22_00_auth.sql b/sql/updates/auth/master/2022_01_22_00_auth.sql
deleted file mode 100644
index 1a7f4c7648c..00000000000
--- a/sql/updates/auth/master/2022_01_22_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=42010;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(42010,9,1,5,NULL,NULL,'302970161D16417B5BE553CC530E011A',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=42010 WHERE `gamebuild`=41793;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '42010';
diff --git a/sql/updates/auth/master/2022_02_25_00_auth.sql b/sql/updates/auth/master/2022_02_25_00_auth.sql
deleted file mode 100644
index 3ea24e07524..00000000000
--- a/sql/updates/auth/master/2022_02_25_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=42423;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(42423,9,2,0,NULL,NULL,'0B03614A7E94DD57548596BE420E9DC2',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=42423 WHERE `gamebuild`=42010;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '42423';
diff --git a/sql/updates/auth/master/2022_02_26_00_auth.sql b/sql/updates/auth/master/2022_02_26_00_auth.sql
deleted file mode 100644
index 5af610105a2..00000000000
--- a/sql/updates/auth/master/2022_02_26_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=42488;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(42488,9,2,0,NULL,NULL,'A78755E6928D83A271C5D1EE3CDB6F15',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=42488 WHERE `gamebuild`=42423;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '42488';
diff --git a/sql/updates/auth/master/2022_03_01_00_auth.sql b/sql/updates/auth/master/2022_03_01_00_auth.sql
deleted file mode 100644
index 0d13a9253e0..00000000000
--- a/sql/updates/auth/master/2022_03_01_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=42521;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(42521,9,2,0,NULL,NULL,'5FE6C12FC407C6B15B4A5D3B5B4A5D3B',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=42521 WHERE `gamebuild`=42488;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '42521';
diff --git a/sql/updates/auth/master/2022_03_02_00_auth.sql b/sql/updates/auth/master/2022_03_02_00_auth.sql
deleted file mode 100644
index 04c9657dd31..00000000000
--- a/sql/updates/auth/master/2022_03_02_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=42538;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(42538,9,2,0,NULL,NULL,'71A7504BD53F8DE518F24265D37310AE',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=42538 WHERE `gamebuild`=42521;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '42538';
diff --git a/sql/updates/auth/master/2022_03_03_00_auth.sql b/sql/updates/auth/master/2022_03_03_00_auth.sql
deleted file mode 100644
index 532e4742053..00000000000
--- a/sql/updates/auth/master/2022_03_03_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=42560;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(42560,9,2,0,NULL,NULL,'115FE8C38A8D67CA4664BB192E0F0DFE',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=42560 WHERE `gamebuild`=42538;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '42560';
diff --git a/sql/updates/auth/master/2022_01_15_00_auth.sql b/sql/updates/auth/master/2022_03_06_00_auth.sql
index a178b68a082..b97fcd92e54 100644
--- a/sql/updates/auth/master/2022_01_15_00_auth.sql
+++ b/sql/updates/auth/master/2022_03_06_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 915.22012 auth
+-- TDB 920.22031 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/auth', 'ARCHIVED');