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