TDB 905.21071 - 2021/07/04TDB905.21071

14 files changed, 2 insertions, 84 deletions

diff --git a/sql/updates/auth/master/2017_10_13_00_auth.sql b/sql/updates/auth/master/2017_10_13_00_auth.sql
deleted file mode 100644
index 145714e9564..00000000000
--- a/sql/updates/auth/master/2017_10_13_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id`=7;
-INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
-(7, 'Skip idle connection check');
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=7;
-INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
-(196,7);
diff --git a/sql/updates/auth/master/2017_12_17_00_auth.sql b/sql/updates/auth/master/2017_12_17_00_auth.sql
deleted file mode 100644
index 89f3a0bc619..00000000000
--- a/sql/updates/auth/master/2017_12_17_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `rbac_linked_permissions` SET `id` = 197 WHERE `linkedId` = 501;
diff --git a/sql/updates/auth/master/2018_01_24_00_auth.sql b/sql/updates/auth/master/2018_01_24_00_auth.sql
deleted file mode 100644
index 119db7ae391..00000000000
--- a/sql/updates/auth/master/2018_01_24_00_auth.sql
+++ /dev/null
@@ -1,8 +0,0 @@
--- 
-DELETE FROM `rbac_permissions` WHERE `id`=871;
-INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
-(871, 'Command: debug instancespawn');
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=871;
-INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
-(196,871);
diff --git a/sql/updates/auth/master/2020_12_06_00_auth.sql b/sql/updates/auth/master/2020_12_06_00_auth.sql
deleted file mode 100644
index b5f8c3e86a7..00000000000
--- a/sql/updates/auth/master/2020_12_06_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=36753;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(36753,9,0,2,NULL,NULL,'386FDE8559B5EAD67B791B490B200B88',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=36753 WHERE `gamebuild`=35662;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '36753';
diff --git a/sql/updates/auth/master/2020_12_07_00_auth.sql b/sql/updates/auth/master/2020_12_07_00_auth.sql
deleted file mode 100644
index f8e3c9eba08..00000000000
--- a/sql/updates/auth/master/2020_12_07_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=36839;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(36839,9,0,2,NULL,NULL,'356EB4412B8EFCF72E3AF50D5181D529',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=36839 WHERE `gamebuild`=36753;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '36839';
diff --git a/sql/updates/auth/master/2020_12_15_00_auth.sql b/sql/updates/auth/master/2020_12_15_00_auth.sql
deleted file mode 100644
index d4c8cae681a..00000000000
--- a/sql/updates/auth/master/2020_12_15_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=36949;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(36949,9,0,2,NULL,NULL,'51C074CD8A09A75384B9B44188C56981',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=36949 WHERE `gamebuild`=36839;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '36949';
diff --git a/sql/updates/auth/master/2020_12_22_00_auth.sql b/sql/updates/auth/master/2020_12_22_00_auth.sql
deleted file mode 100644
index f60d40c31f0..00000000000
--- a/sql/updates/auth/master/2020_12_22_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `account` CHANGE `expansion` `expansion` tinyint(3) unsigned NOT NULL DEFAULT '8';
diff --git a/sql/updates/auth/master/2020_12_31_00_auth.sql b/sql/updates/auth/master/2020_12_31_00_auth.sql
deleted file mode 100644
index 44d29e41def..00000000000
--- a/sql/updates/auth/master/2020_12_31_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id`=881;
-INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
-(881, 'Command: reload vehicle_template');
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=881;
-INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
-(196,881);
diff --git a/sql/updates/auth/master/2021_01_10_00_auth.sql b/sql/updates/auth/master/2021_01_10_00_auth.sql
deleted file mode 100644
index d81eea0922d..00000000000
--- a/sql/updates/auth/master/2021_01_10_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=37142;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(37142,9,0,2,NULL,NULL,'5D9CFB3139F0D1B6C2B304261F9EABC9',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=37142 WHERE `gamebuild`=36949;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '37142';
diff --git a/sql/updates/auth/master/2021_01_13_00_auth.sql b/sql/updates/auth/master/2021_01_13_00_auth.sql
deleted file mode 100644
index a3035fb22cb..00000000000
--- a/sql/updates/auth/master/2021_01_13_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=37176;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(37176,9,0,2,NULL,NULL,'3C725EA504EC3DAED143EB6FF3B48CDA',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=37176 WHERE `gamebuild`=37142;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '37176';
diff --git a/sql/updates/auth/master/2021_02_09_00_auth.sql b/sql/updates/auth/master/2021_02_09_00_auth.sql
deleted file mode 100644
index 1c08faaabc0..00000000000
--- a/sql/updates/auth/master/2021_02_09_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=37474;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(37474,9,0,2,NULL,NULL,'0DE685BBB0551086E7FBDC0B4BB06A5B',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=37474 WHERE `gamebuild`=37176;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '37474';
diff --git a/sql/updates/auth/master/2021_04_10_00_auth.sql b/sql/updates/auth/master/2021_04_10_00_auth.sql
deleted file mode 100644
index fb67d68a4c9..00000000000
--- a/sql/updates/auth/master/2021_04_10_00_auth.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-UPDATE `build_info` SET `mac64AuthSeed`='024C9BE7E44237B7E81C6D42E678D433' WHERE `build`=37474;
-
-DELETE FROM `build_info` WHERE `build`=38134;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(38134,9,0,5,NULL,NULL,'32275ED0F13B357C28BDB0E611EF9E31',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=38134 WHERE `gamebuild`=37474;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '38134';
diff --git a/sql/updates/auth/master/2021_05_12_00_auth.sql b/sql/updates/auth/master/2021_05_12_00_auth.sql
deleted file mode 100644
index aeb60d94ea1..00000000000
--- a/sql/updates/auth/master/2021_05_12_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=38556;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(38556,9,0,5,NULL,NULL,'EC7D5AF64364AC3E7181F3FBA1B3A882',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=38556 WHERE `gamebuild`=38134;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '38556';
diff --git a/sql/updates/auth/master/2020_10_20_00_auth.sql b/sql/updates/auth/master/2021_07_04_00_auth.sql
index 3a890913a62..ab0782353e8 100644
--- a/sql/updates/auth/master/2020_10_20_00_auth.sql
+++ b/sql/updates/auth/master/2021_07_04_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 837.20101 auth
+-- TDB 905.21071 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
-REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/8.x/auth', 'ARCHIVED');
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/auth', 'ARCHIVED');