TDB 910.21101 - 2021/10/15TDB910.21101

3 files changed, 1 insertions, 44 deletions

diff --git a/sql/updates/characters/master/2021_10_02_00_characters.sql b/sql/updates/characters/master/2021_10_02_00_characters.sql
deleted file mode 100644
index b23080ce0b0..00000000000
--- a/sql/updates/characters/master/2021_10_02_00_characters.sql
+++ /dev/null
@@ -1,42 +0,0 @@
--- THIS SQL UPDATE HAS BEEN EDITED TO FIX MYSQL 5.7 COMPATIBILITY
--- ADD COLUMN IF NOT EXISTS
-SET @dbname = DATABASE();
-SET @preparedStatement = (SELECT IF(
-  (
-    SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
-    WHERE
-      (table_name = 'characters')
-      AND (table_schema = @dbname)
-      AND (column_name = 'createTime')
-  ) > 0,
-  "SELECT 'Skipped adding column, already exists.'",
-  CONCAT("ALTER TABLE characters ADD `createTime` bigint(20) NOT NULL DEFAULT '0' AFTER `online`, ADD `createMode` tinyint(4) NOT NULL DEFAULT '0' AFTER `createTime`")
-));
-PREPARE alterIfNotExists FROM @preparedStatement;
-EXECUTE alterIfNotExists;
-DEALLOCATE PREPARE alterIfNotExists;
-
--- EDITED NOTE: updates safe to reapply unconditionally
-
- -- AT_LOGIN_FIRST: Characters that have never logged in have accurate creation timestamp in `logout_time`
-UPDATE `characters` SET `createTime`=`logout_time` WHERE (`at_login` & 0x20) != 0;
- -- attempt to find lowest criteria timestamp for characters that have logged in already
-UPDATE `characters` c
-  INNER JOIN
-  (
-    SELECT cap.`guid` `guid`, COALESCE(MIN(cap.`date`), UNIX_TIMESTAMP()) `date`
-    FROM `character_achievement_progress` cap
-    GROUP BY cap.`guid`
-  ) criteria ON criteria.`guid` = c.`guid`
-  INNER JOIN
-  (
-    SELECT ca.`guid` `guid`, COALESCE(MIN(ca.`date`), UNIX_TIMESTAMP()) `date`
-    FROM `character_achievement` ca
-    GROUP BY ca.`guid`
-  ) achievement ON achievement.`guid` = c.`guid` 
-SET 
-  `createTime` = IF(criteria.`date` < achievement.`date`,
-    criteria.`date`,
-    achievement.`date`)
-WHERE
-  (`at_login` & 0x20) = 0;
diff --git a/sql/updates/characters/master/2021_10_02_01_characters.sql b/sql/updates/characters/master/2021_10_02_01_characters.sql
deleted file mode 100644
index e4c6a5e83b0..00000000000
--- a/sql/updates/characters/master/2021_10_02_01_characters.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `characters` SET `zone`=0 WHERE (`at_login` & 0x20) != 0;
diff --git a/sql/updates/characters/master/2021_08_18_00_characters.sql b/sql/updates/characters/master/2021_10_15_00_characters.sql
index 3b9d8c7e476..0b929d6c9bc 100644
--- a/sql/updates/characters/master/2021_08_18_00_characters.sql
+++ b/sql/updates/characters/master/2021_10_15_00_characters.sql
@@ -1,3 +1,3 @@
--- TDB 910.21081 characters
+-- TDB 910.21101 characters
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/characters', 'ARCHIVED');