82 files changed, 52 insertions, 22 deletions
diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index e8fb5521dbe..15f5db27771 100644
--- a/revision_data.h.in.cmake
+++ b/revision_data.h.in.cmake
@@ -9,8 +9,8 @@
  #define _SOURCE_DIRECTORY          R"(@CMAKE_SOURCE_DIR@)"
  #define _BUILD_DIRECTORY           R"(@BUILDDIR@)"
  #define _MYSQL_EXECUTABLE          R"(@MYSQL_EXECUTABLE@)"
- #define _FULL_DATABASE             "TDB_full_world_925.22071_2022_07_25.sql"
- #define _HOTFIXES_DATABASE         "TDB_full_hotfixes_925.22071_2022_07_25.sql"
+ #define _FULL_DATABASE             "TDB_full_world_927.22081_2022_08_19.sql"
+ #define _HOTFIXES_DATABASE         "TDB_full_hotfixes_927.22081_2022_08_19.sql"
  #define VER_COMPANYNAME_STR        "TrinityCore Developers"
  #define VER_LEGALCOPYRIGHT_STR     "(c)2008-@rev_year@ TrinityCore"
  #define VER_FILEVERSION            0,0,0
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 220d5db739f..35dc61093d3 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.29, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.30, for Linux (x86_64)
 --
 -- Host: localhost    Database: auth
 -- ------------------------------------------------------
--- Server version	8.0.29-0ubuntu0.20.04.3
+-- Server version	8.0.30-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -2611,9 +2611,10 @@ INSERT INTO `updates` VALUES
 ('2022_06_27_00_auth.sql','CF613CCAAF8B6F08AAE1C48DBC4AF4D224291D8D','ARCHIVED','2022-06-27 21:13:58',0),
 ('2022_07_23_00_auth.sql','FEA7A8DA363F097A090F3BB39401C3FD7AE8E9B5','ARCHIVED','2022-07-25 18:40:38',0),
 ('2022_07_25_00_auth.sql','8F5BA8F7E010EDCA70F49FDE947B2F89476A2F95','ARCHIVED','2022-07-25 18:44:10',0),
-('2022_08_02_00_auth.sql','4B97D20928B05086C7863497F4DDD408A51619BE','RELEASED','2022-08-02 18:28:31',0),
-('2022_08_17_00_auth.sql','1A45DAE660690A7F4D0822C514116BF44A3185BB','RELEASED','2022-08-17 10:16:00',0),
-('2022_08_19_00_auth.sql','332E7CC2E69D69BF274E5C61768FB80D1C217BDB','RELEASED','2022-08-19 09:52:06',0);
+('2022_08_02_00_auth.sql','4B97D20928B05086C7863497F4DDD408A51619BE','ARCHIVED','2022-08-02 18:28:31',0),
+('2022_08_17_00_auth.sql','1A45DAE660690A7F4D0822C514116BF44A3185BB','ARCHIVED','2022-08-17 10:16:00',0),
+('2022_08_19_00_auth.sql','332E7CC2E69D69BF274E5C61768FB80D1C217BDB','ARCHIVED','2022-08-19 09:52:06',0),
+('2022_08_19_01_auth.sql','8B32826AE09C27B98C9480EF4D61205666F68318','ARCHIVED','2022-08-19 23:43:01',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2738,7 +2739,7 @@ SET character_set_client = @saved_cs_client;
 /*!50001 SET @saved_col_connection     = @@collation_connection */;
 /*!50001 SET character_set_client      = utf8mb3 */;
 /*!50001 SET character_set_results     = utf8mb3 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
+/*!50001 SET collation_connection      = utf8mb3_general_ci */;
 /*!50001 CREATE ALGORITHM=UNDEFINED */
 /*!50013 */
 /*!50001 VIEW `vw_rbac` AS select `t1`.`linkedId` AS `Permission ID`,`t1`.`id` AS `Permission Group`,ifnull(`t2`.`secId`,'linked') AS `Security Level`,`t3`.`name` AS `Permission` from ((`rbac_linked_permissions` `t1` left join `rbac_default_permissions` `t2` on((`t1`.`id` = `t2`.`permissionId`))) left join `rbac_permissions` `t3` on((`t1`.`linkedId` = `t3`.`id`))) */;
@@ -2755,4 +2756,4 @@ SET character_set_client = @saved_cs_client;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2022-07-25 18:44:12
+-- Dump completed on 2022-08-19 23:43:03
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 22b65f86168..17b3462003f 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.29, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.30, for Linux (x86_64)
 --
 -- Host: localhost    Database: characters
 -- ------------------------------------------------------
--- Server version	8.0.29-0ubuntu0.20.04.3
+-- Server version	8.0.30-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -3674,7 +3674,8 @@ INSERT INTO `updates` VALUES
 ('2022_06_01_00_characters.sql','582AC6E256F8365F83AB70BA165CCC8B218E19FF','ARCHIVED','2022-06-01 21:16:56',0),
 ('2022_07_03_00_characters.sql','D3F04078C0846BCF7C8330AC20C39B8C3AEE7002','ARCHIVED','2022-07-03 23:37:24',0),
 ('2022_07_14_00_characters.sql','2EAD57D77FC39F6678F2D2A7D9C24046E6B836D8','ARCHIVED','2022-07-14 21:44:35',0),
-('2022_07_25_00_characters.sql','3159BB2F3C346A7881920AB2B1F8108247CF13EE','ARCHIVED','2022-07-25 18:44:10',0);
+('2022_07_25_00_characters.sql','3159BB2F3C346A7881920AB2B1F8108247CF13EE','ARCHIVED','2022-07-25 18:44:10',0),
+('2022_08_19_00_characters.sql','1C076A24F2B48F32E8EF835C01F8907CA9E86491','ARCHIVED','2022-08-19 23:43:01',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -3800,4 +3801,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2022-07-25 18:44:12
+-- Dump completed on 2022-08-19 23:43:04
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index 4de0f6a48ce..7626c541700 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.29, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.30, for Linux (x86_64)
 --
 -- Host: localhost    Database: hotfixes
 -- ------------------------------------------------------
--- Server version	8.0.29-0ubuntu0.20.04.3
+-- Server version	8.0.30-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -9529,4 +9529,4 @@ CREATE TABLE `world_state_expression` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2022-07-25 18:44:18
+-- Dump completed on 2022-08-19 23:43:12
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index b1ad795474f..78bb243884b 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.29, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.30, for Linux (x86_64)
 --
 -- Host: localhost    Database: world
 -- ------------------------------------------------------
--- Server version	8.0.29-0ubuntu0.20.04.3
+-- Server version	8.0.30-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -1843,6 +1843,21 @@ CREATE TABLE `gossip_menu` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `gossip_menu_addon`
+--
+
+DROP TABLE IF EXISTS `gossip_menu_addon`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `gossip_menu_addon` (
+  `MenuID` int unsigned NOT NULL DEFAULT '0',
+  `FriendshipFactionID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`MenuID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `gossip_menu_option`
 --
 
@@ -4714,7 +4729,7 @@ CREATE TABLE `world_state` (
 /*!50001 SET @saved_col_connection     = @@collation_connection */;
 /*!50001 SET character_set_client      = utf8mb3 */;
 /*!50001 SET character_set_results     = utf8mb3 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
+/*!50001 SET collation_connection      = utf8mb3_general_ci */;
 /*!50001 CREATE ALGORITHM=UNDEFINED */
 /*!50013 */
 /*!50001 VIEW `vw_conditions_with_labels` AS select (case when (`conditions`.`SourceTypeOrReferenceId` = 0) then 'CONDITION_SOURCE_TYPE_NONE' when (`conditions`.`SourceTypeOrReferenceId` = 1) then 'CONDITION_SOURCE_TYPE_CREATURE_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 2) then 'CONDITION_SOURCE_TYPE_DISENCHANT_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 3) then 'CONDITION_SOURCE_TYPE_FISHING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 4) then 'CONDITION_SOURCE_TYPE_GAMEOBJECT_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 5) then 'CONDITION_SOURCE_TYPE_ITEM_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 6) then 'CONDITION_SOURCE_TYPE_MAIL_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 7) then 'CONDITION_SOURCE_TYPE_MILLING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 8) then 'CONDITION_SOURCE_TYPE_PICKPOCKETING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 9) then 'CONDITION_SOURCE_TYPE_PROSPECTING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 10) then 'CONDITION_SOURCE_TYPE_REFERENCE_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 11) then 'CONDITION_SOURCE_TYPE_SKINNING_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 12) then 'CONDITION_SOURCE_TYPE_SPELL_LOOT_TEMPLATE' when (`conditions`.`SourceTypeOrReferenceId` = 13) then 'CONDITION_SOURCE_TYPE_SPELL_IMPLICIT_TARGET' when (`conditions`.`SourceTypeOrReferenceId` = 14) then 'CONDITION_SOURCE_TYPE_GOSSIP_MENU' when (`conditions`.`SourceTypeOrReferenceId` = 15) then 'CONDITION_SOURCE_TYPE_GOSSIP_MENU_OPTION' when (`conditions`.`SourceTypeOrReferenceId` = 16) then 'CONDITION_SOURCE_TYPE_CREATURE_TEMPLATE_VEHICLE' when (`conditions`.`SourceTypeOrReferenceId` = 17) then 'CONDITION_SOURCE_TYPE_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 18) then 'CONDITION_SOURCE_TYPE_SPELL_CLICK_EVENT' when (`conditions`.`SourceTypeOrReferenceId` = 19) then 'CONDITION_SOURCE_TYPE_QUEST_AVAILABLE' when (`conditions`.`SourceTypeOrReferenceId` = 21) then 'CONDITION_SOURCE_TYPE_VEHICLE_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 22) then 'CONDITION_SOURCE_TYPE_SMART_EVENT' when (`conditions`.`SourceTypeOrReferenceId` = 23) then 'CONDITION_SOURCE_TYPE_NPC_VENDOR' when (`conditions`.`SourceTypeOrReferenceId` = 24) then 'CONDITION_SOURCE_TYPE_SPELL_PROC' when (`conditions`.`SourceTypeOrReferenceId` = 25) then 'CONDITION_SOURCE_TYPE_TERRAIN_SWAP' when (`conditions`.`SourceTypeOrReferenceId` = 26) then 'CONDITION_SOURCE_TYPE_PHASE' when (`conditions`.`SourceTypeOrReferenceId` = 27) then 'CONDITION_SOURCE_TYPE_GRAVEYARD' when (`conditions`.`SourceTypeOrReferenceId` = 28) then 'CONDITION_SOURCE_TYPE_AREATRIGGER' when (`conditions`.`SourceTypeOrReferenceId` = 29) then 'CONDITION_SOURCE_TYPE_CONVERSATION_LINE' when (`conditions`.`SourceTypeOrReferenceId` = 30) then 'CONDITION_SOURCE_TYPE_AREATRIGGER_CLIENT_TRIGGERED' when (`conditions`.`SourceTypeOrReferenceId` = 31) then 'CONDITION_SOURCE_TYPE_TRAINER_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 32) then 'CONDITION_SOURCE_TYPE_OBJECT_ID_VISIBILITY' else `conditions`.`SourceTypeOrReferenceId` end) AS `SourceTypeOrReferenceId`,`conditions`.`SourceGroup` AS `SourceGroup`,`conditions`.`SourceEntry` AS `SourceEntry`,`conditions`.`SourceId` AS `SourceId`,`conditions`.`ElseGroup` AS `ElseGroup`,(case when (`conditions`.`SourceTypeOrReferenceId` = 0) then 'CONDITION_NONE' when (`conditions`.`SourceTypeOrReferenceId` = 1) then 'CONDITION_AURA' when (`conditions`.`SourceTypeOrReferenceId` = 2) then 'CONDITION_ITEM' when (`conditions`.`SourceTypeOrReferenceId` = 3) then 'CONDITION_ITEM_EQUIPPED' when (`conditions`.`SourceTypeOrReferenceId` = 4) then 'CONDITION_ZONEID' when (`conditions`.`SourceTypeOrReferenceId` = 5) then 'CONDITION_REPUTATION_RANK' when (`conditions`.`SourceTypeOrReferenceId` = 6) then 'CONDITION_TEAM' when (`conditions`.`SourceTypeOrReferenceId` = 7) then 'CONDITION_SKILL' when (`conditions`.`SourceTypeOrReferenceId` = 8) then 'CONDITION_QUESTREWARDED' when (`conditions`.`SourceTypeOrReferenceId` = 9) then 'CONDITION_QUESTTAKEN' when (`conditions`.`SourceTypeOrReferenceId` = 10) then 'CONDITION_DRUNKENSTATE' when (`conditions`.`SourceTypeOrReferenceId` = 11) then 'CONDITION_WORLD_STATE' when (`conditions`.`SourceTypeOrReferenceId` = 12) then 'CONDITION_ACTIVE_EVENT' when (`conditions`.`SourceTypeOrReferenceId` = 13) then 'CONDITION_INSTANCE_INFO' when (`conditions`.`SourceTypeOrReferenceId` = 14) then 'CONDITION_QUEST_NONE' when (`conditions`.`SourceTypeOrReferenceId` = 15) then 'CONDITION_CLASS' when (`conditions`.`SourceTypeOrReferenceId` = 16) then 'CONDITION_RACE' when (`conditions`.`SourceTypeOrReferenceId` = 17) then 'CONDITION_ACHIEVEMENT' when (`conditions`.`SourceTypeOrReferenceId` = 18) then 'CONDITION_TITLE' when (`conditions`.`SourceTypeOrReferenceId` = 19) then 'CONDITION_SPAWNMASK' when (`conditions`.`SourceTypeOrReferenceId` = 20) then 'CONDITION_GENDER' when (`conditions`.`SourceTypeOrReferenceId` = 21) then 'CONDITION_UNIT_STATE' when (`conditions`.`SourceTypeOrReferenceId` = 22) then 'CONDITION_MAPID' when (`conditions`.`SourceTypeOrReferenceId` = 23) then 'CONDITION_AREAID' when (`conditions`.`SourceTypeOrReferenceId` = 24) then 'CONDITION_CREATURE_TYPE' when (`conditions`.`SourceTypeOrReferenceId` = 25) then 'CONDITION_SPELL' when (`conditions`.`SourceTypeOrReferenceId` = 26) then 'CONDITION_PHASEMASK' when (`conditions`.`SourceTypeOrReferenceId` = 27) then 'CONDITION_LEVEL' when (`conditions`.`SourceTypeOrReferenceId` = 28) then 'CONDITION_QUEST_COMPLETE' when (`conditions`.`SourceTypeOrReferenceId` = 29) then 'CONDITION_NEAR_CREATURE' when (`conditions`.`SourceTypeOrReferenceId` = 30) then 'CONDITION_NEAR_GAMEOBJECT' when (`conditions`.`SourceTypeOrReferenceId` = 31) then 'CONDITION_OBJECT_ENTRY_GUID_LEGACY' when (`conditions`.`SourceTypeOrReferenceId` = 32) then 'CONDITION_TYPE_MASK_LEGACY' when (`conditions`.`SourceTypeOrReferenceId` = 33) then 'CONDITION_RELATION_TO' when (`conditions`.`SourceTypeOrReferenceId` = 34) then 'CONDITION_REACTION_TO' when (`conditions`.`SourceTypeOrReferenceId` = 35) then 'CONDITION_DISTANCE_TO' when (`conditions`.`SourceTypeOrReferenceId` = 36) then 'CONDITION_ALIVE' when (`conditions`.`SourceTypeOrReferenceId` = 37) then 'CONDITION_HP_VAL' when (`conditions`.`SourceTypeOrReferenceId` = 38) then 'CONDITION_HP_PCT' when (`conditions`.`SourceTypeOrReferenceId` = 39) then 'CONDITION_REALM_ACHIEVEMENT' when (`conditions`.`SourceTypeOrReferenceId` = 40) then 'CONDITION_IN_WATER' when (`conditions`.`SourceTypeOrReferenceId` = 41) then 'CONDITION_TERRAIN_SWAP' when (`conditions`.`SourceTypeOrReferenceId` = 42) then 'CONDITION_STAND_STATE' when (`conditions`.`SourceTypeOrReferenceId` = 43) then 'CONDITION_DAILY_QUEST_DONE' when (`conditions`.`SourceTypeOrReferenceId` = 44) then 'CONDITION_CHARMED' when (`conditions`.`SourceTypeOrReferenceId` = 45) then 'CONDITION_PET_TYPE' when (`conditions`.`SourceTypeOrReferenceId` = 46) then 'CONDITION_TAXI' when (`conditions`.`SourceTypeOrReferenceId` = 47) then 'CONDITION_QUESTSTATE' when (`conditions`.`SourceTypeOrReferenceId` = 48) then 'CONDITION_QUEST_OBJECTIVE_PROGRESS' when (`conditions`.`SourceTypeOrReferenceId` = 49) then 'CONDITION_DIFFICULTY_ID' when (`conditions`.`SourceTypeOrReferenceId` = 50) then 'CONDITION_GAMEMASTER' when (`conditions`.`SourceTypeOrReferenceId` = 51) then 'CONDITION_OBJECT_ENTRY_GUID' when (`conditions`.`SourceTypeOrReferenceId` = 52) then 'CONDITION_TYPE_MASK' else `conditions`.`ConditionTypeOrReference` end) AS `ConditionTypeOrReference`,`conditions`.`ConditionTarget` AS `ConditionTarget`,`conditions`.`ConditionValue1` AS `ConditionValue1`,`conditions`.`ConditionValue2` AS `ConditionValue2`,`conditions`.`ConditionValue3` AS `ConditionValue3`,`conditions`.`NegativeCondition` AS `NegativeCondition`,`conditions`.`ErrorType` AS `ErrorType`,`conditions`.`ErrorTextId` AS `ErrorTextId`,`conditions`.`ScriptName` AS `ScriptName`,`conditions`.`Comment` AS `Comment` from `conditions` */;
@@ -4732,7 +4747,7 @@ CREATE TABLE `world_state` (
 /*!50001 SET @saved_col_connection     = @@collation_connection */;
 /*!50001 SET character_set_client      = utf8mb3 */;
 /*!50001 SET character_set_results     = utf8mb3 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
+/*!50001 SET collation_connection      = utf8mb3_general_ci */;
 /*!50001 CREATE ALGORITHM=UNDEFINED */
 /*!50013 */
 /*!50001 VIEW `vw_disables_with_labels` AS select (case when (`disables`.`sourceType` = 0) then 'DISABLE_TYPE_SPELL' when (`disables`.`sourceType` = 1) then 'DISABLE_TYPE_QUEST' when (`disables`.`sourceType` = 2) then 'DISABLE_TYPE_MAP' when (`disables`.`sourceType` = 3) then 'DISABLE_TYPE_BATTLEGROUND' when (`disables`.`sourceType` = 4) then 'DISABLE_TYPE_ACHIEVEMENT_CRITERIA' when (`disables`.`sourceType` = 5) then 'DISABLE_TYPE_OUTDOORPVP' when (`disables`.`sourceType` = 6) then 'DISABLE_TYPE_VMAP' when (`disables`.`sourceType` = 7) then 'DISABLE_TYPE_MMAP' when (`disables`.`sourceType` = 8) then 'DISABLE_TYPE_LFG_MAP' else `disables`.`sourceType` end) AS `sourceType`,`disables`.`entry` AS `entry`,`disables`.`flags` AS `flags`,`disables`.`params_0` AS `params_0`,`disables`.`params_1` AS `params_1`,`disables`.`comment` AS `comment` from `disables` */;
@@ -4750,7 +4765,7 @@ CREATE TABLE `world_state` (
 /*!50001 SET @saved_col_connection     = @@collation_connection */;
 /*!50001 SET character_set_client      = utf8mb3 */;
 /*!50001 SET character_set_results     = utf8mb3 */;
-/*!50001 SET collation_connection      = utf8_general_ci */;
+/*!50001 SET collation_connection      = utf8mb3_general_ci */;
 /*!50001 CREATE ALGORITHM=UNDEFINED */
 /*!50013 */
 /*!50001 VIEW `vw_smart_scripts_with_labels` AS select `smart_scripts`.`entryorguid` AS `entryorguid`,`smart_scripts`.`source_type` AS `source_type`,`smart_scripts`.`id` AS `id`,`smart_scripts`.`link` AS `link`,(case `smart_scripts`.`event_type` when 0 then 'SMART_EVENT_UPDATE_IC' when 1 then 'SMART_EVENT_UPDATE_OOC' when 2 then 'SMART_EVENT_HEALTH_PCT' when 3 then 'SMART_EVENT_MANA_PCT' when 4 then 'SMART_EVENT_AGGRO' when 5 then 'SMART_EVENT_KILL' when 6 then 'SMART_EVENT_DEATH' when 7 then 'SMART_EVENT_EVADE' when 8 then 'SMART_EVENT_SPELLHIT' when 9 then 'SMART_EVENT_RANGE' when 10 then 'SMART_EVENT_OOC_LOS' when 11 then 'SMART_EVENT_RESPAWN' when 12 then 'SMART_EVENT_TARGET_HEALTH_PCT' when 13 then 'SMART_EVENT_VICTIM_CASTING' when 14 then 'SMART_EVENT_FRIENDLY_HEALTH' when 15 then 'SMART_EVENT_FRIENDLY_IS_CC' when 16 then 'SMART_EVENT_FRIENDLY_MISSING_BUFF' when 17 then 'SMART_EVENT_SUMMONED_UNIT' when 18 then 'SMART_EVENT_TARGET_MANA_PCT' when 19 then 'SMART_EVENT_ACCEPTED_QUEST' when 20 then 'SMART_EVENT_REWARD_QUEST' when 21 then 'SMART_EVENT_REACHED_HOME' when 22 then 'SMART_EVENT_RECEIVE_EMOTE' when 23 then 'SMART_EVENT_HAS_AURA' when 24 then 'SMART_EVENT_TARGET_BUFFED' when 25 then 'SMART_EVENT_RESET' when 26 then 'SMART_EVENT_IC_LOS' when 27 then 'SMART_EVENT_PASSENGER_BOARDED' when 28 then 'SMART_EVENT_PASSENGER_REMOVED' when 29 then 'SMART_EVENT_CHARMED' when 30 then 'SMART_EVENT_CHARMED_TARGET' when 31 then 'SMART_EVENT_SPELLHIT_TARGET' when 32 then 'SMART_EVENT_DAMAGED' when 33 then 'SMART_EVENT_DAMAGED_TARGET' when 34 then 'SMART_EVENT_MOVEMENTINFORM' when 35 then 'SMART_EVENT_SUMMON_DESPAWNED' when 36 then 'SMART_EVENT_CORPSE_REMOVED' when 37 then 'SMART_EVENT_AI_INIT' when 38 then 'SMART_EVENT_DATA_SET' when 39 then 'SMART_EVENT_WAYPOINT_START' when 40 then 'SMART_EVENT_WAYPOINT_REACHED' when 41 then 'SMART_EVENT_TRANSPORT_ADDPLAYER' when 42 then 'SMART_EVENT_TRANSPORT_ADDCREATURE' when 43 then 'SMART_EVENT_TRANSPORT_REMOVE_PLAYER' when 44 then 'SMART_EVENT_TRANSPORT_RELOCATE' when 45 then 'SMART_EVENT_INSTANCE_PLAYER_ENTER' when 46 then 'SMART_EVENT_AREATRIGGER_ONTRIGGER' when 47 then 'SMART_EVENT_QUEST_ACCEPTED' when 48 then 'SMART_EVENT_QUEST_OBJ_COPLETETION' when 49 then 'SMART_EVENT_QUEST_COMPLETION' when 50 then 'SMART_EVENT_QUEST_REWARDED' when 51 then 'SMART_EVENT_QUEST_FAIL' when 52 then 'SMART_EVENT_TEXT_OVER' when 53 then 'SMART_EVENT_RECEIVE_HEAL' when 54 then 'SMART_EVENT_JUST_SUMMONED' when 55 then 'SMART_EVENT_WAYPOINT_PAUSED' when 56 then 'SMART_EVENT_WAYPOINT_RESUMED' when 57 then 'SMART_EVENT_WAYPOINT_STOPPED' when 58 then 'SMART_EVENT_WAYPOINT_ENDED' when 59 then 'SMART_EVENT_TIMED_EVENT_TRIGGERED' when 60 then 'SMART_EVENT_UPDATE' when 61 then 'SMART_EVENT_LINK' when 62 then 'SMART_EVENT_GOSSIP_SELECT' when 63 then 'SMART_EVENT_JUST_CREATED' when 64 then 'SMART_EVENT_GOSSIP_HELLO' when 65 then 'SMART_EVENT_FOLLOW_COMPLETED' when 66 then 'SMART_EVENT_EVENT_PHASE_CHANGE' when 67 then 'SMART_EVENT_IS_BEHIND_TARGET' when 68 then 'SMART_EVENT_GAME_EVENT_START' when 69 then 'SMART_EVENT_GAME_EVENT_END' when 70 then 'SMART_EVENT_GO_LOOT_STATE_CHANGED' when 71 then 'SMART_EVENT_GO_EVENT_INFORM' when 72 then 'SMART_EVENT_ACTION_DONE' when 73 then 'SMART_EVENT_ON_SPELLCLICK' when 74 then 'SMART_EVENT_FRIENDLY_HEALTH_PCT' when 75 then 'SMART_EVENT_DISTANCE_CREATURE' when 76 then 'SMART_EVENT_DISTANCE_GAMEOBJECT' when 77 then 'SMART_EVENT_COUNTER_SET' when 78 then 'SMART_EVENT_SCENE_START' when 79 then 'SMART_EVENT_SCENE_TRIGGER' when 80 then 'SMART_EVENT_SCENE_CANCEL' when 81 then 'SMART_EVENT_SCENE_COMPLETE' when 82 then 'SMART_EVENT_SUMMONED_UNIT_DIES' else `smart_scripts`.`event_type` end) AS `event_type`,`smart_scripts`.`event_phase_mask` AS `event_phase_mask`,`smart_scripts`.`event_chance` AS `event_chance`,`smart_scripts`.`event_flags` AS `event_flags`,`smart_scripts`.`event_param1` AS `event_param1`,`smart_scripts`.`event_param2` AS `event_param2`,`smart_scripts`.`event_param3` AS `event_param3`,`smart_scripts`.`event_param4` AS `event_param4`,`smart_scripts`.`event_param5` AS `event_param5`,(case `smart_scripts`.`action_type` when 0 then 'SMART_ACTION_NONE' when 1 then 'SMART_ACTION_TALK' when 2 then 'SMART_ACTION_SET_FACTION' when 3 then 'SMART_ACTION_MORPH_TO_ENTRY_OR_MODEL' when 4 then 'SMART_ACTION_SOUND' when 5 then 'SMART_ACTION_PLAY_EMOTE' when 6 then 'SMART_ACTION_FAIL_QUEST' when 7 then 'SMART_ACTION_OFFER_QUEST' when 8 then 'SMART_ACTION_SET_REACT_STATE' when 9 then 'SMART_ACTION_ACTIVATE_GOBJECT' when 10 then 'SMART_ACTION_RANDOM_EMOTE' when 11 then 'SMART_ACTION_CAST' when 12 then 'SMART_ACTION_SUMMON_CREATURE' when 13 then 'SMART_ACTION_THREAT_SINGLE_PCT' when 14 then 'SMART_ACTION_THREAT_ALL_PCT' when 15 then 'SMART_ACTION_CALL_AREAEXPLOREDOREVENTHAPPENS' when 16 then 'SMART_ACTION_SET_INGAME_PHASE_GROUP' when 17 then 'SMART_ACTION_SET_EMOTE_STATE' when 18 then 'SMART_ACTION_SET_UNIT_FLAG' when 19 then 'SMART_ACTION_REMOVE_UNIT_FLAG' when 20 then 'SMART_ACTION_AUTO_ATTACK' when 21 then 'SMART_ACTION_ALLOW_COMBAT_MOVEMENT' when 22 then 'SMART_ACTION_SET_EVENT_PHASE' when 23 then 'SMART_ACTION_INC_EVENT_PHASE' when 24 then 'SMART_ACTION_EVADE' when 25 then 'SMART_ACTION_FLEE_FOR_ASSIST' when 26 then 'SMART_ACTION_CALL_GROUPEVENTHAPPENS' when 27 then 'SMART_ACTION_COMBAT_STOP' when 28 then 'SMART_ACTION_REMOVEAURASFROMSPELL' when 29 then 'SMART_ACTION_FOLLOW' when 30 then 'SMART_ACTION_RANDOM_PHASE' when 31 then 'SMART_ACTION_RANDOM_PHASE_RANGE' when 32 then 'SMART_ACTION_RESET_GOBJECT' when 33 then 'SMART_ACTION_CALL_KILLEDMONSTER' when 34 then 'SMART_ACTION_SET_INST_DATA' when 35 then 'SMART_ACTION_SET_INST_DATA64' when 36 then 'SMART_ACTION_UPDATE_TEMPLATE' when 37 then 'SMART_ACTION_DIE' when 38 then 'SMART_ACTION_SET_IN_COMBAT_WITH_ZONE' when 39 then 'SMART_ACTION_CALL_FOR_HELP' when 40 then 'SMART_ACTION_SET_SHEATH' when 41 then 'SMART_ACTION_FORCE_DESPAWN' when 42 then 'SMART_ACTION_SET_INVINCIBILITY_HP_LEVEL' when 43 then 'SMART_ACTION_MOUNT_TO_ENTRY_OR_MODEL' when 44 then 'SMART_ACTION_SET_INGAME_PHASE_ID' when 45 then 'SMART_ACTION_SET_DATA' when 46 then 'SMART_ACTION_ATTACK_STOP' when 47 then 'SMART_ACTION_SET_VISIBILITY' when 48 then 'SMART_ACTION_SET_ACTIVE' when 49 then 'SMART_ACTION_ATTACK_START' when 50 then 'SMART_ACTION_SUMMON_GO' when 51 then 'SMART_ACTION_KILL_UNIT' when 52 then 'SMART_ACTION_ACTIVATE_TAXI' when 53 then 'SMART_ACTION_WP_START' when 54 then 'SMART_ACTION_WP_PAUSE' when 55 then 'SMART_ACTION_WP_STOP' when 56 then 'SMART_ACTION_ADD_ITEM' when 57 then 'SMART_ACTION_REMOVE_ITEM' when 58 then 'SMART_ACTION_INSTALL_AI_TEMPLATE' when 59 then 'SMART_ACTION_SET_RUN' when 60 then 'SMART_ACTION_SET_DISABLE_GRAVITY' when 61 then 'SMART_ACTION_SET_SWIM' when 62 then 'SMART_ACTION_TELEPORT' when 63 then 'SMART_ACTION_SET_COUNTER' when 64 then 'SMART_ACTION_STORE_TARGET_LIST' when 65 then 'SMART_ACTION_WP_RESUME' when 66 then 'SMART_ACTION_SET_ORIENTATION' when 67 then 'SMART_ACTION_CREATE_TIMED_EVENT' when 68 then 'SMART_ACTION_PLAYMOVIE' when 69 then 'SMART_ACTION_MOVE_TO_POS' when 70 then 'SMART_ACTION_ENABLE_TEMP_GOBJ' when 71 then 'SMART_ACTION_EQUIP' when 72 then 'SMART_ACTION_CLOSE_GOSSIP' when 73 then 'SMART_ACTION_TRIGGER_TIMED_EVENT' when 74 then 'SMART_ACTION_REMOVE_TIMED_EVENT' when 75 then 'SMART_ACTION_ADD_AURA' when 76 then 'SMART_ACTION_OVERRIDE_SCRIPT_BASE_OBJECT' when 77 then 'SMART_ACTION_RESET_SCRIPT_BASE_OBJECT' when 78 then 'SMART_ACTION_CALL_SCRIPT_RESET' when 79 then 'SMART_ACTION_SET_RANGED_MOVEMENT' when 80 then 'SMART_ACTION_CALL_TIMED_ACTIONLIST' when 81 then 'SMART_ACTION_SET_NPC_FLAG' when 82 then 'SMART_ACTION_ADD_NPC_FLAG' when 83 then 'SMART_ACTION_REMOVE_NPC_FLAG' when 84 then 'SMART_ACTION_SIMPLE_TALK' when 85 then 'SMART_ACTION_SELF_CAST' when 86 then 'SMART_ACTION_CROSS_CAST' when 87 then 'SMART_ACTION_CALL_RANDOM_TIMED_ACTIONLIST' when 88 then 'SMART_ACTION_CALL_RANDOM_RANGE_TIMED_ACTIONLIST' when 89 then 'SMART_ACTION_RANDOM_MOVE' when 90 then 'SMART_ACTION_SET_UNIT_FIELD_BYTES_1' when 91 then 'SMART_ACTION_REMOVE_UNIT_FIELD_BYTES_1' when 92 then 'SMART_ACTION_INTERRUPT_SPELL' when 93 then 'SMART_ACTION_SEND_GO_CUSTOM_ANIM' when 94 then 'SMART_ACTION_SET_DYNAMIC_FLAG' when 95 then 'SMART_ACTION_ADD_DYNAMIC_FLAG' when 96 then 'SMART_ACTION_REMOVE_DYNAMIC_FLAG' when 97 then 'SMART_ACTION_JUMP_TO_POS' when 98 then 'SMART_ACTION_SEND_GOSSIP_MENU' when 99 then 'SMART_ACTION_GO_SET_LOOT_STATE' when 100 then 'SMART_ACTION_SEND_TARGET_TO_TARGET' when 101 then 'SMART_ACTION_SET_HOME_POS' when 102 then 'SMART_ACTION_SET_HEALTH_REGEN' when 103 then 'SMART_ACTION_SET_ROOT' when 104 then 'SMART_ACTION_SET_GO_FLAG' when 105 then 'SMART_ACTION_ADD_GO_FLAG' when 106 then 'SMART_ACTION_REMOVE_GO_FLAG' when 107 then 'SMART_ACTION_SUMMON_CREATURE_GROUP' when 108 then 'SMART_ACTION_SET_POWER' when 109 then 'SMART_ACTION_ADD_POWER' when 110 then 'SMART_ACTION_REMOVE_POWER' when 111 then 'SMART_ACTION_GAME_EVENT_STOP' when 112 then 'SMART_ACTION_GAME_EVENT_START' when 113 then 'SMART_ACTION_START_CLOSEST_WAYPOINT' when 114 then 'SMART_ACTION_MOVE_OFFSET' when 115 then 'SMART_ACTION_RANDOM_SOUND' when 116 then 'SMART_ACTION_SET_CORPSE_DELAY' when 117 then 'SMART_ACTION_DISABLE_EVADE' when 118 then 'SMART_ACTION_GO_SET_GO_STATE' when 119 then 'SMART_ACTION_SET_CAN_FLY' when 120 then 'SMART_ACTION_REMOVE_AURAS_BY_TYPE' when 121 then 'SMART_ACTION_SET_SIGHT_DIST' when 122 then 'SMART_ACTION_FLEE' when 123 then 'SMART_ACTION_ADD_THREAT' when 124 then 'SMART_ACTION_LOAD_EQUIPMENT' when 125 then 'SMART_ACTION_TRIGGER_RANDOM_TIMED_EVENT' when 126 then 'SMART_ACTION_REMOVE_ALL_GAMEOBJECTS' when 127 then 'SMART_ACTION_PAUSE_MOVEMENT' when 128 then 'SMART_ACTION_PLAY_ANIMKIT' when 129 then 'SMART_ACTION_SCENE_PLAY' when 130 then 'SMART_ACTION_SCENE_CANCEL' when 131 then 'SMART_ACTION_SPAWN_SPAWNGROUP' when 132 then 'SMART_ACTION_DESPAWN_SPAWNGROUP' when 133 then 'SMART_ACTION_RESPAWN_BY_SPAWNID' when 134 then 'SMART_ACTION_INVOKER_CAST' when 135 then 'SMART_ACTION_PLAY_CINEMATIC' when 136 then 'SMART_ACTION_SET_MOVEMENT_SPEED' when 137 then 'SMART_ACTION_PLAY_SPELL_VISUAL_KIT' when 138 then 'SMART_ACTION_OVERRIDE_LIGHT' when 139 then 'SMART_ACTION_OVERRIDE_WEATHER' when 143 then 'SMART_ACTION_CREATE_CONVERSATION' when 144 then 'SMART_ACTION_SET_IMMUNE_PC' when 145 then 'SMART_ACTION_SET_IMMUNE_NPC' when 146 then 'SMART_ACTION_SET_UNINTERACTIBLE' when 147 then 'SMART_ACTION_ACTIVATE_GAMEOBJECT' when 148 then 'SMART_ACTION_ADD_TO_STORED_TARGET_LIST' when 149 then 'SMART_ACTION_BECOME_PERSONAL_CLONE_FOR_PLAYER' else `smart_scripts`.`action_type` end) AS `action_type`,`smart_scripts`.`action_param1` AS `action_param1`,`smart_scripts`.`action_param2` AS `action_param2`,`smart_scripts`.`action_param3` AS `action_param3`,`smart_scripts`.`action_param4` AS `action_param4`,`smart_scripts`.`action_param5` AS `action_param5`,`smart_scripts`.`action_param6` AS `action_param6`,(case `smart_scripts`.`target_type` when 0 then 'SMART_TARGET_NONE' when 1 then 'SMART_TARGET_SELF' when 2 then 'SMART_TARGET_VICTIM' when 3 then 'SMART_TARGET_HOSTILE_SECOND_AGGRO' when 4 then 'SMART_TARGET_HOSTILE_LAST_AGGRO' when 5 then 'SMART_TARGET_HOSTILE_RANDOM' when 6 then 'SMART_TARGET_HOSTILE_RANDOM_NOT_TOP' when 7 then 'SMART_TARGET_ACTION_INVOKER' when 8 then 'SMART_TARGET_POSITION' when 9 then 'SMART_TARGET_CREATURE_RANGE' when 10 then 'SMART_TARGET_CREATURE_GUID' when 11 then 'SMART_TARGET_CREATURE_DISTANCE' when 12 then 'SMART_TARGET_STORED' when 13 then 'SMART_TARGET_GAMEOBJECT_RANGE' when 14 then 'SMART_TARGET_GAMEOBJECT_GUID' when 15 then 'SMART_TARGET_GAMEOBJECT_DISTANCE' when 16 then 'SMART_TARGET_INVOKER_PARTY' when 17 then 'SMART_TARGET_PLAYER_RANGE' when 18 then 'SMART_TARGET_PLAYER_DISTANCE' when 19 then 'SMART_TARGET_CLOSEST_CREATURE' when 20 then 'SMART_TARGET_CLOSEST_GAMEOBJECT' when 21 then 'SMART_TARGET_CLOSEST_PLAYER' when 22 then 'SMART_TARGET_ACTION_INVOKER_VEHICLE' when 23 then 'SMART_TARGET_OWNER_OR_SUMMONER' when 24 then 'SMART_TARGET_THREAT_LIST' when 25 then 'SMART_TARGET_CLOSEST_ENEMY' when 26 then 'SMART_TARGET_CLOSEST_FRIENDLY' when 27 then 'SMART_TARGET_LOOT_RECIPIENTS' when 28 then 'SMART_TARGET_FARTHEST' when 29 then 'SMART_TARGET_VEHICLE_PASSENGER' when 30 then 'SMART_TARGET_CLOSEST_UNSPAWNED_GAMEOBJECT' else `smart_scripts`.`target_type` end) AS `target_type`,`smart_scripts`.`target_param1` AS `target_param1`,`smart_scripts`.`target_param2` AS `target_param2`,`smart_scripts`.`target_param3` AS `target_param3`,`smart_scripts`.`target_param4` AS `target_param4`,`smart_scripts`.`target_x` AS `target_x`,`smart_scripts`.`target_y` AS `target_y`,`smart_scripts`.`target_z` AS `target_z`,`smart_scripts`.`target_o` AS `target_o`,`smart_scripts`.`comment` AS `comment` from `smart_scripts` */;
@@ -4767,4 +4782,4 @@ CREATE TABLE `world_state` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2022-07-25 18:44:14
+-- Dump completed on 2022-08-19 23:43:08
diff --git a/sql/updates/auth/master/2022_07_25_00_auth.sql b/sql/old/9.x/auth/22071_2022_08_19/2022_07_25_00_auth.sql
index db0f935b6ac..db0f935b6ac 100644
--- a/sql/updates/auth/master/2022_07_25_00_auth.sql
+++ b/sql/old/9.x/auth/22071_2022_08_19/2022_07_25_00_auth.sql
diff --git a/sql/updates/auth/master/2022_08_02_00_auth.sql b/sql/old/9.x/auth/22071_2022_08_19/2022_08_02_00_auth.sql
index 740ce9ae2ee..740ce9ae2ee 100644
--- a/sql/updates/auth/master/2022_08_02_00_auth.sql
+++ b/sql/old/9.x/auth/22071_2022_08_19/2022_08_02_00_auth.sql
diff --git a/sql/updates/auth/master/2022_08_17_00_auth.sql b/sql/old/9.x/auth/22071_2022_08_19/2022_08_17_00_auth.sql
index 6fa99fa9b39..6fa99fa9b39 100644
--- a/sql/updates/auth/master/2022_08_17_00_auth.sql
+++ b/sql/old/9.x/auth/22071_2022_08_19/2022_08_17_00_auth.sql
diff --git a/sql/updates/auth/master/2022_08_19_00_auth.sql b/sql/old/9.x/auth/22071_2022_08_19/2022_08_19_00_auth.sql
index cfe5d1193ec..cfe5d1193ec 100644
--- a/sql/updates/auth/master/2022_08_19_00_auth.sql
+++ b/sql/old/9.x/auth/22071_2022_08_19/2022_08_19_00_auth.sql
diff --git a/sql/updates/characters/master/2022_07_25_00_characters.sql b/sql/old/9.x/characters/22071_2022_08_19/2022_07_25_00_characters.sql
index 0c96a338dc2..0c96a338dc2 100644
--- a/sql/updates/characters/master/2022_07_25_00_characters.sql
+++ b/sql/old/9.x/characters/22071_2022_08_19/2022_07_25_00_characters.sql
diff --git a/sql/updates/hotfixes/master/2022_07_25_00_hotfixes.sql b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_07_25_00_hotfixes.sql
index 472a7100fea..472a7100fea 100644
--- a/sql/updates/hotfixes/master/2022_07_25_00_hotfixes.sql
+++ b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_07_25_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2022_08_19_00_hotfixes_enUS.sql b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_00_hotfixes_enUS.sql
index bee546076f5..bee546076f5 100644
--- a/sql/updates/hotfixes/master/2022_08_19_00_hotfixes_enUS.sql
+++ b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_00_hotfixes_enUS.sql
diff --git a/sql/updates/hotfixes/master/2022_08_19_01_hotfixes_esMX.sql b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_01_hotfixes_esMX.sql
index 1b8660072cb..1b8660072cb 100644
--- a/sql/updates/hotfixes/master/2022_08_19_01_hotfixes_esMX.sql
+++ b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_01_hotfixes_esMX.sql
diff --git a/sql/updates/hotfixes/master/2022_08_19_02_hotfixes_ptBR.sql b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_02_hotfixes_ptBR.sql
index eb66fef6e5a..eb66fef6e5a 100644
--- a/sql/updates/hotfixes/master/2022_08_19_02_hotfixes_ptBR.sql
+++ b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_02_hotfixes_ptBR.sql
diff --git a/sql/updates/hotfixes/master/2022_08_19_03_hotfixes_frFR.sql b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_03_hotfixes_frFR.sql
index b5e8d8039db..b5e8d8039db 100644
--- a/sql/updates/hotfixes/master/2022_08_19_03_hotfixes_frFR.sql
+++ b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_03_hotfixes_frFR.sql
diff --git a/sql/updates/hotfixes/master/2022_08_19_04_hotfixes_deDE.sql b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_04_hotfixes_deDE.sql
index 03b982df52f..03b982df52f 100644
--- a/sql/updates/hotfixes/master/2022_08_19_04_hotfixes_deDE.sql
+++ b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_04_hotfixes_deDE.sql
diff --git a/sql/updates/hotfixes/master/2022_08_19_05_hotfixes_esES.sql b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_05_hotfixes_esES.sql
index dfcca757a88..dfcca757a88 100644
--- a/sql/updates/hotfixes/master/2022_08_19_05_hotfixes_esES.sql
+++ b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_05_hotfixes_esES.sql
diff --git a/sql/updates/hotfixes/master/2022_08_19_06_hotfixes_itIT.sql b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_06_hotfixes_itIT.sql
index 8ce53de6029..8ce53de6029 100644
--- a/sql/updates/hotfixes/master/2022_08_19_06_hotfixes_itIT.sql
+++ b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_06_hotfixes_itIT.sql
diff --git a/sql/updates/hotfixes/master/2022_08_19_07_hotfixes_ruRU.sql b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_07_hotfixes_ruRU.sql
index e4102ca804d..e4102ca804d 100644
--- a/sql/updates/hotfixes/master/2022_08_19_07_hotfixes_ruRU.sql
+++ b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_07_hotfixes_ruRU.sql
diff --git a/sql/updates/hotfixes/master/2022_08_19_08_hotfixes_koKR.sql b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_08_hotfixes_koKR.sql
index fb51a151de6..fb51a151de6 100644
--- a/sql/updates/hotfixes/master/2022_08_19_08_hotfixes_koKR.sql
+++ b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_08_hotfixes_koKR.sql
diff --git a/sql/updates/hotfixes/master/2022_08_19_09_hotfixes_zhCN.sql b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_09_hotfixes_zhCN.sql
index b25b52dfdbc..b25b52dfdbc 100644
--- a/sql/updates/hotfixes/master/2022_08_19_09_hotfixes_zhCN.sql
+++ b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_09_hotfixes_zhCN.sql
diff --git a/sql/updates/hotfixes/master/2022_08_19_10_hotfixes_zhTW.sql b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_10_hotfixes_zhTW.sql
index bd857595d8e..bd857595d8e 100644
--- a/sql/updates/hotfixes/master/2022_08_19_10_hotfixes_zhTW.sql
+++ b/sql/old/9.x/hotfixes/22071_2022_08_19/2022_08_19_10_hotfixes_zhTW.sql
diff --git a/sql/updates/world/master/2022_07_25_03_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_25_03_world.sql
index 04e4cd787ef..04e4cd787ef 100644
--- a/sql/updates/world/master/2022_07_25_03_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_25_03_world.sql
diff --git a/sql/updates/world/master/2022_07_29_00_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_00_world.sql
index b7a836bd1ec..b7a836bd1ec 100644
--- a/sql/updates/world/master/2022_07_29_00_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_00_world.sql
diff --git a/sql/updates/world/master/2022_07_29_01_world_goldshire.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_01_world_goldshire.sql
index 0c8efb018f5..0c8efb018f5 100644
--- a/sql/updates/world/master/2022_07_29_01_world_goldshire.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_01_world_goldshire.sql
diff --git a/sql/updates/world/master/2022_07_29_02_world_stormwind.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_02_world_stormwind.sql
index f20092d2605..f20092d2605 100644
--- a/sql/updates/world/master/2022_07_29_02_world_stormwind.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_02_world_stormwind.sql
diff --git a/sql/updates/world/master/2022_07_29_03_world_kharanos.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_03_world_kharanos.sql
index a3d637b8f84..a3d637b8f84 100644
--- a/sql/updates/world/master/2022_07_29_03_world_kharanos.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_03_world_kharanos.sql
diff --git a/sql/updates/world/master/2022_07_29_04_world_ironforge.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_04_world_ironforge.sql
index a664ad72803..a664ad72803 100644
--- a/sql/updates/world/master/2022_07_29_04_world_ironforge.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_04_world_ironforge.sql
diff --git a/sql/updates/world/master/2022_07_29_05_world_dolanaar.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_05_world_dolanaar.sql
index c8ce7258665..c8ce7258665 100644
--- a/sql/updates/world/master/2022_07_29_05_world_dolanaar.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_05_world_dolanaar.sql
diff --git a/sql/updates/world/master/2022_07_29_06_world_darnassus.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_06_world_darnassus.sql
index 2946328b812..2946328b812 100644
--- a/sql/updates/world/master/2022_07_29_06_world_darnassus.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_06_world_darnassus.sql
diff --git a/sql/updates/world/master/2022_07_29_07_world_azurewatch.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_07_world_azurewatch.sql
index aa8f24d0a3d..aa8f24d0a3d 100644
--- a/sql/updates/world/master/2022_07_29_07_world_azurewatch.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_07_world_azurewatch.sql
diff --git a/sql/updates/world/master/2022_07_29_08_world_exodar.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_08_world_exodar.sql
index 4b818b17049..4b818b17049 100644
--- a/sql/updates/world/master/2022_07_29_08_world_exodar.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_08_world_exodar.sql
diff --git a/sql/updates/world/master/2022_07_29_09_world_theramore.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_09_world_theramore.sql
index 34061424f80..34061424f80 100644
--- a/sql/updates/world/master/2022_07_29_09_world_theramore.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_09_world_theramore.sql
diff --git a/sql/updates/world/master/2022_07_29_10_world_razor_hill.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_10_world_razor_hill.sql
index 241bc3af6db..241bc3af6db 100644
--- a/sql/updates/world/master/2022_07_29_10_world_razor_hill.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_10_world_razor_hill.sql
diff --git a/sql/updates/world/master/2022_07_29_11_world_bloodhoof_village.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_11_world_bloodhoof_village.sql
index b057cd13c3d..b057cd13c3d 100644
--- a/sql/updates/world/master/2022_07_29_11_world_bloodhoof_village.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_11_world_bloodhoof_village.sql
diff --git a/sql/updates/world/master/2022_07_29_12_world_thunderbluff.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_12_world_thunderbluff.sql
index f1ed54b792f..f1ed54b792f 100644
--- a/sql/updates/world/master/2022_07_29_12_world_thunderbluff.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_12_world_thunderbluff.sql
diff --git a/sql/updates/world/master/2022_07_29_13_world_brill.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_13_world_brill.sql
index eafe793cd2c..eafe793cd2c 100644
--- a/sql/updates/world/master/2022_07_29_13_world_brill.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_29_13_world_brill.sql
diff --git a/sql/updates/world/master/2022_07_31_00_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_31_00_world.sql
index 09e8379fc79..09e8379fc79 100644
--- a/sql/updates/world/master/2022_07_31_00_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_31_00_world.sql
diff --git a/sql/updates/world/master/2022_07_31_01_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_07_31_01_world.sql
index 092dc6d961f..092dc6d961f 100644
--- a/sql/updates/world/master/2022_07_31_01_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_07_31_01_world.sql
diff --git a/sql/updates/world/master/2022_08_01_00_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_01_00_world.sql
index 5b743ac86f9..5b743ac86f9 100644
--- a/sql/updates/world/master/2022_08_01_00_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_01_00_world.sql
diff --git a/sql/updates/world/master/2022_08_02_00_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_02_00_world.sql
index 7f02a6a610c..7f02a6a610c 100644
--- a/sql/updates/world/master/2022_08_02_00_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_02_00_world.sql
diff --git a/sql/updates/world/master/2022_08_02_01_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_02_01_world.sql
index 02e10aff69d..02e10aff69d 100644
--- a/sql/updates/world/master/2022_08_02_01_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_02_01_world.sql
diff --git a/sql/updates/world/master/2022_08_02_02_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_02_02_world.sql
index cd5d33f658f..cd5d33f658f 100644
--- a/sql/updates/world/master/2022_08_02_02_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_02_02_world.sql
diff --git a/sql/updates/world/master/2022_08_02_03_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_02_03_world.sql
index ec346e080bc..ec346e080bc 100644
--- a/sql/updates/world/master/2022_08_02_03_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_02_03_world.sql
diff --git a/sql/updates/world/master/2022_08_04_00_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_04_00_world.sql
index e08932e5161..e08932e5161 100644
--- a/sql/updates/world/master/2022_08_04_00_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_04_00_world.sql
diff --git a/sql/updates/world/master/2022_08_05_00_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_05_00_world.sql
index 84480b7ffd3..84480b7ffd3 100644
--- a/sql/updates/world/master/2022_08_05_00_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_05_00_world.sql
diff --git a/sql/updates/world/master/2022_08_05_01_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_05_01_world.sql
index 380c86645b6..380c86645b6 100644
--- a/sql/updates/world/master/2022_08_05_01_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_05_01_world.sql
diff --git a/sql/updates/world/master/2022_08_09_00_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_00_world.sql
index 702a194101f..702a194101f 100644
--- a/sql/updates/world/master/2022_08_09_00_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_00_world.sql
diff --git a/sql/updates/world/master/2022_08_09_01_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_01_world.sql
index d6f8d217ad4..d6f8d217ad4 100644
--- a/sql/updates/world/master/2022_08_09_01_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_01_world.sql
diff --git a/sql/updates/world/master/2022_08_09_02_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_02_world.sql
index 614e6e1b0b9..614e6e1b0b9 100644
--- a/sql/updates/world/master/2022_08_09_02_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_02_world.sql
diff --git a/sql/updates/world/master/2022_08_09_03_world_orgrimmar.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_03_world_orgrimmar.sql
index c6cec611398..c6cec611398 100644
--- a/sql/updates/world/master/2022_08_09_03_world_orgrimmar.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_03_world_orgrimmar.sql
diff --git a/sql/updates/world/master/2022_08_09_04_world_undercity.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_04_world_undercity.sql
index 0276587a958..0276587a958 100644
--- a/sql/updates/world/master/2022_08_09_04_world_undercity.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_04_world_undercity.sql
diff --git a/sql/updates/world/master/2022_08_09_05_world_falconwing_square.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_05_world_falconwing_square.sql
index 98c65445c62..98c65445c62 100644
--- a/sql/updates/world/master/2022_08_09_05_world_falconwing_square.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_05_world_falconwing_square.sql
diff --git a/sql/updates/world/master/2022_08_09_06_world_silvermoon.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_06_world_silvermoon.sql
index 52d8bb70bf5..52d8bb70bf5 100644
--- a/sql/updates/world/master/2022_08_09_06_world_silvermoon.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_06_world_silvermoon.sql
diff --git a/sql/updates/world/master/2022_08_09_07_world_shattrath.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_07_world_shattrath.sql
index 653474f6dba..653474f6dba 100644
--- a/sql/updates/world/master/2022_08_09_07_world_shattrath.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_07_world_shattrath.sql
diff --git a/sql/updates/world/master/2022_08_09_08_world_dalaran.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_08_world_dalaran.sql
index ed07e1def1f..ed07e1def1f 100644
--- a/sql/updates/world/master/2022_08_09_08_world_dalaran.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_08_world_dalaran.sql
diff --git a/sql/updates/world/master/2022_08_09_09_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_09_world.sql
index 3d50b1757fb..3d50b1757fb 100644
--- a/sql/updates/world/master/2022_08_09_09_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_09_world.sql
diff --git a/sql/updates/world/master/2022_08_09_10_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_10_world.sql
index dae457f553b..dae457f553b 100644
--- a/sql/updates/world/master/2022_08_09_10_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_10_world.sql
diff --git a/sql/updates/world/master/2022_08_09_11_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_11_world.sql
index 81735bd8de8..81735bd8de8 100644
--- a/sql/updates/world/master/2022_08_09_11_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_09_11_world.sql
diff --git a/sql/updates/world/master/2022_08_10_00_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_10_00_world.sql
index 3091aeaf366..3091aeaf366 100644
--- a/sql/updates/world/master/2022_08_10_00_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_10_00_world.sql
diff --git a/sql/updates/world/master/2022_08_10_01_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_10_01_world.sql
index 6cc979ae150..6cc979ae150 100644
--- a/sql/updates/world/master/2022_08_10_01_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_10_01_world.sql
diff --git a/sql/updates/world/master/2022_08_10_02_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_10_02_world.sql
index f83e09e1b16..f83e09e1b16 100644
--- a/sql/updates/world/master/2022_08_10_02_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_10_02_world.sql
diff --git a/sql/updates/world/master/2022_08_10_03_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_10_03_world.sql
index eeb433e7d9b..eeb433e7d9b 100644
--- a/sql/updates/world/master/2022_08_10_03_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_10_03_world.sql
diff --git a/sql/updates/world/master/2022_08_13_00_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_13_00_world.sql
index 40db4990405..40db4990405 100644
--- a/sql/updates/world/master/2022_08_13_00_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_13_00_world.sql
diff --git a/sql/updates/world/master/2022_08_19_00_world_enUS.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_00_world_enUS.sql
index c94e9a92af2..c94e9a92af2 100644
--- a/sql/updates/world/master/2022_08_19_00_world_enUS.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_00_world_enUS.sql
diff --git a/sql/updates/world/master/2022_08_19_01_world_esMX.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_01_world_esMX.sql
index d3d7023d754..d3d7023d754 100644
--- a/sql/updates/world/master/2022_08_19_01_world_esMX.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_01_world_esMX.sql
diff --git a/sql/updates/world/master/2022_08_19_02_world_ptBR.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_02_world_ptBR.sql
index eab7b51d675..eab7b51d675 100644
--- a/sql/updates/world/master/2022_08_19_02_world_ptBR.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_02_world_ptBR.sql
diff --git a/sql/updates/world/master/2022_08_19_03_world_frFR.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_03_world_frFR.sql
index b18826c30e5..b18826c30e5 100644
--- a/sql/updates/world/master/2022_08_19_03_world_frFR.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_03_world_frFR.sql
diff --git a/sql/updates/world/master/2022_08_19_04_world_deDE.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_04_world_deDE.sql
index 89570552073..89570552073 100644
--- a/sql/updates/world/master/2022_08_19_04_world_deDE.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_04_world_deDE.sql
diff --git a/sql/updates/world/master/2022_08_19_05_world_esES.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_05_world_esES.sql
index 4313ca6b748..4313ca6b748 100644
--- a/sql/updates/world/master/2022_08_19_05_world_esES.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_05_world_esES.sql
diff --git a/sql/updates/world/master/2022_08_19_06_world_itIT.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_06_world_itIT.sql
index 8065f343256..8065f343256 100644
--- a/sql/updates/world/master/2022_08_19_06_world_itIT.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_06_world_itIT.sql
diff --git a/sql/updates/world/master/2022_08_19_07_world_ruRU.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_07_world_ruRU.sql
index d126cba5b3f..d126cba5b3f 100644
--- a/sql/updates/world/master/2022_08_19_07_world_ruRU.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_07_world_ruRU.sql
diff --git a/sql/updates/world/master/2022_08_19_08_world_koKR.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_08_world_koKR.sql
index 535102491ab..535102491ab 100644
--- a/sql/updates/world/master/2022_08_19_08_world_koKR.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_08_world_koKR.sql
diff --git a/sql/updates/world/master/2022_08_19_09_world_zhCN.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_09_world_zhCN.sql
index 8c1b1e8568b..8c1b1e8568b 100644
--- a/sql/updates/world/master/2022_08_19_09_world_zhCN.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_09_world_zhCN.sql
diff --git a/sql/updates/world/master/2022_08_19_10_world_zhTW.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_10_world_zhTW.sql
index 0bf7d1bcc9e..0bf7d1bcc9e 100644
--- a/sql/updates/world/master/2022_08_19_10_world_zhTW.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_10_world_zhTW.sql
diff --git a/sql/updates/world/master/2022_08_19_11_world_quest_poi.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_11_world_quest_poi.sql
index b7b389b4655..b7b389b4655 100644
--- a/sql/updates/world/master/2022_08_19_11_world_quest_poi.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_19_11_world_quest_poi.sql
diff --git a/sql/updates/world/master/2022_08_20_00_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_20_00_world.sql
index da2d1232064..da2d1232064 100644
--- a/sql/updates/world/master/2022_08_20_00_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_20_00_world.sql
diff --git a/sql/updates/world/master/2022_08_20_01_world.sql b/sql/old/9.x/world/22071_2022_08_19/2022_08_20_01_world.sql
index 2d59db62f93..2d59db62f93 100644
--- a/sql/updates/world/master/2022_08_20_01_world.sql
+++ b/sql/old/9.x/world/22071_2022_08_19/2022_08_20_01_world.sql
diff --git a/sql/updates/auth/master/2022_08_19_01_auth.sql b/sql/updates/auth/master/2022_08_19_01_auth.sql
new file mode 100644
index 00000000000..a274ed2be36
--- /dev/null
+++ b/sql/updates/auth/master/2022_08_19_01_auth.sql
@@ -0,0 +1,3 @@
+-- TDB 927.22081 auth
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/auth', 'ARCHIVED');
diff --git a/sql/updates/characters/master/2022_08_19_00_characters.sql b/sql/updates/characters/master/2022_08_19_00_characters.sql
new file mode 100644
index 00000000000..c6d034fe33d
--- /dev/null
+++ b/sql/updates/characters/master/2022_08_19_00_characters.sql
@@ -0,0 +1,3 @@
+-- TDB 927.22081 characters
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/characters', 'ARCHIVED');
diff --git a/sql/updates/hotfixes/master/2022_08_19_11_hotfixes.sql b/sql/updates/hotfixes/master/2022_08_19_11_hotfixes.sql
new file mode 100644
index 00000000000..57d48733650
--- /dev/null
+++ b/sql/updates/hotfixes/master/2022_08_19_11_hotfixes.sql
@@ -0,0 +1,3 @@
+-- TDB 927.22081 hotfixes
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/hotfixes', 'ARCHIVED');
diff --git a/sql/updates/world/master/2022_08_19_12_world.sql b/sql/updates/world/master/2022_08_19_12_world.sql
new file mode 100644
index 00000000000..dd04a0d8a98
--- /dev/null
+++ b/sql/updates/world/master/2022_08_19_12_world.sql
@@ -0,0 +1,4 @@
+-- TDB 927.22081 world
+UPDATE `version` SET `db_version`='TDB 927.22081', `cache_id`=22081 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/world', 'ARCHIVED');