1 ALTER TABLE db_version CHANGE COLUMN required_2008_12_22_08_mangos_milling_loot_template required_2008_12_22_09_mangos_spell_affect bit;
4 -- Table structure for table `spell_affect`
6 DROP TABLE IF EXISTS `spell_affect`;
7 CREATE TABLE `spell_affect` (
8 `entry` smallint(5) unsigned NOT NULL default '0',
9 `effectId` tinyint(3) unsigned NOT NULL default '0',
10 `SpellClassMask0` int(5) unsigned NOT NULL default '0',
11 `SpellClassMask1` int(5) unsigned NOT NULL default '0',
12 `SpellClassMask2` int(5) unsigned NOT NULL default '0',
13 PRIMARY KEY (`entry`,`effectId`)
14 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;