NPC Crafter/exchanger

/*
SQLyog Ultimate v10.42
MySQL - 5.5.9-log : Database - world
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

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

/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`world` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `world`;

/*Table structure for table `craft_system` */

DROP TABLE IF EXISTS `craft_system`;

CREATE TABLE `craft_system` (
  `name` longtext NOT NULL COMMENT 'Craft item name',
  `item` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Craft item entry',
  `count` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Craft count',
  `r_item1` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Reagent 1 entry',
  `r_count1` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Reagent 1 count',
  `r_item2` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Reagent 2 entry',
  `r_count2` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Reagent 2 count',
  `r_item3` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Reagent 3 entry',
  `r_count3` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Reagent 3 count',
  `r_item4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `r_count4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `r_item5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `r_count5` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `craft_system` */

INSERT  INTO `craft_system`(`name`,`item`,`count`,`r_item1`,`r_count1`,`r_item2`,`r_count2`,`r_item3`,`r_count3`,`r_item4`,`r_count4`,`r_item5`,`r_count5`) VALUES ('test2',38497,1,6652,1,32595,2,0,0,0,0,0,0),('test1',40599,10,33635,1,0,0,0,0,0,0,0,0),('test3',49778,1,32595,1,0,0,0,0,0,0,0,0),('test11',53924,2,11613,3,39450,10,7101,6,50248,4,49984,7),('test4',0,0,0,0,0,0,0,0,0,0,0,0),('string1',2550,1,33635,1,0,0,0,0,0,0,0,0);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;