aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--revision_data.h.in.cmake4
-rw-r--r--sql/base/auth_database.sql11
-rw-r--r--sql/base/characters_database.sql5
-rw-r--r--sql/base/dev/hotfixes_database.sql63
-rw-r--r--sql/base/dev/world_database.sql4
-rw-r--r--sql/old/11.x/auth/24111_2024_12_22/2024_11_16_00_auth.sql (renamed from sql/updates/auth/master/2024_11_16_00_auth.sql)0
-rw-r--r--sql/old/11.x/auth/24111_2024_12_22/2024_11_20_00_auth.sql (renamed from sql/updates/auth/master/2024_11_20_00_auth.sql)0
-rw-r--r--sql/old/11.x/auth/24111_2024_12_22/2024_12_18_00_auth.sql (renamed from sql/updates/auth/master/2024_12_18_00_auth.sql)0
-rw-r--r--sql/old/11.x/auth/24111_2024_12_22/2024_12_19_00_auth.sql (renamed from sql/updates/auth/master/2024_12_19_00_auth.sql)0
-rw-r--r--sql/old/11.x/auth/24111_2024_12_22/2024_12_21_00_auth.sql (renamed from sql/updates/auth/master/2024_12_21_00_auth.sql)0
-rw-r--r--sql/old/11.x/characters/24111_2024_12_22/2024_11_16_00_characters.sql (renamed from sql/updates/characters/master/2024_11_16_00_characters.sql)0
-rw-r--r--sql/old/11.x/characters/24111_2024_12_22/2024_12_13_00_characters.sql (renamed from sql/updates/characters/master/2024_12_13_00_characters.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_11_16_23_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_11_16_23_hotfixes.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_11_19_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_02_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_12_02_00_hotfixes.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_18_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_12_18_00_hotfixes.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_21_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2024_12_21_00_hotfixes.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_00_hotfixes_deDE.sql (renamed from sql/updates/hotfixes/master/2024_12_22_00_hotfixes_deDE.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_01_hotfixes_esES.sql (renamed from sql/updates/hotfixes/master/2024_12_22_01_hotfixes_esES.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_02_hotfixes_esMX.sql (renamed from sql/updates/hotfixes/master/2024_12_22_02_hotfixes_esMX.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_03_hotfixes_frFR.sql (renamed from sql/updates/hotfixes/master/2024_12_22_03_hotfixes_frFR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_04_hotfixes_itIT.sql (renamed from sql/updates/hotfixes/master/2024_12_22_04_hotfixes_itIT.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_05_hotfixes_ptBR.sql (renamed from sql/updates/hotfixes/master/2024_12_22_05_hotfixes_ptBR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_06_hotfixes_koKR.sql (renamed from sql/updates/hotfixes/master/2024_12_22_06_hotfixes_koKR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_07_hotfixes_ruRU.sql (renamed from sql/updates/hotfixes/master/2024_12_22_07_hotfixes_ruRU.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_08_hotfixes_zhCN.sql (renamed from sql/updates/hotfixes/master/2024_12_22_08_hotfixes_zhCN.sql)0
-rw-r--r--sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_09_hotfixes_zhTW.sql (renamed from sql/updates/hotfixes/master/2024_12_22_09_hotfixes_zhTW.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_16_13_world.sql (renamed from sql/updates/world/master/2024_11_16_13_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_17_00_world.sql (renamed from sql/updates/world/master/2024_11_17_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_17_01_world.sql (renamed from sql/updates/world/master/2024_11_17_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_17_02_world.sql (renamed from sql/updates/world/master/2024_11_17_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_19_00_world.sql (renamed from sql/updates/world/master/2024_11_19_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_22_00_world.sql (renamed from sql/updates/world/master/2024_11_22_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_22_01_world.sql (renamed from sql/updates/world/master/2024_11_22_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_22_02_world.sql (renamed from sql/updates/world/master/2024_11_22_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_23_00_world.sql (renamed from sql/updates/world/master/2024_11_23_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_24_00_world.sql (renamed from sql/updates/world/master/2024_11_24_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_24_01_world.sql (renamed from sql/updates/world/master/2024_11_24_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_27_00_world.sql (renamed from sql/updates/world/master/2024_11_27_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_27_01_world.sql (renamed from sql/updates/world/master/2024_11_27_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_27_02_world.sql (renamed from sql/updates/world/master/2024_11_27_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_27_03_world.sql (renamed from sql/updates/world/master/2024_11_27_03_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_27_04_world.sql (renamed from sql/updates/world/master/2024_11_27_04_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_28_00_world.sql (renamed from sql/updates/world/master/2024_11_28_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_28_01_world.sql (renamed from sql/updates/world/master/2024_11_28_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_29_00_world.sql (renamed from sql/updates/world/master/2024_11_29_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_29_01_world.sql (renamed from sql/updates/world/master/2024_11_29_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_11_30_00_world.sql (renamed from sql/updates/world/master/2024_11_30_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_01_00_world.sql (renamed from sql/updates/world/master/2024_12_01_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_01_01_world.sql (renamed from sql/updates/world/master/2024_12_01_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_01_02_world.sql (renamed from sql/updates/world/master/2024_12_01_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_01_03_world.sql (renamed from sql/updates/world/master/2024_12_01_03_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_02_00_world.sql (renamed from sql/updates/world/master/2024_12_02_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_02_01_world.sql (renamed from sql/updates/world/master/2024_12_02_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_03_00_world.sql (renamed from sql/updates/world/master/2024_12_03_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_03_01_world.sql (renamed from sql/updates/world/master/2024_12_03_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_03_02_world.sql (renamed from sql/updates/world/master/2024_12_03_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_04_00_world.sql (renamed from sql/updates/world/master/2024_12_04_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_04_01_world.sql (renamed from sql/updates/world/master/2024_12_04_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_04_02_world.sql (renamed from sql/updates/world/master/2024_12_04_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_05_00_world.sql (renamed from sql/updates/world/master/2024_12_05_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_07_00_world.sql (renamed from sql/updates/world/master/2024_12_07_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_08_00_world.sql (renamed from sql/updates/world/master/2024_12_08_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_09_00_world.sql (renamed from sql/updates/world/master/2024_12_09_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_09_01_world.sql (renamed from sql/updates/world/master/2024_12_09_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_10_00_world.sql (renamed from sql/updates/world/master/2024_12_10_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_11_00_world.sql (renamed from sql/updates/world/master/2024_12_11_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_11_01_world.sql (renamed from sql/updates/world/master/2024_12_11_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_11_02_world.sql (renamed from sql/updates/world/master/2024_12_11_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_12_00_world.sql (renamed from sql/updates/world/master/2024_12_12_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_12_01_world.sql (renamed from sql/updates/world/master/2024_12_12_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_15_00_world.sql (renamed from sql/updates/world/master/2024_12_15_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_16_00_world.sql (renamed from sql/updates/world/master/2024_12_16_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_20_00_world.sql (renamed from sql/updates/world/master/2024_12_20_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_20_01_world.sql (renamed from sql/updates/world/master/2024_12_20_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_20_02_world.sql (renamed from sql/updates/world/master/2024_12_20_02_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_20_03_world.sql (renamed from sql/updates/world/master/2024_12_20_03_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_20_04_world.sql (renamed from sql/updates/world/master/2024_12_20_04_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_21_00_world.sql (renamed from sql/updates/world/master/2024_12_21_00_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_21_01_world.sql (renamed from sql/updates/world/master/2024_12_21_01_world.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_22_00_world_deDE.sql (renamed from sql/updates/world/master/2024_12_22_00_world_deDE.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_22_01_world_esES.sql (renamed from sql/updates/world/master/2024_12_22_01_world_esES.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_22_02_world_esMX.sql (renamed from sql/updates/world/master/2024_12_22_02_world_esMX.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_22_03_world_frFR.sql (renamed from sql/updates/world/master/2024_12_22_03_world_frFR.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_22_04_world_itIT.sql (renamed from sql/updates/world/master/2024_12_22_04_world_itIT.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_22_05_world_ptBR.sql (renamed from sql/updates/world/master/2024_12_22_05_world_ptBR.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_22_06_world_koKR.sql (renamed from sql/updates/world/master/2024_12_22_06_world_koKR.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_22_07_world_ruRU.sql (renamed from sql/updates/world/master/2024_12_22_07_world_ruRU.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_22_08_world_zhCN.sql (renamed from sql/updates/world/master/2024_12_22_08_world_zhCN.sql)0
-rw-r--r--sql/old/11.x/world/24111_2024_12_22/2024_12_22_09_world_zhTW.sql (renamed from sql/updates/world/master/2024_12_22_09_world_zhTW.sql)0
-rw-r--r--sql/updates/auth/master/2024_12_22_00_auth.sql3
-rw-r--r--sql/updates/characters/master/2024_12_22_00_characters.sql3
-rw-r--r--sql/updates/hotfixes/master/2024_12_22_10_hotfixes.sql3
-rw-r--r--sql/updates/world/master/2024_12_22_10_world.sql4
94 files changed, 86 insertions, 14 deletions
diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index 6ca21a857c0..81fa20742e7 100644
--- a/revision_data.h.in.cmake
+++ b/revision_data.h.in.cmake
@@ -40,8 +40,8 @@
// Database updater base information
#define DATABASE_MYSQL_EXECUTABLE R"(@MYSQL_EXECUTABLE@)"
-#define DATABASE_FULL_DATABASE "TDB_full_world_1105.24111_2024_11_16.sql"
-#define DATABASE_HOTFIXES_DATABASE "TDB_full_hotfixes_1105.24111_2024_11_16.sql"
+#define DATABASE_FULL_DATABASE "TDB_full_world_1107.24121_2024_12_22.sql"
+#define DATABASE_HOTFIXES_DATABASE "TDB_full_hotfixes_1107.24121_2024_12_22.sql"
// Windows resource defines
#define VER_COMPANYNAME_STR "TrinityCore Developers"
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index ee36f98fba5..34c934d4d01 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -3350,10 +3350,11 @@ INSERT INTO `updates` VALUES
('2024_11_12_00_auth.sql','5A236A557291758C0F2C46FDEC02692E7C53F751','ARCHIVED','2024-11-12 11:42:13',0),
('2024_11_14_00_auth.sql','646A438FAD5A83D80DCDDEDC71BB6CF21A1FE490','ARCHIVED','2024-11-14 10:29:52',0),
('2024_11_16_00_auth.sql','94794542B3320D76E4A3615DB2418EEF38BDFEA1','ARCHIVED','2024-11-16 21:57:39',0),
-('2024_11_20_00_auth.sql','444C765DD16E9B70C1D1163155238E8EE481B17D','RELEASED','2024-11-20 20:39:53',0),
-('2024_12_18_00_auth.sql','1F3145F30A79FEE13F5CD9817F54FAFA9A85DEE6','RELEASED','2024-12-18 22:04:44',0),
-('2024_12_19_00_auth.sql','B01D54F8420CF680F0DDA903210028F0174E310D','RELEASED','2024-12-19 11:32:53',0),
-('2024_12_21_00_auth.sql','9DA5E7911D231D46FE9630D20BDD4AEA0B3CF650','RELEASED','2024-12-21 01:03:37',0);
+('2024_11_20_00_auth.sql','444C765DD16E9B70C1D1163155238E8EE481B17D','ARCHIVED','2024-11-20 20:39:53',0),
+('2024_12_18_00_auth.sql','1F3145F30A79FEE13F5CD9817F54FAFA9A85DEE6','ARCHIVED','2024-12-18 22:04:44',0),
+('2024_12_19_00_auth.sql','B01D54F8420CF680F0DDA903210028F0174E310D','ARCHIVED','2024-12-19 11:32:53',0),
+('2024_12_21_00_auth.sql','9DA5E7911D231D46FE9630D20BDD4AEA0B3CF650','ARCHIVED','2024-12-21 01:03:37',0),
+('2024_12_22_00_auth.sql','6FDF0ABE9952CC96BE04A6BAA0F1161900B4AB88','ARCHIVED','2024-12-22 02:56:17',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3497,4 +3498,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-11-16 21:57:41
+-- Dump completed on 2024-12-22 2:56:19
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index fdd39eb4413..f994bf8bd72 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -3752,7 +3752,8 @@ INSERT INTO `updates` VALUES
('2024_10_03_00_characters.sql','408249A6992999A36EB94089D184972E8E0767A3','ARCHIVED','2024-10-03 11:10:18',0),
('2024_11_04_00_characters.sql','F7980E0CEE728FF866703693690F76F932E7C764','ARCHIVED','2024-11-04 17:14:03',0),
('2024_11_16_00_characters.sql','9D9D87FB8DEB99F074EB499A5BD230FD9C993669','ARCHIVED','2024-11-16 21:57:39',0),
-('2024_12_13_00_characters.sql','4A00C51BA33639F5555AAE40EC672AE47126F7B6','RELEASED','2024-12-13 00:17:03',0);
+('2024_12_13_00_characters.sql','4A00C51BA33639F5555AAE40EC672AE47126F7B6','ARCHIVED','2024-12-13 00:17:03',0),
+('2024_12_22_00_characters.sql','A2F24564430C5BCC96C279E843FA3548B1F831EE','ARCHIVED','2024-12-22 02:56:17',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3880,4 +3881,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2024-11-16 21:57:41
+-- Dump completed on 2024-12-22 2:56:19
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index ca4e827e340..9221f7828ed 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_database.sql
@@ -1367,7 +1367,7 @@ CREATE TABLE `broadcast_text` (
`LanguageID` int NOT NULL DEFAULT '0',
`ConditionID` int NOT NULL DEFAULT '0',
`EmotesID` smallint unsigned NOT NULL DEFAULT '0',
- `Flags` tinyint unsigned NOT NULL DEFAULT '0',
+ `Flags` smallint unsigned NOT NULL DEFAULT '0',
`ChatBubbleDurationMs` int unsigned NOT NULL DEFAULT '0',
`VoiceOverPriorityID` int NOT NULL DEFAULT '0',
`SoundKitID1` int unsigned NOT NULL DEFAULT '0',
@@ -2575,6 +2575,22 @@ CREATE TABLE `creature_family_locale` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `creature_label`
+--
+
+DROP TABLE IF EXISTS `creature_label`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `creature_label` (
+ `ID` int unsigned NOT NULL DEFAULT '0',
+ `LabelID` int NOT NULL DEFAULT '0',
+ `CreatureDifficultyID` int unsigned NOT NULL DEFAULT '0',
+ `VerifiedBuild` int NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `creature_model_data`
--
@@ -3487,6 +3503,22 @@ CREATE TABLE `gameobject_display_info` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `gameobject_label`
+--
+
+DROP TABLE IF EXISTS `gameobject_label`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `gameobject_label` (
+ `ID` int unsigned NOT NULL DEFAULT '0',
+ `LabelID` int NOT NULL DEFAULT '0',
+ `GameObjectID` int unsigned NOT NULL DEFAULT '0',
+ `VerifiedBuild` int NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `gameobjects`
--
@@ -5966,6 +5998,9 @@ CREATE TABLE `lfg_dungeons` (
`MinCountTank` tinyint unsigned NOT NULL DEFAULT '0',
`MinCountHealer` tinyint unsigned NOT NULL DEFAULT '0',
`MinCountDamage` tinyint unsigned NOT NULL DEFAULT '0',
+ `MaxPremadeCountTank` tinyint unsigned NOT NULL DEFAULT '0',
+ `MaxPremadeCountHealer` tinyint unsigned NOT NULL DEFAULT '0',
+ `MaxPremadeCountDamage` tinyint unsigned NOT NULL DEFAULT '0',
`BonusReputationAmount` smallint unsigned NOT NULL DEFAULT '0',
`MentorItemLevel` smallint unsigned NOT NULL DEFAULT '0',
`MentorCharLevel` tinyint unsigned NOT NULL DEFAULT '0',
@@ -6311,8 +6346,8 @@ DROP TABLE IF EXISTS `map_difficulty`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `map_difficulty` (
- `ID` int unsigned NOT NULL DEFAULT '0',
`Message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `ID` int unsigned NOT NULL DEFAULT '0',
`DifficultyID` int NOT NULL DEFAULT '0',
`LockID` int NOT NULL DEFAULT '0',
`ResetInterval` tinyint unsigned NOT NULL DEFAULT '0',
@@ -6518,6 +6553,24 @@ CREATE TABLE `mount_capability` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `mount_equipment`
+--
+
+DROP TABLE IF EXISTS `mount_equipment`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `mount_equipment` (
+ `ID` int unsigned NOT NULL DEFAULT '0',
+ `Item` int NOT NULL DEFAULT '0',
+ `BuffSpell` int NOT NULL DEFAULT '0',
+ `Unknown820` int NOT NULL DEFAULT '0',
+ `LearnedBySpell` int unsigned NOT NULL DEFAULT '0',
+ `VerifiedBuild` int NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `mount_locale`
--
@@ -6839,6 +6892,8 @@ CREATE TABLE `player_condition` (
`ID` int unsigned NOT NULL DEFAULT '0',
`RaceMask` bigint NOT NULL DEFAULT '0',
`FailureDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ `MinLevel` smallint unsigned NOT NULL DEFAULT '0',
+ `MaxLevel` smallint unsigned NOT NULL DEFAULT '0',
`ClassMask` int NOT NULL DEFAULT '0',
`SkillLogic` int unsigned NOT NULL DEFAULT '0',
`LanguageID` int NOT NULL DEFAULT '0',
@@ -10740,6 +10795,8 @@ CREATE TABLE `vignette` (
`VignetteType` tinyint NOT NULL DEFAULT '0',
`RewardQuestID` int NOT NULL DEFAULT '0',
`UiWidgetSetID` int NOT NULL DEFAULT '0',
+ `UiMapPinInfoID` int NOT NULL DEFAULT '0',
+ `ObjectiveType` tinyint NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -10904,4 +10961,4 @@ CREATE TABLE `world_state_expression` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2024-11-16 21:57:45
+-- Dump completed on 2024-12-22 2:56:24
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 94e00c15396..8d4788433f2 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -1630,7 +1630,7 @@ CREATE TABLE `game_tele` (
`map` smallint unsigned NOT NULL DEFAULT '0',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=2183 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command';
+) ENGINE=InnoDB AUTO_INCREMENT=2189 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command';
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -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-11-16 21:57:43
+-- Dump completed on 2024-12-22 2:56:21
diff --git a/sql/updates/auth/master/2024_11_16_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_11_16_00_auth.sql
index 7f039313880..7f039313880 100644
--- a/sql/updates/auth/master/2024_11_16_00_auth.sql
+++ b/sql/old/11.x/auth/24111_2024_12_22/2024_11_16_00_auth.sql
diff --git a/sql/updates/auth/master/2024_11_20_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_11_20_00_auth.sql
index 886c8a7313a..886c8a7313a 100644
--- a/sql/updates/auth/master/2024_11_20_00_auth.sql
+++ b/sql/old/11.x/auth/24111_2024_12_22/2024_11_20_00_auth.sql
diff --git a/sql/updates/auth/master/2024_12_18_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_12_18_00_auth.sql
index 510444839aa..510444839aa 100644
--- a/sql/updates/auth/master/2024_12_18_00_auth.sql
+++ b/sql/old/11.x/auth/24111_2024_12_22/2024_12_18_00_auth.sql
diff --git a/sql/updates/auth/master/2024_12_19_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_12_19_00_auth.sql
index baace5a1f1c..baace5a1f1c 100644
--- a/sql/updates/auth/master/2024_12_19_00_auth.sql
+++ b/sql/old/11.x/auth/24111_2024_12_22/2024_12_19_00_auth.sql
diff --git a/sql/updates/auth/master/2024_12_21_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_12_21_00_auth.sql
index cf04c9bc407..cf04c9bc407 100644
--- a/sql/updates/auth/master/2024_12_21_00_auth.sql
+++ b/sql/old/11.x/auth/24111_2024_12_22/2024_12_21_00_auth.sql
diff --git a/sql/updates/characters/master/2024_11_16_00_characters.sql b/sql/old/11.x/characters/24111_2024_12_22/2024_11_16_00_characters.sql
index d293d2af437..d293d2af437 100644
--- a/sql/updates/characters/master/2024_11_16_00_characters.sql
+++ b/sql/old/11.x/characters/24111_2024_12_22/2024_11_16_00_characters.sql
diff --git a/sql/updates/characters/master/2024_12_13_00_characters.sql b/sql/old/11.x/characters/24111_2024_12_22/2024_12_13_00_characters.sql
index d32b5511299..d32b5511299 100644
--- a/sql/updates/characters/master/2024_12_13_00_characters.sql
+++ b/sql/old/11.x/characters/24111_2024_12_22/2024_12_13_00_characters.sql
diff --git a/sql/updates/hotfixes/master/2024_11_16_23_hotfixes.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_11_16_23_hotfixes.sql
index 99b822bd772..99b822bd772 100644
--- a/sql/updates/hotfixes/master/2024_11_16_23_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_11_16_23_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_11_19_00_hotfixes.sql
index 678c526c8e2..678c526c8e2 100644
--- a/sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_11_19_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_12_02_00_hotfixes.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_02_00_hotfixes.sql
index a3946e51902..a3946e51902 100644
--- a/sql/updates/hotfixes/master/2024_12_02_00_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_02_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_12_18_00_hotfixes.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_18_00_hotfixes.sql
index 5a18de9e7b1..5a18de9e7b1 100644
--- a/sql/updates/hotfixes/master/2024_12_18_00_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_18_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_12_21_00_hotfixes.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_21_00_hotfixes.sql
index ad31157f15f..ad31157f15f 100644
--- a/sql/updates/hotfixes/master/2024_12_21_00_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_21_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2024_12_22_00_hotfixes_deDE.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_00_hotfixes_deDE.sql
index e47eda777de..e47eda777de 100644
--- a/sql/updates/hotfixes/master/2024_12_22_00_hotfixes_deDE.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_00_hotfixes_deDE.sql
diff --git a/sql/updates/hotfixes/master/2024_12_22_01_hotfixes_esES.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_01_hotfixes_esES.sql
index d8a754a9869..d8a754a9869 100644
--- a/sql/updates/hotfixes/master/2024_12_22_01_hotfixes_esES.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_01_hotfixes_esES.sql
diff --git a/sql/updates/hotfixes/master/2024_12_22_02_hotfixes_esMX.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_02_hotfixes_esMX.sql
index 1127dd847aa..1127dd847aa 100644
--- a/sql/updates/hotfixes/master/2024_12_22_02_hotfixes_esMX.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_02_hotfixes_esMX.sql
diff --git a/sql/updates/hotfixes/master/2024_12_22_03_hotfixes_frFR.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_03_hotfixes_frFR.sql
index ae483f079b8..ae483f079b8 100644
--- a/sql/updates/hotfixes/master/2024_12_22_03_hotfixes_frFR.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_03_hotfixes_frFR.sql
diff --git a/sql/updates/hotfixes/master/2024_12_22_04_hotfixes_itIT.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_04_hotfixes_itIT.sql
index 572961d060f..572961d060f 100644
--- a/sql/updates/hotfixes/master/2024_12_22_04_hotfixes_itIT.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_04_hotfixes_itIT.sql
diff --git a/sql/updates/hotfixes/master/2024_12_22_05_hotfixes_ptBR.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_05_hotfixes_ptBR.sql
index c61f4615fba..c61f4615fba 100644
--- a/sql/updates/hotfixes/master/2024_12_22_05_hotfixes_ptBR.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_05_hotfixes_ptBR.sql
diff --git a/sql/updates/hotfixes/master/2024_12_22_06_hotfixes_koKR.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_06_hotfixes_koKR.sql
index 39d1b60c4a1..39d1b60c4a1 100644
--- a/sql/updates/hotfixes/master/2024_12_22_06_hotfixes_koKR.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_06_hotfixes_koKR.sql
diff --git a/sql/updates/hotfixes/master/2024_12_22_07_hotfixes_ruRU.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_07_hotfixes_ruRU.sql
index 9f23f526db6..9f23f526db6 100644
--- a/sql/updates/hotfixes/master/2024_12_22_07_hotfixes_ruRU.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_07_hotfixes_ruRU.sql
diff --git a/sql/updates/hotfixes/master/2024_12_22_08_hotfixes_zhCN.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_08_hotfixes_zhCN.sql
index 6e042d73bfc..6e042d73bfc 100644
--- a/sql/updates/hotfixes/master/2024_12_22_08_hotfixes_zhCN.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_08_hotfixes_zhCN.sql
diff --git a/sql/updates/hotfixes/master/2024_12_22_09_hotfixes_zhTW.sql b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_09_hotfixes_zhTW.sql
index 4f560052d74..4f560052d74 100644
--- a/sql/updates/hotfixes/master/2024_12_22_09_hotfixes_zhTW.sql
+++ b/sql/old/11.x/hotfixes/24111_2024_12_22/2024_12_22_09_hotfixes_zhTW.sql
diff --git a/sql/updates/world/master/2024_11_16_13_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_16_13_world.sql
index 947f3260015..947f3260015 100644
--- a/sql/updates/world/master/2024_11_16_13_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_16_13_world.sql
diff --git a/sql/updates/world/master/2024_11_17_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_17_00_world.sql
index 2ba75476211..2ba75476211 100644
--- a/sql/updates/world/master/2024_11_17_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_17_00_world.sql
diff --git a/sql/updates/world/master/2024_11_17_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_17_01_world.sql
index 79602f19c9b..79602f19c9b 100644
--- a/sql/updates/world/master/2024_11_17_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_17_01_world.sql
diff --git a/sql/updates/world/master/2024_11_17_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_17_02_world.sql
index 71775d2a51f..71775d2a51f 100644
--- a/sql/updates/world/master/2024_11_17_02_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_17_02_world.sql
diff --git a/sql/updates/world/master/2024_11_19_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_19_00_world.sql
index dc2c1212fb1..dc2c1212fb1 100644
--- a/sql/updates/world/master/2024_11_19_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_19_00_world.sql
diff --git a/sql/updates/world/master/2024_11_22_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_22_00_world.sql
index d83952b75ad..d83952b75ad 100644
--- a/sql/updates/world/master/2024_11_22_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_22_00_world.sql
diff --git a/sql/updates/world/master/2024_11_22_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_22_01_world.sql
index 25051f72ea3..25051f72ea3 100644
--- a/sql/updates/world/master/2024_11_22_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_22_01_world.sql
diff --git a/sql/updates/world/master/2024_11_22_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_22_02_world.sql
index c2aaa1522eb..c2aaa1522eb 100644
--- a/sql/updates/world/master/2024_11_22_02_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_22_02_world.sql
diff --git a/sql/updates/world/master/2024_11_23_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_23_00_world.sql
index e4daa9ab37a..e4daa9ab37a 100644
--- a/sql/updates/world/master/2024_11_23_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_23_00_world.sql
diff --git a/sql/updates/world/master/2024_11_24_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_24_00_world.sql
index 34cec28b8d8..34cec28b8d8 100644
--- a/sql/updates/world/master/2024_11_24_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_24_00_world.sql
diff --git a/sql/updates/world/master/2024_11_24_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_24_01_world.sql
index 4d429e8d730..4d429e8d730 100644
--- a/sql/updates/world/master/2024_11_24_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_24_01_world.sql
diff --git a/sql/updates/world/master/2024_11_27_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_00_world.sql
index 4a68aac8665..4a68aac8665 100644
--- a/sql/updates/world/master/2024_11_27_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_00_world.sql
diff --git a/sql/updates/world/master/2024_11_27_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_01_world.sql
index 007e3cf5610..007e3cf5610 100644
--- a/sql/updates/world/master/2024_11_27_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_01_world.sql
diff --git a/sql/updates/world/master/2024_11_27_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_02_world.sql
index 3aff2bf626f..3aff2bf626f 100644
--- a/sql/updates/world/master/2024_11_27_02_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_02_world.sql
diff --git a/sql/updates/world/master/2024_11_27_03_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_03_world.sql
index 1c845cf4c69..1c845cf4c69 100644
--- a/sql/updates/world/master/2024_11_27_03_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_03_world.sql
diff --git a/sql/updates/world/master/2024_11_27_04_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_04_world.sql
index b716d7f2149..b716d7f2149 100644
--- a/sql/updates/world/master/2024_11_27_04_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_27_04_world.sql
diff --git a/sql/updates/world/master/2024_11_28_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_28_00_world.sql
index 6b7243f737d..6b7243f737d 100644
--- a/sql/updates/world/master/2024_11_28_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_28_00_world.sql
diff --git a/sql/updates/world/master/2024_11_28_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_28_01_world.sql
index 898140cff06..898140cff06 100644
--- a/sql/updates/world/master/2024_11_28_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_28_01_world.sql
diff --git a/sql/updates/world/master/2024_11_29_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_29_00_world.sql
index a8cd29fc6e1..a8cd29fc6e1 100644
--- a/sql/updates/world/master/2024_11_29_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_29_00_world.sql
diff --git a/sql/updates/world/master/2024_11_29_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_29_01_world.sql
index 3d6ccd34dce..3d6ccd34dce 100644
--- a/sql/updates/world/master/2024_11_29_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_29_01_world.sql
diff --git a/sql/updates/world/master/2024_11_30_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_11_30_00_world.sql
index 5b69673a725..5b69673a725 100644
--- a/sql/updates/world/master/2024_11_30_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_11_30_00_world.sql
diff --git a/sql/updates/world/master/2024_12_01_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_00_world.sql
index 1184d438e52..1184d438e52 100644
--- a/sql/updates/world/master/2024_12_01_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_00_world.sql
diff --git a/sql/updates/world/master/2024_12_01_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_01_world.sql
index 6afc6ac6606..6afc6ac6606 100644
--- a/sql/updates/world/master/2024_12_01_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_01_world.sql
diff --git a/sql/updates/world/master/2024_12_01_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_02_world.sql
index 4588bd5c44b..4588bd5c44b 100644
--- a/sql/updates/world/master/2024_12_01_02_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_02_world.sql
diff --git a/sql/updates/world/master/2024_12_01_03_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_03_world.sql
index be87ffdae7b..be87ffdae7b 100644
--- a/sql/updates/world/master/2024_12_01_03_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_01_03_world.sql
diff --git a/sql/updates/world/master/2024_12_02_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_02_00_world.sql
index 1c8cca588e7..1c8cca588e7 100644
--- a/sql/updates/world/master/2024_12_02_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_02_00_world.sql
diff --git a/sql/updates/world/master/2024_12_02_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_02_01_world.sql
index f3baa7eeb47..f3baa7eeb47 100644
--- a/sql/updates/world/master/2024_12_02_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_02_01_world.sql
diff --git a/sql/updates/world/master/2024_12_03_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_03_00_world.sql
index fe0cd9ca780..fe0cd9ca780 100644
--- a/sql/updates/world/master/2024_12_03_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_03_00_world.sql
diff --git a/sql/updates/world/master/2024_12_03_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_03_01_world.sql
index 7901397605d..7901397605d 100644
--- a/sql/updates/world/master/2024_12_03_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_03_01_world.sql
diff --git a/sql/updates/world/master/2024_12_03_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_03_02_world.sql
index 21e4edbe349..21e4edbe349 100644
--- a/sql/updates/world/master/2024_12_03_02_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_03_02_world.sql
diff --git a/sql/updates/world/master/2024_12_04_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_04_00_world.sql
index 22a3b393730..22a3b393730 100644
--- a/sql/updates/world/master/2024_12_04_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_04_00_world.sql
diff --git a/sql/updates/world/master/2024_12_04_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_04_01_world.sql
index 2b5893cb05c..2b5893cb05c 100644
--- a/sql/updates/world/master/2024_12_04_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_04_01_world.sql
diff --git a/sql/updates/world/master/2024_12_04_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_04_02_world.sql
index b5c88b1ce54..b5c88b1ce54 100644
--- a/sql/updates/world/master/2024_12_04_02_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_04_02_world.sql
diff --git a/sql/updates/world/master/2024_12_05_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_05_00_world.sql
index 3d727564d6a..3d727564d6a 100644
--- a/sql/updates/world/master/2024_12_05_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_05_00_world.sql
diff --git a/sql/updates/world/master/2024_12_07_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_07_00_world.sql
index bbb45a2731f..bbb45a2731f 100644
--- a/sql/updates/world/master/2024_12_07_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_07_00_world.sql
diff --git a/sql/updates/world/master/2024_12_08_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_08_00_world.sql
index d4e65c2f745..d4e65c2f745 100644
--- a/sql/updates/world/master/2024_12_08_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_08_00_world.sql
diff --git a/sql/updates/world/master/2024_12_09_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_09_00_world.sql
index 1d57e039af2..1d57e039af2 100644
--- a/sql/updates/world/master/2024_12_09_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_09_00_world.sql
diff --git a/sql/updates/world/master/2024_12_09_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_09_01_world.sql
index 5e4a2b806de..5e4a2b806de 100644
--- a/sql/updates/world/master/2024_12_09_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_09_01_world.sql
diff --git a/sql/updates/world/master/2024_12_10_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_10_00_world.sql
index f5fa4ee2dcc..f5fa4ee2dcc 100644
--- a/sql/updates/world/master/2024_12_10_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_10_00_world.sql
diff --git a/sql/updates/world/master/2024_12_11_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_11_00_world.sql
index 3d358f66ed1..3d358f66ed1 100644
--- a/sql/updates/world/master/2024_12_11_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_11_00_world.sql
diff --git a/sql/updates/world/master/2024_12_11_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_11_01_world.sql
index 33437fd1d38..33437fd1d38 100644
--- a/sql/updates/world/master/2024_12_11_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_11_01_world.sql
diff --git a/sql/updates/world/master/2024_12_11_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_11_02_world.sql
index 18fec8692f9..18fec8692f9 100644
--- a/sql/updates/world/master/2024_12_11_02_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_11_02_world.sql
diff --git a/sql/updates/world/master/2024_12_12_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_12_00_world.sql
index b7c0b661b7b..b7c0b661b7b 100644
--- a/sql/updates/world/master/2024_12_12_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_12_00_world.sql
diff --git a/sql/updates/world/master/2024_12_12_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_12_01_world.sql
index ecb80c21633..ecb80c21633 100644
--- a/sql/updates/world/master/2024_12_12_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_12_01_world.sql
diff --git a/sql/updates/world/master/2024_12_15_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_15_00_world.sql
index e72c6628fb0..e72c6628fb0 100644
--- a/sql/updates/world/master/2024_12_15_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_15_00_world.sql
diff --git a/sql/updates/world/master/2024_12_16_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_16_00_world.sql
index 5ebc7cb648c..5ebc7cb648c 100644
--- a/sql/updates/world/master/2024_12_16_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_16_00_world.sql
diff --git a/sql/updates/world/master/2024_12_20_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_00_world.sql
index f85eccdaa76..f85eccdaa76 100644
--- a/sql/updates/world/master/2024_12_20_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_00_world.sql
diff --git a/sql/updates/world/master/2024_12_20_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_01_world.sql
index 46e9de14d48..46e9de14d48 100644
--- a/sql/updates/world/master/2024_12_20_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_01_world.sql
diff --git a/sql/updates/world/master/2024_12_20_02_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_02_world.sql
index 5d9aa8e40b9..5d9aa8e40b9 100644
--- a/sql/updates/world/master/2024_12_20_02_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_02_world.sql
diff --git a/sql/updates/world/master/2024_12_20_03_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_03_world.sql
index fb6150e9f23..fb6150e9f23 100644
--- a/sql/updates/world/master/2024_12_20_03_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_03_world.sql
diff --git a/sql/updates/world/master/2024_12_20_04_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_04_world.sql
index d387da6e079..d387da6e079 100644
--- a/sql/updates/world/master/2024_12_20_04_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_20_04_world.sql
diff --git a/sql/updates/world/master/2024_12_21_00_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_21_00_world.sql
index f78f33639f6..f78f33639f6 100644
--- a/sql/updates/world/master/2024_12_21_00_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_21_00_world.sql
diff --git a/sql/updates/world/master/2024_12_21_01_world.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_21_01_world.sql
index 7a4552d2214..7a4552d2214 100644
--- a/sql/updates/world/master/2024_12_21_01_world.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_21_01_world.sql
diff --git a/sql/updates/world/master/2024_12_22_00_world_deDE.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_00_world_deDE.sql
index 3863c9e669e..3863c9e669e 100644
--- a/sql/updates/world/master/2024_12_22_00_world_deDE.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_00_world_deDE.sql
diff --git a/sql/updates/world/master/2024_12_22_01_world_esES.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_01_world_esES.sql
index 5168d802283..5168d802283 100644
--- a/sql/updates/world/master/2024_12_22_01_world_esES.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_01_world_esES.sql
diff --git a/sql/updates/world/master/2024_12_22_02_world_esMX.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_02_world_esMX.sql
index feb52b6dd86..feb52b6dd86 100644
--- a/sql/updates/world/master/2024_12_22_02_world_esMX.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_02_world_esMX.sql
diff --git a/sql/updates/world/master/2024_12_22_03_world_frFR.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_03_world_frFR.sql
index 16e08faa3fd..16e08faa3fd 100644
--- a/sql/updates/world/master/2024_12_22_03_world_frFR.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_03_world_frFR.sql
diff --git a/sql/updates/world/master/2024_12_22_04_world_itIT.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_04_world_itIT.sql
index 61f6026acea..61f6026acea 100644
--- a/sql/updates/world/master/2024_12_22_04_world_itIT.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_04_world_itIT.sql
diff --git a/sql/updates/world/master/2024_12_22_05_world_ptBR.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_05_world_ptBR.sql
index 37020fc35ce..37020fc35ce 100644
--- a/sql/updates/world/master/2024_12_22_05_world_ptBR.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_05_world_ptBR.sql
diff --git a/sql/updates/world/master/2024_12_22_06_world_koKR.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_06_world_koKR.sql
index 623237331a1..623237331a1 100644
--- a/sql/updates/world/master/2024_12_22_06_world_koKR.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_06_world_koKR.sql
diff --git a/sql/updates/world/master/2024_12_22_07_world_ruRU.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_07_world_ruRU.sql
index 4c572601c7b..4c572601c7b 100644
--- a/sql/updates/world/master/2024_12_22_07_world_ruRU.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_07_world_ruRU.sql
diff --git a/sql/updates/world/master/2024_12_22_08_world_zhCN.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_08_world_zhCN.sql
index dd7b4f31fdd..dd7b4f31fdd 100644
--- a/sql/updates/world/master/2024_12_22_08_world_zhCN.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_08_world_zhCN.sql
diff --git a/sql/updates/world/master/2024_12_22_09_world_zhTW.sql b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_09_world_zhTW.sql
index a51b6ea05ab..a51b6ea05ab 100644
--- a/sql/updates/world/master/2024_12_22_09_world_zhTW.sql
+++ b/sql/old/11.x/world/24111_2024_12_22/2024_12_22_09_world_zhTW.sql
diff --git a/sql/updates/auth/master/2024_12_22_00_auth.sql b/sql/updates/auth/master/2024_12_22_00_auth.sql
new file mode 100644
index 00000000000..a43db5fca0b
--- /dev/null
+++ b/sql/updates/auth/master/2024_12_22_00_auth.sql
@@ -0,0 +1,3 @@
+-- TDB 1107.24121 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_12_22_00_characters.sql b/sql/updates/characters/master/2024_12_22_00_characters.sql
new file mode 100644
index 00000000000..f8e4e599012
--- /dev/null
+++ b/sql/updates/characters/master/2024_12_22_00_characters.sql
@@ -0,0 +1,3 @@
+-- TDB 1107.24121 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_12_22_10_hotfixes.sql b/sql/updates/hotfixes/master/2024_12_22_10_hotfixes.sql
new file mode 100644
index 00000000000..08df808dd5a
--- /dev/null
+++ b/sql/updates/hotfixes/master/2024_12_22_10_hotfixes.sql
@@ -0,0 +1,3 @@
+-- TDB 1107.24121 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_12_22_10_world.sql b/sql/updates/world/master/2024_12_22_10_world.sql
new file mode 100644
index 00000000000..709e3f22c00
--- /dev/null
+++ b/sql/updates/world/master/2024_12_22_10_world.sql
@@ -0,0 +1,4 @@
+-- TDB 1107.24121 world
+UPDATE `version` SET `db_version`='TDB 1107.24121', `cache_id`=24121 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/world', 'ARCHIVED');