custom_droplist.sql 446 B

1234567891011121314
  1. --
  2. -- Table structure for table `custom_droplist`
  3. --
  4. DROP TABLE IF EXISTS `custom_droplist`;
  5. CREATE TABLE `custom_droplist` (
  6. `mobId` INT NOT NULL DEFAULT '0',
  7. `itemId` INT NOT NULL DEFAULT '0',
  8. `min` INT NOT NULL DEFAULT '0',
  9. `max` INT NOT NULL DEFAULT '0',
  10. `category` INT NOT NULL DEFAULT '0',
  11. `chance` INT NOT NULL DEFAULT '0',
  12. PRIMARY KEY (`mobId`,`itemId`,`category`),
  13. KEY `key_mobId` (`mobId`)
  14. ) TYPE=MyISAM;