1 ALTER TABLE db_version CHANGE COLUMN required_7133_01_mangos_skill_discovery_template required_7133_02_mangos_spell_loot_template bit;
3 DROP TABLE IF EXISTS `spell_loot_template`;
4 CREATE TABLE `spell_loot_template` (
5 `entry` mediumint(8) unsigned NOT NULL default '0',
6 `item` mediumint(8) unsigned NOT NULL default '0',
7 `ChanceOrQuestChance` float NOT NULL default '100',
8 `groupid` tinyint(3) unsigned NOT NULL default '0',
9 `mincountOrRef` mediumint(9) NOT NULL default '1',
10 `maxcount` tinyint(3) unsigned NOT NULL default '1',
11 `lootcondition` tinyint(3) unsigned NOT NULL default '0',
12 `condition_value1` mediumint(8) unsigned NOT NULL default '0',
13 `condition_value2` mediumint(8) unsigned NOT NULL default '0',
14 PRIMARY KEY (`entry`,`item`)
15 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';