aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/auth_database.sql39
-rw-r--r--sql/base/characters_database.sql9
-rw-r--r--sql/base/dev/hotfixes_database.sql153
-rw-r--r--sql/base/dev/world_database.sql95
4 files changed, 219 insertions, 77 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 7035bcdc112..9cfd42b4ee4 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.41, for Linux (x86_64)
--
-- Host: localhost Database: auth
-- ------------------------------------------------------
--- Server version 8.0.40-0ubuntu0.22.04.1
+-- Server version 8.0.41-0ubuntu0.22.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -428,7 +428,7 @@ CREATE TABLE `battlenet_account_warband_scenes` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Dumping data for table `battlenet_account_transmog_illusions`
+-- Dumping data for table `battlenet_account_warband_scenes`
--
LOCK TABLES `battlenet_account_warband_scenes` WRITE;
@@ -3508,21 +3508,22 @@ INSERT INTO `updates` VALUES
('2024_12_19_00_auth.sql','B01D54F8420CF680F0DDA903210028F0174E310D','ARCHIVED','2024-12-19 11:32:53',0),
('2024_12_21_00_auth.sql','9DA5E7911D231D46FE9630D20BDD4AEA0B3CF650','ARCHIVED','2024-12-21 01:03:37',0),
('2024_12_22_00_auth.sql','6FDF0ABE9952CC96BE04A6BAA0F1161900B4AB88','ARCHIVED','2024-12-22 02:56:17',0),
-('2025_01_11_00_auth.sql','B32F963095657E8877F3C1EEBB09C8AED55EEECC','RELEASED','2025-01-11 10:51:47',0),
-('2025_01_15_00_auth.sql','8EA1C0A88F6F1EC3DA67DA01CDCF056A530DBB5F','RELEASED','2025-01-15 00:44:53',0),
-('2025_01_15_01_auth.sql','885A553B190CCD7A22791AF4EC3BC15C43DDC2D2','RELEASED','2025-01-15 10:27:39',0),
-('2025_01_22_00_auth.sql','E08C40B02DB391DC1A478B6C714FDDDDB144F24F','RELEASED','2025-01-22 20:58:45',0),
-('2025_01_29_00_auth.sql','7334CFE779D5F79AFAC8EA269950FC07E625810F','RELEASED','2025-01-29 12:57:32',0),
-('2025_01_31_00_auth.sql','DF2640D25C15E41358C1ED46B4F86043583FC8FB','RELEASED','2025-01-31 11:51:23',0),
-('2025_02_03_00_auth.sql','87033116EF72051499AF23FE14545D828F5A9B59','RELEASED','2025-02-03 22:51:31',0),
-('2025_02_19_00_auth.sql','6D0EBB3E2DD1B26682A424EDDC090F515BCA5B32','RELEASED','2025-02-19 00:16:52',0),
-('2025_02_21_00_auth.sql','E9EA49CEB396561D641A7C82251DCBF9DF3E9983','RELEASED','2025-02-21 00:53:17',0),
-('2025_03_02_00_auth.sql','1CEAB7B308823D5FAA51360A1B2A7CA0E89A6081','RELEASED','2025-03-02 14:50:10',0),
-('2025_03_04_00_auth.sql','AB20016BC7251E6DE80E2AC658F18F6076EA81AA','RELEASED','2025-03-04 20:01:43',0),
-('2025_03_05_00_auth.sql','25DA7985BDEA177E1AE7C8DC82063D1C11F7BF92','RELEASED','2025-03-05 11:20:32',0),
-('2025_03_08_00_auth.sql','DA9CEE1C87F8A1CF7FFDF684FD7DDFCC7B04D5AE','RELEASED','2025-03-08 01:37:14',0),
-('2025_03_13_00_auth.sql','942D432EBC68783F76FF3A3CBE6F1FAF32121D18','RELEASED','2025-03-13 19:58:25',0),
-('2025_03_26_00_auth.sql','AACB673BEED68EADC53D121E107E1C780DFE0B88','RELEASED','2025-03-26 10:32:59',0);
+('2025_01_11_00_auth.sql','B32F963095657E8877F3C1EEBB09C8AED55EEECC','ARCHIVED','2025-01-11 10:51:47',0),
+('2025_01_15_00_auth.sql','8EA1C0A88F6F1EC3DA67DA01CDCF056A530DBB5F','ARCHIVED','2025-01-15 00:44:53',0),
+('2025_01_15_01_auth.sql','885A553B190CCD7A22791AF4EC3BC15C43DDC2D2','ARCHIVED','2025-01-15 10:27:39',0),
+('2025_01_22_00_auth.sql','E08C40B02DB391DC1A478B6C714FDDDDB144F24F','ARCHIVED','2025-01-22 20:58:45',0),
+('2025_01_29_00_auth.sql','7334CFE779D5F79AFAC8EA269950FC07E625810F','ARCHIVED','2025-01-29 12:57:32',0),
+('2025_01_31_00_auth.sql','DF2640D25C15E41358C1ED46B4F86043583FC8FB','ARCHIVED','2025-01-31 11:51:23',0),
+('2025_02_03_00_auth.sql','87033116EF72051499AF23FE14545D828F5A9B59','ARCHIVED','2025-02-03 22:51:31',0),
+('2025_02_19_00_auth.sql','6D0EBB3E2DD1B26682A424EDDC090F515BCA5B32','ARCHIVED','2025-02-19 00:16:52',0),
+('2025_02_21_00_auth.sql','E9EA49CEB396561D641A7C82251DCBF9DF3E9983','ARCHIVED','2025-02-21 00:53:17',0),
+('2025_03_02_00_auth.sql','1CEAB7B308823D5FAA51360A1B2A7CA0E89A6081','ARCHIVED','2025-03-02 14:50:10',0),
+('2025_03_04_00_auth.sql','AB20016BC7251E6DE80E2AC658F18F6076EA81AA','ARCHIVED','2025-03-04 20:01:43',0),
+('2025_03_05_00_auth.sql','25DA7985BDEA177E1AE7C8DC82063D1C11F7BF92','ARCHIVED','2025-03-05 11:20:32',0),
+('2025_03_08_00_auth.sql','DA9CEE1C87F8A1CF7FFDF684FD7DDFCC7B04D5AE','ARCHIVED','2025-03-08 01:37:14',0),
+('2025_03_13_00_auth.sql','942D432EBC68783F76FF3A3CBE6F1FAF32121D18','ARCHIVED','2025-03-13 19:58:25',0),
+('2025_03_26_00_auth.sql','AACB673BEED68EADC53D121E107E1C780DFE0B88','ARCHIVED','2025-03-26 10:32:59',0),
+('2025_03_29_00_auth.sql','AB55F260FB970455392E1FD4D760965EE48F7074','ARCHIVED','2025-03-29 01:12:13',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3666,4 +3667,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-12-22 2:56:19
+-- Dump completed on 2025-03-29 1:12:15
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 11bd9f0a13b..11ca327e935 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.41, for Linux (x86_64)
--
-- Host: localhost Database: characters
-- ------------------------------------------------------
--- Server version 8.0.40-0ubuntu0.22.04.1
+-- Server version 8.0.41-0ubuntu0.22.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -3779,7 +3779,8 @@ INSERT INTO `updates` VALUES
('2024_11_16_00_characters.sql','9D9D87FB8DEB99F074EB499A5BD230FD9C993669','ARCHIVED','2024-11-16 21:57:39',0),
('2024_12_13_00_characters.sql','4A00C51BA33639F5555AAE40EC672AE47126F7B6','ARCHIVED','2024-12-13 00:17:03',0),
('2024_12_22_00_characters.sql','A2F24564430C5BCC96C279E843FA3548B1F831EE','ARCHIVED','2024-12-22 02:56:17',0),
-('2025_01_04_00_characters.sql','403E8B642A67765A04A0A4D5BC0752288208079C','RELEASED','2025-01-04 16:31:39',0);
+('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);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3907,4 +3908,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2024-12-22 2:56:19
+-- Dump completed on 2025-03-29 1:12:15
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index 9221f7828ed..561981e3ea2 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_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.41, for Linux (x86_64)
--
-- Host: localhost Database: hotfixes
-- ------------------------------------------------------
--- Server version 8.0.40-0ubuntu0.22.04.1
+-- Server version 8.0.41-0ubuntu0.22.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -983,7 +983,7 @@ CREATE TABLE `azerite_power_set_member` (
`ID` int unsigned NOT NULL DEFAULT '0',
`AzeritePowerSetID` int unsigned NOT NULL DEFAULT '0',
`AzeritePowerID` int NOT NULL DEFAULT '0',
- `Class` int NOT NULL DEFAULT '0',
+ `Class` tinyint NOT NULL DEFAULT '0',
`Tier` tinyint unsigned NOT NULL DEFAULT '0',
`OrderIndex` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -1088,8 +1088,8 @@ CREATE TABLE `barber_shop_style` (
`Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Type` tinyint unsigned NOT NULL DEFAULT '0',
`CostModifier` float NOT NULL DEFAULT '0',
- `Race` tinyint unsigned NOT NULL DEFAULT '0',
- `Sex` tinyint unsigned NOT NULL DEFAULT '0',
+ `Race` tinyint NOT NULL DEFAULT '0',
+ `Sex` tinyint NOT NULL DEFAULT '0',
`Data` tinyint unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -1507,6 +1507,7 @@ CREATE TABLE `challenge_mode_item_bonus_override` (
`DstItemBonusTreeID` int NOT NULL DEFAULT '0',
`Value` int NOT NULL DEFAULT '0',
`RequiredTimeEventPassed` int NOT NULL DEFAULT '0',
+ `RequiredTimeEventNotPassed` int NOT NULL DEFAULT '0',
`SrcItemBonusTreeID` int unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -1524,7 +1525,7 @@ CREATE TABLE `char_base_info` (
`ID` int unsigned NOT NULL DEFAULT '0',
`RaceID` tinyint NOT NULL DEFAULT '0',
`ClassID` tinyint NOT NULL DEFAULT '0',
- `OtherFactionRaceID` int NOT NULL DEFAULT '0',
+ `OtherFactionRaceID` tinyint NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1622,7 +1623,7 @@ CREATE TABLE `chat_channels` (
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Shortcut` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Flags` int NOT NULL DEFAULT '0',
- `FactionGroup` tinyint NOT NULL DEFAULT '0',
+ `FactionGroup` tinyint unsigned NOT NULL DEFAULT '0',
`Ruleset` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -1666,7 +1667,7 @@ DROP TABLE IF EXISTS `chr_class_ui_display`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `chr_class_ui_display` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `ChrClassesID` tinyint unsigned NOT NULL DEFAULT '0',
+ `ChrClassesID` tinyint NOT NULL DEFAULT '0',
`AdvGuidePlayerConditionID` int unsigned NOT NULL DEFAULT '0',
`SplashPlayerConditionID` int unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -1692,7 +1693,6 @@ CREATE TABLE `chr_classes` (
`DisabledString` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`HyphenatedNameMale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`HyphenatedNameFemale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
- `ID` int unsigned NOT NULL DEFAULT '0',
`CreateScreenFileDataID` int unsigned NOT NULL DEFAULT '0',
`SelectScreenFileDataID` int unsigned NOT NULL DEFAULT '0',
`IconFileDataID` int unsigned NOT NULL DEFAULT '0',
@@ -1711,6 +1711,7 @@ CREATE TABLE `chr_classes` (
`CharacterCreationAnimLoopWaitTimeMsFallback` int NOT NULL DEFAULT '0',
`CinematicSequenceID` smallint unsigned NOT NULL DEFAULT '0',
`DefaultSpec` smallint unsigned NOT NULL DEFAULT '0',
+ `ID` tinyint unsigned NOT NULL DEFAULT '0',
`PrimaryStatPriority` tinyint unsigned NOT NULL DEFAULT '0',
`DisplayPower` tinyint NOT NULL DEFAULT '0',
`RangedAttackPowerPerAgility` tinyint unsigned NOT NULL DEFAULT '0',
@@ -1940,6 +1941,7 @@ CREATE TABLE `chr_customization_req` (
`ReqSource` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Flags` int NOT NULL DEFAULT '0',
`ClassMask` int NOT NULL DEFAULT '0',
+ `RegionGroupMask` int NOT NULL DEFAULT '0',
`AchievementID` int NOT NULL DEFAULT '0',
`QuestID` int NOT NULL DEFAULT '0',
`OverrideArchive` int NOT NULL DEFAULT '0',
@@ -2035,9 +2037,9 @@ DROP TABLE IF EXISTS `chr_race_x_chr_model`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `chr_race_x_chr_model` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `ChrRacesID` int unsigned NOT NULL DEFAULT '0',
+ `ChrRacesID` tinyint unsigned NOT NULL DEFAULT '0',
`ChrModelID` int NOT NULL DEFAULT '0',
- `Sex` int NOT NULL DEFAULT '0',
+ `Sex` tinyint NOT NULL DEFAULT '0',
`AllowedTransmogSlots` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -2073,13 +2075,8 @@ CREATE TABLE `chr_races` (
`CinematicSequenceID` int NOT NULL DEFAULT '0',
`ResSicknessSpellID` int NOT NULL DEFAULT '0',
`SplashSoundID` int NOT NULL DEFAULT '0',
- `Alliance` int NOT NULL DEFAULT '0',
- `RaceRelated` int NOT NULL DEFAULT '0',
- `UnalteredVisualRaceID` int NOT NULL DEFAULT '0',
- `DefaultClassID` int NOT NULL DEFAULT '0',
`CreateScreenFileDataID` int NOT NULL DEFAULT '0',
`SelectScreenFileDataID` int NOT NULL DEFAULT '0',
- `NeutralRaceID` int NOT NULL DEFAULT '0',
`LowResScreenFileDataID` int NOT NULL DEFAULT '0',
`AlteredFormStartVisualKitID1` int NOT NULL DEFAULT '0',
`AlteredFormStartVisualKitID2` int NOT NULL DEFAULT '0',
@@ -2090,14 +2087,8 @@ CREATE TABLE `chr_races` (
`HeritageArmorAchievementID` int NOT NULL DEFAULT '0',
`StartingLevel` int NOT NULL DEFAULT '0',
`UiDisplayOrder` int NOT NULL DEFAULT '0',
- `MaleModelFallbackRaceID` int NOT NULL DEFAULT '0',
- `FemaleModelFallbackRaceID` int NOT NULL DEFAULT '0',
- `MaleTextureFallbackRaceID` int NOT NULL DEFAULT '0',
- `FemaleTextureFallbackRaceID` int NOT NULL DEFAULT '0',
`PlayableRaceBit` int NOT NULL DEFAULT '0',
- `HelmetAnimScalingRaceID` int NOT NULL DEFAULT '0',
`TransmogrifyDisabledSlotMask` int NOT NULL DEFAULT '0',
- `UnalteredVisualCustomizationRaceID` int NOT NULL DEFAULT '0',
`AlteredFormCustomizeOffsetFallback1` float NOT NULL DEFAULT '0',
`AlteredFormCustomizeOffsetFallback2` float NOT NULL DEFAULT '0',
`AlteredFormCustomizeOffsetFallback3` float NOT NULL DEFAULT '0',
@@ -2108,13 +2099,23 @@ CREATE TABLE `chr_races` (
`Unknown910_21` float NOT NULL DEFAULT '0',
`Unknown910_22` float NOT NULL DEFAULT '0',
`Unknown910_23` float NOT NULL DEFAULT '0',
- `Unknown1000` int NOT NULL DEFAULT '0',
`BaseLanguage` tinyint NOT NULL DEFAULT '0',
- `CreatureType` tinyint NOT NULL DEFAULT '0',
+ `CreatureType` tinyint unsigned NOT NULL DEFAULT '0',
+ `Alliance` tinyint NOT NULL DEFAULT '0',
+ `RaceRelated` tinyint NOT NULL DEFAULT '0',
+ `UnalteredVisualRaceID` tinyint NOT NULL DEFAULT '0',
+ `DefaultClassID` tinyint NOT NULL DEFAULT '0',
+ `NeutralRaceID` tinyint NOT NULL DEFAULT '0',
+ `MaleModelFallbackRaceID` tinyint NOT NULL DEFAULT '0',
`MaleModelFallbackSex` tinyint NOT NULL DEFAULT '0',
+ `FemaleModelFallbackRaceID` tinyint NOT NULL DEFAULT '0',
`FemaleModelFallbackSex` tinyint NOT NULL DEFAULT '0',
+ `MaleTextureFallbackRaceID` tinyint NOT NULL DEFAULT '0',
`MaleTextureFallbackSex` tinyint NOT NULL DEFAULT '0',
+ `FemaleTextureFallbackRaceID` tinyint NOT NULL DEFAULT '0',
`FemaleTextureFallbackSex` tinyint NOT NULL DEFAULT '0',
+ `HelmetAnimScalingRaceID` tinyint NOT NULL DEFAULT '0',
+ `UnalteredVisualCustomizationRaceID` tinyint NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2515,7 +2516,7 @@ CREATE TABLE `creature_display_info_extra` (
`DisplayRaceID` tinyint NOT NULL DEFAULT '0',
`DisplaySexID` tinyint NOT NULL DEFAULT '0',
`DisplayClassID` tinyint NOT NULL DEFAULT '0',
- `Flags` tinyint NOT NULL DEFAULT '0',
+ `Flags` int NOT NULL DEFAULT '0',
`BakeMaterialResourcesID` int NOT NULL DEFAULT '0',
`HDBakeMaterialResourcesID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -2654,7 +2655,7 @@ DROP TABLE IF EXISTS `creature_type`;
CREATE TABLE `creature_type` (
`ID` int unsigned NOT NULL DEFAULT '0',
`Name` 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;
@@ -2836,6 +2837,7 @@ CREATE TABLE `currency_types` (
`RechargingAmountPerCycle` int unsigned NOT NULL DEFAULT '0',
`RechargingCycleDurationMS` int unsigned NOT NULL DEFAULT '0',
`AccountTransferPercentage` float NOT NULL DEFAULT '0',
+ `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0',
`Flags1` int NOT NULL DEFAULT '0',
`Flags2` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -3154,9 +3156,9 @@ DROP TABLE IF EXISTS `emotes_text_sound`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `emotes_text_sound` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `RaceID` tinyint unsigned NOT NULL DEFAULT '0',
- `ClassID` tinyint unsigned NOT NULL DEFAULT '0',
- `SexID` tinyint unsigned NOT NULL DEFAULT '0',
+ `RaceID` tinyint NOT NULL DEFAULT '0',
+ `ClassID` tinyint NOT NULL DEFAULT '0',
+ `SexID` tinyint NOT NULL DEFAULT '0',
`SoundID` int unsigned NOT NULL DEFAULT '0',
`EmotesTextID` int unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -3808,7 +3810,7 @@ CREATE TABLE `garr_follower` (
`AllySlottingBroadcastTextID` int unsigned NOT NULL DEFAULT '0',
`ChrClassID` tinyint unsigned NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
- `Gender` tinyint unsigned NOT NULL DEFAULT '0',
+ `Gender` tinyint NOT NULL DEFAULT '0',
`AutoCombatantID` int NOT NULL DEFAULT '0',
`CovenantID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -4195,6 +4197,7 @@ CREATE TABLE `gossip_npc_option` (
`TraitTreeID` int NOT NULL DEFAULT '0',
`ProfessionID` int NOT NULL DEFAULT '0',
`Unknown_1002_14` int NOT NULL DEFAULT '0',
+ `SkillLineID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -5498,7 +5501,7 @@ CREATE TABLE `item_sparse` (
`DamageDamageType` tinyint unsigned NOT NULL DEFAULT '0',
`ContainerSlots` tinyint unsigned NOT NULL DEFAULT '0',
`RequiredPVPMedal` tinyint unsigned NOT NULL DEFAULT '0',
- `RequiredPVPRank` tinyint unsigned NOT NULL DEFAULT '0',
+ `RequiredPVPRank` tinyint NOT NULL DEFAULT '0',
`RequiredLevel` tinyint NOT NULL DEFAULT '0',
`InventoryType` tinyint NOT NULL DEFAULT '0',
`OverallQualityID` tinyint NOT NULL DEFAULT '0',
@@ -5735,6 +5738,7 @@ CREATE TABLE `journal_instance` (
`LoreFileDataID` int NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
`AreaID` smallint unsigned NOT NULL DEFAULT '0',
+ `CovenantID` smallint unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6085,7 +6089,7 @@ CREATE TABLE `liquid_type` (
`Texture4` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Texture5` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`Texture6` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
- `Flags` smallint unsigned NOT NULL DEFAULT '0',
+ `Flags` int NOT NULL DEFAULT '0',
`SoundBank` tinyint unsigned NOT NULL DEFAULT '0',
`SoundID` int unsigned NOT NULL DEFAULT '0',
`SpellID` int unsigned NOT NULL DEFAULT '0',
@@ -6547,6 +6551,7 @@ CREATE TABLE `mount_capability` (
`ReqMapID` smallint NOT NULL DEFAULT '0',
`PlayerConditionID` int NOT NULL DEFAULT '0',
`FlightCapabilityID` int NOT NULL DEFAULT '0',
+ `DriveCapabilityID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6681,8 +6686,8 @@ DROP TABLE IF EXISTS `name_gen`;
CREATE TABLE `name_gen` (
`ID` int unsigned NOT NULL DEFAULT '0',
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
- `RaceID` tinyint unsigned NOT NULL DEFAULT '0',
- `Sex` tinyint unsigned NOT NULL DEFAULT '0',
+ `RaceID` tinyint NOT NULL DEFAULT '0',
+ `Sex` tinyint NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6810,7 +6815,7 @@ CREATE TABLE `path` (
`Green` tinyint unsigned NOT NULL DEFAULT '0',
`Blue` tinyint unsigned NOT NULL DEFAULT '0',
`Alpha` tinyint 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;
@@ -6914,7 +6919,7 @@ CREATE TABLE `player_condition` (
`WorldStateExpressionID` smallint unsigned NOT NULL DEFAULT '0',
`WeatherID` int NOT NULL DEFAULT '0',
`PartyStatus` tinyint unsigned NOT NULL DEFAULT '0',
- `LifetimeMaxPVPRank` tinyint unsigned NOT NULL DEFAULT '0',
+ `LifetimeMaxPVPRank` tinyint NOT NULL DEFAULT '0',
`AchievementLogic` int unsigned NOT NULL DEFAULT '0',
`Gender` tinyint NOT NULL DEFAULT '0',
`NativeGender` tinyint NOT NULL DEFAULT '0',
@@ -6944,8 +6949,8 @@ CREATE TABLE `player_condition` (
`MinGuildLevel` tinyint unsigned NOT NULL DEFAULT '0',
`MaxExpansionTier` tinyint NOT NULL DEFAULT '0',
`MinExpansionTier` tinyint NOT NULL DEFAULT '0',
- `MinPVPRank` tinyint unsigned NOT NULL DEFAULT '0',
- `MaxPVPRank` tinyint unsigned NOT NULL DEFAULT '0',
+ `MinPVPRank` tinyint NOT NULL DEFAULT '0',
+ `MaxPVPRank` tinyint NOT NULL DEFAULT '0',
`ContentTuningID` int NOT NULL DEFAULT '0',
`CovenantID` int NOT NULL DEFAULT '0',
`TraitNodeEntryLogic` int unsigned NOT NULL DEFAULT '0',
@@ -7482,6 +7487,7 @@ CREATE TABLE `quest_line_x_quest` (
`QuestID` int unsigned NOT NULL DEFAULT '0',
`OrderIndex` int unsigned NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
+ `Unknown1110` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -9097,7 +9103,7 @@ CREATE TABLE `spell_shapeshift_form` (
`ID` int unsigned NOT NULL DEFAULT '0',
`Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`CreatureDisplayID` int unsigned NOT NULL DEFAULT '0',
- `CreatureType` tinyint NOT NULL DEFAULT '0',
+ `CreatureType` tinyint unsigned NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
`AttackIconFileID` int NOT NULL DEFAULT '0',
`BonusActionBar` tinyint NOT NULL DEFAULT '0',
@@ -9394,7 +9400,7 @@ CREATE TABLE `talent` (
`TierID` tinyint unsigned NOT NULL DEFAULT '0',
`Flags` tinyint unsigned NOT NULL DEFAULT '0',
`ColumnIndex` tinyint unsigned NOT NULL DEFAULT '0',
- `ClassID` tinyint unsigned NOT NULL DEFAULT '0',
+ `ClassID` tinyint NOT NULL DEFAULT '0',
`SpecID` smallint unsigned NOT NULL DEFAULT '0',
`SpellID` int unsigned NOT NULL DEFAULT '0',
`OverridesSpellID` int unsigned NOT NULL DEFAULT '0',
@@ -10830,6 +10836,67 @@ CREATE TABLE `vignette_locale` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `warband_scene`
+--
+
+DROP TABLE IF EXISTS `warband_scene`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `warband_scene` (
+ `Name` text COLLATE utf8mb4_unicode_ci,
+ `Description` text COLLATE utf8mb4_unicode_ci,
+ `Source` text COLLATE utf8mb4_unicode_ci,
+ `PositionX` float NOT NULL DEFAULT '0',
+ `PositionY` float NOT NULL DEFAULT '0',
+ `PositionZ` float NOT NULL DEFAULT '0',
+ `LookAtX` float NOT NULL DEFAULT '0',
+ `LookAtY` float NOT NULL DEFAULT '0',
+ `LookAtZ` float NOT NULL DEFAULT '0',
+ `ID` int unsigned NOT NULL DEFAULT '0',
+ `MapID` int unsigned NOT NULL DEFAULT '0',
+ `Fov` float NOT NULL DEFAULT '0',
+ `TimeOfDay` int NOT NULL DEFAULT '0',
+ `Flags` int NOT NULL DEFAULT '0',
+ `SoundAmbienceID` int NOT NULL DEFAULT '0',
+ `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;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `warband_scene_locale`
+--
+
+DROP TABLE IF EXISTS `warband_scene_locale`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `warband_scene_locale` (
+ `ID` int unsigned NOT NULL DEFAULT '0',
+ `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+ `Name_lang` text COLLATE utf8mb4_unicode_ci,
+ `Description_lang` text COLLATE utf8mb4_unicode_ci,
+ `Source_lang` text COLLATE utf8mb4_unicode_ci,
+ `VerifiedBuild` int NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+/*!50500 PARTITION BY LIST COLUMNS(locale)
+(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB,
+ PARTITION esES VALUES IN ('esES') ENGINE = InnoDB,
+ PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB,
+ PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB,
+ PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB,
+ PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB,
+ PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB,
+ PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB,
+ PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB,
+ PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `wmo_area_table`
--
@@ -10894,7 +10961,7 @@ DROP TABLE IF EXISTS `world_effect`;
CREATE TABLE `world_effect` (
`ID` int unsigned NOT NULL DEFAULT '0',
`QuestFeedbackEffectID` int unsigned NOT NULL DEFAULT '0',
- `WhenToDisplay` tinyint unsigned NOT NULL DEFAULT '0',
+ `WhenToDisplay` int NOT NULL DEFAULT '0',
`TargetType` tinyint unsigned NOT NULL DEFAULT '0',
`TargetAsset` int NOT NULL DEFAULT '0',
`PlayerConditionID` int unsigned NOT NULL DEFAULT '0',
@@ -10923,7 +10990,7 @@ CREATE TABLE `world_map_overlay` (
`HitRectLeft` int NOT NULL DEFAULT '0',
`HitRectRight` int NOT NULL DEFAULT '0',
`PlayerConditionID` int unsigned NOT NULL DEFAULT '0',
- `Flags` int unsigned NOT NULL DEFAULT '0',
+ `Flags` int NOT NULL DEFAULT '0',
`AreaID1` int unsigned NOT NULL DEFAULT '0',
`AreaID2` int unsigned NOT NULL DEFAULT '0',
`AreaID3` int unsigned NOT NULL DEFAULT '0',
@@ -10961,4 +11028,4 @@ CREATE TABLE `world_state_expression` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2024-12-22 2:56:24
+-- Dump completed on 2025-03-29 1:12:19
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 8d4788433f2..5d6d7058a83 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.41, for Linux (x86_64)
--
-- Host: localhost Database: world
-- ------------------------------------------------------
--- Server version 8.0.40-0ubuntu0.22.04.1
+-- Server version 8.0.41-0ubuntu0.22.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -155,8 +155,8 @@ CREATE TABLE `areatrigger_create_properties` (
`AnimKitId` int NOT NULL DEFAULT '0',
`DecalPropertiesId` int unsigned NOT NULL DEFAULT '0',
`SpellForVisuals` int DEFAULT NULL,
- `TimeToTarget` int unsigned NOT NULL DEFAULT '0',
`TimeToTargetScale` int unsigned NOT NULL DEFAULT '0',
+ `Speed` float NOT NULL DEFAULT '1',
`Shape` tinyint unsigned NOT NULL DEFAULT '0',
`ShapeData0` float NOT NULL DEFAULT '0',
`ShapeData1` float NOT NULL DEFAULT '0',
@@ -1810,7 +1810,7 @@ CREATE TABLE `gameobject_template` (
`entry` int unsigned NOT NULL DEFAULT '0',
`type` tinyint unsigned NOT NULL DEFAULT '0',
`displayId` int unsigned NOT NULL DEFAULT '0',
- `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`IconName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`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 '',
@@ -1992,7 +1992,7 @@ CREATE TABLE `gossip_menu_option` (
`ActionPoiID` int unsigned NOT NULL DEFAULT '0',
`GossipNpcOptionID` int DEFAULT NULL,
`BoxCoded` tinyint unsigned NOT NULL DEFAULT '0',
- `BoxMoney` int unsigned NOT NULL DEFAULT '0',
+ `BoxMoney` bigint unsigned NOT NULL DEFAULT '0',
`BoxText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`BoxBroadcastTextID` int unsigned NOT NULL DEFAULT '0',
`SpellID` int DEFAULT NULL,
@@ -2529,10 +2529,10 @@ DROP TABLE IF EXISTS `player_classlevelstats`;
CREATE TABLE `player_classlevelstats` (
`class` tinyint unsigned NOT NULL,
`level` tinyint unsigned NOT NULL,
- `str` smallint unsigned NOT NULL COMMENT 'strength',
- `agi` smallint unsigned NOT NULL COMMENT 'agility',
- `sta` smallint unsigned NOT NULL COMMENT 'stamina',
- `inte` smallint unsigned NOT NULL COMMENT 'intellect',
+ `str` int NOT NULL COMMENT 'strength',
+ `agi` int NOT NULL COMMENT 'agility',
+ `sta` int NOT NULL COMMENT 'stamina',
+ `inte` int NOT NULL COMMENT 'intellect',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`class`,`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Stores levels stats.';
@@ -3881,6 +3881,7 @@ CREATE TABLE `serverside_spell` (
`AttributesEx12` int unsigned NOT NULL DEFAULT '0',
`AttributesEx13` int unsigned NOT NULL DEFAULT '0',
`AttributesEx14` int unsigned NOT NULL DEFAULT '0',
+ `AttributesEx15` int unsigned NOT NULL DEFAULT '0',
`Stances` bigint unsigned NOT NULL DEFAULT '0',
`StancesNot` bigint unsigned NOT NULL DEFAULT '0',
`Targets` int unsigned NOT NULL DEFAULT '0',
@@ -4183,6 +4184,75 @@ CREATE TABLE `spawn_group_template` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `spawn_tracking`
+--
+
+DROP TABLE IF EXISTS `spawn_tracking`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `spawn_tracking` (
+ `SpawnTrackingId` int unsigned NOT NULL,
+ `SpawnType` tinyint unsigned NOT NULL,
+ `SpawnId` bigint unsigned NOT NULL,
+ `QuestObjectiveId` int unsigned NOT NULL,
+ PRIMARY KEY (`SpawnTrackingId`,`SpawnType`,`SpawnId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `spawn_tracking_quest_objective`
+--
+
+DROP TABLE IF EXISTS `spawn_tracking_quest_objective`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `spawn_tracking_quest_objective` (
+ `SpawnTrackingId` int unsigned NOT NULL,
+ `QuestObjectiveId` int unsigned NOT NULL,
+ `VerifiedBuild` int NOT NULL DEFAULT '0',
+ PRIMARY KEY (`SpawnTrackingId`,`QuestObjectiveId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `spawn_tracking_state`
+--
+
+DROP TABLE IF EXISTS `spawn_tracking_state`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `spawn_tracking_state` (
+ `SpawnType` tinyint unsigned NOT NULL,
+ `SpawnId` bigint unsigned NOT NULL,
+ `State` tinyint unsigned NOT NULL DEFAULT '0',
+ `Visible` tinyint unsigned NOT NULL DEFAULT '1',
+ `StateSpellVisualId` int unsigned DEFAULT NULL,
+ `StateAnimId` smallint unsigned DEFAULT NULL,
+ `StateAnimKitId` smallint unsigned DEFAULT NULL,
+ `StateWorldEffects` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ PRIMARY KEY (`SpawnType`,`SpawnId`,`State`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `spawn_tracking_template`
+--
+
+DROP TABLE IF EXISTS `spawn_tracking_template`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `spawn_tracking_template` (
+ `SpawnTrackingId` int unsigned NOT NULL,
+ `MapId` smallint unsigned NOT NULL DEFAULT '0',
+ `PhaseId` int NOT NULL DEFAULT '0',
+ `PhaseGroup` int NOT NULL DEFAULT '0',
+ `PhaseUseFlags` tinyint unsigned NOT NULL DEFAULT '0',
+ `VerifiedBuild` int NOT NULL DEFAULT '0',
+ PRIMARY KEY (`SpawnTrackingId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `spell_area`
--
@@ -4423,13 +4493,14 @@ DROP TABLE IF EXISTS `spell_target_position`;
CREATE TABLE `spell_target_position` (
`ID` int unsigned NOT NULL DEFAULT '0',
`EffectIndex` tinyint unsigned NOT NULL DEFAULT '0',
+ `OrderIndex` int NOT NULL DEFAULT '0',
`MapID` smallint unsigned NOT NULL DEFAULT '0',
`PositionX` float NOT NULL DEFAULT '0',
`PositionY` float NOT NULL DEFAULT '0',
`PositionZ` float NOT NULL DEFAULT '0',
`Orientation` float DEFAULT NULL,
`VerifiedBuild` int NOT NULL DEFAULT '0',
- PRIMARY KEY (`ID`,`EffectIndex`)
+ PRIMARY KEY (`ID`,`EffectIndex`,`OrderIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -4666,6 +4737,7 @@ CREATE TABLE `vehicle_accessory` (
`description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`summontype` tinyint unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType',
`summontimer` int unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes',
+ `RideSpellID` int DEFAULT NULL,
PRIMARY KEY (`guid`,`seat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -4718,6 +4790,7 @@ CREATE TABLE `vehicle_template_accessory` (
`description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`summontype` tinyint unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType',
`summontimer` int unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes',
+ `RideSpellID` int DEFAULT NULL,
PRIMARY KEY (`entry`,`seat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -4983,4 +5056,4 @@ CREATE TABLE `world_state` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2024-12-22 2:56:21
+-- Dump completed on 2025-03-29 1:12:17