· 6 years ago · Jan 19, 2020, 09:36 PM
1CREATE TABLE IF NOT EXISTS `spell_template` (
2 `Id` int(11) unsigned NOT NULL DEFAULT '0',
3 `School` int(11) unsigned NOT NULL DEFAULT '0',
4 `Category` int(11) unsigned NOT NULL DEFAULT '0',
5 `CastUI` int(11) unsigned NOT NULL DEFAULT '0',
6 `Dispel` int(11) unsigned NOT NULL DEFAULT '0',
7 `Mechanic` int(11) unsigned NOT NULL DEFAULT '0',
8 `Attributes` int(11) unsigned NOT NULL DEFAULT '0',
9 `AttributesEx` int(11) unsigned NOT NULL DEFAULT '0',
10 `AttributesEx2` int(11) unsigned NOT NULL DEFAULT '0',
11 `AttributesEx3` int(11) unsigned NOT NULL DEFAULT '0',
12 `AttributesEx4` int(11) unsigned NOT NULL DEFAULT '0',
13 `Stances` int(11) unsigned NOT NULL DEFAULT '0',
14 `StancesNot` int(11) unsigned NOT NULL DEFAULT '0',
15 `Targets` int(11) unsigned NOT NULL DEFAULT '0',
16 `TargetCreatureType` int(11) unsigned NOT NULL DEFAULT '0',
17 `RequiresSpellFocus` int(11) unsigned NOT NULL DEFAULT '0',
18 `CasterAuraState` int(11) unsigned NOT NULL DEFAULT '0',
19 `TargetAuraState` int(11) unsigned NOT NULL DEFAULT '0',
20 `CastingTimeIndex` int(11) unsigned NOT NULL DEFAULT '0',
21 `RecoveryTime` int(11) unsigned NOT NULL DEFAULT '0',
22 `CategoryRecoveryTime` int(11) unsigned NOT NULL DEFAULT '0',
23 `InterruptFlags` int(11) unsigned NOT NULL DEFAULT '0',
24 `AuraInterruptFlags` int(11) unsigned NOT NULL DEFAULT '0',
25 `ChannelInterruptFlags` int(11) unsigned NOT NULL DEFAULT '0',
26 `ProcFlags` int(11) unsigned NOT NULL DEFAULT '0',
27 `ProcChance` int(11) unsigned NOT NULL DEFAULT '0',
28 `ProcCharges` int(11) unsigned NOT NULL DEFAULT '0',
29 `MaxLevel` int(11) unsigned NOT NULL DEFAULT '0',
30 `BaseLevel` int(11) unsigned NOT NULL DEFAULT '0',
31 `SpellLevel` int(11) unsigned NOT NULL DEFAULT '0',
32 `DurationIndex` int(11) unsigned NOT NULL DEFAULT '0',
33 `PowerType` int(11) unsigned NOT NULL DEFAULT '0',
34 `ManaCost` int(11) unsigned NOT NULL DEFAULT '0',
35 `ManaCostPerlevel` int(11) unsigned NOT NULL DEFAULT '0',
36 `ManaPerSecond` int(11) unsigned NOT NULL DEFAULT '0',
37 `ManaPerSecondPerLevel` int(11) unsigned NOT NULL DEFAULT '0',
38 `RangeIndex` int(11) unsigned NOT NULL DEFAULT '1',
39 `Speed` float NOT NULL DEFAULT '0',
40 `ModalNextSpell` int(11) unsigned NOT NULL DEFAULT '0',
41 `StackAmount` int(11) unsigned NOT NULL DEFAULT '0',
42 `Totem1` int(11) unsigned NOT NULL DEFAULT '0',
43 `Totem2` int(11) unsigned NOT NULL DEFAULT '0',
44 `Reagent1` int(11) NOT NULL DEFAULT '0',
45 `Reagent2` int(11) NOT NULL DEFAULT '0',
46 `Reagent3` int(11) NOT NULL DEFAULT '0',
47 `Reagent4` int(11) NOT NULL DEFAULT '0',
48 `Reagent5` int(11) NOT NULL DEFAULT '0',
49 `Reagent6` int(11) NOT NULL DEFAULT '0',
50 `Reagent7` int(11) NOT NULL DEFAULT '0',
51 `Reagent8` int(11) NOT NULL DEFAULT '0',
52 `ReagentCount1` int(11) unsigned NOT NULL DEFAULT '0',
53 `ReagentCount2` int(11) unsigned NOT NULL DEFAULT '0',
54 `ReagentCount3` int(11) unsigned NOT NULL DEFAULT '0',
55 `ReagentCount4` int(11) unsigned NOT NULL DEFAULT '0',
56 `ReagentCount5` int(11) unsigned NOT NULL DEFAULT '0',
57 `ReagentCount6` int(11) unsigned NOT NULL DEFAULT '0',
58 `ReagentCount7` int(11) unsigned NOT NULL DEFAULT '0',
59 `ReagentCount8` int(11) unsigned NOT NULL DEFAULT '0',
60 `EquippedItemClass` int(11) NOT NULL DEFAULT '-1',
61 `EquippedItemSubClassMask` int(11) NOT NULL DEFAULT '0',
62 `EquippedItemInventoryTypeMask` int(11) NOT NULL DEFAULT '0',
63 `Effect1` int(11) unsigned NOT NULL DEFAULT '0',
64 `Effect2` int(11) unsigned NOT NULL DEFAULT '0',
65 `Effect3` int(11) unsigned NOT NULL DEFAULT '0',
66 `EffectDieSides1` int(11) NOT NULL DEFAULT '0',
67 `EffectDieSides2` int(11) NOT NULL DEFAULT '0',
68 `EffectDieSides3` int(11) NOT NULL DEFAULT '0',
69 `EffectBaseDice1` int(11) unsigned NOT NULL DEFAULT '0',
70 `EffectBaseDice2` int(11) unsigned NOT NULL DEFAULT '0',
71 `EffectBaseDice3` int(11) unsigned NOT NULL DEFAULT '0',
72 `EffectDicePerLevel1` float NOT NULL DEFAULT '0',
73 `EffectDicePerLevel2` float NOT NULL DEFAULT '0',
74 `EffectDicePerLevel3` float NOT NULL DEFAULT '0',
75 `EffectRealPointsPerLevel1` float NOT NULL DEFAULT '0',
76 `EffectRealPointsPerLevel2` float NOT NULL DEFAULT '0',
77 `EffectRealPointsPerLevel3` float NOT NULL DEFAULT '0',
78 `EffectBasePoints1` int(11) NOT NULL DEFAULT '0',
79 `EffectBasePoints2` int(11) NOT NULL DEFAULT '0',
80 `EffectBasePoints3` int(11) NOT NULL DEFAULT '0',
81 `EffectMechanic1` int(11) unsigned NOT NULL DEFAULT '0',
82 `EffectMechanic2` int(11) unsigned NOT NULL DEFAULT '0',
83 `EffectMechanic3` int(11) unsigned NOT NULL DEFAULT '0',
84 `EffectImplicitTargetA1` int(11) unsigned NOT NULL DEFAULT '0',
85 `EffectImplicitTargetA2` int(11) unsigned NOT NULL DEFAULT '0',
86 `EffectImplicitTargetA3` int(11) unsigned NOT NULL DEFAULT '0',
87 `EffectImplicitTargetB1` int(11) unsigned NOT NULL DEFAULT '0',
88 `EffectImplicitTargetB2` int(11) unsigned NOT NULL DEFAULT '0',
89 `EffectImplicitTargetB3` int(11) unsigned NOT NULL DEFAULT '0',
90 `EffectRadiusIndex1` int(11) unsigned NOT NULL DEFAULT '0',
91 `EffectRadiusIndex2` int(11) unsigned NOT NULL DEFAULT '0',
92 `EffectRadiusIndex3` int(11) unsigned NOT NULL DEFAULT '0',
93 `EffectApplyAuraName1` int(11) unsigned NOT NULL DEFAULT '0',
94 `EffectApplyAuraName2` int(11) unsigned NOT NULL DEFAULT '0',
95 `EffectApplyAuraName3` int(11) unsigned NOT NULL DEFAULT '0',
96 `EffectAmplitude1` int(11) unsigned NOT NULL DEFAULT '0',
97 `EffectAmplitude2` int(11) unsigned NOT NULL DEFAULT '0',
98 `EffectAmplitude3` int(11) unsigned NOT NULL DEFAULT '0',
99 `EffectMultipleValue1` float NOT NULL DEFAULT '0',
100 `EffectMultipleValue2` float NOT NULL DEFAULT '0',
101 `EffectMultipleValue3` float NOT NULL DEFAULT '0',
102 `EffectChainTarget1` int(11) unsigned NOT NULL DEFAULT '0',
103 `EffectChainTarget2` int(11) unsigned NOT NULL DEFAULT '0',
104 `EffectChainTarget3` int(11) unsigned NOT NULL DEFAULT '0',
105 `EffectItemType1` int(11) unsigned NOT NULL DEFAULT '0',
106 `EffectItemType2` int(11) unsigned NOT NULL DEFAULT '0',
107 `EffectItemType3` int(11) unsigned NOT NULL DEFAULT '0',
108 `EffectMiscValue1` int(11) NOT NULL DEFAULT '0',
109 `EffectMiscValue2` int(11) NOT NULL DEFAULT '0',
110 `EffectMiscValue3` int(11) NOT NULL DEFAULT '0',
111 `EffectTriggerSpell1` int(11) unsigned NOT NULL DEFAULT '0',
112 `EffectTriggerSpell2` int(11) unsigned NOT NULL DEFAULT '0',
113 `EffectTriggerSpell3` int(11) unsigned NOT NULL DEFAULT '0',
114 `EffectPointsPerComboPoint1` float NOT NULL DEFAULT '0',
115 `EffectPointsPerComboPoint2` float NOT NULL DEFAULT '0',
116 `EffectPointsPerComboPoint3` float NOT NULL DEFAULT '0',
117 `SpellVisual` int(11) unsigned NOT NULL DEFAULT '0',
118 `SpellIconID` int(11) unsigned NOT NULL DEFAULT '0',
119 `ActiveIconID` int(11) unsigned NOT NULL DEFAULT '0',
120 `SpellPriority` int(11) unsigned NOT NULL DEFAULT '0',
121 `SpellName` text NOT NULL,
122 `SpellName2` text,
123 `SpellName3` text,
124 `SpellName4` text,
125 `SpellName5` text,
126 `SpellName6` text,
127 `SpellName7` text,
128 `SpellName8` text,
129 `Rank` text,
130 `Rank2` text,
131 `Rank3` text,
132 `Rank4` text,
133 `Rank5` text,
134 `Rank6` text,
135 `Rank7` text,
136 `Rank8` text,
137 `ManaCostPercentage` int(11) unsigned NOT NULL DEFAULT '0',
138 `StartRecoveryCategory` int(11) unsigned NOT NULL DEFAULT '0',
139 `StartRecoveryTime` int(11) unsigned NOT NULL DEFAULT '0',
140 `MaxTargetLevel` int(11) unsigned NOT NULL DEFAULT '0',
141 `SpellFamilyName` int(11) unsigned NOT NULL DEFAULT '0',
142 `SpellFamilyFlags` bigint(20) unsigned NOT NULL DEFAULT '0',
143 `MaxAffectedTargets` int(11) unsigned NOT NULL DEFAULT '0',
144 `DmgClass` int(11) unsigned NOT NULL DEFAULT '0',
145 `PreventionType` int(11) unsigned NOT NULL DEFAULT '0',
146 `StanceBarOrder` int(11) NOT NULL DEFAULT '0',
147 `DmgMultiplier1` float NOT NULL DEFAULT '0',
148 `DmgMultiplier2` float NOT NULL DEFAULT '0',
149 `DmgMultiplier3` float NOT NULL DEFAULT '0',
150 `MinFactionId` int(11) unsigned NOT NULL DEFAULT '0',
151 `MinReputation` int(11) unsigned NOT NULL DEFAULT '0',
152 `RequiredAuraVision` int(11) unsigned NOT NULL DEFAULT '0',
153 `IsServerSide` int(11) unsigned NOT NULL DEFAULT '0',
154 `AttributesServerside` int(11) unsigned NOT NULL DEFAULT '0',
155 PRIMARY KEY (`Id`)
156) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Export of .dbc Spell.dbc';