Spell template
Материал из YTDB DataBase
Версия от 17:57, 17 декабря 2016; NeatElves (Обсуждение | вклад)
К описанию таблиц базы данных mangos.
Таблица `spell_template`
Содержит все заклинания, которые используются в игре.
Структура
Field | Type | Attributes | Null | Key | Default | Comments |
id | int(11) | unsigned | NO | PRI | 0 | |
Category | int(11) | unsigned | NO | 0 | ||
Dispel | int(11) | unsigned | NO | 0 | ||
Mechanic | int(11) | unsigned | NO | 0 | ||
Attributes | int(11) | unsigned | NO | 0 | ||
AttributesEx | int(11) | unsigned | NO | 0 | ||
AttributesEx2 | int(11) | unsigned | NO | 0 | ||
AttributesEx3 | int(11) | unsigned | NO | 0 | ||
AttributesEx4 | int(11) | unsigned | NO | 0 | ||
AttributesEx5 | int(11) | unsigned | NO | 0 | ||
AttributesEx6 | int(11) | unsigned | NO | 0 | ||
AttributesEx7 | int(11) | unsigned | NO | 0 | ||
Stances | int(11) | unsigned | NO | 0 | ||
StancesNot | int(11) | unsigned | NO | 0 | ||
Targets | int(11) | unsigned | NO | 0 | ||
TargetCreatureType | int(11) | unsigned | NO | 0 | ||
RequiresSpellFocus | int(11) | unsigned | NO | 0 | ||
FacingCasterFlags | int(11) | unsigned | NO | 0 | ||
CasterAuraState | int(11) | unsigned | NO | 0 | ||
TargetAuraState | int(11) | unsigned | NO | 0 | ||
CasterAuraStateNot | int(11) | unsigned | NO | 0 | ||
TargetAuraStateNot | int(11) | unsigned | NO | 0 | ||
CasterAuraSpell | int(11) | unsigned | NO | 0 | ||
TargetAuraSpell | int(11) | unsigned | NO | 0 | ||
ExcludeCasterAuraSpell | int(11) | unsigned | NO | 0 | ||
ExcludeTargetAuraSpell | int(11) | unsigned | NO | 0 | ||
CastingTimeIndex | int(11) | unsigned | NO | 0 | ||
RecoveryTime | int(11) | unsigned | NO | 0 | ||
CategoryRecoveryTime | int(11) | unsigned | NO | 0 | ||
InterruptFlags | int(11) | unsigned | NO | 0 | ||
AuraInterruptFlags | int(11) | unsigned | NO | 0 | ||
ChannelInterruptFlags | int(11) | unsigned | NO | 0 | ||
ProcFlags | int(11) | unsigned | NO | 0 | ||
ProcChance | int(11) | unsigned | NO | 0 | ||
ProcCharges | int(11) | unsigned | NO | 0 | ||
MaxLevel | int(11) | unsigned | NO | 0 | ||
BaseLevel | int(11) | unsigned | NO | 0 | ||
SpellLevel | int(11) | unsigned | NO | 0 | ||
DurationIndex | int(11) | unsigned | NO | 0 | ||
PowerType | int(11) | unsigned | NO | 0 | ||
ManaCost | int(11) | unsigned | NO | 0 | ||
ManaCostPerlevel | int(11) | unsigned | NO | 0 | ||
ManaPerSecond | int(11) | unsigned | NO | 0 | ||
ManaPerSecondPerLevel | int(11) | unsigned | NO | 0 | ||
RangeIndex | int(11) | unsigned | NO | 0 | ||
Speed | float | NO | 0 | |||
StackAmount | int(11) | unsigned | NO | 0 | ||
Totem1 | int(11) | unsigned | NO | 0 | ||
Totem2 | int(11) | unsigned | NO | 0 | ||
Reagent1 | int(11) | NO | 0 | |||
Reagent2 | int(11) | NO | 0 | |||
Reagent3 | int(11) | NO | 0 | |||
Reagent4 | int(11) | NO | 0 | |||
Reagent5 | int(11) | NO | 0 | |||
Reagent6 | int(11) | NO | 0 | |||
Reagent7 | int(11) | NO | 0 | |||
Reagent8 | int(11) | NO | 0 | |||
ReagentCount1 | int(11) | unsigned | NO | 0 | ||
ReagentCount2 | int(11) | unsigned | NO | 0 | ||
ReagentCount3 | int(11) | unsigned | NO | 0 | ||
ReagentCount4 | int(11) | unsigned | NO | 0 | ||
ReagentCount5 | int(11) | unsigned | NO | 0 | ||
ReagentCount6 | int(11) | unsigned | NO | 0 | ||
ReagentCount7 | int(11) | unsigned | NO | 0 | ||
ReagentCount8 | int(11) | unsigned | NO | 0 | ||
EquippedItemClass | int(11) | NO | -1 | |||
EquippedItemSubClassMask | int(11) | NO | 0 | |||
EquippedItemInventoryTypeMask | int(11) | NO | 0 | |||
Effect1 | int(11) | unsigned | NO | 0 | ||
Effect2 | int(11) | unsigned | NO | 0 | ||
Effect3 | int(11) | unsigned | NO | 0 | ||
EffectDieSides1 | int(11) | NO | 0 | |||
EffectDieSides2 | int(11) | NO | 0 | |||
EffectDieSides3 | int(11) | NO | 0 |