TDB 837.20081 - 2020/08/14TDB837.20081

16 files changed, 1 insertions, 80 deletions

diff --git a/sql/updates/auth/master/2017_06_12_01_auth.sql b/sql/updates/auth/master/2017_06_12_01_auth.sql
deleted file mode 100644
index 17c204b56af..00000000000
--- a/sql/updates/auth/master/2017_06_12_01_auth.sql
+++ /dev/null
@@ -1,12 +0,0 @@
--- 
-DELETE FROM `rbac_permissions` WHERE `id` BETWEEN 856 AND 860;
-INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
-(856, 'Command: npc spawngroup'),
-(857, 'Command: npc despawngroup'),
-(858, 'Command: gobject spawngroup'),
-(859, 'Command: gobject despawngroup'),
-(860, 'Command: list respawns');
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId` BETWEEN 856 AND 860;
-INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
-(197,856),(197,857),(197,858),(197,859),(197,860);
diff --git a/sql/updates/auth/master/2017_06_12_02_auth.sql b/sql/updates/auth/master/2017_06_12_02_auth.sql
deleted file mode 100644
index 2b42dc39b12..00000000000
--- a/sql/updates/auth/master/2017_06_12_02_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id`=865;
-INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
-(865, 'Command: npc showloot');
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=865;
-INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
-(197,865);
diff --git a/sql/updates/auth/master/2017_06_17_00_auth.sql b/sql/updates/auth/master/2017_06_17_00_auth.sql
deleted file mode 100644
index 10f1a69824e..00000000000
--- a/sql/updates/auth/master/2017_06_17_00_auth.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-UPDATE `rbac_permissions` SET `name`="Command: debug worldstate" WHERE `id`=339;
diff --git a/sql/updates/auth/master/2017_06_28_00_auth_rbac.sql b/sql/updates/auth/master/2017_06_28_00_auth_rbac.sql
deleted file mode 100644
index e854b107804..00000000000
--- a/sql/updates/auth/master/2017_06_28_00_auth_rbac.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- 
-UPDATE `rbac_permissions` SET `name`="Command: debug combat" WHERE `id`=309;
diff --git a/sql/updates/auth/master/2020_06_20_00_auth.sql b/sql/updates/auth/master/2020_06_20_00_auth.sql
deleted file mode 100644
index fdb95bfe335..00000000000
--- a/sql/updates/auth/master/2020_06_20_00_auth.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-ALTER TABLE `account_access`
-  CHANGE COLUMN `id` `AccountID` INT(10) UNSIGNED NOT NULL,
-  CHANGE COLUMN `gmlevel` `SecurityLevel` TINYINT(3) UNSIGNED NOT NULL,
-  ADD COLUMN `Comment` VARCHAR(255) DEFAULT NULL AFTER `RealmID`;
-
-UPDATE `rbac_permissions` SET `name` = 'Command: account set seclevel' WHERE `id` = 228;
diff --git a/sql/updates/auth/master/2020_07_02_00_auth.sql b/sql/updates/auth/master/2020_07_02_00_auth.sql
deleted file mode 100644
index b75f5b655c8..00000000000
--- a/sql/updates/auth/master/2020_07_02_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=34963;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(34963,8,3,0,NULL,NULL,'7BA50C879C5D04221423B02AC3603A11',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=34963 WHERE `gamebuild`=34769;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '34963';
diff --git a/sql/updates/auth/master/2020_07_03_00_auth.sql b/sql/updates/auth/master/2020_07_03_00_auth.sql
deleted file mode 100644
index 11eef31f0b3..00000000000
--- a/sql/updates/auth/master/2020_07_03_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `build_info` SET `mac64AuthSeed`='C5658A17E702163447BAAAE46D130A1B' WHERE `build`=34963;
diff --git a/sql/updates/auth/master/2020_07_23_00_auth.sql b/sql/updates/auth/master/2020_07_23_00_auth.sql
deleted file mode 100644
index 3d7de2db057..00000000000
--- a/sql/updates/auth/master/2020_07_23_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=35249;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(35249,8,3,7,NULL,NULL,'C7B11F9AE9FF1409F5582902B3D10D1C',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=35249 WHERE `gamebuild`=34963;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '35249';
diff --git a/sql/updates/auth/master/2020_07_24_00_auth.sql b/sql/updates/auth/master/2020_07_24_00_auth.sql
deleted file mode 100644
index 4ebd920eb75..00000000000
--- a/sql/updates/auth/master/2020_07_24_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=35284;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(35284,8,3,7,NULL,NULL,'EA3818E7DCFD2009DBFC83EE3C1E4F1B',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=35284 WHERE `gamebuild`=35249;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '35284';
diff --git a/sql/updates/auth/master/2020_07_25_00_auth.sql b/sql/updates/auth/master/2020_07_25_00_auth.sql
deleted file mode 100644
index a024012f549..00000000000
--- a/sql/updates/auth/master/2020_07_25_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `build_info` SET `mac64AuthSeed`='A6201B0AC5A73D13AB2FDCC79BB252AF' WHERE `build`=35284;
diff --git a/sql/updates/auth/master/2020_08_02_00_auth.sql b/sql/updates/auth/master/2020_08_02_00_auth.sql
deleted file mode 100644
index 035ca4c4367..00000000000
--- a/sql/updates/auth/master/2020_08_02_00_auth.sql
+++ /dev/null
@@ -1,13 +0,0 @@
--- AUTH CLEANUP PHASE 3
--- update `account` structure
--- sha_pass_hash/s/v kept around for now, for backwards compatibility
-ALTER TABLE `account`
-    DROP COLUMN `sessionkey`,
-    ADD COLUMN `salt` BINARY(32) AFTER `username`,
-    ADD COLUMN `verifier` BINARY(32) AFTER `salt`,
-    ADD COLUMN `session_key` BINARY(40) AFTER `verifier`,
-    MODIFY COLUMN `s` VARCHAR(64) NOT NULL DEFAULT 'dummy value, use `salt` instead',
-    MODIFY COLUMN `v` VARCHAR(64) NOT NULL DEFAULT 'dummy value, use `verifier` instead';
-
-UPDATE `account` SET `salt`=REVERSE(UNHEX(`s`)), `s`=DEFAULT WHERE LENGTH(`s`)=64;
-UPDATE `account` SET `verifier`=REVERSE(UNHEX(`v`)), `v`=DEFAULT WHERE LENGTH(`v`)=64;
diff --git a/sql/updates/auth/master/2020_08_03_00_auth.sql b/sql/updates/auth/master/2020_08_03_00_auth.sql
deleted file mode 100644
index 47fd5fdf4db..00000000000
--- a/sql/updates/auth/master/2020_08_03_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `account` MODIFY COLUMN `session_key` VARBINARY(64) AFTER `verifier`;
diff --git a/sql/updates/auth/master/2020_08_03_01_auth.sql b/sql/updates/auth/master/2020_08_03_01_auth.sql
deleted file mode 100644
index f46d259aa4b..00000000000
--- a/sql/updates/auth/master/2020_08_03_01_auth.sql
+++ /dev/null
@@ -1,5 +0,0 @@
--- 
-ALTER TABLE `account`
-    DROP COLUMN `session_key`,
-    ADD COLUMN `session_key_auth` BINARY(40) DEFAULT NULL AFTER `verifier`,
-    ADD COLUMN `session_key_bnet` VARBINARY(64) DEFAULT NULL AFTER `session_key_auth`;
diff --git a/sql/updates/auth/master/2020_08_06_00_auth.sql b/sql/updates/auth/master/2020_08_06_00_auth.sql
deleted file mode 100644
index 5500f01eb42..00000000000
--- a/sql/updates/auth/master/2020_08_06_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=35435;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(35435,8,3,7,NULL,NULL,'BB397A92FE23740EA52FC2B5BA2EC8E0',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=35435 WHERE `gamebuild`=35284;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '35435';
diff --git a/sql/updates/auth/master/2020_08_08_00_auth.sql b/sql/updates/auth/master/2020_08_08_00_auth.sql
deleted file mode 100644
index 9e23436071d..00000000000
--- a/sql/updates/auth/master/2020_08_08_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `build_info` SET `mac64AuthSeed`='8FE657C14A46BCDB2CE6DA37E430450E' WHERE `build`=35435;
diff --git a/sql/updates/auth/master/2020_06_17_01_auth.sql b/sql/updates/auth/master/2020_08_14_00_auth.sql
index 7cee90391bd..61deac3b721 100644
--- a/sql/updates/auth/master/2020_06_17_01_auth.sql
+++ b/sql/updates/auth/master/2020_08_14_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 830.20061 auth
+-- TDB 837.20081 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/8.x/auth', 'ARCHIVED');