TDB 335.20081 - 2020/08/15TDB335.20081

5 files changed, 1 insertions, 25 deletions

diff --git a/sql/updates/auth/3.3.5/2020_08_02_00_auth.sql b/sql/updates/auth/3.3.5/2020_08_02_00_auth.sql
deleted file mode 100644
index 035ca4c4367..00000000000
--- a/sql/updates/auth/3.3.5/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/3.3.5/2020_08_03_00_auth.sql b/sql/updates/auth/3.3.5/2020_08_03_00_auth.sql
deleted file mode 100644
index 47fd5fdf4db..00000000000
--- a/sql/updates/auth/3.3.5/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/3.3.5/2020_08_03_01_auth.sql b/sql/updates/auth/3.3.5/2020_08_03_01_auth.sql
deleted file mode 100644
index f46d259aa4b..00000000000
--- a/sql/updates/auth/3.3.5/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/3.3.5/2020_08_11_00_auth.sql b/sql/updates/auth/3.3.5/2020_08_11_00_auth.sql
deleted file mode 100644
index 16296ac7c90..00000000000
--- a/sql/updates/auth/3.3.5/2020_08_11_00_auth.sql
+++ /dev/null
@@ -1,5 +0,0 @@
--- 
-DELETE FROM `rbac_permissions` WHERE `id`=705;
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=705;
-DELETE FROM `rbac_account_permissions` WHERE `permissionId`=705;
-DELETE FROM `rbac_default_permissions` WHERE `permissionId`=705;
diff --git a/sql/updates/auth/3.3.5/2020_07_15_00_auth.sql b/sql/updates/auth/3.3.5/2020_08_15_00_auth.sql
index d0cbe2be812..9a33bcc953f 100644
--- a/sql/updates/auth/3.3.5/2020_07_15_00_auth.sql
+++ b/sql/updates/auth/3.3.5/2020_08_15_00_auth.sql
@@ -1,2 +1,2 @@
--- TDB 335.20071 auth
+-- TDB 335.20081 auth
 UPDATE `updates` SET `state`='ARCHIVED';