aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/auth_database.sql9
-rw-r--r--sql/base/characters_database.sql11
-rw-r--r--sql/base/dev/world_database.sql66
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