wc3hDDCu

1USE `essentialmode`;
2
3-- Dumping structure for tabell essentialmode.items
4CREATE TABLE IF NOT EXISTS `items` (
5  `id` int(11) NOT NULL AUTO_INCREMENT,
6  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
7  `label` varchar(255) COLLATE utf8mb4_bin NOT NULL,
8  `limit` int(11) NOT NULL DEFAULT '-1',
9  `rare` int(11) NOT NULL DEFAULT '0',
10  `can_remove` int(11) NOT NULL DEFAULT '1',
11  PRIMARY KEY (`id`) USING BTREE
12) ENGINE=InnoDB AUTO_INCREMENT=175 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT;
13
14-- Dumpar data för tabell essentialmode.items: ~110 rows (ungefär)
15/*!40000 ALTER TABLE `items` DISABLE KEYS */;
16INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
17	(1, 'bread', '🍞 Bröd', 25, 0, 1);
18INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
19	(2, 'water', '💦 Vatten', 25, 0, 1);
20INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
21	(8, 'weed', 'Weed', 180, 0, 1);
22INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
23	(9, 'weed_pooch', 'Packat Weed', -1, 0, 1);
24INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
25	(10, 'coke', 'Kokain', 180, 0, 1);
26INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
27	(11, 'coke_pooch', 'Packat kokain', -1, 0, 1);
28INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
29	(12, 'meth', 'Meth', 180, 0, 1);
30INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
31	(13, 'meth_pooch', 'Packat meth', -1, 0, 1);
32INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
33	(14, 'opium', 'Opium', 180, 0, 1);
34INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
35	(15, 'opium_pooch', 'Packat opium', -1, 0, 1);
36INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
37	(16, 'wine', 'Vin', 25, 0, 1);
38INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
39	(17, 'whisky', 'Whisky', 25, 0, 1);
40INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
41	(18, 'beer', 'Öl', 25, 0, 1);
42INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
43	(19, 'burger', 'Hamburgare', 25, 0, 1);
44INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
45	(24, 'bandage', 'Bandage', 20, 0, 1);
46INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
47	(25, 'medikit', 'Medkit', 10, 0, 1);
48INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
49	(26, 'alive_chicken', 'Levande kyckling', -1, 0, 1);
50INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
51	(27, 'slaughtered_chicken', 'Slaktad kyckling', -1, 0, 1);
52INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
53	(28, 'packaged_chicken', 'Paketerad kyckling', -1, 0, 1);
54INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
55	(29, 'fish', 'Fisk', -1, 0, 1);
56INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
57	(30, 'stone', 'Sten', -1, 0, 1);
58INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
59	(31, 'washed_stone', 'Tvättad sten', -1, 0, 1);
60INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
61	(32, 'copper', 'Koppar', -1, 0, 1);
62INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
63	(33, 'iron', 'Järn', -1, 0, 1);
64INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
65	(34, 'gold', 'Guld', -1, 0, 1);
66INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
67	(35, 'diamond', 'Diamant', -1, 0, 1);
68INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
69	(36, 'wood', 'Trä', -1, 0, 1);
70INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
71	(37, 'packaged_plank', 'Paketerade plank', -1, 0, 1);
72INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
73	(38, 'cutted_wood', 'Kluvet trä', -1, 0, 1);
74INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
75	(39, 'petrol', 'Bensin', -1, 0, 1);
76INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
77	(40, 'petrol_raffin', 'Bensin', -1, 0, 1);
78INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
79	(41, 'essence', 'Essence', -1, 0, 1);
80INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
81	(42, 'whool', 'Ull', -1, 0, 1);
82INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
83	(43, 'fabric', 'Tyg', -1, 0, 1);
84INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
85	(44, 'clothe', 'Kläder', -1, 0, 1);
86INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
87	(45, 'gazbottle', 'Bensindunk', -1, 0, 1);
88INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
89	(46, 'fixtool', 'Reparations verktyg', -1, 0, 1);
90INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
91	(47, 'cartool', 'Car tool', -1, 0, 1);
92INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
93	(48, 'fixkit', 'Reparationskit', 5, 0, 1);
94INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
95	(49, 'blowpipe', 'Gasblås', -1, 0, 1);
96INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
97	(50, 'carokit', 'Bilkit', -1, 0, 1);
98INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
99	(51, 'hamburger', 'Hamburgare', 25, 0, 1);
100INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
101	(52, 'sandwich', 'Macka', 25, 0, 1);
102INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
103	(53, 'chocolate', 'Choklad', 25, 0, 1);
104INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
105	(59, 'jager', 'Jägermeister', 5, 0, 1);
106INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
107	(60, 'vodka', 'Vodka', 5, 0, 1);
108INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
109	(61, 'rhum', 'Rom', 5, 0, 1);
110INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
111	(62, 'whisky', 'Whisky', 5, 0, 1);
112INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
113	(63, 'tequila', 'Tequila', 5, 0, 1);
114INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
115	(64, 'martini', 'Martini blanc', 10, 0, 1);
116INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
117	(65, 'soda', 'Soda', 10, 0, 1);
118INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
119	(66, 'jusfruit', 'Fruktjuice', 10, 0, 1);
120INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
121	(67, 'icetea', 'Is te', 10, 0, 1);
122INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
123	(68, 'energy', 'Energy Drink', 10, 0, 1);
124INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
125	(69, 'drpepper', 'Dr. Pepper', 10, 0, 1);
126INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
127	(70, 'limonade', 'Lemonade', 10, 0, 1);
128INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
129	(71, 'bolcacahuetes', 'Cashewnötter', 10, 0, 1);
130INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
131	(72, 'bolnoixcajou', 'jordnötter', 10, 0, 1);
132INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
133	(73, 'bolpistache', 'pistachenötter', 10, 0, 1);
134INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
135	(74, 'bolchips', 'chips', 10, 0, 1);
136INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
137	(75, 'saucisson', 'Saucisson', 10, 0, 1);
138INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
139	(76, 'grapperaisin', 'Vindruvor', 10, 0, 1);
140INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
141	(77, 'jagerbomb', 'Jägerbomb', 5, 0, 1);
142INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
143	(78, 'golem', 'Golem', 5, 0, 1);
144INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
145	(79, 'whiskycoca', 'Whisky och Cola', 5, 0, 1);
146INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
147	(80, 'vodkaenergy', 'Vodka och redbull', 5, 0, 1);
148INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
149	(81, 'vodkafruit', 'Sourz', 5, 0, 1);
150INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
151	(82, 'rhumfruit', 'Malibu original', 5, 0, 1);
152INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
153	(83, 'teqpaf', 'Cocktail', 5, 0, 1);
154INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
155	(84, 'rhumcoca', 'Rom och Cola', 5, 0, 1);
156INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
157	(85, 'mojito', 'Mojito', 5, 0, 1);
158INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
159	(86, 'ice', 'Is', 10, 0, 1);
160INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
161	(87, 'mixapero', 'Mixa Pero (Ej drickbar)', 3, 0, 1);
162INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
163	(88, 'metreshooter', 'Shot', 3, 0, 1);
164INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
165	(89, 'jagercerbere', 'Jäger Cerbere (Ej drickbar)', 3, 0, 1);
166INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
167	(90, 'menthe', 'Mint', 10, 0, 1);
168INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
169	(92, 'redbull', 'Redbull', 10, 0, 1);
170INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
171	(93, 'beef', 'Biff', 10, 0, 1);
172INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
173	(94, 'partydrog', 'Partypiller', 10, 0, 1);
174INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
175	(123, 'lsd', 'Lsd', -1, 0, 1);
176INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
177	(124, 'lsd_pooch', 'LSD Piller', -1, 0, 1);
178INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
179	(125, 'clip', 'Magasin', -1, 0, 1);
180INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
181	(126, 'gps', 'GPS', -1, 0, 1);
182INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
183	(127, 'anchovy', 'Ansjovis', -1, 0, 1);
184INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
185	(128, 'pompano', 'Florida Pompano', -1, 0, 1);
186INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
187	(129, 'salmon', 'Lax', -1, 0, 1);
188INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
189	(130, 'tuna', 'Tonfisk', -1, 0, 1);
190INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
191	(131, 'sardany', 'Sardin', -1, 0, 1);
192INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
193	(132, 'mullet', 'Multe', -1, 0, 1);
194INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
195	(133, 'fishingrod', 'Fiskespö', 1, 0, 1);
196INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
197	(134, 'fishing_bait', 'Fiske bete', -1, 0, 1);
198INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
199	(135, 'hummer', 'Hummer', -1, 0, 1);
200INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
201	(136, 'fix_kit', 'Repairkit', -1, 0, 1);
202INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
203	(137, 'repair_kit', 'Repairkit', -1, 0, 1);
204INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
205	(138, 'license', '💳 Körkort ', 1, 0, 1);
206INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
207	(160, 'black_chip', 'Darkweb chip', 1, 0, 1);
208INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
209	(161, 'phone', 'Telefon', 1, 0, 1);
210INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
211	(162, 'gadda', 'Gädda', -1, 0, 1);
212INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
213	(163, 'abborre', 'Abborre', -1, 0, 1);
214INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
215	(164, 'mort', 'Mört', -1, 0, 1);
216INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
217	(165, 'oring', 'Öring', -1, 0, 1);
218INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
219	(166, 'harr', 'Harr', -1, 0, 1);
220INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
221	(167, 'asp', 'Asp', -1, 0, 1);
222INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
223	(168, 'borrmaskin', 'Borrmaskin', 1, 0, 1);
224INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
225	(169, 'kofot', 'Kofot', -1, 0, 1);
226INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
227	(170, 'cigarette', 'Cigarett', -1, 0, 1);
228INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
229	(171, 'lighter', 'Tändare', -1, 0, 1);
230INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
231	(172, 'cigarett', 'Cigarett', -1, 0, 1);
232INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
233	(173, 'phone', 'iTelefon', -1, 0, 1);
234INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
235	(174, 'komradio', 'Komradio', 2, 0, 1);
236/*!40000 ALTER TABLE `items` ENABLE KEYS */;