2 -- Table structure for table `reference_loot_template`
5 DROP TABLE IF EXISTS `reference_loot_template`;
6 CREATE TABLE `reference_loot_template` (
7 `entry` mediumint(8) unsigned NOT NULL default '0',
8 `item` mediumint(8) unsigned NOT NULL default '0',
9 `ChanceOrQuestChance` float NOT NULL default '100',
10 `groupid` tinyint(3) unsigned NOT NULL default '0',
11 `mincountOrRef` mediumint(9) NOT NULL default '1',
12 `maxcount` tinyint(3) unsigned NOT NULL default '1',
13 `lootcondition` tinyint(3) unsigned NOT NULL default '0',
14 `condition_value1` mediumint(8) unsigned NOT NULL default '0',
15 `condition_value2` mediumint(8) unsigned NOT NULL default '0',
16 PRIMARY KEY (`entry`,`item`)
17 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
20 -- Dumping data for table `reference_loot_template`
23 LOCK TABLES `reference_loot_template` WRITE;
24 /*!40000 ALTER TABLE `reference_loot_template` DISABLE KEYS */;
25 /*!40000 ALTER TABLE `reference_loot_template` ENABLE KEYS */;