TDB 1102.24092 - 2024/09/23TDB1102.24092

64 files changed, 31 insertions, 16 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index e69f4eac84b..c75dbf91a11 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -3236,11 +3236,12 @@ INSERT INTO `updates` VALUES
 ('2024_08_31_00_auth.sql','D10F12D25D526A2C5E12FCEA2DEB55C342879F06','ARCHIVED','2024-08-31 10:32:16',0),
 ('2024_08_31_01_auth.sql','3ADC34DAE405697983EDDD32D0F3FC6F122CA819','ARCHIVED','2024-09-01 15:48:43',0),
 ('2024_09_03_00_auth.sql','BF65B550256CA64F0936D98A619E8A2A7E7A9B59','ARCHIVED','2024-09-03 00:47:42',0),
-('2024_09_05_00_auth.sql','9CD84EB94AE50F14A392C216E7CA7BA33E92376E','RELEASED','2024-09-05 13:38:34',0),
-('2024_09_05_01_auth.sql','42D5E703382C57C4ADD862CF215F1166625100E5','RELEASED','2024-09-05 23:42:10',0),
-('2024_09_11_00_auth.sql','8B810B5EB20D769A50A2D01411BBD065732E4EE6','RELEASED','2024-09-11 12:23:18',0),
-('2024_09_18_00_auth.sql','073B6E954B585CD81BFADD58CDAD166E85D2653A','RELEASED','2024-09-18 10:26:42',0),
-('2024_09_18_01_auth.sql','6AE1437E24D4837EB2347ADAA80A4093CA9F6D67','RELEASED','2024-09-18 21:30:31',0);
+('2024_09_05_00_auth.sql','9CD84EB94AE50F14A392C216E7CA7BA33E92376E','ARCHIVED','2024-09-05 13:38:34',0),
+('2024_09_05_01_auth.sql','42D5E703382C57C4ADD862CF215F1166625100E5','ARCHIVED','2024-09-05 23:42:10',0),
+('2024_09_11_00_auth.sql','8B810B5EB20D769A50A2D01411BBD065732E4EE6','ARCHIVED','2024-09-11 12:23:18',0),
+('2024_09_18_00_auth.sql','073B6E954B585CD81BFADD58CDAD166E85D2653A','ARCHIVED','2024-09-18 10:26:42',0),
+('2024_09_18_01_auth.sql','6AE1437E24D4837EB2347ADAA80A4093CA9F6D67','ARCHIVED','2024-09-18 21:30:31',0),
+('2024_09_23_00_auth.sql','CBAB00B40360D8942AD1E4EDBE0F0097F3F6FC9B','ARCHIVED','2024-09-23 22:48:10',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -3384,4 +3385,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 2024-09-03  0:47:44
+-- Dump completed on 2024-09-23 22:48:12
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 556f50eb348..5a01bb9d82d 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -3747,7 +3747,8 @@ INSERT INTO `updates` VALUES
 ('2024_08_04_00_characters.sql','7D153C59998416E6EA1455086730A2321AD0F2A8','ARCHIVED','2024-08-04 17:58:59',0),
 ('2024_08_05_00_characters.sql','7E4AE28F9EC370A1B22DBD8DD718EE027A321F33','ARCHIVED','2024-08-05 11:19:40',0),
 ('2024_08_26_00_characters.sql','68EEBE1D639D59B24F5121008C2D103CA67FFC9A','ARCHIVED','2024-08-26 00:49:08',0),
-('2024_09_03_00_characters.sql','71ECC73A3F324EB64DA19B0CC4DF72A85E022BDC','ARCHIVED','2024-09-03 00:47:42',0);
+('2024_09_03_00_characters.sql','71ECC73A3F324EB64DA19B0CC4DF72A85E022BDC','ARCHIVED','2024-09-03 00:47:42',0),
+('2024_09_23_00_characters.sql','D8491BCEE728F40D55D47E3A4BC5A5F083EBD02E','ARCHIVED','2024-09-23 22:48:10',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -3875,4 +3876,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2024-09-03  0:47:44
+-- Dump completed on 2024-09-23 22:48:12
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index 5b32be0a424..0e424df11e3 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_database.sql
@@ -4672,7 +4672,7 @@ DROP TABLE IF EXISTS `item_bonus_tree_node`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `item_bonus_tree_node` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `ItemContext` tinyint unsigned NOT NULL DEFAULT '0',
+  `ItemContext` tinyint NOT NULL DEFAULT '0',
   `ChildItemBonusTreeID` smallint unsigned NOT NULL DEFAULT '0',
   `ChildItemBonusListID` smallint unsigned NOT NULL DEFAULT '0',
   `ChildItemLevelSelectorID` smallint unsigned NOT NULL DEFAULT '0',
@@ -9919,8 +9919,8 @@ DROP TABLE IF EXISTS `trait_sub_tree`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trait_sub_tree` (
-  `Name` text COLLATE utf8mb4_unicode_ci,
-  `Description` text COLLATE utf8mb4_unicode_ci,
+  `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ID` int unsigned NOT NULL DEFAULT '0',
   `UiTextureAtlasElementID` int NOT NULL DEFAULT '0',
   `TraitTreeID` int NOT NULL DEFAULT '0',
@@ -9938,9 +9938,9 @@ DROP TABLE IF EXISTS `trait_sub_tree_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trait_sub_tree_locale` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `Name_lang` text COLLATE utf8mb4_unicode_ci,
-  `Description_lang` text COLLATE utf8mb4_unicode_ci,
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Description_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
@@ -10864,4 +10864,4 @@ CREATE TABLE `world_state_expression` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2024-09-03  0:47:48
+-- Dump completed on 2024-09-23 22:48:16
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 7793ce17634..e35107b5ea3 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -4983,4 +4983,4 @@ CREATE TABLE `world_state` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2024-09-03  0:47:46
+-- Dump completed on 2024-09-23 22:48:14
diff --git a/sql/updates/auth/master/2024_09_03_00_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_03_00_auth.sql
index f953e7436c4..f953e7436c4 100644
--- a/sql/updates/auth/master/2024_09_03_00_auth.sql
+++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_03_00_auth.sql
diff --git a/sql/updates/auth/master/2024_09_05_00_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_05_00_auth.sql
index 5008d467ab1..5008d467ab1 100644
--- a/sql/updates/auth/master/2024_09_05_00_auth.sql
+++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_05_00_auth.sql
diff --git a/sql/updates/auth/master/2024_09_05_01_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_05_01_auth.sql
index d8db68e7325..d8db68e7325 100644
--- a/sql/updates/auth/master/2024_09_05_01_auth.sql
+++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_05_01_auth.sql
diff --git a/sql/updates/auth/master/2024_09_11_00_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_11_00_auth.sql
index c69af833d34..c69af833d34 100644
--- a/sql/updates/auth/master/2024_09_11_00_auth.sql
+++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_11_00_auth.sql
diff --git a/sql/updates/auth/master/2024_09_18_00_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_18_00_auth.sql
index 951d4b5ccc1..951d4b5ccc1 100644
--- a/sql/updates/auth/master/2024_09_18_00_auth.sql
+++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_18_00_auth.sql
diff --git a/sql/updates/auth/master/2024_09_18_01_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_18_01_auth.sql
index 4df91310654..4df91310654 100644
--- a/sql/updates/auth/master/2024_09_18_01_auth.sql
+++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_18_01_auth.sql
diff --git a/sql/updates/characters/master/2024_09_03_00_characters.sql b/sql/old/11.x/characters/24091_2024_09_23/2024_09_03_00_characters.sql
index 223b65274d7..223b65274d7 100644
--- a/sql/updates/characters/master/2024_09_03_00_characters.sql
+++ b/sql/old/11.x/characters/24091_2024_09_23/2024_09_03_00_characters.sql
diff --git a/sql/updates/hotfixes/master/2024_09_03_01_hotfixes.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_03_01_hotfixes.sql
index cb40afc53e6..cb40afc53e6 100644
--- a/sql/updates/hotfixes/master/2024_09_03_01_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_03_01_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_09_22_00_hotfixes.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_22_00_hotfixes.sql
index ed0eb609975..ed0eb609975 100644
--- a/sql/updates/hotfixes/master/2024_09_22_00_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_22_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_09_23_00_hotfixes.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_00_hotfixes.sql
index df4f2746472..df4f2746472 100644
--- a/sql/updates/hotfixes/master/2024_09_23_00_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_09_23_01_hotfixes_deDE.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_01_hotfixes_deDE.sql
index ba9f4e1bce4..ba9f4e1bce4 100644
--- a/sql/updates/hotfixes/master/2024_09_23_01_hotfixes_deDE.sql
+++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_01_hotfixes_deDE.sql
diff --git a/sql/updates/hotfixes/master/2024_09_23_02_hotfixes_esES.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_02_hotfixes_esES.sql
index 2d138791896..2d138791896 100644
--- a/sql/updates/hotfixes/master/2024_09_23_02_hotfixes_esES.sql
+++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_02_hotfixes_esES.sql
diff --git a/sql/updates/hotfixes/master/2024_09_23_03_hotfixes_esMX.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_03_hotfixes_esMX.sql
index 3afd4d67e0f..3afd4d67e0f 100644
--- a/sql/updates/hotfixes/master/2024_09_23_03_hotfixes_esMX.sql
+++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_03_hotfixes_esMX.sql
diff --git a/sql/updates/hotfixes/master/2024_09_23_04_hotfixes_frFR.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_04_hotfixes_frFR.sql
index a3405cf5cd0..a3405cf5cd0 100644
--- a/sql/updates/hotfixes/master/2024_09_23_04_hotfixes_frFR.sql
+++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_04_hotfixes_frFR.sql
diff --git a/sql/updates/hotfixes/master/2024_09_23_05_hotfixes_itIT.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_05_hotfixes_itIT.sql
index 70fa3954e86..70fa3954e86 100644
--- a/sql/updates/hotfixes/master/2024_09_23_05_hotfixes_itIT.sql
+++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_05_hotfixes_itIT.sql
diff --git a/sql/updates/hotfixes/master/2024_09_23_06_hotfixes_koKR.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_06_hotfixes_koKR.sql
index ac61cae0780..ac61cae0780 100644
--- a/sql/updates/hotfixes/master/2024_09_23_06_hotfixes_koKR.sql
+++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_06_hotfixes_koKR.sql
diff --git a/sql/updates/hotfixes/master/2024_09_23_07_hotfixes_ptBR.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_07_hotfixes_ptBR.sql
index a7cbab0b4fa..a7cbab0b4fa 100644
--- a/sql/updates/hotfixes/master/2024_09_23_07_hotfixes_ptBR.sql
+++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_07_hotfixes_ptBR.sql
diff --git a/sql/updates/hotfixes/master/2024_09_23_08_hotfixes_ruRU.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_08_hotfixes_ruRU.sql
index 3d7e6d3e9ac..3d7e6d3e9ac 100644
--- a/sql/updates/hotfixes/master/2024_09_23_08_hotfixes_ruRU.sql
+++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_08_hotfixes_ruRU.sql
diff --git a/sql/updates/hotfixes/master/2024_09_23_09_hotfixes_zhCN.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_09_hotfixes_zhCN.sql
index 997366547fb..997366547fb 100644
--- a/sql/updates/hotfixes/master/2024_09_23_09_hotfixes_zhCN.sql
+++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_09_hotfixes_zhCN.sql
diff --git a/sql/updates/hotfixes/master/2024_09_23_10_hotfixes_zhTW.sql b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_10_hotfixes_zhTW.sql
index 8bef672bcd3..8bef672bcd3 100644
--- a/sql/updates/hotfixes/master/2024_09_23_10_hotfixes_zhTW.sql
+++ b/sql/old/11.x/hotfixes/24091_2024_09_23/2024_09_23_10_hotfixes_zhTW.sql
diff --git a/sql/updates/world/master/2024_09_03_04_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_03_04_world.sql
index 0f5dd34331b..0f5dd34331b 100644
--- a/sql/updates/world/master/2024_09_03_04_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_03_04_world.sql
diff --git a/sql/updates/world/master/2024_09_03_05_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_03_05_world.sql
index 879fe147c03..879fe147c03 100644
--- a/sql/updates/world/master/2024_09_03_05_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_03_05_world.sql
diff --git a/sql/updates/world/master/2024_09_04_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_00_world.sql
index 82aa3c1531d..82aa3c1531d 100644
--- a/sql/updates/world/master/2024_09_04_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_00_world.sql
diff --git a/sql/updates/world/master/2024_09_04_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_01_world.sql
index d18f3f9b4fc..d18f3f9b4fc 100644
--- a/sql/updates/world/master/2024_09_04_01_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_01_world.sql
diff --git a/sql/updates/world/master/2024_09_04_02_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_02_world.sql
index 0b239db8970..0b239db8970 100644
--- a/sql/updates/world/master/2024_09_04_02_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_02_world.sql
diff --git a/sql/updates/world/master/2024_09_04_03_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_03_world.sql
index 6ac9ceca518..6ac9ceca518 100644
--- a/sql/updates/world/master/2024_09_04_03_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_04_03_world.sql
diff --git a/sql/updates/world/master/2024_09_06_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_00_world.sql
index b584b1613aa..b584b1613aa 100644
--- a/sql/updates/world/master/2024_09_06_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_00_world.sql
diff --git a/sql/updates/world/master/2024_09_06_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_01_world.sql
index e7fd81506a5..e7fd81506a5 100644
--- a/sql/updates/world/master/2024_09_06_01_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_01_world.sql
diff --git a/sql/updates/world/master/2024_09_06_02_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_02_world.sql
index 2e066c40f0f..2e066c40f0f 100644
--- a/sql/updates/world/master/2024_09_06_02_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_02_world.sql
diff --git a/sql/updates/world/master/2024_09_06_03_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_03_world.sql
index a7c3517f380..a7c3517f380 100644
--- a/sql/updates/world/master/2024_09_06_03_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_03_world.sql
diff --git a/sql/updates/world/master/2024_09_06_04_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_04_world.sql
index eb2ff304cb8..eb2ff304cb8 100644
--- a/sql/updates/world/master/2024_09_06_04_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_06_04_world.sql
diff --git a/sql/updates/world/master/2024_09_07_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_07_00_world.sql
index 026c315dbe1..026c315dbe1 100644
--- a/sql/updates/world/master/2024_09_07_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_07_00_world.sql
diff --git a/sql/updates/world/master/2024_09_07_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_07_01_world.sql
index 5008e78a006..5008e78a006 100644
--- a/sql/updates/world/master/2024_09_07_01_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_07_01_world.sql
diff --git a/sql/updates/world/master/2024_09_07_02_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_07_02_world.sql
index 148156601a2..148156601a2 100644
--- a/sql/updates/world/master/2024_09_07_02_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_07_02_world.sql
diff --git a/sql/updates/world/master/2024_09_08_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_08_00_world.sql
index 9239c5d47f2..9239c5d47f2 100644
--- a/sql/updates/world/master/2024_09_08_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_08_00_world.sql
diff --git a/sql/updates/world/master/2024_09_08_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_08_01_world.sql
index c25ee8e25a1..c25ee8e25a1 100644
--- a/sql/updates/world/master/2024_09_08_01_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_08_01_world.sql
diff --git a/sql/updates/world/master/2024_09_09_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_09_00_world.sql
index f98f37bc2d4..f98f37bc2d4 100644
--- a/sql/updates/world/master/2024_09_09_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_09_00_world.sql
diff --git a/sql/updates/world/master/2024_09_09_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_09_01_world.sql
index a0c1582f39a..a0c1582f39a 100644
--- a/sql/updates/world/master/2024_09_09_01_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_09_01_world.sql
diff --git a/sql/updates/world/master/2024_09_09_02_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_09_02_world.sql
index 1bab8e08a71..1bab8e08a71 100644
--- a/sql/updates/world/master/2024_09_09_02_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_09_02_world.sql
diff --git a/sql/updates/world/master/2024_09_10_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_10_00_world.sql
index 8182c8a1a89..8182c8a1a89 100644
--- a/sql/updates/world/master/2024_09_10_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_10_00_world.sql
diff --git a/sql/updates/world/master/2024_09_12_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_12_00_world.sql
index 86cb8ed78db..86cb8ed78db 100644
--- a/sql/updates/world/master/2024_09_12_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_12_00_world.sql
diff --git a/sql/updates/world/master/2024_09_12_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_12_01_world.sql
index e71947422f7..e71947422f7 100644
--- a/sql/updates/world/master/2024_09_12_01_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_12_01_world.sql
diff --git a/sql/updates/world/master/2024_09_12_02_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_12_02_world.sql
index abf36df7dcb..abf36df7dcb 100644
--- a/sql/updates/world/master/2024_09_12_02_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_12_02_world.sql
diff --git a/sql/updates/world/master/2024_09_14_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_14_00_world.sql
index fb71f7cdb6e..fb71f7cdb6e 100644
--- a/sql/updates/world/master/2024_09_14_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_14_00_world.sql
diff --git a/sql/updates/world/master/2024_09_14_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_14_01_world.sql
index 3d5421a852e..3d5421a852e 100644
--- a/sql/updates/world/master/2024_09_14_01_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_14_01_world.sql
diff --git a/sql/updates/world/master/2024_09_14_02_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_14_02_world.sql
index 27559419cfd..27559419cfd 100644
--- a/sql/updates/world/master/2024_09_14_02_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_14_02_world.sql
diff --git a/sql/updates/world/master/2024_09_15_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_15_00_world.sql
index 9514593bed0..9514593bed0 100644
--- a/sql/updates/world/master/2024_09_15_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_15_00_world.sql
diff --git a/sql/updates/world/master/2024_09_15_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_15_01_world.sql
index f758fce55b3..f758fce55b3 100644
--- a/sql/updates/world/master/2024_09_15_01_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_15_01_world.sql
diff --git a/sql/updates/world/master/2024_09_16_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_16_00_world.sql
index 1b5ed037eec..1b5ed037eec 100644
--- a/sql/updates/world/master/2024_09_16_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_16_00_world.sql
diff --git a/sql/updates/world/master/2024_09_17_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_17_00_world.sql
index 68817d38592..68817d38592 100644
--- a/sql/updates/world/master/2024_09_17_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_17_00_world.sql
diff --git a/sql/updates/world/master/2024_09_17_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_17_01_world.sql
index e6df25d08bf..e6df25d08bf 100644
--- a/sql/updates/world/master/2024_09_17_01_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_17_01_world.sql
diff --git a/sql/updates/world/master/2024_09_18_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_18_00_world.sql
index d92be32e5f3..d92be32e5f3 100644
--- a/sql/updates/world/master/2024_09_18_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_18_00_world.sql
diff --git a/sql/updates/world/master/2024_09_18_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_18_01_world.sql
index bc0602e41e8..bc0602e41e8 100644
--- a/sql/updates/world/master/2024_09_18_01_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_18_01_world.sql
diff --git a/sql/updates/world/master/2024_09_20_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_20_00_world.sql
index ea42cb0b070..ea42cb0b070 100644
--- a/sql/updates/world/master/2024_09_20_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_20_00_world.sql
diff --git a/sql/updates/world/master/2024_09_21_00_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_21_00_world.sql
index 1e6ee1f3b11..1e6ee1f3b11 100644
--- a/sql/updates/world/master/2024_09_21_00_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_21_00_world.sql
diff --git a/sql/updates/world/master/2024_09_21_01_world.sql b/sql/old/11.x/world/24091_2024_09_23/2024_09_21_01_world.sql
index 8cad2f6a5c4..8cad2f6a5c4 100644
--- a/sql/updates/world/master/2024_09_21_01_world.sql
+++ b/sql/old/11.x/world/24091_2024_09_23/2024_09_21_01_world.sql
diff --git a/sql/updates/auth/master/2024_09_23_00_auth.sql b/sql/updates/auth/master/2024_09_23_00_auth.sql
new file mode 100644
index 00000000000..c4d4e867cdd
--- /dev/null
+++ b/sql/updates/auth/master/2024_09_23_00_auth.sql
@@ -0,0 +1,3 @@
+-- TDB 1102.24092 auth
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/auth', 'ARCHIVED');
diff --git a/sql/updates/characters/master/2024_09_23_00_characters.sql b/sql/updates/characters/master/2024_09_23_00_characters.sql
new file mode 100644
index 00000000000..b385b929e1b
--- /dev/null
+++ b/sql/updates/characters/master/2024_09_23_00_characters.sql
@@ -0,0 +1,3 @@
+-- TDB 1102.24092 characters
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/characters', 'ARCHIVED');
diff --git a/sql/updates/hotfixes/master/2024_09_23_11_hotfixes.sql b/sql/updates/hotfixes/master/2024_09_23_11_hotfixes.sql
new file mode 100644
index 00000000000..7edd4006d4d
--- /dev/null
+++ b/sql/updates/hotfixes/master/2024_09_23_11_hotfixes.sql
@@ -0,0 +1,3 @@
+-- TDB 1102.24092 hotfixes
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/hotfixes', 'ARCHIVED');
diff --git a/sql/updates/world/master/2024_09_23_00_world.sql b/sql/updates/world/master/2024_09_23_00_world.sql
new file mode 100644
index 00000000000..ce874f7f33d
--- /dev/null
+++ b/sql/updates/world/master/2024_09_23_00_world.sql
@@ -0,0 +1,4 @@
+-- TDB 1102.24092 world
+UPDATE `version` SET `db_version`='TDB 1102.24092', `cache_id`=24092 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/world', 'ARCHIVED');