· 6 years ago · Jan 19, 2020, 09:36 PM
1CREATE TABLE IF NOT EXISTS `spell_template` (
2 `entry` int(4) unsigned NOT NULL DEFAULT '0',
3 `build` smallint(4) unsigned NOT NULL DEFAULT '5875' COMMENT 'Game client build for which to load this entry',
4 `school` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'Resistances.dbc',
5 `category` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCategory.dbc',
6 `castUI` int(4) unsigned NOT NULL DEFAULT '0',
7 `dispel` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellDispelType.dbc',
8 `mechanic` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellMechanic.dbc',
9 `attributes` int(4) unsigned NOT NULL DEFAULT '0',
10 `attributesEx` int(4) unsigned NOT NULL DEFAULT '0',
11 `attributesEx2` int(4) unsigned NOT NULL DEFAULT '0',
12 `attributesEx3` int(4) unsigned NOT NULL DEFAULT '0',
13 `attributesEx4` int(4) unsigned NOT NULL DEFAULT '0',
14 `stances` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellShapeshiftForm.dbc',
15 `stancesNot` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellShapeshiftForm.dbc',
16 `targets` int(4) unsigned NOT NULL DEFAULT '0',
17 `targetCreatureType` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'CreatureType.dbc',
18 `requiresSpellFocus` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellFocusObject.dbc',
19 `casterAuraState` int(4) unsigned NOT NULL DEFAULT '0',
20 `targetAuraState` int(4) unsigned NOT NULL DEFAULT '0',
21 `castingTimeIndex` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCastTimes.dbc',
22 `recoveryTime` int(4) unsigned NOT NULL DEFAULT '0',
23 `categoryRecoveryTime` int(4) unsigned NOT NULL DEFAULT '0',
24 `interruptFlags` int(4) unsigned NOT NULL DEFAULT '0',
25 `auraInterruptFlags` int(4) unsigned NOT NULL DEFAULT '0',
26 `channelInterruptFlags` int(4) unsigned NOT NULL DEFAULT '0',
27 `procFlags` int(4) unsigned NOT NULL DEFAULT '0',
28 `procChance` int(4) unsigned NOT NULL DEFAULT '0',
29 `procCharges` int(4) unsigned NOT NULL DEFAULT '0',
30 `maxLevel` int(4) unsigned NOT NULL DEFAULT '0',
31 `baseLevel` int(4) unsigned NOT NULL DEFAULT '0',
32 `spellLevel` int(4) unsigned NOT NULL DEFAULT '0',
33 `durationIndex` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellDuration.dbc',
34 `powerType` int(4) unsigned NOT NULL DEFAULT '0',
35 `manaCost` int(4) unsigned NOT NULL DEFAULT '0',
36 `manCostPerLevel` int(4) unsigned NOT NULL DEFAULT '0',
37 `manaPerSecond` int(4) unsigned NOT NULL DEFAULT '0',
38 `manaPerSecondPerLevel` int(4) unsigned NOT NULL DEFAULT '0',
39 `rangeIndex` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellRange.dbc',
40 `speed` float NOT NULL DEFAULT '0',
41 `modelNextSpell` int(4) unsigned NOT NULL DEFAULT '0',
42 `stackAmount` int(4) unsigned NOT NULL DEFAULT '0',
43 `totem1` int(4) unsigned NOT NULL DEFAULT '0',
44 `totem2` int(4) unsigned NOT NULL DEFAULT '0',
45 `reagent1` int(4) NOT NULL DEFAULT '0',
46 `reagent2` int(4) NOT NULL DEFAULT '0',
47 `reagent3` int(4) NOT NULL DEFAULT '0',
48 `reagent4` int(4) NOT NULL DEFAULT '0',
49 `reagent5` int(4) NOT NULL DEFAULT '0',
50 `reagent6` int(4) NOT NULL DEFAULT '0',
51 `reagent7` int(4) NOT NULL DEFAULT '0',
52 `reagent8` int(4) NOT NULL DEFAULT '0',
53 `reagentCount1` int(4) unsigned NOT NULL DEFAULT '0',
54 `reagentCount2` int(4) unsigned NOT NULL DEFAULT '0',
55 `reagentCount3` int(4) unsigned NOT NULL DEFAULT '0',
56 `reagentCount4` int(4) unsigned NOT NULL DEFAULT '0',
57 `reagentCount5` int(4) unsigned NOT NULL DEFAULT '0',
58 `reagentCount6` int(4) unsigned NOT NULL DEFAULT '0',
59 `reagentCount7` int(4) unsigned NOT NULL DEFAULT '0',
60 `reagentCount8` int(4) unsigned NOT NULL DEFAULT '0',
61 `equippedItemClass` int(4) NOT NULL DEFAULT '0' COMMENT 'ItemClass.dbc',
62 `equippedItemSubClassMask` int(4) NOT NULL DEFAULT '0' COMMENT 'ItemSubClass.dbc',
63 `equippedItemInventoryTypeMask` int(4) NOT NULL DEFAULT '0',
64 `effect1` int(4) unsigned NOT NULL DEFAULT '0',
65 `effect2` int(4) unsigned NOT NULL DEFAULT '0',
66 `effect3` int(4) unsigned NOT NULL DEFAULT '0',
67 `effectDieSides1` int(4) NOT NULL DEFAULT '0',
68 `effectDieSides2` int(4) NOT NULL DEFAULT '0',
69 `effectDieSides3` int(4) NOT NULL DEFAULT '0',
70 `effectBaseDice1` int(4) unsigned NOT NULL DEFAULT '0',
71 `effectBaseDice2` int(4) unsigned NOT NULL DEFAULT '0',
72 `effectBaseDice3` int(4) unsigned NOT NULL DEFAULT '0',
73 `effectDicePerLevel1` float NOT NULL DEFAULT '0',
74 `effectDicePerLevel2` float NOT NULL DEFAULT '0',
75 `effectDicePerLevel3` float NOT NULL DEFAULT '0',
76 `effectRealPointsPerLevel1` float NOT NULL DEFAULT '0',
77 `effectRealPointsPerLevel2` float NOT NULL DEFAULT '0',
78 `effectRealPointsPerLevel3` float NOT NULL DEFAULT '0',
79 `effectBasePoints1` int(4) NOT NULL DEFAULT '0',
80 `effectBasePoints2` int(4) NOT NULL DEFAULT '0',
81 `effectBasePoints3` int(4) NOT NULL DEFAULT '0',
82 `effectMechanic1` int(4) unsigned NOT NULL DEFAULT '0',
83 `effectMechanic2` int(4) unsigned NOT NULL DEFAULT '0',
84 `effectMechanic3` int(4) unsigned NOT NULL DEFAULT '0',
85 `effectImplicitTargetA1` int(4) unsigned NOT NULL DEFAULT '0',
86 `effectImplicitTargetA2` int(4) unsigned NOT NULL DEFAULT '0',
87 `effectImplicitTargetA3` int(4) unsigned NOT NULL DEFAULT '0',
88 `effectImplicitTargetB1` int(4) unsigned NOT NULL DEFAULT '0',
89 `effectImplicitTargetB2` int(4) unsigned NOT NULL DEFAULT '0',
90 `effectImplicitTargetB3` int(4) unsigned NOT NULL DEFAULT '0',
91 `effectRadiusIndex1` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellRadius.dbc',
92 `effectRadiusIndex2` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellRadius.dbc',
93 `effectRadiusIndex3` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellRadius.dbc',
94 `effectApplyAuraName1` int(4) unsigned NOT NULL DEFAULT '0',
95 `effectApplyAuraName2` int(4) unsigned NOT NULL DEFAULT '0',
96 `effectApplyAuraName3` int(4) unsigned NOT NULL DEFAULT '0',
97 `effectAmplitude1` int(4) unsigned NOT NULL DEFAULT '0',
98 `effectAmplitude2` int(4) unsigned NOT NULL DEFAULT '0',
99 `effectAmplitude3` int(4) unsigned NOT NULL DEFAULT '0',
100 `effectMultipleValue1` float NOT NULL DEFAULT '0',
101 `effectMultipleValue2` float NOT NULL DEFAULT '0',
102 `effectMultipleValue3` float NOT NULL DEFAULT '0',
103 `effectChainTarget1` int(4) unsigned NOT NULL DEFAULT '0',
104 `effectChainTarget2` int(4) unsigned NOT NULL DEFAULT '0',
105 `effectChainTarget3` int(4) unsigned NOT NULL DEFAULT '0',
106 `effectItemType1` int(4) unsigned NOT NULL DEFAULT '0',
107 `effectItemType2` int(4) unsigned NOT NULL DEFAULT '0',
108 `effectItemType3` int(4) unsigned NOT NULL DEFAULT '0',
109 `effectMiscValue1` int(4) NOT NULL DEFAULT '0',
110 `effectMiscValue2` int(4) NOT NULL DEFAULT '0',
111 `effectMiscValue3` int(4) NOT NULL DEFAULT '0',
112 `effectTriggerSpell1` int(4) unsigned NOT NULL DEFAULT '0',
113 `effectTriggerSpell2` int(4) unsigned NOT NULL DEFAULT '0',
114 `effectTriggerSpell3` int(4) unsigned NOT NULL DEFAULT '0',
115 `effectPointsPerComboPoint1` float NOT NULL DEFAULT '0',
116 `effectPointsPerComboPoint2` float NOT NULL DEFAULT '0',
117 `effectPointsPerComboPoint3` float NOT NULL DEFAULT '0',
118 `spellVisual1` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellVisual.dbc',
119 `spellVisual2` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellVisual.dbc',
120 `spellIconId` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellIcon.dbc',
121 `activeIconId` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellIcon.dbc',
122 `spellPriority` int(4) unsigned NOT NULL DEFAULT '0',
123 `name` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
124 `nameFlags` int(4) unsigned NOT NULL DEFAULT '0',
125 `nameSubtext` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
126 `nameSubtextFlags` int(4) unsigned NOT NULL DEFAULT '0',
127 `description` varchar(1024) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
128 `descriptionFlags` int(4) unsigned NOT NULL DEFAULT '0',
129 `auraDescription` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
130 `auraDescriptionFlags` int(4) unsigned NOT NULL DEFAULT '0',
131 `manaCostPercentage` int(4) unsigned NOT NULL DEFAULT '0',
132 `startRecoveryCategory` int(4) unsigned NOT NULL DEFAULT '0',
133 `startRecoveryTime` int(4) unsigned NOT NULL DEFAULT '0',
134 `minTargetLevel` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'Custom Field',
135 `maxTargetLevel` int(4) unsigned NOT NULL DEFAULT '0',
136 `spellFamilyName` int(4) unsigned NOT NULL DEFAULT '0' COMMENT 'ChrClasses.dbc',
137 `spellFamilyFlags` bigint(20) unsigned NOT NULL DEFAULT '0',
138 `maxAffectedTargets` int(4) unsigned NOT NULL DEFAULT '0',
139 `dmgClass` int(4) unsigned NOT NULL DEFAULT '0',
140 `preventionType` int(4) unsigned NOT NULL DEFAULT '0',
141 `stanceBarOrder` int(4) NOT NULL DEFAULT '0',
142 `dmgMultiplier1` float NOT NULL DEFAULT '0',
143 `dmgMultiplier2` float NOT NULL DEFAULT '0',
144 `dmgMultiplier3` float NOT NULL DEFAULT '0',
145 `minFactionId` int(4) unsigned NOT NULL DEFAULT '0',
146 `minReputation` int(4) unsigned NOT NULL DEFAULT '0',
147 `requiredAuraVision` int(4) unsigned NOT NULL DEFAULT '0',
148 `customFlags` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Custom Field',
149 PRIMARY KEY (`entry`,`build`)
150) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;