yPuenKD4

1-- Adminer 3.3.4 MySQL dump
2
3SET NAMES utf8;
4SET foreign_key_checks = 0;
5SET time_zone = 'SYSTEM';
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `craft_list`;
9CREATE TABLE `craft_list` (
10  `item_id` int(11) NOT NULL,
11  `quantity` int(11) NOT NULL,
12  KEY `item_id` (`item_id`),
13  CONSTRAINT `craft_list_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`)
14) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
15
16INSERT INTO `craft_list` (`item_id`, `quantity`) VALUES
17(1,	3),
18(2,	1),
19(3,	2),
20(4,	2);
21
22DROP TABLE IF EXISTS `items`;
23CREATE TABLE `items` (
24  `id` int(11) NOT NULL AUTO_INCREMENT,
25  `name` varchar(255) COLLATE utf8_bin NOT NULL,
26  PRIMARY KEY (`id`)
27) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
28
29INSERT INTO `items` (`id`, `name`) VALUES
30(1,	'Stone pickaxe'),
31(2,	'Iron pickaxe'),
32(3,	'Stone shovel'),
33(4,	'Iron shovel');
34
35DROP TABLE IF EXISTS `materials`;
36CREATE TABLE `materials` (
37  `id` int(11) NOT NULL AUTO_INCREMENT,
38  `name` varchar(255) COLLATE utf8_bin NOT NULL,
39  PRIMARY KEY (`id`)
40) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
41
42INSERT INTO `materials` (`id`, `name`) VALUES
43(1,	'Wood'),
44(2,	'Stone'),
45(3,	'Iron');
46
47DROP TABLE IF EXISTS `recipes`;
48CREATE TABLE `recipes` (
49  `item_id` int(11) NOT NULL,
50  `material_id` int(11) NOT NULL,
51  `quantity` int(11) NOT NULL,
52  KEY `item_id` (`item_id`),
53  KEY `material_id` (`material_id`),
54  CONSTRAINT `recipes_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`),
55  CONSTRAINT `recipes_ibfk_2` FOREIGN KEY (`material_id`) REFERENCES `materials` (`id`)
56) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
57
58INSERT INTO `recipes` (`item_id`, `material_id`, `quantity`) VALUES
59(1,	2,	3),
60(1,	1,	2),
61(2,	1,	2),
62(2,	3,	3),
63(3,	1,	2),
64(3,	2,	1),
65(4,	1,	2),
66(4,	3,	1);
67
68-- 2012-08-20 13:10:50