· 8 years ago · Dec 01, 2017, 10:12 AM
1
2DROP TABLE IF EXISTS `spell_dbc`;
3CREATE TABLE `spell_dbc` (
4 `Id` int(10) unsigned NOT NULL,
5 `Category` int(10) unsigned NOT NULL default '0',
6 `Dispel` tinyint(3) unsigned NOT NULL DEFAULT '0',
7 `Mechanic` tinyint(3) unsigned NOT NULL DEFAULT '0',
8 `Attributes` int(10) unsigned NOT NULL DEFAULT '0',
9 `AttributesEx` int(10) unsigned NOT NULL DEFAULT '0',
10 `AttributesEx2` int(10) unsigned NOT NULL DEFAULT '0',
11 `AttributesEx3` int(10) unsigned NOT NULL DEFAULT '0',
12 `AttributesEx4` int(10) unsigned NOT NULL DEFAULT '0',
13 `AttributesEx5` int(10) unsigned NOT NULL DEFAULT '0',
14 `AttributesEx6` int(10) unsigned NOT NULL DEFAULT '0',
15 `AttributesEx7` int(10) unsigned NOT NULL DEFAULT '0',
16 `Stances` tinyint(3) unsigned NOT NULL DEFAULT '0',
17 `StancesNot` int(10) unsigned NOT NULL DEFAULT '0',
18 `Targets` int(10) unsigned NOT NULL DEFAULT '0',
19 `RequiresSpellFocus` int(10) unsigned NOT NULL DEFAULT '0',
20 `CasterAuraSpell` int(10) unsigned NOT NULL DEFAULT '0',
21 `TargetAuraSpell` int(10) unsigned NOT NULL DEFAULT '0',
22 `ExcludeCasterAuraSpell` int(10) unsigned NOT NULL DEFAULT '0',
23 `ExcludeTargetAuraSpell` int(10) unsigned NOT NULL DEFAULT '0',
24 `CastingTimeIndex` tinyint(3) unsigned NOT NULL DEFAULT '1',
25 `RecoveryTime` int(10) unsigned NOT NULL DEFAULT '0',
26 `CategoryRecoveryTime` int(10) unsigned NOT NULL DEFAULT '0',
27 `InterruptFlags` int(10) unsigned NOT NULL DEFAULT '0',
28 `AuraInterruptFlags` int(10) unsigned NOT NULL DEFAULT '0',
29 `ProcFlags` int(10) unsigned NOT NULL DEFAULT '0',
30 `ProcChance` tinyint(3) unsigned NOT NULL DEFAULT '0',
31 `ProcCharges` tinyint(3) unsigned NOT NULL DEFAULT '0',
32 `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
33 `BaseLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
34 `SpellLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
35 `DurationIndex` smallint(5) unsigned NOT NULL DEFAULT '0',
36 `RangeIndex` tinyint(3) unsigned NOT NULL DEFAULT '1',
37 `StackAmount` tinyint(3) unsigned NOT NULL DEFAULT '0',
38 `EquippedItemClass` int(11) NOT NULL DEFAULT '-1',
39 `EquippedItemSubClassMask` int(11) NOT NULL DEFAULT '0',
40 `EquippedItemInventoryTypeMask` int(11) NOT NULL DEFAULT '0',
41 `Effect1` tinyint(3) unsigned NOT NULL DEFAULT '0',
42 `Effect2` tinyint(3) unsigned NOT NULL DEFAULT '0',
43 `Effect3` tinyint(3) unsigned NOT NULL DEFAULT '0',
44 `EffectDieSides1` int(11) NOT NULL DEFAULT '0',
45 `EffectDieSides2` int(11) NOT NULL DEFAULT '0',
46 `EffectDieSides3` int(11) NOT NULL DEFAULT '0',
47 `EffectRealPointsPerLevel1` float NOT NULL DEFAULT '0',
48 `EffectRealPointsPerLevel2` float NOT NULL DEFAULT '0',
49 `EffectRealPointsPerLevel3` float NOT NULL DEFAULT '0',
50 `EffectBasePoints1` int(11) NOT NULL DEFAULT '0',
51 `EffectBasePoints2` int(11) NOT NULL DEFAULT '0',
52 `EffectBasePoints3` int(11) NOT NULL DEFAULT '0',
53 `EffectMechanic1` tinyint(3) unsigned NOT NULL DEFAULT '0',
54 `EffectMechanic2` tinyint(3) unsigned NOT NULL DEFAULT '0',
55 `EffectMechanic3` tinyint(3) unsigned NOT NULL DEFAULT '0',
56 `EffectImplicitTargetA1` tinyint(3) unsigned NOT NULL DEFAULT '0',
57 `EffectImplicitTargetA2` tinyint(3) unsigned NOT NULL DEFAULT '0',
58 `EffectImplicitTargetA3` tinyint(3) unsigned NOT NULL DEFAULT '0',
59 `EffectImplicitTargetB1` tinyint(3) unsigned NOT NULL DEFAULT '0',
60 `EffectImplicitTargetB2` tinyint(3) unsigned NOT NULL DEFAULT '0',
61 `EffectImplicitTargetB3` tinyint(3) unsigned NOT NULL DEFAULT '0',
62 `EffectRadiusIndex1` tinyint(3) unsigned NOT NULL DEFAULT '0',
63 `EffectRadiusIndex2` tinyint(3) unsigned NOT NULL DEFAULT '0',
64 `EffectRadiusIndex3` tinyint(3) unsigned NOT NULL DEFAULT '0',
65 `EffectApplyAuraName1` smallint(5) unsigned NOT NULL DEFAULT '0',
66 `EffectApplyAuraName2` smallint(5) unsigned NOT NULL DEFAULT '0',
67 `EffectApplyAuraName3` smallint(5) unsigned NOT NULL DEFAULT '0',
68 `EffectAmplitude1` int(11) NOT NULL DEFAULT '0',
69 `EffectAmplitude2` int(11) NOT NULL DEFAULT '0',
70 `EffectAmplitude3` int(11) NOT NULL DEFAULT '0',
71 `EffectMultipleValue1` float NOT NULL DEFAULT '0',
72 `EffectMultipleValue2` float NOT NULL DEFAULT '0',
73 `EffectMultipleValue3` float NOT NULL DEFAULT '0',
74 `EffectItemType1` int(11) NOT NULL DEFAULT '0',
75 `EffectMiscValue1` int(11) NOT NULL DEFAULT '0',
76 `EffectMiscValue2` int(11) NOT NULL DEFAULT '0',
77 `EffectMiscValue3` int(11) NOT NULL DEFAULT '0',
78 `EffectMiscValueB1` int(11) NOT NULL DEFAULT '0',
79 `EffectMiscValueB2` int(11) NOT NULL DEFAULT '0',
80 `EffectMiscValueB3` int(11) NOT NULL DEFAULT '0',
81 `EffectTriggerSpell1` int(10) unsigned NOT NULL DEFAULT '0',
82 `EffectTriggerSpell2` int(10) unsigned NOT NULL DEFAULT '0',
83 `EffectTriggerSpell3` int(10) unsigned NOT NULL DEFAULT '0',
84 `EffectSpellClassMaskA1` int(10) unsigned NOT NULL DEFAULT '0',
85 `EffectSpellClassMaskA2` int(10) unsigned NOT NULL DEFAULT '0',
86 `EffectSpellClassMaskA3` int(10) unsigned NOT NULL DEFAULT '0',
87 `EffectSpellClassMaskB1` int(10) unsigned NOT NULL DEFAULT '0',
88 `EffectSpellClassMaskB2` int(10) unsigned NOT NULL DEFAULT '0',
89 `EffectSpellClassMaskB3` int(10) unsigned NOT NULL DEFAULT '0',
90 `EffectSpellClassMaskC1` int(10) unsigned NOT NULL DEFAULT '0',
91 `EffectSpellClassMaskC2` int(10) unsigned NOT NULL DEFAULT '0',
92 `EffectSpellClassMaskC3` int(10) unsigned NOT NULL DEFAULT '0',
93 `SpellIconID` int(10) unsigned NOT NULL DEFAULT '0',
94 `MaxTargetLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
95 `SpellFamilyName` tinyint(3) unsigned NOT NULL DEFAULT '0',
96 `SpellFamilyFlags1` int(10) unsigned NOT NULL DEFAULT '0',
97 `SpellFamilyFlags2` int(10) unsigned NOT NULL DEFAULT '0',
98 `SpellFamilyFlags3` int(10) unsigned NOT NULL DEFAULT '0',
99 `MaxAffectedTargets` tinyint(3) unsigned NOT NULL DEFAULT '0',
100 `DmgClass` tinyint(3) unsigned NOT NULL DEFAULT '0',
101 `PreventionType` tinyint(3) unsigned NOT NULL DEFAULT '0',
102 `DmgMultiplier1` float NOT NULL DEFAULT '0',
103 `DmgMultiplier2` float NOT NULL DEFAULT '0',
104 `DmgMultiplier3` float NOT NULL DEFAULT '0',
105 `AreaGroupId` int(11) NOT NULL DEFAULT '0',
106 `SchoolMask` int(10) unsigned NOT NULL DEFAULT '0',
107 `Comment` text NOT NULL,
108 PRIMARY KEY (`Id`)
109) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom spell.dbc entries';