/*
SQLyog Community Edition- MySQL GUI v7.14 
MySQL - 5.0.75-0ubuntu10.2-log : Database - realms
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`realms` /*!40100 DEFAULT CHARACTER SET latin1 */;

/*Table structure for table `alchemical_items` */

DROP TABLE IF EXISTS `alchemical_items`;

CREATE TABLE `alchemical_items` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `plural` varchar(255) default NULL,
  `value` int(11) default NULL,
  `prefix` varchar(100) default NULL,
  `plural_prefix` varchar(100) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

/*Data for the table `alchemical_items` */

insert  into `alchemical_items`(`id`,`name`,`plural`,`value`,`prefix`,`plural_prefix`) values (1,'alchemist\'s fire','alchemist\'s fire',20,'a flask of','flasks of'),(2,'acid','acid',10,'a flask of','flasks of'),(3,'smokestick','smokesticks',20,'a',''),(4,'holy water','holy water',25,'a flask of','flasks of'),(5,'antitoxin','antitoxin',50,'a vial of','vials of'),(6,'everburning torch','everburning torches',100,'an',''),(7,'tanglefoot bag','tanglefoot bags',50,'a',''),(8,'thunderstone','thunderstones',30,'a','');

/*Table structure for table `ammunition` */

DROP TABLE IF EXISTS `ammunition`;

CREATE TABLE `ammunition` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `weapon_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `ammunition` */

insert  into `ammunition`(`id`,`dice_lower`,`dice_upper`,`weapon_id`) values (1,1,50,69),(2,51,75,70),(3,76,80,71),(4,81,100,72);

/*Table structure for table `armor` */

DROP TABLE IF EXISTS `armor`;

CREATE TABLE `armor` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `plural` varchar(255) default NULL,
  `value` int(11) default NULL,
  `prefix` varchar(100) default NULL,
  `plural_prefix` varchar(100) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

/*Data for the table `armor` */

insert  into `armor`(`id`,`name`,`plural`,`value`,`prefix`,`plural_prefix`) values (1,'padded armor','padded armor',5,'a [size]set of','[size]sets of'),(2,'leather armor','leather armor',10,'a [size]set of','[size]sets of'),(3,'studded leather armor','studded leather armor',25,'a [size]set of','[size]sets of'),(4,'chain shirt','chain shirts',100,'a [size]','[size]'),(5,'hide armor','hide armor',15,'a [size]set of','[size]sets of'),(6,'scale mail','scale mail',50,'a [size]set of','[size]sets of'),(7,'chainmail','chainmail',150,'a [size]set of','[size]sets of'),(8,'breastplate','breastplates',200,'a [size]','[size]'),(9,'splint mail','spint mail',200,'a [size]set of','[size]sets of'),(10,'banded mail','banded mail',250,'a [size]set of','[size]sets of'),(11,'half-plate armor','half-plate armor',600,'a [size]set of','[size]sets of'),(12,'full plate armor','full plate armor',1500,'a [size]set of','[size]sets of'),(13,'buckler','bucklers',15,'a [size]','[size]'),(14,'light wooden shield','light wooden shields',3,'a [size]','[size]'),(15,'light steel shield','light steel shields',9,'a [size]','[size]'),(16,'heavy wooden shield','heavy wooden shields',7,'a [size]','[size]'),(17,'heavy steel shield','heavy steel shields',20,'a [size]','[size]'),(18,'tower shield','tower shields',30,'a [size]','[size]'),(19,'darkwood buckler','darkwood bucklers',205,'a [size]','[size]'),(20,'darkwood shield','darkwood shields',257,'a [size]','[size]');

/*Table structure for table `armor_sizes` */

DROP TABLE IF EXISTS `armor_sizes`;

CREATE TABLE `armor_sizes` (
  `id` int(11) NOT NULL auto_increment,
  `name` enum('small','medium') default NULL,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `armor_sizes` */

insert  into `armor_sizes`(`id`,`name`,`dice_lower`,`dice_upper`) values (1,'small',1,10),(2,'medium',11,100);

/*Table structure for table `armor_special_abilities` */

DROP TABLE IF EXISTS `armor_special_abilities`;

CREATE TABLE `armor_special_abilities` (
  `id` int(11) NOT NULL auto_increment,
  `power` enum('minor','medium','major') default NULL,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `name` char(255) default NULL,
  `value` int(11) default NULL,
  `bonus` tinyint(4) default NULL,
  `level` tinyint(4) default NULL,
  `type` char(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

/*Data for the table `armor_special_abilities` */

insert  into `armor_special_abilities`(`id`,`power`,`dice_lower`,`dice_upper`,`name`,`value`,`bonus`,`level`,`type`) values (1,'minor',1,25,'glamered',2700,NULL,1,'glamered'),(2,'minor',26,32,'light fortification',NULL,1,1,'fortification'),(4,'minor',33,52,'slick',3750,NULL,1,'slick'),(5,'minor',53,72,'shadow',3750,NULL,1,'shadow'),(6,'minor',73,92,'silent moves',3750,NULL,1,'silent moves'),(7,'minor',93,96,'spell resistance (13)',NULL,2,1,'spell resistance'),(8,'minor',97,97,'improved slick',15000,NULL,2,'slick'),(9,'minor',98,98,'improved shadow',15000,NULL,2,'shadow'),(10,'minor',99,99,'improved silent moves',15000,NULL,2,'silent moves'),(11,'minor',100,100,'roll twice',NULL,NULL,NULL,NULL);

/*Table structure for table `art_names` */

DROP TABLE IF EXISTS `art_names`;

CREATE TABLE `art_names` (
  `id` int(11) NOT NULL auto_increment,
  `art_value_id` int(11) default NULL,
  `name` varchar(255) default NULL,
  `plural` varchar(255) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

/*Data for the table `art_names` */

insert  into `art_names`(`id`,`art_value_id`,`name`,`plural`) values (1,1,'a silver ewer','silver ewers'),(2,1,'a carved bone statuette','carved bone statuettes'),(3,1,'a carved ivory statuette','carved ivory statuette'),(4,1,'a finely wrought small gold bracelet','finely wrought small gold bracelets'),(5,2,'a set of cloth of gold vestments','sets of cloth of gold vestments'),(6,2,'a black velvet mask with numerous citrines','black velvet masks with numerous citrines'),(7,2,'a silver chalice with lapis lazuli gems','silver chalices with lapis lazuli gems'),(8,3,'a large well-done wool tapestry','large well-done wool tapestries'),(9,3,'a brass mug with jade inlays','brass mugs with jade inlays'),(10,4,'a silver comb with moonstones','silver combs with moonstones'),(11,4,'a silver-plated steel longsword with jet jewels in hilt','silver plated steel longswords with jet jewels in hilt'),(12,5,'a carved harp of exotic wood with ivory inlay and zircon gems','carved harps of exotic wood with ivory inlay and zircon gems'),(13,5,'a 10 lb. solid gold idol','10 lb. solid gold idols'),(14,6,'a gold dragon comb with red garnet eye','gold dragon combs with red garnet eyes'),(15,6,'a gold and topaz bottle stopper cork','gold and topaz bottle stopper corks'),(16,6,'a ceremonial electrum dagger with a star ruby in the pommel','ceremonial electrum daggers with star rubies in the pommels'),(17,7,'an eyepatch with a mock eye of sapphire and moonstone','eyepatches with mock eyes of sapphire and moonstone'),(18,7,'a fire opal pendant on a fine gold chain','fire opal pendants on fine gold chains'),(19,7,'an old masterpiece painting','old masterpiece paintings'),(20,8,'an embroidered silk and velvet mantle with numerous moonstones','embroidered silk and velvet mantles with numerous moonstones'),(21,8,'a sapphire pendant on gold chain','sapphire pendants on gold chains'),(22,9,'an embroidered and bejeweled glove','embroidered and bejeweled gloves'),(23,9,'a jeweled anklet','jeweled anklets'),(24,9,'a gold music box','gold music boxes'),(25,10,'a golden circlet with four aquamarines','golden circlets with four aquamarines each'),(26,10,'a string of small pink pearls','strings of small pink pearls'),(27,11,'a jeweled gold crown','jeweled gold crowns'),(28,11,'a jeweled electrum ring','jeweled electrum rings'),(29,12,'a gold and ruby ring','gold and ruby rings'),(30,12,'a gold cup set with emeralds','gold cups set with emeralds');

/*Table structure for table `art_values` */

DROP TABLE IF EXISTS `art_values`;

CREATE TABLE `art_values` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `average_value` int(11) default NULL,
  `dice_number` int(11) default NULL,
  `dice_sides` tinyint(4) default NULL,
  `multiplier` int(11) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

/*Data for the table `art_values` */

insert  into `art_values`(`id`,`dice_lower`,`dice_upper`,`average_value`,`dice_number`,`dice_sides`,`multiplier`) values (1,1,10,55,1,10,10),(2,11,25,105,3,6,10),(3,26,40,350,1,6,100),(4,41,50,550,1,10,100),(5,51,60,700,2,6,100),(6,61,70,1050,3,6,100),(7,71,80,1400,4,6,100),(8,81,85,1750,5,6,100),(9,86,90,2500,1,4,1000),(10,91,95,3500,1,6,1000),(11,96,99,5000,2,4,1000),(12,100,100,7000,2,6,1000);

/*Table structure for table `common_melee_weapons` */

DROP TABLE IF EXISTS `common_melee_weapons`;

CREATE TABLE `common_melee_weapons` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `weapon_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

/*Data for the table `common_melee_weapons` */

insert  into `common_melee_weapons`(`id`,`dice_lower`,`dice_upper`,`weapon_id`) values (1,1,4,1),(2,5,14,2),(3,15,24,3),(4,25,28,4),(5,29,41,5),(6,42,45,6),(7,46,50,7),(8,51,54,8),(9,55,57,9),(10,58,61,10),(11,62,66,11),(12,67,70,12),(13,71,74,13),(14,75,84,14),(15,85,89,15),(16,90,100,16);

/*Table structure for table `common_ranged_weapons` */

DROP TABLE IF EXISTS `common_ranged_weapons`;

CREATE TABLE `common_ranged_weapons` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `type` char(100) default NULL,
  `weapon_id` int(11) default NULL,
  `str_bonus` tinyint(4) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

/*Data for the table `common_ranged_weapons` */

insert  into `common_ranged_weapons`(`id`,`dice_lower`,`dice_upper`,`type`,`weapon_id`,`str_bonus`) values (1,1,10,'ammunition',NULL,NULL),(2,11,15,'weapon',59,NULL),(3,16,25,'weapon',60,NULL),(4,26,35,'weapon',61,NULL),(5,36,39,'weapon',62,NULL),(6,40,41,'weapon',63,NULL),(7,42,46,'weapon',64,NULL),(8,47,51,'weapon',67,NULL),(9,52,56,'weapon',67,1),(10,57,61,'weapon',67,2),(11,62,65,'weapon',65,NULL),(12,66,75,'weapon',66,NULL),(13,76,80,'weapon',68,NULL),(14,81,85,'weapon',68,1),(15,86,90,'weapon',68,2),(16,91,95,'weapon',68,3),(17,96,100,'weapon',68,4);

/*Table structure for table `darkwood_shields` */

DROP TABLE IF EXISTS `darkwood_shields`;

CREATE TABLE `darkwood_shields` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `armor_id` int(11) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `darkwood_shields` */

insert  into `darkwood_shields`(`id`,`dice_lower`,`dice_upper`,`armor_id`) values (1,1,50,19),(2,51,100,20);

/*Table structure for table `gear` */

DROP TABLE IF EXISTS `gear`;

CREATE TABLE `gear` (
  `id` int(11) NOT NULL auto_increment,
  `name` char(255) default NULL,
  `plural` char(255) default NULL,
  `prefix` char(100) default NULL,
  `plural_prefix` char(100) default NULL,
  `value` decimal(14,4) default NULL,
  `unit` char(100) default NULL,
  `quantity` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

/*Data for the table `gear` */

insert  into `gear`(`id`,`name`,`plural`,`prefix`,`plural_prefix`,`value`,`unit`,`quantity`) values (1,'backpack','backpacks','a','','2.0000',NULL,NULL),(2,'crowbar','crowbars','a','','2.0000',NULL,NULL),(3,'bullseye lantern','bullseye lanterns','a','','12.0000',NULL,NULL),(4,'simple lock','simple locks','a','','20.0000',NULL,NULL),(5,'average lock','average locks','an','','40.0000',NULL,NULL),(6,'good lock','good locks','a','','80.0000',NULL,NULL),(7,'superior lock','superior locks','a','','150.0000',NULL,NULL),(8,'masterwork manacles','masterwork manacles','a set of','sets of','50.0000',NULL,NULL),(9,'small steal mirror','small steal mirrors','a','','10.0000',NULL,NULL),(10,'silk rope','silk rope','','','10.0000','ft.',50),(11,'spyglass','spyglasses','a','','1000.0000',NULL,NULL),(12,'masterwork artisan\'s tools','masterwork artisan\'s tools','a set of','sets of','55.0000',NULL,NULL),(13,'climber\'s kit','climber\'s kits','a','','80.0000',NULL,NULL),(14,'disguise kit','disguise kits','a','','50.0000',NULL,NULL),(15,'healer\'s kit','healer\'s kits','a','','50.0000',NULL,NULL),(16,'silver holy symbol','silver holy symbols','a','','25.0000',NULL,NULL),(17,'hourglass','hourglasses','an','','25.0000',NULL,NULL),(18,'magnifying glass','magnifying glasses','a','','100.0000',NULL,NULL),(19,'masterwork musical instrument','masterwork musical instruments','a','','100.0000',NULL,NULL),(20,'masterwork thieves\' tools','masterwork thieves\' tools','a set of','sets of','50.0000',NULL,NULL);

/*Table structure for table `gem_names` */

DROP TABLE IF EXISTS `gem_names`;

CREATE TABLE `gem_names` (
  `id` int(11) NOT NULL auto_increment,
  `gem_value_id` int(11) default NULL,
  `name` varchar(100) default NULL,
  `plural` varchar(100) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;

/*Data for the table `gem_names` */

insert  into `gem_names`(`id`,`gem_value_id`,`name`,`plural`) values (1,1,'a banded agate','banded agates'),(2,1,'an eye agate','eye agates'),(3,1,'a moss agate','moss agates'),(4,1,'an azurite','azurites'),(5,1,'a blue quartz','blue quartzes'),(6,1,'a hematite','hematites'),(7,1,'a lapis lazuli','lapis lazulis'),(8,1,'a malachite','malachites'),(9,1,'an obsidian','obsidians'),(10,1,'a rhodochrosite','rhodochrosites'),(11,1,'a tiger eye turquoise','tiger eye turquoises'),(12,1,'a freshwater pearl','freshwater pearls'),(13,2,'a bloodstone','bloodstones'),(14,2,'a carnelian','carnelians'),(15,2,'a chalcedony','chalcedonies'),(16,2,'a chrysoprase','chrysoprases'),(17,2,'a citrine','citrines'),(18,2,'an iolite','iolites'),(19,2,'a jasper','jaspers'),(20,2,'a moonstone','moonstones'),(21,2,'an onyx','onyxes'),(22,2,'a peridot','peridots'),(23,2,'a rock crystal','rock crystals'),(24,2,'a sard','sards'),(25,2,'a sardonyx','sardonyxes'),(26,2,'a rose quartz','rose quartzes'),(27,2,'a smoky quartz','smoky quartzes'),(28,2,'a star rose quartz','star rose quartzes'),(29,2,'a zircon','zircons'),(30,3,'an amber','ambers'),(31,3,'an amethyst','amethysts'),(32,3,'a chrysoberyl','chrysoberyls'),(33,3,'a coral','corals'),(34,3,'a red garnet','red garnets'),(35,3,'a brown-green garnet','brown-green garnet'),(36,3,'a jade','jades'),(37,3,'a jet','jets'),(38,3,'a white pearl','white pearls'),(39,3,'a golden pearl','golden pearls'),(40,3,'a pink pearl','pink pearls'),(41,3,'a silver pearl','silver pearls'),(42,3,'a red spinel','red spinels'),(43,3,'a red-brown spinel','red-brown spinels'),(44,3,'a deep green spinel','deep green spinels'),(45,3,'a tourmaline','tourmalines'),(46,4,'an alexandrite','alexandrites'),(47,4,'an aquamarine','aquamarines'),(48,4,'a violet garnet','violet garnets'),(49,4,'a black pearl','black pearls'),(50,4,'a deep blue spinel','deep blue spinnels'),(51,4,'a golden yellow topaz','golden yellow topazes'),(52,5,'an emerald','emeralds'),(53,5,'a white opal','white opals'),(54,5,'a black opal','black opals'),(55,5,'a fire opal','fire opals'),(56,5,'a blue sapphire','blue sapphires'),(57,5,'a fiery yellow corundum','fiery yellow corundums'),(58,5,'a rich purple corundum','rich purple corundums'),(59,5,'a blue star sapphire','blue star sapphire'),(60,5,'a black star sapphire','black star sapphire'),(61,5,'a star ruby','star rubies'),(62,6,'a clearest bright green emerald','clearest bright green emeralds'),(63,6,'a blue-white diamond','blue-white diamonds'),(64,6,'a canary diamond','canary diamonds'),(65,6,'a pink diamond','pink diamonds'),(66,6,'a brown diamond','brown diamonds'),(67,6,'a blue diamond','blue diamonds'),(68,6,'a jacinth','jacinths'),(78,1,'a fluorspar','fluorspars'),(77,1,'a crown of silver gemstone','crown of silver gemstones'),(76,1,'a tiger eye agate','tiger eye agates'),(75,1,'a fire agate','fire agates'),(79,1,'a greenstone','greenstones'),(80,1,'a hyaline','hyalines'),(81,1,'a piece of ivory','pieces of ivory'),(82,1,'a nelvine','nelvines'),(83,1,'a sanidine','sanidines'),(84,1,'a turqoise','turqoises'),(85,1,'a violine','violines'),(86,2,'an andar','andars'),(87,2,'an adventurine','adventurines'),(88,2,'a hydrophane','hydrophanes'),(89,2,'an iol','iols'),(90,2,'an irtios','irtioses'),(91,2,'an orprase','orprases'),(92,2,'a phenalope','phenalopes'),(93,2,'a rock crystal quartz','rock crystal quartzes'),(94,2,'a spodumene','spodumenes'),(95,2,'a tchazar','tchazars'),(96,3,'an angelar\'s skin gemstone','angelar\'s skin gemstones'),(97,3,'a Laeral\'s tears','Laeral\'s tears'),(98,3,'a white tourmaline','white tourmalines'),(99,3,'a golden tourmaline','golden tourmalines'),(100,3,'a pink tourmaline','pink tourmalines'),(101,3,'a silver pearl tourmaline','silver pearl tourmalines'),(102,3,'a waterstar','waterstars'),(103,5,'a black corundum','black corundums'),(104,5,'a blue corundum','blue corundums'),(105,5,'a water opal','water opals'),(106,5,'an orl','orls'),(107,5,'a ravenar','ravenars'),(108,5,'a red tears','red tears'),(109,5,'a sapphire','sapphires'),(110,5,'a tomb jade','tomb jades');

/*Table structure for table `gem_realms` */

DROP TABLE IF EXISTS `gem_realms`;

CREATE TABLE `gem_realms` (
  `id` int(11) NOT NULL auto_increment,
  `gem_name_id` int(11) NOT NULL,
  `realm_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=170 DEFAULT CHARSET=latin1;

/*Data for the table `gem_realms` */

insert  into `gem_realms`(`id`,`gem_name_id`,`realm_id`) values (1,1,1),(2,1,2),(3,2,1),(4,2,2),(5,3,1),(6,3,2),(7,4,1),(8,4,2),(9,5,1),(10,5,2),(11,6,1),(12,6,2),(13,7,1),(14,7,2),(15,8,1),(16,8,2),(17,9,1),(18,9,2),(19,10,1),(20,10,2),(21,11,1),(23,12,1),(24,12,2),(25,13,1),(26,13,2),(27,14,1),(28,14,2),(29,15,1),(30,15,2),(31,16,1),(32,16,2),(33,17,1),(34,17,2),(35,18,1),(36,18,2),(37,19,1),(38,19,2),(39,20,1),(40,20,2),(41,21,1),(42,22,2),(43,23,1),(45,24,1),(46,24,2),(47,25,1),(48,25,2),(49,26,1),(50,26,2),(51,27,1),(52,27,2),(53,28,1),(54,28,2),(55,29,1),(56,29,2),(57,30,1),(58,30,2),(59,31,1),(60,31,2),(61,32,1),(62,32,2),(63,33,1),(64,33,2),(65,34,1),(66,34,2),(67,35,1),(68,35,2),(69,36,1),(70,36,2),(71,37,1),(72,37,2),(73,38,1),(74,38,2),(75,39,1),(76,39,2),(77,40,1),(78,40,2),(79,41,1),(80,41,2),(81,42,1),(82,42,2),(83,43,1),(84,43,2),(85,44,1),(86,44,2),(87,45,1),(89,46,1),(90,46,2),(91,47,1),(92,47,2),(93,48,1),(94,48,2),(95,49,1),(96,49,2),(97,50,1),(98,50,2),(99,51,1),(100,51,2),(101,52,1),(102,52,2),(103,53,1),(104,53,2),(105,54,1),(106,54,2),(107,55,1),(108,55,2),(109,56,1),(111,57,1),(112,57,2),(113,58,1),(114,59,1),(115,59,2),(116,60,1),(117,60,2),(118,61,1),(119,61,2),(120,62,1),(121,62,2),(122,63,1),(123,63,2),(124,64,1),(125,64,2),(126,65,1),(127,65,2),(128,66,1),(129,66,2),(130,67,1),(131,67,2),(132,68,1),(133,68,2),(134,75,2),(135,76,2),(136,77,2),(137,78,2),(138,79,2),(139,80,2),(140,81,2),(141,82,2),(142,83,2),(143,84,2),(144,85,2),(145,86,2),(146,87,2),(147,88,2),(148,89,2),(149,90,2),(150,91,2),(151,92,2),(152,93,2),(153,94,2),(154,95,2),(155,96,2),(156,97,2),(157,98,2),(158,99,2),(159,100,2),(160,101,2),(161,102,2),(162,103,2),(163,104,2),(164,105,2),(165,106,2),(166,107,2),(167,108,2),(168,109,2),(169,110,2);

/*Table structure for table `gem_values` */

DROP TABLE IF EXISTS `gem_values`;

CREATE TABLE `gem_values` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `average_value` int(11) default NULL,
  `dice_number` int(11) default NULL,
  `dice_sides` tinyint(4) default NULL,
  `multiplier` int(11) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

/*Data for the table `gem_values` */

insert  into `gem_values`(`id`,`dice_lower`,`dice_upper`,`average_value`,`dice_number`,`dice_sides`,`multiplier`) values (1,1,24,10,4,4,1),(2,26,50,50,2,4,10),(3,51,70,100,4,4,100),(4,71,90,500,2,4,100),(5,91,99,1000,4,4,100),(6,100,100,5000,2,4,1000);

/*Table structure for table `magic_armor` */

DROP TABLE IF EXISTS `magic_armor`;

CREATE TABLE `magic_armor` (
  `id` int(11) NOT NULL auto_increment,
  `power` enum('minor','medium','major') default NULL,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `lookup_type` enum('shields','armor','specific_armor','specific_shields','special') default NULL,
  `bonus` tinyint(4) default NULL,
  `base_price` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Data for the table `magic_armor` */

insert  into `magic_armor`(`id`,`power`,`dice_lower`,`dice_upper`,`lookup_type`,`bonus`,`base_price`) values (1,'minor',1,60,'shields',1,1000),(2,'minor',61,80,'armor',1,1000),(3,'minor',81,85,'shields',2,4000),(4,'minor',86,87,'armor',2,4000),(5,'minor',88,89,'specific_armor',NULL,NULL),(6,'minor',90,91,'specific_shields',NULL,NULL),(7,'minor',92,100,'special',NULL,NULL);

/*Table structure for table `magic_items` */

DROP TABLE IF EXISTS `magic_items`;

CREATE TABLE `magic_items` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) NOT NULL,
  `dice_upper` tinyint(4) NOT NULL,
  `power` enum('minor','medium','major') NOT NULL,
  `lookup_type` char(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Data for the table `magic_items` */

insert  into `magic_items`(`id`,`dice_lower`,`dice_upper`,`power`,`lookup_type`) values (1,1,4,'minor','armor'),(2,5,9,'minor','weapons'),(3,10,44,'minor','potions'),(4,45,46,'minor','rings'),(5,47,81,'minor','scrolls'),(6,82,91,'minor','wands'),(7,92,100,'minor','wondrous_items');

/*Table structure for table `masterwork_shields` */

DROP TABLE IF EXISTS `masterwork_shields`;

CREATE TABLE `masterwork_shields` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `armor_id` int(11) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Data for the table `masterwork_shields` */

insert  into `masterwork_shields`(`id`,`dice_lower`,`dice_upper`,`armor_id`) values (1,1,17,13),(2,18,40,14),(3,41,60,15),(4,61,83,16),(5,84,100,17);

/*Table structure for table `mundane_alchemical_items` */

DROP TABLE IF EXISTS `mundane_alchemical_items`;

CREATE TABLE `mundane_alchemical_items` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `dice_number` int(11) default NULL,
  `dice_sides` tinyint(4) default NULL,
  `alchemical_item_id` int(11) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

/*Data for the table `mundane_alchemical_items` */

insert  into `mundane_alchemical_items`(`id`,`dice_lower`,`dice_upper`,`dice_number`,`dice_sides`,`alchemical_item_id`) values (1,1,12,1,4,1),(2,13,24,2,4,2),(3,25,36,1,4,3),(4,37,48,1,4,4),(5,49,62,1,4,5),(6,63,74,1,1,6),(7,75,88,1,4,7),(8,89,100,1,4,8);

/*Table structure for table `mundane_armor` */

DROP TABLE IF EXISTS `mundane_armor`;

CREATE TABLE `mundane_armor` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `lookup_type` enum('armor','masterwork armor','darkwood shield','masterwork shield') default NULL,
  `lookup_id` int(11) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

/*Data for the table `mundane_armor` */

insert  into `mundane_armor`(`id`,`dice_lower`,`dice_upper`,`lookup_type`,`lookup_id`) values (1,1,12,'armor',4),(2,13,18,'masterwork armor',3),(3,19,26,'armor',8),(4,27,34,'armor',10),(5,35,54,'armor',11),(6,55,80,'armor',12),(7,81,90,'darkwood shield',NULL),(8,91,100,'masterwork shield',NULL);

/*Table structure for table `mundane_gear` */

DROP TABLE IF EXISTS `mundane_gear`;

CREATE TABLE `mundane_gear` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `gear_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

/*Data for the table `mundane_gear` */

insert  into `mundane_gear`(`id`,`dice_lower`,`dice_upper`,`gear_id`) values (1,1,3,1),(2,4,6,2),(3,7,11,3),(4,12,16,4),(5,17,21,5),(6,22,28,6),(7,29,35,7),(8,36,40,8),(9,41,43,9),(10,44,46,10),(11,47,53,11),(12,54,58,12),(13,59,63,13),(14,64,68,14),(15,69,73,15),(16,74,77,16),(17,78,81,17),(18,82,88,18),(19,89,95,19),(20,96,100,20);

/*Table structure for table `mundane_treasure` */

DROP TABLE IF EXISTS `mundane_treasure`;

CREATE TABLE `mundane_treasure` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `lookup_type` char(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `mundane_treasure` */

insert  into `mundane_treasure`(`id`,`dice_lower`,`dice_upper`,`lookup_type`) values (1,1,17,'alchemical_items'),(2,18,50,'armor'),(3,51,83,'weapons'),(4,84,100,'tools_and_gear');

/*Table structure for table `mundane_weapons` */

DROP TABLE IF EXISTS `mundane_weapons`;

CREATE TABLE `mundane_weapons` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `type` char(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*Data for the table `mundane_weapons` */

insert  into `mundane_weapons`(`id`,`dice_lower`,`dice_upper`,`type`) values (1,1,50,'common melee'),(2,51,70,'uncommon'),(3,71,100,'common ranged');

/*Table structure for table `random_armor` */

DROP TABLE IF EXISTS `random_armor`;

CREATE TABLE `random_armor` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `armor_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

/*Data for the table `random_armor` */

insert  into `random_armor`(`id`,`dice_lower`,`dice_upper`,`armor_id`) values (1,1,1,1),(2,2,2,2),(3,3,17,3),(4,18,32,4),(5,33,42,5),(6,43,43,6),(7,44,44,7),(8,45,57,8),(9,58,58,9),(10,59,59,10),(11,60,60,11),(12,61,100,12);

/*Table structure for table `random_shields` */

DROP TABLE IF EXISTS `random_shields`;

CREATE TABLE `random_shields` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `armor_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

/*Data for the table `random_shields` */

insert  into `random_shields`(`id`,`dice_lower`,`dice_upper`,`armor_id`) values (1,1,10,13),(2,11,15,14),(3,16,20,15),(4,21,30,16),(5,31,95,17),(6,96,100,18);

/*Table structure for table `realms` */

DROP TABLE IF EXISTS `realms`;

CREATE TABLE `realms` (
  `id` int(11) NOT NULL auto_increment,
  `name` char(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `realms` */

insert  into `realms`(`id`,`name`) values (1,'Core'),(2,'Forgotten Realms');

/*Table structure for table `scroll_spells` */

DROP TABLE IF EXISTS `scroll_spells`;

CREATE TABLE `scroll_spells` (
  `id` int(11) NOT NULL auto_increment,
  `type` enum('arcane','divine') default NULL,
  `level` tinyint(4) default NULL,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `name` char(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;

/*Data for the table `scroll_spells` */

insert  into `scroll_spells`(`id`,`type`,`level`,`dice_lower`,`dice_upper`,`name`) values (1,'divine',2,1,1,'animal messenger'),(2,'divine',2,2,2,'animal trance'),(3,'divine',2,3,4,'augury'),(4,'divine',2,5,6,'barkskin'),(5,'divine',2,7,9,'bear\'s endurance'),(6,'divine',2,10,12,'bull\'s strength'),(7,'divine',2,13,14,'calm emotions'),(8,'divine',2,15,17,'cat\'s grace'),(9,'divine',2,18,18,'chill metal'),(10,'divine',2,19,20,'consecrate'),(11,'divine',2,21,24,'cure moderate wounds'),(12,'divine',2,25,26,'darkness'),(13,'divine',2,27,27,'death kneel'),(14,'divine',2,28,30,'delay poison'),(15,'divine',2,31,32,'desecreate'),(16,'divine',2,33,35,'eagle\'s splendor'),(17,'divine',2,36,37,'enthrall'),(18,'divine',2,38,39,'find traps'),(19,'divine',2,40,40,'fire trap'),(20,'divine',2,41,42,'flame blade'),(21,'divine',2,43,44,'flaming sphere'),(22,'divine',2,45,46,'fog cloud'),(23,'divine',2,47,47,'gentle repose'),(24,'divine',2,48,48,'gust of wind'),(25,'divine',2,49,49,'heat metal'),(26,'divine',2,50,51,'hold animal'),(27,'divine',2,52,54,'hold person'),(28,'divine',2,55,56,'inflict moderate wounds'),(29,'divine',2,57,58,'make whole'),(30,'divine',2,59,61,'owl\'s wisdom'),(31,'divine',2,62,62,'reduce animal'),(32,'divine',2,63,64,'remove paralysis'),(33,'divine',2,65,67,'resist energy'),(34,'divine',2,68,70,'lesser restoration'),(35,'divine',2,71,72,'shatter'),(36,'divine',2,73,74,'shield other'),(37,'divine',2,75,76,'silence'),(38,'divine',2,77,77,'snare'),(39,'divine',2,78,78,'soften earth and stone'),(40,'divine',2,79,80,'sound burst'),(41,'divine',2,81,81,'speak with plants'),(42,'divine',2,82,83,'spider climb'),(43,'divine',2,84,85,'spiritual weapon'),(44,'divine',2,86,86,'status'),(45,'divine',2,87,88,'summon monster II'),(46,'divine',2,89,90,'summon nature\'s ally II'),(47,'divine',2,91,92,'summon swarm'),(48,'divine',2,93,93,'tree shape'),(49,'divine',2,94,95,'undetectable alignment'),(50,'divine',2,96,97,'warp wood'),(51,'divine',2,98,98,'wood shape'),(52,'divine',2,99,100,'zone of truth');

/*Table structure for table `scrolls` */

DROP TABLE IF EXISTS `scrolls`;

CREATE TABLE `scrolls` (
  `id` int(11) NOT NULL auto_increment,
  `power` enum('minor','medium','major') default NULL,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `level` tinyint(4) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `scrolls` */

insert  into `scrolls`(`id`,`power`,`dice_lower`,`dice_upper`,`level`) values (1,'medium',1,5,2),(2,'medium',6,65,3),(3,'medium',66,95,4),(4,'medium',96,100,5);

/*Table structure for table `shield_special_abilities` */

DROP TABLE IF EXISTS `shield_special_abilities`;

CREATE TABLE `shield_special_abilities` (
  `id` int(11) NOT NULL auto_increment,
  `power` enum('minor','medium','major') default NULL,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `name` char(255) default NULL,
  `value` int(11) default NULL,
  `bonus` tinyint(4) default NULL,
  `level` tinyint(4) default NULL,
  `type` char(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

/*Data for the table `shield_special_abilities` */

insert  into `shield_special_abilities`(`id`,`power`,`dice_lower`,`dice_upper`,`name`,`value`,`bonus`,`level`,`type`) values (1,'minor',1,20,'arrow catching',NULL,1,1,'arrow catching'),(2,'minor',21,40,'bashing',NULL,1,1,'bashing'),(3,'minor',41,50,'blinding',NULL,1,1,'blinding'),(4,'minor',51,75,'light fortification',NULL,1,1,'fortification'),(5,'minor',76,92,'arrow deflection',NULL,2,1,'arrow deflection'),(6,'minor',93,97,'animated',NULL,2,1,'animated'),(7,'minor',98,99,'spell resistance (13)',NULL,2,1,'spell resistance'),(8,'minor',100,100,'roll twice',NULL,NULL,NULL,NULL);

/*Table structure for table `specific_armor` */

DROP TABLE IF EXISTS `specific_armor`;

CREATE TABLE `specific_armor` (
  `id` int(11) NOT NULL auto_increment,
  `power` enum('minor','medium','major') default NULL,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `name` char(255) default NULL,
  `plural` char(255) default NULL,
  `value` int(11) default NULL,
  `prefix` char(255) default NULL,
  `plural_prefix` char(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*Data for the table `specific_armor` */

insert  into `specific_armor`(`id`,`power`,`dice_lower`,`dice_upper`,`name`,`plural`,`value`,`prefix`,`plural_prefix`) values (1,'minor',1,50,'mithral shirt','mithral shirts',1100,'a',''),(2,'minor',51,80,'dragonhide plate','dragonhide plate',3300,'a set of','sets of'),(3,'minor',81,100,'elven chain','elven chain',4150,'a set of','sets of');

/*Table structure for table `specific_shields` */

DROP TABLE IF EXISTS `specific_shields`;

CREATE TABLE `specific_shields` (
  `id` int(11) NOT NULL auto_increment,
  `power` enum('minor','medium','major') default NULL,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `name` char(255) default NULL,
  `plural` char(255) default NULL,
  `value` int(11) default NULL,
  `prefix` char(255) default NULL,
  `plural_prefix` char(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `specific_shields` */

insert  into `specific_shields`(`id`,`power`,`dice_lower`,`dice_upper`,`name`,`plural`,`value`,`prefix`,`plural_prefix`) values (1,'minor',1,30,'darkwood buckler','darkwood bucklers',205,'a',''),(2,'minor',31,80,'darkwood shield','darkwood shields',257,'a',''),(3,'minor',81,95,'mithral heavy shield','mithral heavy shields',1020,'a',''),(4,'minor',96,100,'caster\'s shield','caster\'s shields',3153,'a','');

/*Table structure for table `treasure_listings` */

DROP TABLE IF EXISTS `treasure_listings`;

CREATE TABLE `treasure_listings` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `treasure_subtype_id` int(11) default NULL,
  `dice_number` smallint(6) default NULL,
  `dice_sides` tinyint(4) default NULL,
  `multiplier` int(11) default NULL,
  `el` tinyint(4) default NULL,
  `addend` int(11) default NULL,
  UNIQUE KEY `treasure_listing_id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=210 DEFAULT CHARSET=latin1;

/*Data for the table `treasure_listings` */

insert  into `treasure_listings`(`id`,`dice_lower`,`dice_upper`,`treasure_subtype_id`,`dice_number`,`dice_sides`,`multiplier`,`el`,`addend`) values (1,1,14,11,0,0,0,1,0),(2,15,29,1,1,6,1000,1,0),(3,30,52,2,1,8,100,1,0),(4,53,95,3,2,8,10,1,0),(5,96,100,4,1,4,10,1,0),(6,1,90,12,0,0,0,1,0),(7,91,95,5,1,1,1,1,0),(8,96,100,6,1,1,1,1,0),(9,1,71,13,0,0,0,1,0),(10,72,95,7,1,1,1,1,0),(11,96,100,8,1,1,1,1,0),(12,1,13,11,0,0,0,2,0),(13,14,23,1,1,10,1000,2,0),(14,24,43,2,2,10,100,2,0),(15,44,95,3,4,10,10,2,0),(16,96,100,4,1,8,10,2,0),(17,1,81,12,0,0,0,2,0),(18,82,95,5,1,3,1,2,0),(19,96,100,6,1,3,1,2,0),(20,1,49,13,0,0,0,2,0),(21,50,85,7,1,1,1,2,0),(22,86,100,8,1,1,1,2,0),(23,1,11,11,0,0,0,3,0),(24,12,21,1,2,10,1000,3,0),(25,22,41,2,4,8,100,3,0),(26,42,95,3,1,4,100,3,0),(27,96,100,4,1,10,10,3,0),(28,1,77,12,0,0,0,3,0),(29,78,95,5,1,3,1,3,0),(30,96,100,6,1,3,1,3,0),(31,1,49,13,0,0,0,3,0),(32,50,79,7,1,3,1,3,0),(33,80,100,8,1,1,1,3,0),(34,1,11,11,0,0,0,4,0),(35,12,21,1,3,10,1000,4,0),(36,22,41,2,4,12,100,4,0),(37,42,95,3,1,4,100,4,0),(38,96,100,4,1,8,10,4,0),(39,1,70,12,0,0,0,4,0),(40,71,95,5,1,4,1,4,0),(41,96,100,6,1,3,1,4,0),(42,1,42,13,0,0,0,4,0),(43,43,62,7,1,4,1,4,0),(44,63,100,8,1,1,1,4,0),(45,1,10,11,0,0,0,5,0),(46,11,19,1,1,4,10000,5,0),(47,20,38,2,1,6,1000,5,0),(48,39,95,3,1,8,100,5,0),(49,96,100,4,1,10,10,5,0),(50,1,60,12,0,0,0,5,0),(51,61,95,5,1,4,1,5,0),(52,96,100,6,1,4,1,5,0),(53,1,57,13,0,0,0,5,0),(54,58,67,7,1,4,1,5,0),(55,68,100,8,1,3,1,5,0),(56,1,10,11,0,0,0,6,0),(57,11,18,1,1,6,10000,6,0),(58,19,37,2,1,8,1000,6,0),(59,38,95,3,1,10,100,6,0),(60,96,100,4,1,12,10,6,0),(61,1,56,12,0,0,0,6,0),(62,57,92,5,1,4,1,6,0),(63,93,100,6,1,4,1,6,0),(64,1,54,13,0,0,0,6,0),(65,55,59,7,1,4,1,6,0),(66,60,99,8,1,4,1,6,0),(67,100,100,9,1,1,1,6,0),(68,0,11,11,0,0,0,7,0),(69,12,18,1,1,10,10000,7,0),(70,19,35,2,1,12,1000,7,0),(71,36,93,3,2,6,100,7,0),(72,94,100,4,3,4,10,7,0),(73,1,48,12,0,0,0,7,0),(74,49,88,5,1,4,1,7,0),(75,89,100,6,1,4,1,7,0),(76,1,51,13,0,0,0,7,0),(77,52,97,8,1,4,1,7,0),(78,98,100,9,1,1,1,7,0),(79,1,10,11,0,0,0,8,0),(80,11,15,1,1,12,10000,8,0),(81,16,29,2,2,6,1000,8,0),(82,30,87,3,2,8,100,8,0),(83,88,100,4,3,6,10,8,0),(84,1,40,12,0,0,0,8,0),(85,41,80,5,1,6,1,8,0),(86,81,100,6,1,4,1,8,0),(87,1,48,13,0,0,0,8,0),(88,49,96,8,1,4,1,8,0),(89,97,100,9,1,1,1,8,0),(90,1,10,11,0,0,0,9,0),(91,11,15,1,2,6,10000,9,0),(92,16,29,2,2,8,1000,9,0),(93,30,85,3,5,4,100,9,0),(94,86,100,4,2,12,10,9,0),(95,1,40,12,0,0,0,9,0),(96,41,80,5,1,8,1,9,0),(97,81,100,6,1,4,1,9,0),(98,1,43,13,0,0,0,9,0),(99,44,91,8,1,4,1,9,0),(100,92,100,9,1,1,1,9,0),(101,1,10,11,0,0,0,10,0),(102,11,24,2,2,10,1000,10,0),(103,25,79,3,6,4,100,10,0),(104,80,100,4,5,6,10,10,0),(105,1,35,12,0,0,0,10,0),(106,36,79,5,1,8,1,10,0),(107,80,100,6,1,6,1,10,0),(108,1,40,13,0,0,0,10,0),(109,41,88,8,1,4,1,10,0),(110,89,99,9,1,1,1,10,0),(111,100,100,10,1,1,1,10,0),(112,1,8,11,0,0,0,11,0),(113,9,14,2,3,10,1000,11,0),(114,15,75,3,4,8,100,11,0),(115,76,100,4,4,10,10,11,0),(116,1,24,12,0,0,0,11,0),(117,25,74,5,1,10,1,11,0),(118,75,100,6,1,6,1,11,0),(119,1,31,13,0,0,0,11,0),(120,32,84,8,1,4,1,11,0),(121,85,98,9,1,1,1,11,0),(122,99,100,10,1,1,1,11,0),(123,1,8,11,0,0,0,12,0),(124,9,14,2,3,12,1000,12,0),(125,15,75,3,1,4,1000,12,0),(126,76,100,4,1,4,100,12,0),(127,1,17,12,0,0,0,12,0),(128,18,70,5,1,10,1,12,0),(129,71,100,6,1,8,1,12,0),(130,1,27,13,0,0,0,12,0),(131,28,82,8,1,6,1,12,0),(132,83,97,9,1,1,1,12,0),(133,98,100,10,1,1,1,12,0),(134,1,8,11,0,0,0,13,0),(135,9,75,3,1,4,1000,13,0),(136,76,100,4,1,10,100,13,0),(137,1,11,12,0,0,0,13,0),(138,12,66,5,1,12,1,13,0),(139,67,100,6,1,10,1,13,0),(140,1,19,13,0,0,0,13,0),(141,20,73,8,1,6,1,13,0),(142,74,95,9,1,1,1,13,0),(143,96,100,10,1,1,1,13,0),(144,1,8,11,0,0,0,14,0),(145,9,75,3,1,6,1000,14,0),(146,76,100,4,1,12,100,14,0),(147,1,11,12,0,0,0,14,0),(148,12,66,5,2,8,1,14,0),(149,67,100,6,2,6,1,14,0),(150,1,19,13,0,0,0,14,0),(151,20,58,8,1,6,1,14,0),(152,59,92,9,1,1,1,14,0),(153,93,100,10,1,1,1,14,0),(154,1,3,11,0,0,0,15,0),(155,4,74,3,1,8,1000,15,0),(156,75,100,4,3,4,100,15,0),(157,1,9,12,0,0,0,15,0),(158,10,65,5,2,10,1,15,0),(159,55,100,6,2,8,1,15,0),(160,1,11,13,0,0,0,15,0),(161,12,46,8,1,10,1,15,0),(162,47,90,9,1,1,1,15,0),(163,91,100,10,1,1,1,15,0),(164,1,3,11,0,0,0,16,0),(165,4,74,3,1,12,1000,16,0),(166,75,100,4,3,4,100,16,0),(167,1,7,12,0,0,0,16,0),(168,8,64,5,4,6,1,16,0),(169,65,100,6,2,10,1,16,0),(170,1,40,13,0,0,0,16,0),(171,41,46,8,1,10,1,16,0),(172,47,90,9,1,3,1,16,0),(173,91,100,10,1,1,1,16,0),(174,1,3,11,0,0,0,17,0),(175,4,68,3,3,4,1000,17,0),(176,69,100,4,2,10,100,17,0),(177,1,4,12,0,0,0,17,0),(178,5,63,5,4,8,1,17,0),(179,64,100,6,3,8,1,17,0),(180,1,33,13,0,0,0,17,0),(181,34,83,9,1,3,1,17,0),(182,84,100,10,1,1,1,17,0),(183,1,2,11,0,0,0,18,0),(184,3,65,3,3,6,1000,18,0),(185,66,100,4,5,4,100,18,0),(186,1,4,12,0,0,0,18,0),(187,5,54,5,3,12,1,18,0),(188,55,100,6,3,10,1,18,0),(189,1,24,13,0,0,0,18,0),(190,25,80,9,1,4,1,18,0),(191,81,100,10,1,1,1,18,0),(192,1,2,11,0,0,0,19,0),(193,3,65,3,3,8,1000,19,0),(194,66,100,4,3,10,100,19,0),(195,1,3,12,0,0,0,19,0),(196,4,50,5,6,6,1,19,0),(197,51,127,6,6,6,1,19,0),(198,1,4,13,0,0,0,19,0),(199,5,70,9,1,4,1,19,0),(200,71,100,10,1,1,1,19,0),(201,1,2,11,0,0,0,20,0),(202,3,65,3,4,8,1000,20,0),(203,66,100,4,4,10,100,20,0),(204,1,2,12,0,0,0,20,0),(205,3,38,5,4,10,1,20,0),(206,39,100,6,7,6,1,20,0),(207,1,25,13,0,0,0,20,0),(208,26,65,9,1,4,1,20,0),(209,66,100,10,1,3,1,20,0);

/*Table structure for table `treasure_subtypes` */

DROP TABLE IF EXISTS `treasure_subtypes`;

CREATE TABLE `treasure_subtypes` (
  `id` int(11) NOT NULL auto_increment,
  `type` enum('coins','goods','items') NOT NULL,
  `name` varchar(100) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

/*Data for the table `treasure_subtypes` */

insert  into `treasure_subtypes`(`id`,`type`,`name`) values (1,'coins','cp'),(2,'coins','sp'),(3,'coins','gp'),(4,'coins','pp'),(5,'goods','gems'),(6,'goods','art'),(7,'items','mundane'),(8,'items','minor'),(9,'items','medium'),(10,'items','major'),(11,'coins','-'),(12,'goods','-'),(13,'items','-');

/*Table structure for table `uncommon_weapons` */

DROP TABLE IF EXISTS `uncommon_weapons`;

CREATE TABLE `uncommon_weapons` (
  `id` int(11) NOT NULL auto_increment,
  `dice_lower` tinyint(4) default NULL,
  `dice_upper` tinyint(4) default NULL,
  `weapon_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;

/*Data for the table `uncommon_weapons` */

insert  into `uncommon_weapons`(`id`,`dice_lower`,`dice_upper`,`weapon_id`) values (1,1,3,17),(2,4,7,18),(3,8,10,19),(4,11,12,20),(5,13,16,21),(6,17,19,22),(7,20,21,23),(8,22,23,24),(9,24,26,25),(10,27,31,26),(11,32,35,27),(12,36,37,28),(13,38,39,29),(14,40,41,30),(15,42,43,31),(16,44,45,32),(17,46,48,33),(18,49,51,34),(19,52,54,35),(20,55,56,36),(21,57,58,37),(22,59,61,38),(23,62,64,39),(24,65,67,40),(25,68,70,41),(26,71,72,42),(27,73,74,43),(28,75,76,44),(29,77,78,45),(30,79,80,46),(31,81,82,47),(32,83,84,48),(33,85,86,49),(34,87,89,50),(35,90,91,51),(36,92,94,52),(37,95,97,53),(38,98,100,54);

/*Table structure for table `weapons` */

DROP TABLE IF EXISTS `weapons`;

CREATE TABLE `weapons` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `plural` varchar(255) default NULL,
  `prefix` varchar(100) default NULL,
  `plural_prefix` varchar(100) default NULL,
  `value` decimal(14,4) default NULL,
  `type` enum('single','double','ammunition') default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;

/*Data for the table `weapons` */

insert  into `weapons`(`id`,`name`,`plural`,`prefix`,`plural_prefix`,`value`,`type`) values (1,'dagger','daggers','a','','2.0000','single'),(2,'greataxe','greataxes','a','','20.0000','single'),(3,'greatsword','greatswords','a','','50.0000','single'),(4,'kama','kamas','a','','2.0000','single'),(5,'longsword','longswords','a','','15.0000','single'),(6,'light mace','light maces','a','','5.0000','single'),(7,'heavy mace','heavy maces','a','','12.0000','single'),(8,'nunchaku','nunchaku','a pair of','pairs of','2.0000','single'),(9,'quarterstaff','quarterstaffs','a','','0.0000','double'),(10,'rapier','rapiers','a','','20.0000','single'),(11,'scimitar','scimitars','a','','15.0000','single'),(12,'shortspear','shortspears','a','','2.0000','single'),(13,'siangham','sianghams','a','','3.0000','single'),(14,'bastard sword','bastard swords','a','','35.0000','single'),(15,'short sword','short swords','a','','10.0000','single'),(16,'dwarven waraxe','dwarven waraxes','a','','30.0000','single'),(17,'orc double axe','orc double axes','an','','60.0000','double'),(18,'battleaxe','battleaxes','a','','10.0000','single'),(19,'spiked chain','spiked chains','a','','25.0000','single'),(20,'club','club','a','','0.0000','single'),(21,'hand crossbow','hand crossbows','a','','100.0000','single'),(22,'repeating crossbow','repeating crossbows','a','','250.0000','single'),(23,'punching dagger','punching daggers','a','','2.0000','single'),(24,'falchion','falchions','a','','75.0000','single'),(25,'dire flail','dire flails','a','','90.0000','double'),(26,'heavy flail','heavy flails','a','','15.0000','single'),(27,'flail','flails','a','','8.0000','single'),(28,'guantlet','gauntlets','a','','2.0000','single'),(29,'spiked gauntlet','spiked gauntlets','a','','5.0000','single'),(30,'glaive','glaives','a','','8.0000','single'),(31,'greatclub','greatclubs','a','','5.0000','single'),(32,'guisarme','guisarmes','a','','9.0000','single'),(33,'halberd','halberds','a','','10.0000','single'),(34,'spear','spears','a','','1.0000','single'),(35,'gnome hooked hammer','gnome hooked hammers','a','','20.0000','double'),(36,'light hammer','light hammers','a','','1.0000','single'),(37,'handaxe','handaxes','a','','6.0000','single'),(38,'kukri','kukris','a','','8.0000','single'),(39,'lance','lances','a','','10.0000','single'),(40,'longspear','longspears','a','','5.0000','single'),(41,'morningstar','morningstars','a','','8.0000','single'),(42,'net','nets','a','','20.0000','single'),(43,'heavy pick','heavy picks','a','','8.0000','single'),(44,'light pick','light picks','a','','4.0000','single'),(45,'ranseur','ransuers','a','','10.0000','single'),(46,'sap','saps','a','','1.0000','single'),(47,'scythe','scythes','a','','18.0000','single'),(48,'shuriken','shurikens','a','','10.0000','ammunition'),(49,'sickle','sickles','a','','6.0000','single'),(50,'two-bladed sword','two-bladed swords','a','','100.0000','double'),(51,'trident','tridents','a','','15.0000','single'),(52,'dwarven urgrosh','dwarven urgroshes','a','','50.0000','double'),(53,'warhammer','warhammers','a','','12.0000','single'),(54,'whip','whips','a','','1.0000','single'),(59,'throwing axe','throwing axes','a','','8.0000','single'),(60,'heavy crossbow','heavy crossbows','a','','50.0000','single'),(61,'light crossbow','light crossbows','a','','35.0000','single'),(62,'dart','darts','a','','0.5000','single'),(63,'javelin','javelins','a','','1.0000','single'),(64,'shortbow','shortbows','a','','30.0000','single'),(65,'sling','slings','a','','0.0000','single'),(66,'longbow','longbows','a','','75.0000','single'),(67,'composite shortbow','composite shortbows','a','','30.0000','single'),(68,'composite longbow','composite longbows','a','','75.0000','single'),(69,'arrow','arrows','an','','2.5000','ammunition'),(70,'crossbow bolt','crossbow bolts','a','','5.0000','ammunition'),(71,'repeating crossbow bolt','repeating crossbow bolts','a','','10.0000','ammunition'),(72,'sling bullet','sling bullets','a','','0.5000','ammunition');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;