mount_template

-- mount
set @spellID = XXXXX;
set @Name = 'XXXXX';
set @Description = 'XXXXX';
set @SourceDescription = 'XXXXX';
set @MountTypeID = XXXXX;
set @MountID = XXXXX;
set @UiModelSceneID = XXXXX;

-- mount locale
set @Name_lang = 'XXXXX';
set @Description_lang = 'XXXXX';
set @SourceDescription_lang = 'XXXXX';

-- mount display
set @guidID = XXXXX; -- 3000
set @DisplayID = XXXXX;

-- mount_capability
set @RequiredRidingSkill = 75;

replace INTO `mount` (`SpellID`, `Name`, `Description`, `SourceDescription`, `CameraPivotMultiplier`, `MountTypeID`, `Flags`, `Source`, `ID`, `PlayerConditionId`, `UiModelSceneID`, `VerifiedBuild`) VALUES
(@spellID, @Name, @Description, @SourceDescription, '0', @MountTypeID, '0', 2, @MountID, '0', @UiModelSceneID, '1');

replace INTO `mount_locale` (`ID`, `locale`, `Name_lang`, `Description_lang`, `SourceDescription_lang`, `VerifiedBuild`) VALUES
(@MountID, 'ruRU', @Name_lang, @Description_lang, @SourceDescription_lang, '1');

replace INTO `mount_x_display` (`ID`, `MountID`, `DisplayID`, `PlayerConditionID`, `VerifiedBuild`) VALUES (@guidID, @MountID, @DisplayID, '0', '1');

replace INTO `mount_capability` (`RequiredSpell`, `SpeedModSpell`, `RequiredRidingSkill`, `RequiredArea`, `RequiredMap`, `Flags`, `ID`, `RequiredAura`, `VerifiedBuild`) VALUES
('0', '0', @RequiredRidingSkill, '0', '0', '0', @MountID, '0', '1');