DROP TABLE IF EXISTS `spell_dbc`;
CREATE TABLE `spell_dbc` (
    `Id` INT UNSIGNED NOT NULL,
    `Dispel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `Mechanic` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `Attributes` INT UNSIGNED NOT NULL DEFAULT 0,
    `AttributesEx` INT UNSIGNED NOT NULL DEFAULT 0,
    `AttributesEx2` INT UNSIGNED NOT NULL DEFAULT 0,
    `AttributesEx3` INT UNSIGNED NOT NULL DEFAULT 0,
    `AttributesEx4` INT UNSIGNED NOT NULL DEFAULT 0,
    `AttributesEx5` INT UNSIGNED NOT NULL DEFAULT 0,
    `Targets` INT UNSIGNED NOT NULL DEFAULT 0,
    `CastingTimeIndex` TINYINT UNSIGNED NOT NULL DEFAULT 1,
    `AuraInterruptFlags` INT UNSIGNED NOT NULL DEFAULT 0,
    `ProcFlags` INT UNSIGNED NOT NULL DEFAULT 0,
    `ProcChance` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `ProcCharges` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `MaxLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `BaseLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `SpellLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `DurationIndex` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    `RangeIndex` TINYINT UNSIGNED NOT NULL DEFAULT 1,
    `StackAmount` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EquippedItemClass` INT NOT NULL DEFAULT -1,
    `EquippedItemSubClassMask` INT NOT NULL DEFAULT 0 DEFAULT 0,
    `EquippedItemInventoryTypeMask` INT NOT NULL DEFAULT 0 DEFAULT 0,
    `Effect1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `Effect2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `Effect3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectDieSides1` INT NOT NULL DEFAULT 0,
    `EffectDieSides2` INT NOT NULL DEFAULT 0,
    `EffectDieSides3` INT NOT NULL DEFAULT 0,
    `EffectBaseDice1` INT NOT NULL DEFAULT 0,
    `EffectBaseDice2` INT NOT NULL DEFAULT 0,
    `EffectBaseDice3` INT NOT NULL DEFAULT 0,
    `EffectDicePerLevel1` FLOAT NOT NULL DEFAULT 0,
    `EffectDicePerLevel2` FLOAT NOT NULL DEFAULT 0,
    `EffectDicePerLevel3` FLOAT NOT NULL DEFAULT 0,
    `EffectRealPointsPerLevel1` FLOAT NOT NULL DEFAULT 0,
    `EffectRealPointsPerLevel2` FLOAT NOT NULL DEFAULT 0,
    `EffectRealPointsPerLevel3` FLOAT NOT NULL DEFAULT 0,
    `EffectBasePoints1` INT NOT NULL DEFAULT 0,
    `EffectBasePoints2` INT NOT NULL DEFAULT 0,
    `EffectBasePoints3` INT NOT NULL DEFAULT 0,
    `EffectMechanic1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectMechanic2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectMechanic3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectImplicitTargetA1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectImplicitTargetA2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectImplicitTargetA3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectImplicitTargetB1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectImplicitTargetB2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectImplicitTargetB3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectRadiusIndex1` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectRadiusIndex2` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectRadiusIndex3` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectApplyAuraName1` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectApplyAuraName2` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectApplyAuraName3` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    `EffectAmplitude1` INT NOT NULL DEFAULT 0,
    `EffectAmplitude2` INT NOT NULL DEFAULT 0,
    `EffectAmplitude3` INT NOT NULL DEFAULT 0,
    `EffectMultipleValue1` FLOAT NOT NULL DEFAULT 0,
    `EffectMultipleValue2` FLOAT NOT NULL DEFAULT 0,
    `EffectMultipleValue3` FLOAT NOT NULL DEFAULT 0,
    `EffectMiscValue1` INT NOT NULL DEFAULT 0,
    `EffectMiscValue2` INT NOT NULL DEFAULT 0,
    `EffectMiscValue3` INT NOT NULL DEFAULT 0,
    `EffectMiscValueB1` INT NOT NULL DEFAULT 0,
    `EffectMiscValueB2` INT NOT NULL DEFAULT 0,
    `EffectMiscValueB3` INT NOT NULL DEFAULT 0,
    `EffectTriggerSpell1` INT UNSIGNED NOT NULL DEFAULT 0,
    `EffectTriggerSpell2` INT UNSIGNED NOT NULL DEFAULT 0,
    `EffectTriggerSpell3` INT UNSIGNED NOT NULL DEFAULT 0,
    `EffectSpellClassMaskA1` INT UNSIGNED NOT NULL DEFAULT 0,
    `EffectSpellClassMaskA2` INT UNSIGNED NOT NULL DEFAULT 0,
    `EffectSpellClassMaskA3` INT UNSIGNED NOT NULL DEFAULT 0,
    `EffectSpellClassMaskB1` INT UNSIGNED NOT NULL DEFAULT 0,
    `EffectSpellClassMaskB2` INT UNSIGNED NOT NULL DEFAULT 0,
    `EffectSpellClassMaskB3` INT UNSIGNED NOT NULL DEFAULT 0,
    `EffectSpellClassMaskC1` INT UNSIGNED NOT NULL DEFAULT 0,
    `EffectSpellClassMaskC2` INT UNSIGNED NOT NULL DEFAULT 0,
    `EffectSpellClassMaskC3` INT UNSIGNED NOT NULL DEFAULT 0,
    `MaxTargetLevel` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `SpellFamilyName` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `SpellFamilyFlags1` INT UNSIGNED NOT NULL DEFAULT 0,
    `SpellFamilyFlags2` INT UNSIGNED NOT NULL DEFAULT 0,
    `SpellFamilyFlags3` INT UNSIGNED NOT NULL DEFAULT 0,
    `MaxAffectedTargets` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `DmgClass` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `PreventionType` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `DmgMultiplier1` FLOAT NOT NULL DEFAULT 0,
    `DmgMultiplier2` FLOAT NOT NULL DEFAULT 0,
    `DmgMultiplier3` FLOAT NOT NULL DEFAULT 0,
    `AreaGroupId` INT NOT NULL DEFAULT 0,
    `SchoolMask` INT UNSIGNED NOT NULL DEFAULT 0,
    `Comment` TEXT NOT NULL,
    PRIMARY KEY (`id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom spell.dbc entries';

INSERT INTO `spell_dbc` (`Id`, `DurationIndex`, `Effect1`, `EffectImplicitTargetA1`, `EffectApplyAuraName1`, `Comment`) VALUES (62388, 21, 6, 1, 4, 'Demonic Circle: Teleport(48020) - casterAuraSpell');
