TDB 905.21071 - 2021/07/04TDB905.21071

14 files changed, 85 insertions, 0 deletions

diff --git a/sql/old/9.x/auth/20101_2021_07_04/2017_10_13_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2017_10_13_00_auth.sql
new file mode 100644
index 00000000000..145714e9564
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2017_10_13_00_auth.sql
@@ -0,0 +1,7 @@
+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/old/9.x/auth/20101_2021_07_04/2017_12_17_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2017_12_17_00_auth.sql
new file mode 100644
index 00000000000..89f3a0bc619
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2017_12_17_00_auth.sql
@@ -0,0 +1 @@
+UPDATE `rbac_linked_permissions` SET `id` = 197 WHERE `linkedId` = 501;
diff --git a/sql/old/9.x/auth/20101_2021_07_04/2018_01_24_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2018_01_24_00_auth.sql
new file mode 100644
index 00000000000..119db7ae391
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2018_01_24_00_auth.sql
@@ -0,0 +1,8 @@
+-- 
+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/old/9.x/auth/20101_2021_07_04/2020_10_20_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2020_10_20_00_auth.sql
new file mode 100644
index 00000000000..3a890913a62
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2020_10_20_00_auth.sql
@@ -0,0 +1,3 @@
+-- TDB 837.20101 auth
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/8.x/auth', 'ARCHIVED');
diff --git a/sql/old/9.x/auth/20101_2021_07_04/2020_12_06_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2020_12_06_00_auth.sql
new file mode 100644
index 00000000000..b5f8c3e86a7
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2020_12_06_00_auth.sql
@@ -0,0 +1,7 @@
+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/old/9.x/auth/20101_2021_07_04/2020_12_07_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2020_12_07_00_auth.sql
new file mode 100644
index 00000000000..f8e3c9eba08
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2020_12_07_00_auth.sql
@@ -0,0 +1,7 @@
+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/old/9.x/auth/20101_2021_07_04/2020_12_15_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2020_12_15_00_auth.sql
new file mode 100644
index 00000000000..d4c8cae681a
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2020_12_15_00_auth.sql
@@ -0,0 +1,7 @@
+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/old/9.x/auth/20101_2021_07_04/2020_12_22_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2020_12_22_00_auth.sql
new file mode 100644
index 00000000000..f60d40c31f0
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2020_12_22_00_auth.sql
@@ -0,0 +1 @@
+ALTER TABLE `account` CHANGE `expansion` `expansion` tinyint(3) unsigned NOT NULL DEFAULT '8';
diff --git a/sql/old/9.x/auth/20101_2021_07_04/2020_12_31_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2020_12_31_00_auth.sql
new file mode 100644
index 00000000000..44d29e41def
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2020_12_31_00_auth.sql
@@ -0,0 +1,7 @@
+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/old/9.x/auth/20101_2021_07_04/2021_01_10_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2021_01_10_00_auth.sql
new file mode 100644
index 00000000000..d81eea0922d
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2021_01_10_00_auth.sql
@@ -0,0 +1,7 @@
+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/old/9.x/auth/20101_2021_07_04/2021_01_13_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2021_01_13_00_auth.sql
new file mode 100644
index 00000000000..a3035fb22cb
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2021_01_13_00_auth.sql
@@ -0,0 +1,7 @@
+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/old/9.x/auth/20101_2021_07_04/2021_02_09_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2021_02_09_00_auth.sql
new file mode 100644
index 00000000000..1c08faaabc0
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2021_02_09_00_auth.sql
@@ -0,0 +1,7 @@
+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/old/9.x/auth/20101_2021_07_04/2021_04_10_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2021_04_10_00_auth.sql
new file mode 100644
index 00000000000..fb67d68a4c9
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2021_04_10_00_auth.sql
@@ -0,0 +1,9 @@
+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/old/9.x/auth/20101_2021_07_04/2021_05_12_00_auth.sql b/sql/old/9.x/auth/20101_2021_07_04/2021_05_12_00_auth.sql
new file mode 100644
index 00000000000..aeb60d94ea1
--- /dev/null
+++ b/sql/old/9.x/auth/20101_2021_07_04/2021_05_12_00_auth.sql
@@ -0,0 +1,7 @@
+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';