summaryrefslogtreecommitdiff
path: root/docs/spell_dbc.md
diff options
context:
space:
mode:
authorFrancescoBorzi <borzifrancesco@gmail.com>2019-02-25 19:24:20 +0100
committerFrancescoBorzi <borzifrancesco@gmail.com>2019-02-25 19:24:20 +0100
commita35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 (patch)
tree91e0cde00f6f27b730b0df3f4338fcf99fa8447a /docs/spell_dbc.md
parentd8d1823802ded97300fa57405d80b16736603489 (diff)
downloadwiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.gz
wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.bz2
wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.zip
Import DB wiki from TC 335
Diffstat (limited to 'docs/spell_dbc.md')
-rw-r--r--docs/spell_dbc.md3535
1 files changed, 3435 insertions, 100 deletions
diff --git a/docs/spell_dbc.md b/docs/spell_dbc.md
index 5f9de4c..63cd5c7 100644
--- a/docs/spell_dbc.md
+++ b/docs/spell_dbc.md
@@ -1,100 +1,3435 @@
-[Database Structure](Database-Structure) > [World-Database](World-Database) > [spell_dbc](spell_dbc)
-
-Column | Type | Description
---- | --- | ---
-Id | int(10) unsigned |
-Dispel | int(10) unsigned |
-Mechanic | int(10) unsigned |
-Attributes | int(10) unsigned |
-AttributesEx | int(10) unsigned |
-AttributesEx2 | int(10) unsigned |
-AttributesEx3 | int(10) unsigned |
-AttributesEx4 | int(10) unsigned |
-AttributesEx5 | int(10) unsigned |
-AttributesEx6 | int(10) unsigned |
-AttributesEx7 | int(10) unsigned |
-Stances | int(10) unsigned |
-StancesNot | int(10) unsigned |
-Targets | int(10) unsigned |
-CastingTimeIndex | int(10) unsigned |
-AuraInterruptFlags | int(10) unsigned |
-ProcFlags | int(10) unsigned |
-ProcChance | int(10) unsigned |
-ProcCharges | int(10) unsigned |
-MaxLevel | int(10) unsigned |
-BaseLevel | int(10) unsigned |
-SpellLevel | int(10) unsigned |
-DurationIndex | int(10) unsigned |
-RangeIndex | int(10) unsigned |
-StackAmount | int(10) unsigned |
-EquippedItemClass | int(11) |
-EquippedItemSubClassMask | int(11) |
-EquippedItemInventoryTypeMask | int(11) |
-Effect1 | int(10) unsigned |
-Effect2 | int(10) unsigned |
-Effect3 | int(10) unsigned |
-EffectDieSides1 | int(11) |
-EffectDieSides2 | int(11) |
-EffectDieSides3 | int(11) |
-EffectRealPointsPerLevel1 | float |
-EffectRealPointsPerLevel2 | float |
-EffectRealPointsPerLevel3 | float |
-EffectBasePoints1 | int(11) |
-EffectBasePoints2 | int(11) |
-EffectBasePoints3 | int(11) |
-EffectMechanic1 | int(10) unsigned |
-EffectMechanic2 | int(10) unsigned |
-EffectMechanic3 | int(10) unsigned |
-EffectImplicitTargetA1 | int(10) unsigned |
-EffectImplicitTargetA2 | int(10) unsigned |
-EffectImplicitTargetA3 | int(10) unsigned |
-EffectImplicitTargetB1 | int(10) unsigned |
-EffectImplicitTargetB2 | int(10) unsigned |
-EffectImplicitTargetB3 | int(10) unsigned |
-EffectRadiusIndex1 | int(10) unsigned |
-EffectRadiusIndex2 | int(10) unsigned |
-EffectRadiusIndex3 | int(10) unsigned |
-EffectApplyAuraName1 | int(10) unsigned |
-EffectApplyAuraName2 | int(10) unsigned |
-EffectApplyAuraName3 | int(10) unsigned |
-EffectAmplitude1 | int(11) |
-EffectAmplitude2 | int(11) |
-EffectAmplitude3 | int(11) |
-EffectMultipleValue1 | float |
-EffectMultipleValue2 | float |
-EffectMultipleValue3 | float |
-EffectItemType1 | int(10) unsigned |
-EffectItemType2 | int(10) unsigned |
-EffectItemType3 | int(10) unsigned |
-EffectMiscValue1 | int(11) |
-EffectMiscValue2 | int(11) |
-EffectMiscValue3 | int(11) |
-EffectMiscValueB1 | int(11) |
-EffectMiscValueB2 | int(11) |
-EffectMiscValueB3 | int(11) |
-EffectTriggerSpell1 | int(10) unsigned |
-EffectTriggerSpell2 | int(10) unsigned |
-EffectTriggerSpell3 | int(10) unsigned |
-EffectSpellClassMaskA1 | int(10) unsigned |
-EffectSpellClassMaskA2 | int(10) unsigned |
-EffectSpellClassMaskA3 | int(10) unsigned |
-EffectSpellClassMaskB1 | int(10) unsigned |
-EffectSpellClassMaskB2 | int(10) unsigned |
-EffectSpellClassMaskB3 | int(10) unsigned |
-EffectSpellClassMaskC1 | int(10) unsigned |
-EffectSpellClassMaskC2 | int(10) unsigned |
-EffectSpellClassMaskC3 | int(10) unsigned |
-MaxTargetLevel | int(10) unsigned |
-SpellFamilyName | int(10) unsigned |
-SpellFamilyFlags1 | int(10) unsigned |
-SpellFamilyFlags2 | int(10) unsigned |
-SpellFamilyFlags3 | int(10) unsigned |
-MaxAffectedTargets | int(10) unsigned |
-DmgClass | int(10) unsigned |
-PreventionType | int(10) unsigned |
-DmgMultiplier1 | float |
-DmgMultiplier2 | float |
-DmgMultiplier3 | float |
-AreaGroupId | int(11) |
-SchoolMask | int(10) unsigned |
-Comment | text |
+# spell\_dbc
+
+`Back-to:World`
+
+**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](https://trinitycore.atlassian.net/wiki/display/tc/Hotfixes))
+
+**Structure**
+
+<table>
+<tbody>
+<tr class="odd">
+<td><p><strong>Field</strong></p></td>
+<td><p><strong>Type</strong></p></td>
+<td><p><strong>Attributes</strong></p></td>
+<td><p><strong>Key</strong></p></td>
+<td><p><strong>Null</strong></p></td>
+<td><p><strong>Default</strong></p></td>
+<td><p><strong>Extra</strong></p></td>
+<td><p><strong>Comment</strong></p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-Id">Id</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>NULL</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-Dispel">Dispel</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-Mechanic">Mechanic</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-Attributes">Attributes</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-AttributesEx">AttributesEx</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-AttributesEx">AttributesEx2</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-AttributesEx">AttributesEx3</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-AttributesEx">AttributesEx4</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-AttributesEx">AttributesEx5</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-Stances">Stances</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-StancesNot">StancesNot</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-Targets">Targets</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-CastingTimeIndex">CastingTimeIndex</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>1</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-AuraInterruptFlags">AuraInterruptFlags</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-ProcFlags">ProcFlags</a></p></td>
+<td><p>int(10)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-ProcChance">ProcChance</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-ProcCharges">ProcCharges</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-MaxLevel">MaxLevel</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-BaseLevel">BaseLevel</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-SpellLevel">SpellLevel</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-DurationIndex">DurationIndex</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-RangeIndex">RangeIndex</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>1</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-StackAmount">StackAmount</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EquippedItemClass">EquippedItemClass</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><div class="content-wrapper">
+<div class="preformatted panel" style="border-width: 1px;">
+<div class="preformattedContent panelContent">
+<pre><code>-1</code></pre>
+</div>
+</div>
+</div></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EquippedItemSubClassMask">EquippedItemSubClassMask</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EquippedItemInventoryTypeMask">EquippedItemInventoryTypeMask</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-Effect">Effect1</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-Effect">Effect2</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-Effect">Effect3</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectDieSides">EffectDieSides1</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectDieSides">EffectDieSides2</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectDieSides">EffectDieSides3</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectRealPointsPerLevel">EffectRealPointsPerLevel1</a></p></td>
+<td><p>float</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectRealPointsPerLevel">EffectRealPointsPerLevel2</a></p></td>
+<td><p>float</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectRealPointsPerLevel">EffectRealPointsPerLevel3</a></p></td>
+<td><p>float</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectBasePoints">EffectBasePoints1</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectBasePoints">EffectBasePoints2</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectBasePoints">EffectBasePoints3</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectMechanic">EffectMechanic1</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectMechanic">EffectMechanic2</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectMechanic">EffectMechanic3</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectImplicitTargetA">EffectImplicitTargetA1</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectImplicitTargetA">EffectImplicitTargetA2</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectImplicitTargetA">EffectImplicitTargetA3</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectImplicitTargetB">EffectImplicitTargetB1</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectImplicitTargetB">EffectImplicitTargetB2</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectImplicitTargetB">EffectImplicitTargetB3</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectRadiusIndex">EffectRadiusIndex1</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectRadiusIndex">EffectRadiusIndex2</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectRadiusIndex">EffectRadiusIndex3</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectApplyAuraName">EffectApplyAuraName1</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectApplyAuraName">EffectApplyAuraName2</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectApplyAuraName">EffectApplyAuraName3</a></p></td>
+<td><p>smallint(5)</p></td>
+<td><p>unsigned</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectAmplitude">EffectAmplitude1</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectAmplitude">EffectAmplitude2</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectAmplitude">EffectAmplitude3</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectMultipleValue">EffectMultipleValue1</a></p></td>
+<td><p>float</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectMultipleValue">EffectMultipleValue2</a></p></td>
+<td><p>float</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectMultipleValue">EffectMultipleValue3</a></p></td>
+<td><p>float</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectMiscValue">EffectMiscValue1</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectMiscValue">EffectMiscValue2</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectMiscValue">EffectMiscValue3</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#spell_dbc-EffectMiscValueB">EffectMiscValueB1</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#spell_dbc-EffectMiscValueB">EffectMiscValueB2</a></p></td>
+<td><p>int(11)</p></td>
+<td><p>signed</p></td>
+<td><p><br />
+</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p><br />
+</p></td>
+<td><p><br />
+</p></td>
+<