All pastes #1546663 Raw Edit

All v.62 Monster Drops - CioNide

public sql v1 · immutable
#1546663 ·published 2009-08-29 03:08 UTC
rendered paste body
-- MySQL Administrator dump 1.4---- -------------------------------------------------------- Server version	5.0.85-community-nt/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;---- Create schema odinms--CREATE DATABASE IF NOT EXISTS odinms;USE odinms;---- Definition of table `monsterdrops`--DROP TABLE IF EXISTS `monsterdrops`;CREATE TABLE `monsterdrops` (  `monsterdropid` int(10) unsigned NOT NULL auto_increment,  `monsterid` int(11) NOT NULL default '0',  `itemid` int(11) NOT NULL default '0',  `chance` int(11) NOT NULL default '0',  PRIMARY KEY  (`monsterdropid`),  UNIQUE KEY `monsterid` (`monsterid`,`itemid`),  UNIQUE KEY `monsterid_2` (`monsterid`,`itemid`),  UNIQUE KEY `monsterid_3` (`monsterid`,`itemid`),  UNIQUE KEY `monsterid_4` (`monsterid`,`itemid`),  UNIQUE KEY `monsterid_5` (`monsterid`,`itemid`),  UNIQUE KEY `monsterid_6` (`monsterid`,`itemid`)) ENGINE=InnoDB AUTO_INCREMENT=17715 DEFAULT CHARSET=latin1;---- Dumping data for table `monsterdrops`--/*!40000 ALTER TABLE `monsterdrops` DISABLE KEYS */;INSERT INTO `monsterdrops` (`monsterdropid`,`monsterid`,`itemid`,`chance`) VALUES  (17702,100101,4000000,5), (17703,100101,2041006,12000), (17704,100101,2000000,100), (17705,100101,4020001,600), (17706,100101,2060000,200), (17707,100101,4010001,600), (17708,100101,2061000,200), (17709,100101,1040013,2400), (17710,100101,1041012,2400), (17711,100101,1060004,2400), (17712,100101,1040017,2400), (17713,100101,1060013,2400), (17714,100101,2010009,100);/*!40000 ALTER TABLE `monsterdrops` ENABLE KEYS */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;