spell_dbc

The `spell_dbc` table

This table contains data regarding serverside spells which are not to be found in Client DBC files.

Note: Not longer used since Warlords of Draenor Expansion (see Hotfixes)

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
Id	int(10)	unsigned	PRI	NO	NULL
Dispel	tinyint(3)	unsigned		NO	0
Mechanic	tinyint(3)	unsigned		NO	0
Attributes	int(10)	unsigned		NO	0
AttributesEx	int(10)	unsigned		NO	0
AttributesEx2	int(10)	unsigned		NO	0
AttributesEx3	int(10)	unsigned		NO	0
AttributesEx4	int(10)	unsigned		NO	0
AttributesEx5	int(10)	unsigned		NO	0
Stances	int(10)	unsigned		NO	0
StancesNot	int(10)	unsigned		NO	0
Targets	int(10)	unsigned		NO	0
CastingTimeIndex	tinyint(3)	unsigned		NO	1
AuraInterruptFlags	int(10)	unsigned		NO	0
ProcFlags	int(10)	unsigned		NO	0
ProcChance	tinyint(3)	unsigned		NO	0
ProcCharges	tinyint(3)	unsigned		NO	0
MaxLevel	tinyint(3)	unsigned		NO	0
BaseLevel	tinyint(3)	unsigned		NO	0
SpellLevel	tinyint(3)	unsigned		NO	0
DurationIndex	smallint(5)	unsigned		NO	0
RangeIndex	tinyint(3)	unsigned		NO	1
StackAmount	tinyint(3)	unsigned		NO	0
EquippedItemClass	int(11)	signed		NO	`-1`
EquippedItemSubClassMask	int(11)	signed		NO	0
EquippedItemInventoryTypeMask	int(11)	signed		NO	0
Effect1	tinyint(3)	unsigned		NO	0
Effect2	tinyint(3)	unsigned		NO	0
Effect3	tinyint(3)	unsigned		NO	0
EffectDieSides1	int(11)	signed		NO	0
EffectDieSides2	int(11)	signed		NO	0
EffectDieSides3	int(11)	signed		NO	0
EffectRealPointsPerLevel1	float	signed		NO	0
EffectRealPointsPerLevel2	float	signed		NO	0
EffectRealPointsPerLevel3	float	signed		NO	0
EffectBasePoints1	int(11)	signed		NO	0
EffectBasePoints2	int(11)	signed		NO	0
EffectBasePoints3	int(11)	signed		NO	0
EffectMechanic1	tinyint(3)	unsigned