aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql7
-rw-r--r--sql/base/characters_database.sql13
-rw-r--r--sql/base/dev/hotfixes_database.sql65
-rw-r--r--sql/base/dev/world_database.sql8
-rw-r--r--sql/old/11.x/auth/25071_2025_08_16/2025_07_21_00_auth.sql (renamed from sql/updates/auth/master/2025_07_21_00_auth.sql)0
-rw-r--r--sql/old/11.x/auth/25071_2025_08_16/2025_08_13_00_auth.sql (renamed from sql/updates/auth/master/2025_08_13_00_auth.sql)0
-rw-r--r--sql/old/11.x/characters/25071_2025_08_16/2025_07_21_00_characters.sql (renamed from sql/updates/characters/master/2025_07_21_00_characters.sql)0
-rw-r--r--sql/old/11.x/characters/25071_2025_08_16/2025_08_13_00_characters.sql (renamed from sql/updates/characters/master/2025_08_13_00_characters.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_07_21_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2025_07_21_00_hotfixes.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_00_hotfixes.sql (renamed from sql/updates/hotfixes/master/2025_08_13_00_hotfixes.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_01_hotfixes_enUS.sql (renamed from sql/updates/hotfixes/master/2025_08_13_01_hotfixes_enUS.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_02_hotfixes_deDE.sql (renamed from sql/updates/hotfixes/master/2025_08_13_02_hotfixes_deDE.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_03_hotfixes_esMX.sql (renamed from sql/updates/hotfixes/master/2025_08_13_03_hotfixes_esMX.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_04_hotfixes_frFR.sql (renamed from sql/updates/hotfixes/master/2025_08_13_04_hotfixes_frFR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_05_hotfixes_ptBR.sql (renamed from sql/updates/hotfixes/master/2025_08_13_05_hotfixes_ptBR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_06_hotfixes_esES.sql (renamed from sql/updates/hotfixes/master/2025_08_13_06_hotfixes_esES.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_07_hotfixes_itIT.sql (renamed from sql/updates/hotfixes/master/2025_08_13_07_hotfixes_itIT.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_08_hotfixes_koKR.sql (renamed from sql/updates/hotfixes/master/2025_08_13_08_hotfixes_koKR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_09_hotfixes_ruRU.sql (renamed from sql/updates/hotfixes/master/2025_08_13_09_hotfixes_ruRU.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_10_hotfixes_zhCN.sql (renamed from sql/updates/hotfixes/master/2025_08_13_10_hotfixes_zhCN.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_11_hotfixes_zhTW.sql (renamed from sql/updates/hotfixes/master/2025_08_13_11_hotfixes_zhTW.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_00_hotfixes_enUS.sql (renamed from sql/updates/hotfixes/master/2025_08_15_00_hotfixes_enUS.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_01_hotfixes_deDE.sql (renamed from sql/updates/hotfixes/master/2025_08_15_01_hotfixes_deDE.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_02_hotfixes_esES.sql (renamed from sql/updates/hotfixes/master/2025_08_15_02_hotfixes_esES.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_03_hotfixes_esMX.sql (renamed from sql/updates/hotfixes/master/2025_08_15_03_hotfixes_esMX.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_04_hotfixes_frFR.sql (renamed from sql/updates/hotfixes/master/2025_08_15_04_hotfixes_frFR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_05_hotfixes_itIT.sql (renamed from sql/updates/hotfixes/master/2025_08_15_05_hotfixes_itIT.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_06_hotfixes_koKR.sql (renamed from sql/updates/hotfixes/master/2025_08_15_06_hotfixes_koKR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_07_hotfixes_ptBR.sql (renamed from sql/updates/hotfixes/master/2025_08_15_07_hotfixes_ptBR.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_08_hotfixes_ruRU.sql (renamed from sql/updates/hotfixes/master/2025_08_15_08_hotfixes_ruRU.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_09_hotfixes_zhCN.sql (renamed from sql/updates/hotfixes/master/2025_08_15_09_hotfixes_zhCN.sql)0
-rw-r--r--sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_10_hotfixes_zhTW.sql (renamed from sql/updates/hotfixes/master/2025_08_15_10_hotfixes_zhTW.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_21_01_world.sql (renamed from sql/updates/world/master/2025_07_21_01_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_22_00_world.sql (renamed from sql/updates/world/master/2025_07_22_00_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_23_00_world.sql (renamed from sql/updates/world/master/2025_07_23_00_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_24_00_world.sql (renamed from sql/updates/world/master/2025_07_24_00_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_26_00_world.sql (renamed from sql/updates/world/master/2025_07_26_00_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_27_00_world.sql (renamed from sql/updates/world/master/2025_07_27_00_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_29_00_world.sql (renamed from sql/updates/world/master/2025_07_29_00_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_29_01_world.sql (renamed from sql/updates/world/master/2025_07_29_01_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_29_02_world.sql (renamed from sql/updates/world/master/2025_07_29_02_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_29_03_world.sql (renamed from sql/updates/world/master/2025_07_29_03_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_29_04_world.sql (renamed from sql/updates/world/master/2025_07_29_04_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_29_05_world.sql (renamed from sql/updates/world/master/2025_07_29_05_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_29_06_world.sql (renamed from sql/updates/world/master/2025_07_29_06_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_29_07_world.sql (renamed from sql/updates/world/master/2025_07_29_07_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_29_08_world.sql (renamed from sql/updates/world/master/2025_07_29_08_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_07_29_09_world.sql (renamed from sql/updates/world/master/2025_07_29_09_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_02_00_world.sql (renamed from sql/updates/world/master/2025_08_02_00_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_02_01_world.sql (renamed from sql/updates/world/master/2025_08_02_01_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_02_02_world.sql (renamed from sql/updates/world/master/2025_08_02_02_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_05_00_world.sql (renamed from sql/updates/world/master/2025_08_05_00_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_13_00_world.sql (renamed from sql/updates/world/master/2025_08_13_00_world.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_13_01_world_enUS.sql (renamed from sql/updates/world/master/2025_08_13_01_world_enUS.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_13_02_world_deDE.sql (renamed from sql/updates/world/master/2025_08_13_02_world_deDE.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_13_03_world_esMX.sql (renamed from sql/updates/world/master/2025_08_13_03_world_esMX.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_13_04_world_frFR.sql (renamed from sql/updates/world/master/2025_08_13_04_world_frFR.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_13_05_world_ptBR.sql (renamed from sql/updates/world/master/2025_08_13_05_world_ptBR.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_13_06_world_esES.sql (renamed from sql/updates/world/master/2025_08_13_06_world_esES.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_13_07_world_itIT.sql (renamed from sql/updates/world/master/2025_08_13_07_world_itIT.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_13_08_world_koKR.sql (renamed from sql/updates/world/master/2025_08_13_08_world_koKR.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_13_09_world_ruRU.sql (renamed from sql/updates/world/master/2025_08_13_09_world_ruRU.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_13_10_world_zhCN.sql (renamed from sql/updates/world/master/2025_08_13_10_world_zhCN.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_13_11_world_zhTW.sql (renamed from sql/updates/world/master/2025_08_13_11_world_zhTW.sql)0
-rw-r--r--sql/old/11.x/world/25071_2025_08_16/2025_08_13_12_world.sql (renamed from sql/updates/world/master/2025_08_13_12_world.sql)0
-rw-r--r--sql/updates/auth/master/2025_08_16_00_auth.sql3
-rw-r--r--sql/updates/characters/master/2025_08_16_00_characters.sql3
-rw-r--r--sql/updates/hotfixes/master/2025_08_16_00_hotfixes.sql3
-rw-r--r--sql/updates/world/master/2025_08_16_00_world.sql4
69 files changed, 76 insertions, 30 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index b31dd804ba1..ff3377a398b 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -2,7 +2,7 @@
--
-- Host: localhost Database: auth
-- ------------------------------------------------------
--- Server version 8.0.42-0ubuntu0.22.04.1
+-- Server version 8.0.42-0ubuntu0.22.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -3751,7 +3751,8 @@ INSERT INTO `updates` VALUES
('2025_06_27_00_auth.sql','243C89DFED0058323EF9690D124C1F20036D461B','ARCHIVED','2025-06-27 14:22:49',0),
('2025_07_14_00_auth.sql','5F975A202CF84F2BFEA366E0BEDF8FA63035CD62','ARCHIVED','2025-07-14 23:10:54',0),
('2025_07_21_00_auth.sql','44AA781EE1B1C66E8433E50A2E20916EB1BEFE23','ARCHIVED','2025-07-21 22:51:05',0),
-('2025_08_13_00_auth.sql','5F67141AB407AEC202E8048765256AB11C5621EA','RELEASED','2025-08-12 19:26:13',0);
+('2025_08_13_00_auth.sql','5F67141AB407AEC202E8048765256AB11C5621EA','ARCHIVED','2025-08-12 19:26:13',0),
+('2025_08_16_00_auth.sql','DCAB779D0FC212FDF964D055BEC17AC1255A013C','ARCHIVED','2025-08-16 14:58:22',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3895,4 +3896,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 2025-07-21 22:51:07
+-- Dump completed on 2025-08-16 14:58:24
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index a70185ede3d..c93b076181a 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2,7 +2,7 @@
--
-- Host: localhost Database: characters
-- ------------------------------------------------------
--- Server version 8.0.42-0ubuntu0.22.04.1
+-- Server version 8.0.42-0ubuntu0.22.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -600,9 +600,9 @@ DROP TABLE IF EXISTS `character_bank_tab_settings`;
CREATE TABLE `character_bank_tab_settings` (
`characterGuid` bigint unsigned NOT NULL,
`tabId` tinyint unsigned NOT NULL,
- `name` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `icon` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `description` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `name` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `icon` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `description` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`depositFlags` int DEFAULT '0',
PRIMARY KEY (`characterGuid`,`tabId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3821,7 +3821,8 @@ INSERT INTO `updates` VALUES
('2025_05_31_00_characters.sql','C240EB5C4008B6AA0514802A18D7DD875680DE82','ARCHIVED','2025-05-31 19:45:56',0),
('2025_06_27_00_characters.sql','35088BA5BA4BD3B7FAAD6FD4FAE38E52A5B71CD8','ARCHIVED','2025-06-27 14:22:08',0),
('2025_07_21_00_characters.sql','056A99B9AA90186E5B3177BF54C86607B6518BE9','ARCHIVED','2025-07-21 22:51:05',0),
-('2025_08_13_00_characters.sql','9C2321777E6C34F18799C8967B1CA0C44F17DA18','RELEASED','2025-08-12 20:17:45',0);
+('2025_08_13_00_characters.sql','9C2321777E6C34F18799C8967B1CA0C44F17DA18','ARCHIVED','2025-08-12 20:17:45',0),
+('2025_08_16_00_characters.sql','8DF6284B6C7BEDAB599F7E4802FF8BCD80613A92','ARCHIVED','2025-08-16 14:58:22',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3949,4 +3950,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2025-07-21 22:51:07
+-- Dump completed on 2025-08-16 14:58:24
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index 2a4487226d0..d88b1324dc2 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_database.sql
@@ -2,7 +2,7 @@
--
-- Host: localhost Database: hotfixes
-- ------------------------------------------------------
--- Server version 8.0.42-0ubuntu0.22.04.1
+-- Server version 8.0.42-0ubuntu0.22.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -269,7 +269,7 @@ DROP TABLE IF EXISTS `animation_data`;
CREATE TABLE `animation_data` (
`ID` int unsigned NOT NULL DEFAULT '0',
`Fallback` smallint unsigned NOT NULL DEFAULT '0',
- `BehaviorTier` tinyint unsigned NOT NULL DEFAULT '0',
+ `BehaviorTier` tinyint NOT NULL DEFAULT '0',
`BehaviorID` smallint NOT NULL DEFAULT '0',
`Flags1` int NOT NULL DEFAULT '0',
`Flags2` int NOT NULL DEFAULT '0',
@@ -1044,15 +1044,23 @@ CREATE TABLE `azerite_unlock_mapping` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Table structure for table `bank_bag_slot_prices`
+-- Table structure for table `bank_tab`
--
-DROP TABLE IF EXISTS `bank_bag_slot_prices`;
+DROP TABLE IF EXISTS `bank_tab`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `bank_bag_slot_prices` (
+CREATE TABLE `bank_tab` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `Cost` int unsigned NOT NULL DEFAULT '0',
+ `Cost` bigint unsigned NOT NULL DEFAULT '0',
+ `BankType` tinyint unsigned NOT NULL DEFAULT '0',
+ `OrderIndex` tinyint NOT NULL DEFAULT '0',
+ `PlayerConditionID` int NOT NULL DEFAULT '0',
+ `PurchasePromptTitle` int NOT NULL DEFAULT '0',
+ `PurchasePromptBody` int NOT NULL DEFAULT '0',
+ `PurchasePromptConfirmation` int NOT NULL DEFAULT '0',
+ `TabCleanupConfirmation` int NOT NULL DEFAULT '0',
+ `TabNameEditBoxHeader` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1069,7 +1077,7 @@ CREATE TABLE `banned_addons` (
`ID` int unsigned NOT NULL DEFAULT '0',
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Version` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
- `Flags` tinyint unsigned NOT NULL DEFAULT '0',
+ `Flags` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1489,6 +1497,7 @@ CREATE TABLE `cfg_regions` (
`Raidorigin` int unsigned NOT NULL DEFAULT '0',
`RegionGroupMask` tinyint unsigned NOT NULL DEFAULT '0',
`ChallengeOrigin` int unsigned NOT NULL DEFAULT '0',
+ `TimeEventRegionGroupID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1543,7 +1552,7 @@ CREATE TABLE `char_titles` (
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Name1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`MaskID` smallint NOT NULL DEFAULT '0',
- `Flags` tinyint NOT NULL DEFAULT '0',
+ `Flags` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1698,6 +1707,7 @@ CREATE TABLE `chr_classes` (
`IconFileDataID` int unsigned NOT NULL DEFAULT '0',
`LowResScreenFileDataID` int unsigned NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
+ `StartingLevel` int NOT NULL DEFAULT '0',
`SpellTextureBlobFileDataID` int unsigned NOT NULL DEFAULT '0',
`ArmorTypeMask` int unsigned NOT NULL DEFAULT '0',
`CharStartKitUnknown901` int NOT NULL DEFAULT '0',
@@ -1712,6 +1722,7 @@ CREATE TABLE `chr_classes` (
`CinematicSequenceID` smallint unsigned NOT NULL DEFAULT '0',
`DefaultSpec` smallint unsigned NOT NULL DEFAULT '0',
`ID` tinyint unsigned NOT NULL DEFAULT '0',
+ `HasStrengthBonus` tinyint unsigned NOT NULL DEFAULT '0',
`PrimaryStatPriority` tinyint NOT NULL DEFAULT '0',
`DisplayPower` tinyint NOT NULL DEFAULT '0',
`RangedAttackPowerPerAgility` tinyint unsigned NOT NULL DEFAULT '0',
@@ -1722,6 +1733,8 @@ CREATE TABLE `chr_classes` (
`ClassColorG` tinyint unsigned NOT NULL DEFAULT '0',
`ClassColorB` tinyint unsigned NOT NULL DEFAULT '0',
`RolesMask` tinyint unsigned NOT NULL DEFAULT '0',
+ `DamageBonusStat` tinyint unsigned NOT NULL DEFAULT '0',
+ `HasRelicSlot` tinyint unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2557,6 +2570,7 @@ CREATE TABLE `creature_family` (
`MaxScaleLevel` tinyint NOT NULL DEFAULT '0',
`PetFoodMask` smallint NOT NULL DEFAULT '0',
`PetTalentType` tinyint NOT NULL DEFAULT '0',
+ `CategoryEnumID` int NOT NULL DEFAULT '0',
`IconFileID` int NOT NULL DEFAULT '0',
`SkillLine1` smallint NOT NULL DEFAULT '0',
`SkillLine2` smallint NOT NULL DEFAULT '0',
@@ -3203,6 +3217,7 @@ CREATE TABLE `expected_stat` (
`PlayerSecondaryStat` float NOT NULL DEFAULT '0',
`ArmorConstant` float NOT NULL DEFAULT '0',
`CreatureSpellDamage` float NOT NULL DEFAULT '0',
+ `ContentSetID` int NOT NULL DEFAULT '0',
`Lvl` int unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -4541,7 +4556,7 @@ DROP TABLE IF EXISTS `item`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `ClassID` tinyint unsigned NOT NULL DEFAULT '0',
+ `ClassID` int NOT NULL DEFAULT '0',
`SubclassID` tinyint unsigned NOT NULL DEFAULT '0',
`Material` tinyint unsigned NOT NULL DEFAULT '0',
`InventoryType` tinyint NOT NULL DEFAULT '0',
@@ -5409,6 +5424,7 @@ CREATE TABLE `item_set_spell` (
`ID` int unsigned NOT NULL DEFAULT '0',
`ChrSpecID` smallint unsigned NOT NULL DEFAULT '0',
`SpellID` int unsigned NOT NULL DEFAULT '0',
+ `TraitSubTreeID` smallint unsigned NOT NULL DEFAULT '0',
`Threshold` tinyint unsigned NOT NULL DEFAULT '0',
`ItemSetID` int unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -6322,12 +6338,24 @@ CREATE TABLE `map_challenge_mode` (
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`ID` int unsigned NOT NULL DEFAULT '0',
`MapID` smallint unsigned NOT NULL DEFAULT '0',
- `Flags` tinyint unsigned NOT NULL DEFAULT '0',
+ `Flags` int NOT NULL DEFAULT '0',
`ExpansionLevel` int unsigned NOT NULL DEFAULT '0',
`RequiredWorldStateID` int NOT NULL DEFAULT '0',
`CriteriaCount1` smallint NOT NULL DEFAULT '0',
`CriteriaCount2` smallint NOT NULL DEFAULT '0',
`CriteriaCount3` smallint NOT NULL DEFAULT '0',
+ `FirstRewardQuestID1` int NOT NULL DEFAULT '0',
+ `FirstRewardQuestID2` int NOT NULL DEFAULT '0',
+ `FirstRewardQuestID3` int NOT NULL DEFAULT '0',
+ `FirstRewardQuestID4` int NOT NULL DEFAULT '0',
+ `FirstRewardQuestID5` int NOT NULL DEFAULT '0',
+ `FirstRewardQuestID6` int NOT NULL DEFAULT '0',
+ `RewardQuestID1` int NOT NULL DEFAULT '0',
+ `RewardQuestID2` int NOT NULL DEFAULT '0',
+ `RewardQuestID3` int NOT NULL DEFAULT '0',
+ `RewardQuestID4` int NOT NULL DEFAULT '0',
+ `RewardQuestID5` int NOT NULL DEFAULT '0',
+ `RewardQuestID6` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -8460,8 +8488,8 @@ CREATE TABLE `spell_category` (
`ID` int unsigned NOT NULL DEFAULT '0',
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Flags` int NOT NULL DEFAULT '0',
- `UsesPerWeek` tinyint unsigned NOT NULL DEFAULT '0',
- `MaxCharges` tinyint NOT NULL DEFAULT '0',
+ `UsesPerWeek` int NOT NULL DEFAULT '0',
+ `MaxCharges` int NOT NULL DEFAULT '0',
`ChargeRecoveryTime` int NOT NULL DEFAULT '0',
`TypeMask` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -8645,7 +8673,7 @@ DROP TABLE IF EXISTS `spell_equipped_items`;
CREATE TABLE `spell_equipped_items` (
`ID` int unsigned NOT NULL DEFAULT '0',
`SpellID` int NOT NULL DEFAULT '0',
- `EquippedItemClass` tinyint NOT NULL DEFAULT '0',
+ `EquippedItemClass` int NOT NULL DEFAULT '0',
`EquippedItemInvTypes` int NOT NULL DEFAULT '0',
`EquippedItemSubclass` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -9415,6 +9443,10 @@ CREATE TABLE `spell_visual_kit` (
`FallbackSpellVisualKitId` int NOT NULL DEFAULT '0',
`DelayMin` smallint unsigned NOT NULL DEFAULT '0',
`DelayMax` smallint unsigned NOT NULL DEFAULT '0',
+ `MinimumSpellVisualDensityFilterType` int NOT NULL DEFAULT '0',
+ `MinimumSpellVisualDensityFilterParam` int NOT NULL DEFAULT '0',
+ `ReducedSpellVisualDensityFilterType` int NOT NULL DEFAULT '0',
+ `ReducedSpellVisualDensityFilterParam` int NOT NULL DEFAULT '0',
`Flags1` int NOT NULL DEFAULT '0',
`Flags2` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -10745,7 +10777,7 @@ CREATE TABLE `unit_power_bar` (
`RegenerationPeace` float NOT NULL DEFAULT '0',
`RegenerationCombat` float NOT NULL DEFAULT '0',
`BarType` tinyint unsigned NOT NULL DEFAULT '0',
- `Flags` smallint unsigned NOT NULL DEFAULT '0',
+ `Flags` int NOT NULL DEFAULT '0',
`StartInset` float NOT NULL DEFAULT '0',
`EndInset` float NOT NULL DEFAULT '0',
`FileDataID1` int NOT NULL DEFAULT '0',
@@ -11009,7 +11041,6 @@ DROP TABLE IF EXISTS `warband_scene`;
CREATE TABLE `warband_scene` (
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
- `Source` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`PositionX` float NOT NULL DEFAULT '0',
`PositionY` float NOT NULL DEFAULT '0',
`PositionZ` float NOT NULL DEFAULT '0',
@@ -11025,7 +11056,6 @@ CREATE TABLE `warband_scene` (
`Quality` tinyint NOT NULL DEFAULT '0',
`TextureKit` int NOT NULL DEFAULT '0',
`DefaultScenePriority` int NOT NULL DEFAULT '0',
- `SourceType` tinyint NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -11043,7 +11073,6 @@ CREATE TABLE `warband_scene_locale` (
`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,
- `Source_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
@@ -11192,4 +11221,4 @@ CREATE TABLE `world_state_expression` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2025-07-21 22:51:12
+-- Dump completed on 2025-08-16 14:58:29
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 77a3413e32d..b2dcebb26e4 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -2,7 +2,7 @@
--
-- Host: localhost Database: world
-- ------------------------------------------------------
--- Server version 8.0.42-0ubuntu0.22.04.1
+-- Server version 8.0.42-0ubuntu0.22.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -182,7 +182,7 @@ DROP TABLE IF EXISTS `areatrigger_create_properties_orbit`;
CREATE TABLE `areatrigger_create_properties_orbit` (
`AreaTriggerCreatePropertiesId` int unsigned NOT NULL,
`IsCustom` tinyint unsigned NOT NULL,
- `StartDelay` int unsigned NOT NULL DEFAULT '0',
+ `ExtraTimeForBlending` int NOT NULL DEFAULT '0',
`CircleRadius` float NOT NULL DEFAULT '0',
`BlendFromRadius` float NOT NULL DEFAULT '0',
`InitialAngle` float NOT NULL DEFAULT '0',
@@ -1052,6 +1052,7 @@ CREATE TABLE `creature_template_difficulty` (
`CreatureDifficultyID` int NOT NULL DEFAULT '0',
`TypeFlags` int unsigned NOT NULL DEFAULT '0',
`TypeFlags2` int unsigned NOT NULL DEFAULT '0',
+ `TypeFlags3` int unsigned NOT NULL DEFAULT '0',
`LootID` int unsigned NOT NULL DEFAULT '0',
`PickPocketLootID` int unsigned NOT NULL DEFAULT '0',
`SkinLootID` int unsigned NOT NULL DEFAULT '0',
@@ -4776,6 +4777,7 @@ CREATE TABLE `vehicle_template` (
`creatureId` int unsigned NOT NULL,
`despawnDelayMs` int NOT NULL DEFAULT '0',
`Pitch` float DEFAULT NULL,
+ `CustomFlags` int unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`creatureId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -5061,4 +5063,4 @@ CREATE TABLE `world_state` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2025-07-21 22:51:09
+-- Dump completed on 2025-08-16 14:58:26
diff --git a/sql/updates/auth/master/2025_07_21_00_auth.sql b/sql/old/11.x/auth/25071_2025_08_16/2025_07_21_00_auth.sql
index 8135a85c764..8135a85c764 100644
--- a/sql/updates/auth/master/2025_07_21_00_auth.sql
+++ b/sql/old/11.x/auth/25071_2025_08_16/2025_07_21_00_auth.sql
diff --git a/sql/updates/auth/master/2025_08_13_00_auth.sql b/sql/old/11.x/auth/25071_2025_08_16/2025_08_13_00_auth.sql
index 8544b57cb5e..8544b57cb5e 100644
--- a/sql/updates/auth/master/2025_08_13_00_auth.sql
+++ b/sql/old/11.x/auth/25071_2025_08_16/2025_08_13_00_auth.sql
diff --git a/sql/updates/characters/master/2025_07_21_00_characters.sql b/sql/old/11.x/characters/25071_2025_08_16/2025_07_21_00_characters.sql
index e3b556455a5..e3b556455a5 100644
--- a/sql/updates/characters/master/2025_07_21_00_characters.sql
+++ b/sql/old/11.x/characters/25071_2025_08_16/2025_07_21_00_characters.sql
diff --git a/sql/updates/characters/master/2025_08_13_00_characters.sql b/sql/old/11.x/characters/25071_2025_08_16/2025_08_13_00_characters.sql
index 0fbb7311b12..0fbb7311b12 100644
--- a/sql/updates/characters/master/2025_08_13_00_characters.sql
+++ b/sql/old/11.x/characters/25071_2025_08_16/2025_08_13_00_characters.sql
diff --git a/sql/updates/hotfixes/master/2025_07_21_00_hotfixes.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_07_21_00_hotfixes.sql
index bc14c513528..bc14c513528 100644
--- a/sql/updates/hotfixes/master/2025_07_21_00_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_07_21_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2025_08_13_00_hotfixes.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_00_hotfixes.sql
index 9d6e1dec51c..9d6e1dec51c 100644
--- a/sql/updates/hotfixes/master/2025_08_13_00_hotfixes.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2025_08_13_01_hotfixes_enUS.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_01_hotfixes_enUS.sql
index 0c38d4e5d2e..0c38d4e5d2e 100644
--- a/sql/updates/hotfixes/master/2025_08_13_01_hotfixes_enUS.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_01_hotfixes_enUS.sql
diff --git a/sql/updates/hotfixes/master/2025_08_13_02_hotfixes_deDE.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_02_hotfixes_deDE.sql
index befae6bd86f..befae6bd86f 100644
--- a/sql/updates/hotfixes/master/2025_08_13_02_hotfixes_deDE.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_02_hotfixes_deDE.sql
diff --git a/sql/updates/hotfixes/master/2025_08_13_03_hotfixes_esMX.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_03_hotfixes_esMX.sql
index 00fc245e2cc..00fc245e2cc 100644
--- a/sql/updates/hotfixes/master/2025_08_13_03_hotfixes_esMX.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_03_hotfixes_esMX.sql
diff --git a/sql/updates/hotfixes/master/2025_08_13_04_hotfixes_frFR.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_04_hotfixes_frFR.sql
index 5eab4ebecd6..5eab4ebecd6 100644
--- a/sql/updates/hotfixes/master/2025_08_13_04_hotfixes_frFR.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_04_hotfixes_frFR.sql
diff --git a/sql/updates/hotfixes/master/2025_08_13_05_hotfixes_ptBR.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_05_hotfixes_ptBR.sql
index 7e0460f006f..7e0460f006f 100644
--- a/sql/updates/hotfixes/master/2025_08_13_05_hotfixes_ptBR.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_05_hotfixes_ptBR.sql
diff --git a/sql/updates/hotfixes/master/2025_08_13_06_hotfixes_esES.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_06_hotfixes_esES.sql
index 59b5a438c87..59b5a438c87 100644
--- a/sql/updates/hotfixes/master/2025_08_13_06_hotfixes_esES.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_06_hotfixes_esES.sql
diff --git a/sql/updates/hotfixes/master/2025_08_13_07_hotfixes_itIT.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_07_hotfixes_itIT.sql
index 8cd14e5320d..8cd14e5320d 100644
--- a/sql/updates/hotfixes/master/2025_08_13_07_hotfixes_itIT.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_07_hotfixes_itIT.sql
diff --git a/sql/updates/hotfixes/master/2025_08_13_08_hotfixes_koKR.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_08_hotfixes_koKR.sql
index 0c866ff52ff..0c866ff52ff 100644
--- a/sql/updates/hotfixes/master/2025_08_13_08_hotfixes_koKR.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_08_hotfixes_koKR.sql
diff --git a/sql/updates/hotfixes/master/2025_08_13_09_hotfixes_ruRU.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_09_hotfixes_ruRU.sql
index 6562c5436fa..6562c5436fa 100644
--- a/sql/updates/hotfixes/master/2025_08_13_09_hotfixes_ruRU.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_09_hotfixes_ruRU.sql
diff --git a/sql/updates/hotfixes/master/2025_08_13_10_hotfixes_zhCN.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_10_hotfixes_zhCN.sql
index d54c2d07b2f..d54c2d07b2f 100644
--- a/sql/updates/hotfixes/master/2025_08_13_10_hotfixes_zhCN.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_10_hotfixes_zhCN.sql
diff --git a/sql/updates/hotfixes/master/2025_08_13_11_hotfixes_zhTW.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_11_hotfixes_zhTW.sql
index a916d14ad10..a916d14ad10 100644
--- a/sql/updates/hotfixes/master/2025_08_13_11_hotfixes_zhTW.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_13_11_hotfixes_zhTW.sql
diff --git a/sql/updates/hotfixes/master/2025_08_15_00_hotfixes_enUS.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_00_hotfixes_enUS.sql
index 9b57792503d..9b57792503d 100644
--- a/sql/updates/hotfixes/master/2025_08_15_00_hotfixes_enUS.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_00_hotfixes_enUS.sql
diff --git a/sql/updates/hotfixes/master/2025_08_15_01_hotfixes_deDE.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_01_hotfixes_deDE.sql
index 4595d95052e..4595d95052e 100644
--- a/sql/updates/hotfixes/master/2025_08_15_01_hotfixes_deDE.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_01_hotfixes_deDE.sql
diff --git a/sql/updates/hotfixes/master/2025_08_15_02_hotfixes_esES.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_02_hotfixes_esES.sql
index 2ad0b5ce2be..2ad0b5ce2be 100644
--- a/sql/updates/hotfixes/master/2025_08_15_02_hotfixes_esES.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_02_hotfixes_esES.sql
diff --git a/sql/updates/hotfixes/master/2025_08_15_03_hotfixes_esMX.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_03_hotfixes_esMX.sql
index 0c0f2685748..0c0f2685748 100644
--- a/sql/updates/hotfixes/master/2025_08_15_03_hotfixes_esMX.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_03_hotfixes_esMX.sql
diff --git a/sql/updates/hotfixes/master/2025_08_15_04_hotfixes_frFR.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_04_hotfixes_frFR.sql
index bb1a6908810..bb1a6908810 100644
--- a/sql/updates/hotfixes/master/2025_08_15_04_hotfixes_frFR.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_04_hotfixes_frFR.sql
diff --git a/sql/updates/hotfixes/master/2025_08_15_05_hotfixes_itIT.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_05_hotfixes_itIT.sql
index e780bf2416d..e780bf2416d 100644
--- a/sql/updates/hotfixes/master/2025_08_15_05_hotfixes_itIT.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_05_hotfixes_itIT.sql
diff --git a/sql/updates/hotfixes/master/2025_08_15_06_hotfixes_koKR.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_06_hotfixes_koKR.sql
index 127faa8600a..127faa8600a 100644
--- a/sql/updates/hotfixes/master/2025_08_15_06_hotfixes_koKR.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_06_hotfixes_koKR.sql
diff --git a/sql/updates/hotfixes/master/2025_08_15_07_hotfixes_ptBR.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_07_hotfixes_ptBR.sql
index e23b4dc8474..e23b4dc8474 100644
--- a/sql/updates/hotfixes/master/2025_08_15_07_hotfixes_ptBR.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_07_hotfixes_ptBR.sql
diff --git a/sql/updates/hotfixes/master/2025_08_15_08_hotfixes_ruRU.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_08_hotfixes_ruRU.sql
index a4acb247cbb..a4acb247cbb 100644
--- a/sql/updates/hotfixes/master/2025_08_15_08_hotfixes_ruRU.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_08_hotfixes_ruRU.sql
diff --git a/sql/updates/hotfixes/master/2025_08_15_09_hotfixes_zhCN.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_09_hotfixes_zhCN.sql
index 0a1a1e36f0b..0a1a1e36f0b 100644
--- a/sql/updates/hotfixes/master/2025_08_15_09_hotfixes_zhCN.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_09_hotfixes_zhCN.sql
diff --git a/sql/updates/hotfixes/master/2025_08_15_10_hotfixes_zhTW.sql b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_10_hotfixes_zhTW.sql
index 7424d45e15c..7424d45e15c 100644
--- a/sql/updates/hotfixes/master/2025_08_15_10_hotfixes_zhTW.sql
+++ b/sql/old/11.x/hotfixes/25071_2025_08_16/2025_08_15_10_hotfixes_zhTW.sql
diff --git a/sql/updates/world/master/2025_07_21_01_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_21_01_world.sql
index e31199b4be8..e31199b4be8 100644
--- a/sql/updates/world/master/2025_07_21_01_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_21_01_world.sql
diff --git a/sql/updates/world/master/2025_07_22_00_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_22_00_world.sql
index bdb698f042a..bdb698f042a 100644
--- a/sql/updates/world/master/2025_07_22_00_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_22_00_world.sql
diff --git a/sql/updates/world/master/2025_07_23_00_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_23_00_world.sql
index 2b3bc3c5a37..2b3bc3c5a37 100644
--- a/sql/updates/world/master/2025_07_23_00_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_23_00_world.sql
diff --git a/sql/updates/world/master/2025_07_24_00_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_24_00_world.sql
index 9fc8c86cf0a..9fc8c86cf0a 100644
--- a/sql/updates/world/master/2025_07_24_00_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_24_00_world.sql
diff --git a/sql/updates/world/master/2025_07_26_00_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_26_00_world.sql
index b3737ceb62c..b3737ceb62c 100644
--- a/sql/updates/world/master/2025_07_26_00_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_26_00_world.sql
diff --git a/sql/updates/world/master/2025_07_27_00_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_27_00_world.sql
index b5d030dc073..b5d030dc073 100644
--- a/sql/updates/world/master/2025_07_27_00_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_27_00_world.sql
diff --git a/sql/updates/world/master/2025_07_29_00_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_00_world.sql
index 72593924b6a..72593924b6a 100644
--- a/sql/updates/world/master/2025_07_29_00_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_00_world.sql
diff --git a/sql/updates/world/master/2025_07_29_01_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_01_world.sql
index 50511e50cf0..50511e50cf0 100644
--- a/sql/updates/world/master/2025_07_29_01_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_01_world.sql
diff --git a/sql/updates/world/master/2025_07_29_02_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_02_world.sql
index 2a89f95eef4..2a89f95eef4 100644
--- a/sql/updates/world/master/2025_07_29_02_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_02_world.sql
diff --git a/sql/updates/world/master/2025_07_29_03_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_03_world.sql
index 7c23d2ead89..7c23d2ead89 100644
--- a/sql/updates/world/master/2025_07_29_03_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_03_world.sql
diff --git a/sql/updates/world/master/2025_07_29_04_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_04_world.sql
index faf4d43dcc6..faf4d43dcc6 100644
--- a/sql/updates/world/master/2025_07_29_04_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_04_world.sql
diff --git a/sql/updates/world/master/2025_07_29_05_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_05_world.sql
index bcddf880b13..bcddf880b13 100644
--- a/sql/updates/world/master/2025_07_29_05_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_05_world.sql
diff --git a/sql/updates/world/master/2025_07_29_06_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_06_world.sql
index 5bd92e05f83..5bd92e05f83 100644
--- a/sql/updates/world/master/2025_07_29_06_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_06_world.sql
diff --git a/sql/updates/world/master/2025_07_29_07_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_07_world.sql
index da2da224dcc..da2da224dcc 100644
--- a/sql/updates/world/master/2025_07_29_07_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_07_world.sql
diff --git a/sql/updates/world/master/2025_07_29_08_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_08_world.sql
index 8ca5758feca..8ca5758feca 100644
--- a/sql/updates/world/master/2025_07_29_08_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_08_world.sql
diff --git a/sql/updates/world/master/2025_07_29_09_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_09_world.sql
index 9b8aadebcd5..9b8aadebcd5 100644
--- a/sql/updates/world/master/2025_07_29_09_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_07_29_09_world.sql
diff --git a/sql/updates/world/master/2025_08_02_00_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_02_00_world.sql
index 60692ea5473..60692ea5473 100644
--- a/sql/updates/world/master/2025_08_02_00_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_02_00_world.sql
diff --git a/sql/updates/world/master/2025_08_02_01_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_02_01_world.sql
index 72c9e27603b..72c9e27603b 100644
--- a/sql/updates/world/master/2025_08_02_01_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_02_01_world.sql
diff --git a/sql/updates/world/master/2025_08_02_02_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_02_02_world.sql
index 495dc8196c4..495dc8196c4 100644
--- a/sql/updates/world/master/2025_08_02_02_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_02_02_world.sql
diff --git a/sql/updates/world/master/2025_08_05_00_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_05_00_world.sql
index 23f11f2b4c8..23f11f2b4c8 100644
--- a/sql/updates/world/master/2025_08_05_00_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_05_00_world.sql
diff --git a/sql/updates/world/master/2025_08_13_00_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_00_world.sql
index ce62921b66e..ce62921b66e 100644
--- a/sql/updates/world/master/2025_08_13_00_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_00_world.sql
diff --git a/sql/updates/world/master/2025_08_13_01_world_enUS.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_01_world_enUS.sql
index 9ae7298aece..9ae7298aece 100644
--- a/sql/updates/world/master/2025_08_13_01_world_enUS.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_01_world_enUS.sql
diff --git a/sql/updates/world/master/2025_08_13_02_world_deDE.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_02_world_deDE.sql
index cef63cab65f..cef63cab65f 100644
--- a/sql/updates/world/master/2025_08_13_02_world_deDE.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_02_world_deDE.sql
diff --git a/sql/updates/world/master/2025_08_13_03_world_esMX.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_03_world_esMX.sql
index 53d129f135d..53d129f135d 100644
--- a/sql/updates/world/master/2025_08_13_03_world_esMX.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_03_world_esMX.sql
diff --git a/sql/updates/world/master/2025_08_13_04_world_frFR.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_04_world_frFR.sql
index c1b7ea6e231..c1b7ea6e231 100644
--- a/sql/updates/world/master/2025_08_13_04_world_frFR.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_04_world_frFR.sql
diff --git a/sql/updates/world/master/2025_08_13_05_world_ptBR.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_05_world_ptBR.sql
index c33bf9e7df2..c33bf9e7df2 100644
--- a/sql/updates/world/master/2025_08_13_05_world_ptBR.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_05_world_ptBR.sql
diff --git a/sql/updates/world/master/2025_08_13_06_world_esES.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_06_world_esES.sql
index 5b7944b5463..5b7944b5463 100644
--- a/sql/updates/world/master/2025_08_13_06_world_esES.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_06_world_esES.sql
diff --git a/sql/updates/world/master/2025_08_13_07_world_itIT.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_07_world_itIT.sql
index 218f401615e..218f401615e 100644
--- a/sql/updates/world/master/2025_08_13_07_world_itIT.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_07_world_itIT.sql
diff --git a/sql/updates/world/master/2025_08_13_08_world_koKR.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_08_world_koKR.sql
index 4f5cea16d7c..4f5cea16d7c 100644
--- a/sql/updates/world/master/2025_08_13_08_world_koKR.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_08_world_koKR.sql
diff --git a/sql/updates/world/master/2025_08_13_09_world_ruRU.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_09_world_ruRU.sql
index e326a3549c3..e326a3549c3 100644
--- a/sql/updates/world/master/2025_08_13_09_world_ruRU.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_09_world_ruRU.sql
diff --git a/sql/updates/world/master/2025_08_13_10_world_zhCN.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_10_world_zhCN.sql
index 9fe4b0cf806..9fe4b0cf806 100644
--- a/sql/updates/world/master/2025_08_13_10_world_zhCN.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_10_world_zhCN.sql
diff --git a/sql/updates/world/master/2025_08_13_11_world_zhTW.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_11_world_zhTW.sql
index 1fdab108550..1fdab108550 100644
--- a/sql/updates/world/master/2025_08_13_11_world_zhTW.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_11_world_zhTW.sql
diff --git a/sql/updates/world/master/2025_08_13_12_world.sql b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_12_world.sql
index 413c50af92c..413c50af92c 100644
--- a/sql/updates/world/master/2025_08_13_12_world.sql
+++ b/sql/old/11.x/world/25071_2025_08_16/2025_08_13_12_world.sql
diff --git a/sql/updates/auth/master/2025_08_16_00_auth.sql b/sql/updates/auth/master/2025_08_16_00_auth.sql
new file mode 100644
index 00000000000..8c96feb0370
--- /dev/null
+++ b/sql/updates/auth/master/2025_08_16_00_auth.sql
@@ -0,0 +1,3 @@
+-- TDB 1120.25081 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/2025_08_16_00_characters.sql b/sql/updates/characters/master/2025_08_16_00_characters.sql
new file mode 100644
index 00000000000..33efc7188f6
--- /dev/null
+++ b/sql/updates/characters/master/2025_08_16_00_characters.sql
@@ -0,0 +1,3 @@
+-- TDB 1120.25081 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/2025_08_16_00_hotfixes.sql b/sql/updates/hotfixes/master/2025_08_16_00_hotfixes.sql
new file mode 100644
index 00000000000..9693ca9de0a
--- /dev/null
+++ b/sql/updates/hotfixes/master/2025_08_16_00_hotfixes.sql
@@ -0,0 +1,3 @@
+-- TDB 1120.25081 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/2025_08_16_00_world.sql b/sql/updates/world/master/2025_08_16_00_world.sql
new file mode 100644
index 00000000000..c3a26d2c784
--- /dev/null
+++ b/sql/updates/world/master/2025_08_16_00_world.sql
@@ -0,0 +1,4 @@
+-- TDB 1120.25081 world
+UPDATE `version` SET `db_version`='TDB 1120.25081', `cache_id`=25081 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/world', 'ARCHIVED');