1 CREATE TABLE `item_loot_template` (
2 `entry` int(11) unsigned NOT NULL default '0',
3 `item` int(11) unsigned NOT NULL default '0',
4 `chance` float NOT NULL default '100',
5 `questchance` float NOT NULL default '0',
6 `maxcount` int(11) unsigned NOT NULL default '1',
7 PRIMARY KEY (`entry`,`item`)
8 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';