kAgxNeup

1DROP TABLE IF EXISTS `dbc_Spell`;
2CREATE TABLE `dbc_Spell` (
3	`m_ID` INT NOT NULL DEFAULT '0',
4	`m_attributes` INT UNSIGNED NOT NULL DEFAULT '0',
5	`m_attributesEx` INT UNSIGNED NOT NULL DEFAULT '0',
6	`m_attributesExB` INT UNSIGNED NOT NULL DEFAULT '0',
7	`m_attributesExC` INT UNSIGNED NOT NULL DEFAULT '0',
8	`m_attributesExD` INT UNSIGNED NOT NULL DEFAULT '0',
9	`m_attributesExE` INT UNSIGNED NOT NULL DEFAULT '0',
10	`m_attributesExF` INT UNSIGNED NOT NULL DEFAULT '0',
11	`m_attributesExG` INT UNSIGNED NOT NULL DEFAULT '0',
12	`m_attributesExH` INT UNSIGNED NOT NULL DEFAULT '0',
13	`m_unk_400_1` INT UNSIGNED NOT NULL DEFAULT '0',
14	`m_castingTimeIndex` INT NOT NULL DEFAULT '0',
15	`m_durationIndex` INT NOT NULL DEFAULT '0',
16	`m_powerType` INT NOT NULL DEFAULT '0',
17	`m_rangeIndex` INT NOT NULL DEFAULT '0',
18	`m_speed` FLOAT NOT NULL DEFAULT '0',
19	`m_spellVisualID_1` INT UNSIGNED NOT NULL DEFAULT '0',
20	`m_spellVisualID_2` INT UNSIGNED NOT NULL DEFAULT '0',
21	`m_spellIconID` INT NOT NULL DEFAULT '0',
22	`m_activeIconID` INT NOT NULL DEFAULT '0',
23	`m_name` TEXT NOT NULL,
24	`m_nameSubtext` TEXT NOT NULL,
25	`m_description` TEXT NOT NULL,
26	`m_auraDescription` TEXT NOT NULL,
27	`m_schoolMask` INT NOT NULL DEFAULT '0',
28	`m_runeCostID` INT NOT NULL DEFAULT '0',
29	`m_spellMissileID` INT NOT NULL DEFAULT '0',
30	`m_spellDescriptionVariableID` INT NOT NULL DEFAULT '0',
31	`m_spellDifficultyID` INT NOT NULL DEFAULT '0',
32	`m_unk_f1` FLOAT NOT NULL DEFAULT '0',
33	`m_spellScalingID` INT NOT NULL DEFAULT '0',
34	`m_SpellAuraOptionsId` INT NOT NULL DEFAULT '0',
35	`m_SpellAuraRestrictionsId` INT NOT NULL DEFAULT '0',
36	`m_SpellCastingRequirementsId` INT NOT NULL DEFAULT '0',
37	`m_SpellCategoriesId` INT NOT NULL DEFAULT '0',
38	`m_SpellClassOptionsId` INT NOT NULL DEFAULT '0',
39	`m_SpellCooldownsId` INT NOT NULL DEFAULT '0',
40	`m_unk_i1` INT NOT NULL DEFAULT '0',
41	`m_SpellEquippedItemsId` INT NOT NULL DEFAULT '0',
42	`m_SpellInterruptsId` INT NOT NULL DEFAULT '0',
43	`m_SpellLevelsId` INT NOT NULL DEFAULT '0',
44	`m_SpellPowerId` INT NOT NULL DEFAULT '0',
45	`m_SpellReagentsId` INT NOT NULL DEFAULT '0',
46	`m_SpellShapeshiftId` INT NOT NULL DEFAULT '0',
47	`m_SpellTargetRestrictionsId` INT NOT NULL DEFAULT '0',
48	`m_SpellTotemsId` INT NOT NULL DEFAULT '0',
49	`m_ResearchProjectId` INT NOT NULL DEFAULT '0',
50	PRIMARY KEY (`m_ID`)
51) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Export of Spell.dbc';