diff options
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/master/2022_09_02_00_auth.sql | 10 | ||||
| -rw-r--r-- | sql/updates/auth/master/2022_09_08_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2022_09_23_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2022_10_03_00_auth.sql | 3 | ||||
| -rw-r--r-- | sql/updates/auth/master/2022_11_20_00_auth.sql (renamed from sql/updates/auth/master/2022_08_21_00_auth.sql) | 2 |
5 files changed, 1 insertions, 28 deletions
diff --git a/sql/updates/auth/master/2022_09_02_00_auth.sql b/sql/updates/auth/master/2022_09_02_00_auth.sql deleted file mode 100644 index ead11623565..00000000000 --- a/sql/updates/auth/master/2022_09_02_00_auth.sql +++ /dev/null @@ -1,10 +0,0 @@ --- -SET @PERMISSION := 883; - -DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=@PERMISSION; -DELETE FROM `rbac_permissions` WHERE `id`=@PERMISSION; -INSERT INTO `rbac_permissions` (`id`, `name`) VALUES -(@PERMISSION, 'Command: quest objective complete'); - -INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES -(196, @PERMISSION); diff --git a/sql/updates/auth/master/2022_09_08_00_auth.sql b/sql/updates/auth/master/2022_09_08_00_auth.sql deleted file mode 100644 index 1a188d14664..00000000000 --- a/sql/updates/auth/master/2022_09_08_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=45338; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(45338,9,2,7,NULL,NULL,'5CE2094A41B61EDA9DF56378BC3B1DE0',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=45338 WHERE `gamebuild` IN(45114, 45161); - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '45338'; diff --git a/sql/updates/auth/master/2022_09_23_00_auth.sql b/sql/updates/auth/master/2022_09_23_00_auth.sql deleted file mode 100644 index 2cba9673db4..00000000000 --- a/sql/updates/auth/master/2022_09_23_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=45745; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(45745,9,2,7,NULL,NULL,'0F6DC90161694D765A595A3AF603166B',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=45745 WHERE `gamebuild`=45338; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '45745'; diff --git a/sql/updates/auth/master/2022_10_03_00_auth.sql b/sql/updates/auth/master/2022_10_03_00_auth.sql deleted file mode 100644 index ca85f55b3ee..00000000000 --- a/sql/updates/auth/master/2022_10_03_00_auth.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `rbac_account_permissions` WHERE `permissionId`=416; -DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=416; -DELETE FROM `rbac_permissions` WHERE `id`=416; diff --git a/sql/updates/auth/master/2022_08_21_00_auth.sql b/sql/updates/auth/master/2022_11_20_00_auth.sql index 6be643a1373..7f3734af8d8 100644 --- a/sql/updates/auth/master/2022_08_21_00_auth.sql +++ b/sql/updates/auth/master/2022_11_20_00_auth.sql @@ -1,3 +1,3 @@ --- TDB 927.22082 auth +-- TDB 927.22111 auth UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/auth', 'ARCHIVED'); |