From 06b9be494a7e4d1249d11550cc0eec2e35712d25 Mon Sep 17 00:00:00 2001 From: TDB Release Date: Wed, 17 Nov 2021 13:31:04 +0000 Subject: TDB 915.21111 - 2021/11/17 --- sql/updates/auth/master/2018_08_30_00_auth.sql | 9 --------- sql/updates/auth/master/2018_09_06_00_auth.sql | 3 --- sql/updates/auth/master/2018_09_17_00_auth.sql | 6 ------ sql/updates/auth/master/2021_10_15_00_auth.sql | 3 --- sql/updates/auth/master/2021_10_15_01_auth.sql | 11 ----------- sql/updates/auth/master/2021_10_16_00_auth.sql | 1 - sql/updates/auth/master/2021_10_22_00_auth.sql | 7 ------- sql/updates/auth/master/2021_10_23_00_auth.sql | 3 --- sql/updates/auth/master/2021_10_26_00_auth.sql | 7 ------- sql/updates/auth/master/2021_11_05_00_auth.sql | 7 ------- sql/updates/auth/master/2021_11_06_00_auth.sql | 7 ------- sql/updates/auth/master/2021_11_10_00_auth.sql | 7 ------- sql/updates/auth/master/2021_11_12_00_auth.sql | 7 ------- sql/updates/auth/master/2021_11_17_00_auth.sql | 3 +++ 14 files changed, 3 insertions(+), 78 deletions(-) delete mode 100644 sql/updates/auth/master/2018_08_30_00_auth.sql delete mode 100644 sql/updates/auth/master/2018_09_06_00_auth.sql delete mode 100644 sql/updates/auth/master/2018_09_17_00_auth.sql delete mode 100644 sql/updates/auth/master/2021_10_15_00_auth.sql delete mode 100644 sql/updates/auth/master/2021_10_15_01_auth.sql delete mode 100644 sql/updates/auth/master/2021_10_16_00_auth.sql delete mode 100644 sql/updates/auth/master/2021_10_22_00_auth.sql delete mode 100644 sql/updates/auth/master/2021_10_23_00_auth.sql delete mode 100644 sql/updates/auth/master/2021_10_26_00_auth.sql delete mode 100644 sql/updates/auth/master/2021_11_05_00_auth.sql delete mode 100644 sql/updates/auth/master/2021_11_06_00_auth.sql delete mode 100644 sql/updates/auth/master/2021_11_10_00_auth.sql delete mode 100644 sql/updates/auth/master/2021_11_12_00_auth.sql create mode 100644 sql/updates/auth/master/2021_11_17_00_auth.sql (limited to 'sql/updates/auth') 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_00_auth.sql b/sql/updates/auth/master/2021_10_15_00_auth.sql deleted file mode 100644 index b39ba801874..00000000000 --- a/sql/updates/auth/master/2021_10_15_00_auth.sql +++ /dev/null @@ -1,3 +0,0 @@ --- TDB 910.21101 auth -UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; -REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/auth', 'ARCHIVED'); 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_11_17_00_auth.sql b/sql/updates/auth/master/2021_11_17_00_auth.sql new file mode 100644 index 00000000000..13e6fef525c --- /dev/null +++ b/sql/updates/auth/master/2021_11_17_00_auth.sql @@ -0,0 +1,3 @@ +-- TDB 915.21111 auth +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/auth', 'ARCHIVED'); -- cgit v1.2.3