diff options
author | TDB Release <tdb-release@build.bot> | 2025-08-16 15:03:50 +0000 |
---|---|---|
committer | TDB Release <tdb-release@build.bot> | 2025-08-16 15:03:50 +0000 |
commit | b4d69dfd6d782b283ae4f9ebfcc780d6f84eb64a (patch) | |
tree | d8ad48a143780693bf7044a643eb66f110ae94cb | |
parent | de80c713d0aad00166bb2a25fe70ec3672da7fa0 (diff) |
TDB 1120.25081 - 2025/08/16TDB1120.25081
-rw-r--r-- | revision_data.h.in.cmake | 4 | ||||
-rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
-rw-r--r-- | sql/base/characters_database.sql | 13 | ||||
-rw-r--r-- | sql/base/dev/hotfixes_database.sql | 65 | ||||
-rw-r--r-- | sql/base/dev/world_database.sql | 8 | ||||
-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.sql | 3 | ||||
-rw-r--r-- | sql/updates/characters/master/2025_08_16_00_characters.sql | 3 | ||||
-rw-r--r-- | sql/updates/hotfixes/master/2025_08_16_00_hotfixes.sql | 3 | ||||
-rw-r--r-- | sql/updates/world/master/2025_08_16_00_world.sql | 4 |
70 files changed, 78 insertions, 32 deletions
diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake index 82cad7ddf29..f2852bf89cf 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_1117.25071_2025_07_21.sql" -#define DATABASE_HOTFIXES_DATABASE "TDB_full_hotfixes_1117.25071_2025_07_21.sql" +#define DATABASE_FULL_DATABASE "TDB_full_world_1120.25081_2025_08_16.sql" +#define DATABASE_HOTFIXES_DATABASE "TDB_full_hotfixes_1120.25081_2025_08_16.sql" // Windows resource defines #define TRINITY_COMPANYNAME_STR "TrinityCore Developers" 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'); |