9pexqZVV

1--
2-- Estrutura da tabela `items`
3--
4
5CREATE TABLE IF NOT EXISTS `items` (
6`id` int(11) NOT NULL,
7  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
8  `label` varchar(255) COLLATE utf8mb4_bin NOT NULL,
9  `limit` int(11) NOT NULL DEFAULT -1,
10  `rare` int(11) NOT NULL DEFAULT 0,
11  `can_remove` int(11) NOT NULL DEFAULT 1
12) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
13
14--
15-- Extraindo dados da tabela `items`
16--
17
18INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
19('bread', 'Bread', -1, 0, 1),
20('water', 'Water', -1, 0, 1),
21('wine', 'Wine', -1, 0, 1),
22('beer', 'Beer', -1, 0, 1),
23('vodka', 'Vodka', -1, 0, 1),
24('chocolate', 'Chocolate', -1, 0, 1),
25('sandwich', 'Sandwich', -1, 0, 1),
26('hamburger', 'Hamburger', -1, 0, 1),
27('tequila', 'Tequila', -1, 0, 1),
28('whisky', 'Whisky', -1, 0, 1),
29('cupcake', 'Cupcake', -1, 0, 1),
30('cocacola', 'Coca-Cola', -1, 0, 1),
31('icetea', 'Ice-Tea', -1, 0, 1),
32('redbull', 'Coffe', -1, 0, 1);
33
34--
35-- Indexes for dumped tables
36--
37
38--
39-- Indexes for table `items`
40--
41ALTER TABLE `items`
42 ADD PRIMARY KEY (`id`);
43
44--
45-- AUTO_INCREMENT for dumped tables
46--
47
48--
49-- AUTO_INCREMENT for table `items`
50--
51ALTER TABLE `items`
52MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=52;