aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2021-10-15 10:18:03 +0000
committerTDB Release <tdb-release@build.bot>2021-10-15 10:18:03 +0000
commit251ad7f8a838c0de1495b351ad6bead2e5968896 (patch)
tree0b0b57124142e16bcb4ac4396c6a624040fa3a11 /sql/updates/auth
parent990e4d86576751c517549eecc0747b2a8b65129a (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.sql7
-rw-r--r--sql/updates/auth/master/2021_08_19_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2021_09_02_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2021_09_10_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2021_10_07_00_auth.sql8
-rw-r--r--sql/updates/auth/master/2021_10_13_00_auth.sql7
-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');