-- Dragon Form: self-only permanent transform aura into a Black Dragon Whelp.
-- EffectMiscValue_1 is a creature_template entry (441, Black Dragon Whelp), not a raw display id --
-- AuraEffect::HandleAuraTransform resolves the display model from the creature template.
-- Toggle off via right-clicking the buff icon; mounting also cancels it (AuraInterruptFlags = mount).
-- EquippedItemClass must be -1 (no item requirement) -- the column's schema default is 0
-- (ITEM_CLASS_CONSUMABLE), which Player::HasItemFitToSpellRequirements doesn't handle for
-- non-weapon/armor classes and rejects with SPELL_FAILED_EQUIPPED_ITEM_CLASS, silently blocking
-- every cast (logged as "HasItemFitToSpellRequirements: Not handled spell requirement for item
-- class 0"). Found in-game 2026-08-14 testing .dragon-rawr.
DELETE FROM `spell_dbc` WHERE `ID` = 900000;
INSERT INTO `spell_dbc`
    (`ID`, `Attributes`, `CastingTimeIndex`, `RecoveryTime`, `AuraInterruptFlags`, `DurationIndex`, `RangeIndex`,
     `SchoolMask`, `Effect_1`, `ImplicitTargetA_1`, `EffectAura_1`, `EffectMiscValue_1`, `EquippedItemClass`, `Name_Lang_enUS`)
VALUES
    (900000, 0, 1, 1000, 131072, 21, 1, 1, 6, 1, 56, 441, -1, 'Dragon Form');

-- Whelp Breath: single-target fire bolt, gated in C++ (spell_dragon_legacy_whelp_breath) to require
-- SPELL_DRAGON_FORM (900000) to be active on the caster.
DELETE FROM `spell_dbc` WHERE `ID` = 900001;
INSERT INTO `spell_dbc`
    (`ID`, `Attributes`, `CastingTimeIndex`, `RecoveryTime`, `RangeIndex`, `SchoolMask`,
     `Effect_1`, `ImplicitTargetA_1`, `EffectBasePoints_1`, `EquippedItemClass`, `Name_Lang_enUS`)
VALUES
    (900001, 0, 1, 6000, 5, 4, 2, 6, 49, -1, 'Whelp Breath');

DELETE FROM `spell_script_names` WHERE `spell_id` = 900001;
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (900001, 'spell_dragon_legacy_whelp_breath');

-- Cleanup: spell 900002 ("Dragon Stance (test)") was a throwaway stance-bar experiment (see
-- PLAN.md "Stance bar experiment" -- rejected 2026-08-14, no bonus action bar appeared in-game).
-- No re-insert -- the ID is retired, not reused.
DELETE FROM `spell_dbc` WHERE `ID` = 900002;
