TDB 335.25101 - 2025/10/21TDB335.25101

3 files changed, 44 insertions, 42 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index bd52ab0edd4..890b885d496 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.40, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.43, for Linux (x86_64)
 --
 -- Host: localhost    Database: auth
 -- ------------------------------------------------------
--- Server version	8.0.40-0ubuntu0.22.04.1
+-- Server version	8.0.43-0ubuntu0.22.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -2532,7 +2532,8 @@ INSERT INTO `updates` VALUES
 ('2024_08_30_00_auth.sql','BD76942F1C29AAA2450E051E7CA552672B5E331B','ARCHIVED','2024-08-30 19:24:30',0),
 ('2024_09_26_00_auth.sql','E37C3997FD7851EA360774AC568912846C448272','ARCHIVED','2024-09-26 18:27:26',0),
 ('2024_11_22_00_auth.sql','F2C1D1572A3968E9E9D778EF7DC82778DF3EF887','ARCHIVED','2024-11-22 23:18:14',0),
-('2025_02_14_00_auth.sql','4A30E92FF519BB41C520CDBF90019291217C26A2','RELEASED','2025-02-14 17:20:00',0);
+('2025_02_14_00_auth.sql','4A30E92FF519BB41C520CDBF90019291217C26A2','ARCHIVED','2025-02-14 17:20:00',0),
+('2025_10_21_00_auth.sql','1A221989F98337CB285B4328E791F5531CFD2454','ARCHIVED','2025-10-21 18:16:45',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2671,4 +2672,4 @@ SET character_set_client = @saved_cs_client;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2024-11-22 23:18:17
+-- Dump completed on 2025-10-21 18:16:58
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 65d3b736271..e4af5329b4e 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.40, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.43, for Linux (x86_64)
 --
 -- Host: localhost    Database: characters
 -- ------------------------------------------------------
--- Server version	8.0.40-0ubuntu0.22.04.1
+-- Server version	8.0.43-0ubuntu0.22.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -2691,8 +2691,9 @@ INSERT INTO `updates` VALUES
 ('2024_08_17_00_characters.sql','08705FBCB8504E8B1009FDAF955F56D734FAD782','ARCHIVED','2024-08-17 22:26:12',0),
 ('2024_10_03_00_characters.sql','408249A6992999A36EB94089D184972E8E0767A3','ARCHIVED','2024-10-03 11:10:18',0),
 ('2024_11_22_00_characters.sql','9EA2A4F88036D1D5F47EE8A6B634D52D0014986E','ARCHIVED','2024-11-22 23:18:14',0),
-('2025_07_20_00_characters_2022_07_03_00_characters.sql','D3F04078C0846BCF7C8330AC20C39B8C3AEE7002','RELEASED','2022-07-03 23:37:24',0),
-('2025_09_09_00_characters.sql','A1A793D656117C31DAA92653DF0BE4AE6354358A','RELEASED','2025-09-09 14:03:38',0);
+('2025_07_20_00_characters_2022_07_03_00_characters.sql','D3F04078C0846BCF7C8330AC20C39B8C3AEE7002','ARCHIVED','2022-07-03 23:37:24',0),
+('2025_09_09_00_characters.sql','A1A793D656117C31DAA92653DF0BE4AE6354358A','ARCHIVED','2025-09-09 14:03:38',0),
+('2025_10_21_00_characters.sql','DAC3249AE0CF374815D6A656489FE7B0AD3AA051','ARCHIVED','2025-10-21 18:16:45',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2863,4 +2864,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2024-11-22 23:18:18
+-- Dump completed on 2025-10-21 18:16:58
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 857872f96af..aad46131d63 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.40, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.43, for Linux (x86_64)
 --
 -- Host: localhost    Database: world
 -- ------------------------------------------------------
--- Server version	8.0.40-0ubuntu0.22.04.1
+-- Server version	8.0.43-0ubuntu0.22.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -384,11 +384,11 @@ DROP TABLE IF EXISTS `creature_classlevelstats`;
 CREATE TABLE `creature_classlevelstats` (
   `level` tinyint unsigned NOT NULL,
   `class` tinyint unsigned NOT NULL,
-  `basehp0` smallint unsigned NOT NULL DEFAULT '1',
-  `basehp1` smallint unsigned NOT NULL DEFAULT '1',
-  `basehp2` smallint unsigned NOT NULL DEFAULT '1',
-  `basemana` smallint unsigned NOT NULL DEFAULT '0',
-  `basearmor` smallint unsigned NOT NULL DEFAULT '1',
+  `basehp0` int unsigned NOT NULL DEFAULT '1',
+  `basehp1` int unsigned NOT NULL DEFAULT '1',
+  `basehp2` int unsigned NOT NULL DEFAULT '1',
+  `basemana` int unsigned NOT NULL DEFAULT '1',
+  `basearmor` int unsigned NOT NULL DEFAULT '1',
   `attackpower` smallint unsigned NOT NULL DEFAULT '0',
   `rangedattackpower` smallint unsigned NOT NULL DEFAULT '0',
   `damage_base` float NOT NULL DEFAULT '0',
@@ -1225,7 +1225,7 @@ CREATE TABLE `gameobject` (
   `animprogress` tinyint unsigned NOT NULL DEFAULT '0',
   `state` tinyint unsigned NOT NULL DEFAULT '0',
   `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
-  `StringId` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `StringId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`guid`)
 ) ENGINE=InnoDB AUTO_INCREMENT=2134507 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Gameobject System';
@@ -1347,33 +1347,33 @@ CREATE TABLE `gameobject_template` (
   `castBarCaption` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `unk1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `size` float NOT NULL DEFAULT '1',
-  `Data0` int unsigned NOT NULL DEFAULT '0',
+  `Data0` int NOT NULL DEFAULT '0',
   `Data1` int NOT NULL DEFAULT '0',
-  `Data2` int unsigned NOT NULL DEFAULT '0',
-  `Data3` int unsigned NOT NULL DEFAULT '0',
-  `Data4` int unsigned NOT NULL DEFAULT '0',
-  `Data5` int unsigned NOT NULL DEFAULT '0',
+  `Data2` int NOT NULL DEFAULT '0',
+  `Data3` int NOT NULL DEFAULT '0',
+  `Data4` int NOT NULL DEFAULT '0',
+  `Data5` int NOT NULL DEFAULT '0',
   `Data6` int NOT NULL DEFAULT '0',
-  `Data7` int unsigned NOT NULL DEFAULT '0',
-  `Data8` int unsigned NOT NULL DEFAULT '0',
-  `Data9` int unsigned NOT NULL DEFAULT '0',
-  `Data10` int unsigned NOT NULL DEFAULT '0',
-  `Data11` int unsigned NOT NULL DEFAULT '0',
-  `Data12` int unsigned NOT NULL DEFAULT '0',
-  `Data13` int unsigned NOT NULL DEFAULT '0',
-  `Data14` int unsigned NOT NULL DEFAULT '0',
-  `Data15` int unsigned NOT NULL DEFAULT '0',
-  `Data16` int unsigned NOT NULL DEFAULT '0',
-  `Data17` int unsigned NOT NULL DEFAULT '0',
-  `Data18` int unsigned NOT NULL DEFAULT '0',
-  `Data19` int unsigned NOT NULL DEFAULT '0',
-  `Data20` int unsigned NOT NULL DEFAULT '0',
-  `Data21` int unsigned NOT NULL DEFAULT '0',
-  `Data22` int unsigned NOT NULL DEFAULT '0',
-  `Data23` int unsigned NOT NULL DEFAULT '0',
+  `Data7` int NOT NULL DEFAULT '0',
+  `Data8` int NOT NULL DEFAULT '0',
+  `Data9` int NOT NULL DEFAULT '0',
+  `Data10` int NOT NULL DEFAULT '0',
+  `Data11` int NOT NULL DEFAULT '0',
+  `Data12` int NOT NULL DEFAULT '0',
+  `Data13` int NOT NULL DEFAULT '0',
+  `Data14` int NOT NULL DEFAULT '0',
+  `Data15` int NOT NULL DEFAULT '0',
+  `Data16` int NOT NULL DEFAULT '0',
+  `Data17` int NOT NULL DEFAULT '0',
+  `Data18` int NOT NULL DEFAULT '0',
+  `Data19` int NOT NULL DEFAULT '0',
+  `Data20` int NOT NULL DEFAULT '0',
+  `Data21` int NOT NULL DEFAULT '0',
+  `Data22` int NOT NULL DEFAULT '0',
+  `Data23` int NOT NULL DEFAULT '0',
   `AIName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
-  `StringId` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `StringId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`entry`),
   KEY `idx_name` (`name`)
@@ -2828,7 +2828,7 @@ CREATE TABLE `quest_template` (
   `RewardFactionValue5` int NOT NULL DEFAULT '0',
   `RewardFactionOverride5` int NOT NULL DEFAULT '0',
   `TimeAllowed` int unsigned NOT NULL DEFAULT '0',
-  `AllowableRaces` smallint unsigned NOT NULL DEFAULT '0',
+  `AllowableRaces` int unsigned NOT NULL DEFAULT '0',
   `LogTitle` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `LogDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `QuestDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
@@ -4071,4 +4071,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2024-11-22 23:18:19
+-- Dump completed on 2025-10-21 18:16:59