BsW6z8CN

1-- phpMyAdmin SQL Dump
2-- version 3.4.11.1deb2+deb7u2
3-- http://www.phpmyadmin.net
4--
5-- Počítač: localhost
6-- Vygenerováno: Úte 31. led 2017, 21:53
7-- Verze MySQL: 5.5.46
8-- Verze PHP: 5.4.45-0+deb7u2
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Databáze: `gamecraft`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabulky `items`
27--
28
29CREATE TABLE IF NOT EXISTS `items` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `name` varchar(100) COLLATE utf8_czech_ci DEFAULT NULL,
32  `categoryId` int(11) DEFAULT NULL,
33  `rarity` int(11) DEFAULT NULL,
34  PRIMARY KEY (`id`),
35  UNIQUE KEY `uniqueNameCategoryIndex` (`name`,`categoryId`),
36  KEY `categoryId` (`categoryId`)
37) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=35 ;
38
39--
40-- Vypisuji data pro tabulku `items`
41--
42
43INSERT INTO `items` (`id`, `name`, `categoryId`, `rarity`) VALUES
44(1, 'TNT', 1, NULL),
45(2, 'Melon Launcher', 1, NULL),
46(3, 'Paintball Gun', 1, NULL),
47(4, 'Ethereal Pearl', 1, NULL),
48(5, 'Fireworks', 1, NULL),
49(6, 'Bat Blaster', 1, NULL),
50(7, 'Coin Party Bomb', 1, NULL),
51(8, 'Flesh Hook', 1, NULL),
52(9, 'Mythical Chest', 1, NULL),
53(10, 'COW', 2, NULL),
54(11, 'WOLF', 2, NULL),
55(12, 'CHICKEN', 2, NULL),
56(13, 'SHEEP', 2, NULL),
57(14, 'MUSHROOM_COW', 2, NULL),
58(15, 'PIG', 2, NULL),
59(16, 'Ancient Chest', 1, NULL),
60(17, 'Old Chest', 1, NULL),
61(18, 'Gem Party Bomb', 1, NULL),
62(19, 'Dueling Sword', 1, NULL),
63(20, 'Football', 1, NULL),
64(21, 'OCELOT', 2, NULL),
65(22, 'Bat Morph', 4, NULL),
66(23, 'Minecart', 5, NULL),
67(24, 'Slime Mount', 5, NULL),
68(25, 'Myticka Truhla', 1, NULL),
69(26, 'Starodavna Truhla', 1, NULL),
70(27, 'Infernal Horror', 5, NULL),
71(28, 'Ohnostroj', 1, NULL),
72(29, 'Meloun Launcher', 1, NULL),
73(30, 'Glacial Steed', 5, NULL),
74(31, 'GCredits Party Bomb', 1, NULL),
75(32, 'Stara Truhla', 1, NULL),
76(33, 'Netopyr Blaster', 1, NULL),
77(34, 'Mount Mule', 5, NULL);
78
79--
80-- Omezení pro exportované tabulky
81--
82
83--
84-- Omezení pro tabulku `items`
85--
86ALTER TABLE `items`
87  ADD CONSTRAINT `items_ibfk_1` FOREIGN KEY (`categoryId`) REFERENCES `itemCategories` (`id`);
88
89/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
90/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
91/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;