From cba7c3ab5e41f17a1e480f8591022537abadcb66 Mon Sep 17 00:00:00 2001 From: TDB Release Date: Mon, 21 Jul 2025 22:56:17 +0000 Subject: TDB 1117.25071 - 2025/07/21 --- sql/base/auth_database.sql | 19 ++++---- sql/base/characters_database.sql | 5 ++- sql/base/dev/hotfixes_database.sql | 88 +++++++++++++++++++++++++++++++++----- sql/base/dev/world_database.sql | 16 ++++--- 4 files changed, 100 insertions(+), 28 deletions(-) (limited to 'sql/base') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index cca9dae9d50..3d28ebe8f6b 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -3710,14 +3710,15 @@ INSERT INTO `updates` VALUES ('2025_05_14_00_auth.sql','E4C40DFB18415ADB60223BA7518A2F0FCD491712','ARCHIVED','2025-05-14 10:24:56',0), ('2025_05_30_00_auth.sql','37191DD7967326918A3BE9EB919CEECBA42098A2','ARCHIVED','2025-05-30 11:42:16',0), ('2025_05_31_00_auth.sql','5EF8B1EBE4CF99E5D1C02BD6141FB35EA19FED6C','ARCHIVED','2025-05-31 19:45:56',0), -('2025_06_03_00_auth.sql','2ADB0D37ED7223C2EA94497B0F7B7C0BF91A72B8','RELEASED','2025-06-03 01:11:51',0), -('2025_06_05_00_auth.sql','E40328A6899D04BCDB6A36337BD243837AF92205','RELEASED','2025-06-05 00:26:43',0), -('2025_06_05_02_auth.sql','C2B67F688AC54CF6994F4709D0ECE692C968F346','RELEASED','2025-06-05 16:22:53',0), -('2025_06_18_00_auth.sql','AB5F6069BD37C93050022700F1C4B814D9D139C1','RELEASED','2025-06-17 23:13:05',0), -('2025_06_19_00_auth.sql','1C0ACAEEFC934F91F44C113E6CD9D7A40ED1C979','RELEASED','2025-06-18 22:51:15',0), -('2025_06_25_00_auth.sql','27DC7FB423FFB3788082CCFC18D5432650B09FB3','RELEASED','2025-06-25 01:15:04',0), -('2025_06_27_00_auth.sql','243C89DFED0058323EF9690D124C1F20036D461B','RELEASED','2025-06-27 14:22:49',0), -('2025_07_14_00_auth.sql','5F975A202CF84F2BFEA366E0BEDF8FA63035CD62','RELEASED','2025-07-14 23:10:54',0); +('2025_06_03_00_auth.sql','2ADB0D37ED7223C2EA94497B0F7B7C0BF91A72B8','ARCHIVED','2025-06-03 01:11:51',0), +('2025_06_05_00_auth.sql','E40328A6899D04BCDB6A36337BD243837AF92205','ARCHIVED','2025-06-05 00:26:43',0), +('2025_06_05_02_auth.sql','C2B67F688AC54CF6994F4709D0ECE692C968F346','ARCHIVED','2025-06-05 16:22:53',0), +('2025_06_18_00_auth.sql','AB5F6069BD37C93050022700F1C4B814D9D139C1','ARCHIVED','2025-06-17 23:13:05',0), +('2025_06_19_00_auth.sql','1C0ACAEEFC934F91F44C113E6CD9D7A40ED1C979','ARCHIVED','2025-06-18 22:51:15',0), +('2025_06_25_00_auth.sql','27DC7FB423FFB3788082CCFC18D5432650B09FB3','ARCHIVED','2025-06-25 01:15:04',0), +('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); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3861,4 +3862,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-05-31 19:45:57 +-- Dump completed on 2025-07-21 22:51:07 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 28b1021d2c2..be834419bdc 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -3831,7 +3831,8 @@ INSERT INTO `updates` VALUES ('2025_01_04_00_characters.sql','403E8B642A67765A04A0A4D5BC0752288208079C','ARCHIVED','2025-01-04 16:31:39',0), ('2025_03_29_00_characters.sql','6A49C236D0B8CCD8A5B6B51F60E116B3380772D7','ARCHIVED','2025-03-29 01:12:13',0), ('2025_05_31_00_characters.sql','C240EB5C4008B6AA0514802A18D7DD875680DE82','ARCHIVED','2025-05-31 19:45:56',0), -('2025_06_27_00_characters.sql','35088BA5BA4BD3B7FAAD6FD4FAE38E52A5B71CD8','RELEASED','2025-06-27 14:22:08',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); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3959,4 +3960,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2025-05-31 19:45:58 +-- Dump completed on 2025-07-21 22:51:07 diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index 241a04977e9..2a4487226d0 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -1290,7 +1290,7 @@ CREATE TABLE `battlemaster_list` ( `GameType` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ShortDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `LongDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `InstanceType` tinyint NOT NULL DEFAULT '0', + `PvpType` int NOT NULL DEFAULT '0', `MinLevel` tinyint NOT NULL DEFAULT '0', `MaxLevel` tinyint NOT NULL DEFAULT '0', `RatedPlayers` tinyint NOT NULL DEFAULT '0', @@ -2310,6 +2310,8 @@ CREATE TABLE `content_tuning` ( `ExpansionID` int NOT NULL DEFAULT '0', `HealthItemLevelCurveID` int NOT NULL DEFAULT '0', `DamageItemLevelCurveID` int NOT NULL DEFAULT '0', + `HealthPrimaryStatCurveID` int NOT NULL DEFAULT '0', + `DamagePrimaryStatCurveID` int NOT NULL DEFAULT '0', `MinLevel` int NOT NULL DEFAULT '0', `MaxLevel` int NOT NULL DEFAULT '0', `MinLevelType` int NOT NULL DEFAULT '0', @@ -6896,8 +6898,8 @@ DROP TABLE IF EXISTS `perks_activity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `perks_activity` ( - `ActivityName` text COLLATE utf8mb4_unicode_ci, - `Description` text COLLATE utf8mb4_unicode_ci, + `ActivityName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ID` int unsigned NOT NULL DEFAULT '0', `CriteriaTreeID` int NOT NULL DEFAULT '0', `ThresholdContributionAmount` int NOT NULL DEFAULT '0', @@ -6917,9 +6919,9 @@ DROP TABLE IF EXISTS `perks_activity_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `perks_activity_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `ActivityName_lang` text COLLATE utf8mb4_unicode_ci, - `Description_lang` text COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `ActivityName_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Description_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci @@ -6995,7 +6997,7 @@ CREATE TABLE `player_condition` ( `CurrentCompletedQuestLogic` int unsigned NOT NULL DEFAULT '0', `SpellLogic` int unsigned NOT NULL DEFAULT '0', `ItemLogic` int unsigned NOT NULL DEFAULT '0', - `ItemFlags` tinyint unsigned NOT NULL DEFAULT '0', + `ItemFlags` int NOT NULL DEFAULT '0', `AuraSpellLogic` int unsigned NOT NULL DEFAULT '0', `WorldStateExpressionID` smallint unsigned NOT NULL DEFAULT '0', `WeatherID` int NOT NULL DEFAULT '0', @@ -7169,6 +7171,70 @@ CREATE TABLE `player_condition_locale` ( PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `player_data_element_account` +-- + +DROP TABLE IF EXISTS `player_data_element_account`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `player_data_element_account` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `StorageIndex` int NOT NULL DEFAULT '0', + `Type` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `player_data_element_character` +-- + +DROP TABLE IF EXISTS `player_data_element_character`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `player_data_element_character` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `StorageIndex` int NOT NULL DEFAULT '0', + `Type` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `player_data_flag_account` +-- + +DROP TABLE IF EXISTS `player_data_flag_account`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `player_data_flag_account` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `StorageIndex` int NOT NULL DEFAULT '0', + `Unknown1107` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `player_data_flag_character` +-- + +DROP TABLE IF EXISTS `player_data_flag_character`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `player_data_flag_character` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `StorageIndex` int NOT NULL DEFAULT '0', + `Unknown1107` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `power_display` -- @@ -7669,7 +7735,7 @@ DROP TABLE IF EXISTS `quest_v2`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_v2` ( `ID` int unsigned NOT NULL DEFAULT '0', - `UniqueBitFlag` smallint unsigned NOT NULL DEFAULT '0', + `UniqueBitFlag` int NOT NULL DEFAULT '0', `UiQuestDetailsTheme` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -9479,7 +9545,7 @@ CREATE TABLE `talent` ( `ID` int unsigned NOT NULL DEFAULT '0', `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `TierID` tinyint unsigned NOT NULL DEFAULT '0', - `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `ColumnIndex` tinyint unsigned NOT NULL DEFAULT '0', `TabID` smallint unsigned NOT NULL DEFAULT '0', `ClassID` tinyint NOT NULL DEFAULT '0', @@ -11016,7 +11082,7 @@ CREATE TABLE `wmo_area_table` ( `IntroSound` smallint unsigned NOT NULL DEFAULT '0', `UwIntroSound` smallint unsigned NOT NULL DEFAULT '0', `AreaTableID` smallint unsigned NOT NULL DEFAULT '0', - `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; @@ -11126,4 +11192,4 @@ CREATE TABLE `world_state_expression` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2025-05-31 19:46:02 +-- Dump completed on 2025-07-21 22:51:12 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 130a92a5b20..77a3413e32d 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -1630,7 +1630,7 @@ CREATE TABLE `game_tele` ( `map` smallint unsigned NOT NULL DEFAULT '0', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=2291 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command'; +) ENGINE=InnoDB AUTO_INCREMENT=2305 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2653,11 +2653,16 @@ CREATE TABLE `playerchoice` ( `UiTextureKitId` int NOT NULL DEFAULT '0', `SoundKitId` int unsigned NOT NULL DEFAULT '0', `CloseSoundKitId` int unsigned NOT NULL DEFAULT '0', - `Duration` bigint NOT NULL DEFAULT '0', + `Duration` bigint DEFAULT '0', `PendingChoiceText` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `Question` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `HideWarboardHeader` tinyint(1) NOT NULL DEFAULT '0', + `HideWarboardHeader` tinyint unsigned NOT NULL DEFAULT '0', `KeepOpenAfterChoice` tinyint unsigned NOT NULL DEFAULT '0', + `ShowChoicesAsList` tinyint unsigned NOT NULL DEFAULT '0', + `ForceDontShowChoicesAsList` tinyint unsigned NOT NULL DEFAULT '0', + `MaxResponses` int unsigned DEFAULT NULL, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `InfiniteRange` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ChoiceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2689,7 +2694,6 @@ DROP TABLE IF EXISTS `playerchoice_response`; CREATE TABLE `playerchoice_response` ( `ChoiceId` int NOT NULL, `ResponseId` int NOT NULL, - `ResponseIdentifier` smallint unsigned NOT NULL, `Index` int unsigned NOT NULL, `ChoiceArtFileId` int NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', @@ -4194,7 +4198,7 @@ CREATE TABLE `spawn_tracking` ( `SpawnTrackingId` int unsigned NOT NULL, `SpawnType` tinyint unsigned NOT NULL, `SpawnId` bigint unsigned NOT NULL, - `QuestObjectiveId` int unsigned NOT NULL, + `QuestObjectiveIds` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`SpawnTrackingId`,`SpawnType`,`SpawnId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -5057,4 +5061,4 @@ CREATE TABLE `world_state` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2025-05-31 19:45:59 +-- Dump completed on 2025-07-21 22:51:09 -- cgit v1.2.3