diff options
| author | TDB Release <tdb-release@build.bot> | 2021-10-15 10:18:03 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2021-10-15 10:18:03 +0000 |
| commit | 251ad7f8a838c0de1495b351ad6bead2e5968896 (patch) | |
| tree | 0b0b57124142e16bcb4ac4396c6a624040fa3a11 /sql/updates/auth | |
| parent | 990e4d86576751c517549eecc0747b2a8b65129a (diff) | |
TDB 910.21101 - 2021/10/15TDB910.21101
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/master/2018_03_08_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2021_08_19_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2021_09_02_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2021_09_10_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2021_10_07_00_auth.sql | 8 | ||||
| -rw-r--r-- | sql/updates/auth/master/2021_10_13_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2021_10_15_00_auth.sql (renamed from sql/updates/auth/master/2021_08_18_00_auth.sql) | 2 |
7 files changed, 1 insertions, 44 deletions
diff --git a/sql/updates/auth/master/2018_03_08_00_auth.sql b/sql/updates/auth/master/2018_03_08_00_auth.sql deleted file mode 100644 index 8b0e18b1e6c..00000000000 --- a/sql/updates/auth/master/2018_03_08_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `rbac_permissions` WHERE `id` = 873; -INSERT INTO `rbac_permissions` (`id`,`name`) VALUES -(873, 'Command: reload creature_movement_override'); - -DELETE FROM `rbac_linked_permissions` WHERE `linkedId` = 873; -INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES -(196, 873); diff --git a/sql/updates/auth/master/2021_08_19_00_auth.sql b/sql/updates/auth/master/2021_08_19_00_auth.sql deleted file mode 100644 index 25578015b56..00000000000 --- a/sql/updates/auth/master/2021_08_19_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=39804; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(39804,9,1,0,NULL,NULL,'E42D2BBA12ED260A76F9B1E477E19EA5',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=39804 WHERE `gamebuild`=39653; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '39804'; diff --git a/sql/updates/auth/master/2021_09_02_00_auth.sql b/sql/updates/auth/master/2021_09_02_00_auth.sql deleted file mode 100644 index 49419e3a601..00000000000 --- a/sql/updates/auth/master/2021_09_02_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=40000; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(40000,9,1,0,NULL,NULL,'4CB1433AB637F09F03FBBD1B221B04B0',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=40000 WHERE `gamebuild`=39804; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '40000'; diff --git a/sql/updates/auth/master/2021_09_10_00_auth.sql b/sql/updates/auth/master/2021_09_10_00_auth.sql deleted file mode 100644 index d29cb7efac0..00000000000 --- a/sql/updates/auth/master/2021_09_10_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=40120; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(40120,9,1,0,NULL,NULL,'04F47EAEFD8BDEFE14AA0350EA336678',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=40120 WHERE `gamebuild`=40000; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '40120'; diff --git a/sql/updates/auth/master/2021_10_07_00_auth.sql b/sql/updates/auth/master/2021_10_07_00_auth.sql deleted file mode 100644 index dabafcf8538..00000000000 --- a/sql/updates/auth/master/2021_10_07_00_auth.sql +++ /dev/null @@ -1,8 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (40120,40443); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(40120,9,1,0,NULL,NULL,'04F47EAEFD8BDEFE14AA0350EA336678','853F0F2985CEAED46DF422583CD07A7C',NULL,NULL), -(40443,9,1,0,NULL,NULL,'8597BB43E8AB38C85504E8BFB72ABBF5',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=40443 WHERE `gamebuild`=40120; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '40443'; diff --git a/sql/updates/auth/master/2021_10_13_00_auth.sql b/sql/updates/auth/master/2021_10_13_00_auth.sql deleted file mode 100644 index fc061979487..00000000000 --- a/sql/updates/auth/master/2021_10_13_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=40593; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(40593,9,1,0,NULL,NULL,'BA14570F2D62D5F61953394164A8DAE2',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=40593 WHERE `gamebuild`=40443; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '40593'; diff --git a/sql/updates/auth/master/2021_08_18_00_auth.sql b/sql/updates/auth/master/2021_10_15_00_auth.sql index 075b853b378..b39ba801874 100644 --- a/sql/updates/auth/master/2021_08_18_00_auth.sql +++ b/sql/updates/auth/master/2021_10_15_00_auth.sql @@ -1,3 +1,3 @@ --- TDB 910.21081 auth +-- TDB 910.21101 auth UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/auth', 'ARCHIVED'); |
