2 DROP TABLE IF EXISTS `spell_affect`;
3 CREATE TABLE `spell_affect` (
4 `entry` smallint(5) unsigned NOT NULL default '0',
5 `effectId` tinyint(3) unsigned NOT NULL default '0',
6 `SpellId` smallint(5) unsigned NOT NULL default '0',
7 `SchoolMask` tinyint(3) unsigned NOT NULL default '0',
8 `Category` smallint(5) unsigned NOT NULL default '0',
9 `SkillID` smallint(5) unsigned NOT NULL default '0',
10 `SpellFamily` tinyint(3) unsigned NOT NULL default '0',
11 `SpellFamilyMask` bigint(20) unsigned NOT NULL default '0',
12 `Charges` smallint(5) unsigned NOT NULL default '0',
13 PRIMARY KEY (`entry`,`effectId`)
14 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
17 DELETE FROM `spell_affect` WHERE `entry` IN (34936);
18 INSERT INTO `spell_affect` VALUES
19 (34936,0,0,0,0,0,0,274877906945,1);