TDB 915.21111 - 2021/11/17TDB915.21111

13 files changed, 1 insertions, 76 deletions

diff --git a/sql/updates/auth/master/2018_08_30_00_auth.sql b/sql/updates/auth/master/2018_08_30_00_auth.sql
deleted file mode 100644
index 1ee1f8d7ee4..00000000000
--- a/sql/updates/auth/master/2018_08_30_00_auth.sql
+++ /dev/null
@@ -1,9 +0,0 @@
--- 
-DELETE FROM `rbac_permissions` WHERE `id`=874;
-INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
-(874, "Command: go instance");
-
-SET @parent := (SELECT `id` FROM `rbac_linked_permissions` WHERE `linkedId`=852);
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=874;
-INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
-(@parent, 874);
diff --git a/sql/updates/auth/master/2018_09_06_00_auth.sql b/sql/updates/auth/master/2018_09_06_00_auth.sql
deleted file mode 100644
index 5a9718edcfb..00000000000
--- a/sql/updates/auth/master/2018_09_06_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- rbac simplify
-DELETE FROM `rbac_linked_permissions` WHERE `linkedid` IN (378,379,380,381,382,383,384,385,386,852,874);
-DELETE FROM `rbac_permissions` WHERE `id` IN (378,379,380,381,382,383,384,385,386,852,874);
diff --git a/sql/updates/auth/master/2018_09_17_00_auth.sql b/sql/updates/auth/master/2018_09_17_00_auth.sql
deleted file mode 100644
index 7aa76283e57..00000000000
--- a/sql/updates/auth/master/2018_09_17_00_auth.sql
+++ /dev/null
@@ -1,6 +0,0 @@
--- 
-DELETE FROM `rbac_permissions` WHERE `id`=852;
-INSERT INTO `rbac_permissions` (`id`,`name`) VALUES (852, 'Command: debug dummy');
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=852;
-INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES (196,852);
diff --git a/sql/updates/auth/master/2021_10_15_01_auth.sql b/sql/updates/auth/master/2021_10_15_01_auth.sql
deleted file mode 100644
index 53dafc768eb..00000000000
--- a/sql/updates/auth/master/2021_10_15_01_auth.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-DROP TABLE IF EXISTS `battle_pet_declinedname`;
-CREATE TABLE `battle_pet_declinedname` (
-  `guid` bigint(20) NOT NULL,
-  `genitive` varchar(12) NOT NULL DEFAULT '',
-  `dative` varchar(12) NOT NULL DEFAULT '',
-  `accusative` varchar(12) NOT NULL DEFAULT '',
-  `instrumental` varchar(12) NOT NULL DEFAULT '',
-  `prepositional` varchar(12) NOT NULL DEFAULT '',
-  PRIMARY KEY (`guid`),
-  CONSTRAINT fk_battle_pet__battle_pet_declinedname FOREIGN KEY (`guid`) REFERENCES `battle_pets` (`guid`) ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/auth/master/2021_10_16_00_auth.sql b/sql/updates/auth/master/2021_10_16_00_auth.sql
deleted file mode 100644
index c0dfb9a29a1..00000000000
--- a/sql/updates/auth/master/2021_10_16_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `battle_pets` ADD `displayId` int(11) NOT NULL DEFAULT '0' AFTER `breed`;
diff --git a/sql/updates/auth/master/2021_10_22_00_auth.sql b/sql/updates/auth/master/2021_10_22_00_auth.sql
deleted file mode 100644
index 1bd7830845f..00000000000
--- a/sql/updates/auth/master/2021_10_22_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id` = 882;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(882, 'Command: reload spell_script_names');
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId` = 882;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(196, 882);
diff --git a/sql/updates/auth/master/2021_10_23_00_auth.sql b/sql/updates/auth/master/2021_10_23_00_auth.sql
deleted file mode 100644
index 5a0e26c23fe..00000000000
--- a/sql/updates/auth/master/2021_10_23_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- rbac simplify
-DELETE FROM `rbac_linked_permissions` WHERE `linkedid` IN (834,799,800,801);
-DELETE FROM `rbac_permissions` WHERE `id` IN (834,799,800,801);
diff --git a/sql/updates/auth/master/2021_10_26_00_auth.sql b/sql/updates/auth/master/2021_10_26_00_auth.sql
deleted file mode 100644
index aa539e257c5..00000000000
--- a/sql/updates/auth/master/2021_10_26_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=40725;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(40725,9,1,0,NULL,NULL,'C1EBDBEB9BB2956EBCCEF7C9D27A1B3B',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=40725 WHERE `gamebuild`=40593;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '40725';
diff --git a/sql/updates/auth/master/2021_11_05_00_auth.sql b/sql/updates/auth/master/2021_11_05_00_auth.sql
deleted file mode 100644
index 499aedc616f..00000000000
--- a/sql/updates/auth/master/2021_11_05_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=40906;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(40906,9,1,5,NULL,NULL,'F5FC259C8635488AFE0D0CD023F361D4',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=40906 WHERE `gamebuild`=40725;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '40906';
diff --git a/sql/updates/auth/master/2021_11_06_00_auth.sql b/sql/updates/auth/master/2021_11_06_00_auth.sql
deleted file mode 100644
index 48f79b34acb..00000000000
--- a/sql/updates/auth/master/2021_11_06_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=40944;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(40944,9,1,5,NULL,NULL,'368FC7FABAF487A8A049C11970657074',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=40944 WHERE `gamebuild`=40906;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '40944';
diff --git a/sql/updates/auth/master/2021_11_10_00_auth.sql b/sql/updates/auth/master/2021_11_10_00_auth.sql
deleted file mode 100644
index 27683cb56e6..00000000000
--- a/sql/updates/auth/master/2021_11_10_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=40966;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(40966,9,1,5,NULL,NULL,'D90F47AF21F381D2D8F3763B994BAC88',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=40966 WHERE `gamebuild`=40944;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '40966';
diff --git a/sql/updates/auth/master/2021_11_12_00_auth.sql b/sql/updates/auth/master/2021_11_12_00_auth.sql
deleted file mode 100644
index 9901038cfd4..00000000000
--- a/sql/updates/auth/master/2021_11_12_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=41031;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(41031,9,1,5,NULL,NULL,'019A0FACD6B0D6374B7BA69A5B677449',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=41031 WHERE `gamebuild`=40966;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '41031';
diff --git a/sql/updates/auth/master/2021_10_15_00_auth.sql b/sql/updates/auth/master/2021_11_17_00_auth.sql
index b39ba801874..13e6fef525c 100644
--- a/sql/updates/auth/master/2021_10_15_00_auth.sql
+++ b/sql/updates/auth/master/2021_11_17_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 910.21101 auth
+-- TDB 915.21111 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/auth', 'ARCHIVED');