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