· 6 years ago · May 12, 2019, 01:12 PM
1DROP TABLE IF EXISTS `items`;
2CREATE TABLE IF NOT EXISTS `items` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `name` varchar(50) COLLATE utf8mb4_bin NOT NULL,
5 `label` varchar(50) COLLATE utf8mb4_bin NOT NULL,
6 `limit` int(11) NOT NULL DEFAULT '-1',
7 `rare` int(11) NOT NULL DEFAULT '0',
8 `can_remove` int(11) NOT NULL DEFAULT '1',
9 PRIMARY KEY (`id`)
10) ENGINE=InnoDB AUTO_INCREMENT=3006 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
11
12/*!40000 ALTER TABLE `items` DISABLE KEYS */;
13INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
14 (1, 'bread', 'Hamburger', 25, 0, 1),
15 (2, 'water', 'Ayran', 30, 0, 1),
16 (3, 'weed', 'Esrar', 100, 0, 1),
17 (4, 'weed_pooch', 'Ä°ÅŸlenmiÅŸ Esrar', 60, 0, 1),
18 (5, 'coke', 'Kokain', 100, 0, 1),
19 (6, 'coke_pooch', 'Ä°ÅŸlenmiÅŸ Kokain', 60, 0, 1),
20 (7, 'meth', 'Meth', 100, 0, 1),
21 (8, 'meth_pooch', 'Ä°ÅŸlenmiÅŸ Meth', 60, 0, 1),
22 (9, 'opium', 'Afyon', 100, 0, 1),
23 (10, 'opium_pooch', 'Ä°ÅŸlenmiÅŸ Afyon', 60, 0, 1),
24 (11, 'alive_chicken', 'Canlı Tavuk', 100, 0, 1),
25 (12, 'slaughtered_chicken', 'KesilmiÅŸ Tavuk', 100, 0, 1),
26 (13, 'packaged_chicken', 'PaketlenmiÅŸ Tavuk', 200, 0, 1),
27 (14, 'fish', 'Balık', 200, 0, 1),
28 (15, 'stone', 'TaÅŸ', 15, 0, 1),
29 (16, 'washed_stone', 'TemizlenmiÅŸ TaÅŸ', 15, 0, 1),
30 (17, 'copper', 'Bakır', 200, 0, 1),
31 (18, 'iron', 'Demir', 150, 0, 1),
32 (19, 'gold', 'Altın', 100, 0, 1),
33 (20, 'diamond', 'Elmas', 100, 0, 1),
34 (21, 'wood', 'Odun', 100, 0, 1),
35 (22, 'cutted_wood', 'KesilmiÅŸ Odun', 100, 0, 1),
36 (23, 'packaged_plank', 'PaketlenmiÅŸ Odun', 100, 0, 1),
37 (25, 'petrol_raffin', 'Rafine Benzin', 140, 0, 1),
38 (26, 'essence', 'Benzin', 140, 0, 1),
39 (28, 'fabric', 'KumaÅŸ', -1, 0, 1),
40 (29, 'clothe', 'Giysi', -1, 0, 1),
41 (30, 'gazbottle', 'Gaz ÅžiÅŸesi', -1, 0, 1),
42 (31, 'fixtool', 'Tamir Çantası', 5, 0, 1),
43 (32, 'carotool', 'Araçlar', -1, 0, 1),
44 (33, 'blowpipe', 'Lehim lambası', -1, 0, 1),
45 (34, 'fixkit', 'Tamir Takımı', -1, 0, 1),
46 (35, 'carokit', 'Body Tamir Takımı', -1, 0, 1),
47 (36, 'beer', 'Bira', 20, 0, 1),
48 (37, 'bandage', 'Bandaj', 20, 0, 1),
49 (38, 'medikit', 'İlk Yardım Çantası', 20, 0, 1),
50 (39, 'pills', 'Antibiyotik', 10, 0, 1),
51 (40, 'lockpick', 'Maymuncuk', -1, 0, 1),
52 (42, 'coffee', 'Kahve', -1, 0, 1),
53 (49, 'clip', 'Mermi', -1, 0, 1),
54 (50, 'jager', 'Jägermeister', 100, 0, 1),
55 (52, 'rhum', 'Rum', 100, 0, 1),
56 (53, 'whisky', 'Viski', 100, 0, 1),
57 (54, 'tequila', 'Tekila', 5, 0, 1),
58 (56, 'soda', 'TürkKızılay Soda', 5, 0, 1),
59 (59, 'energy', 'Enerji İçeceği', 5, 0, 1),
60 (62, 'bolcacahuetes', 'Fıstık Kasesi', 100, 0, 1),
61 (64, 'bolpistache', 'Mısır Çerezi', 100, 0, 1),
62 (65, 'bolchips', 'Cips', 100, 0, 1),
63 (66, 'saucisson', 'Sosis', 100, 0, 1),
64 (67, 'grapperaisin', 'Üzüm Salkımı', 5, 0, 1),
65 (74, 'teqpaf', 'Teq\'paf', 5, 0, 1),
66 (121, 'pearl', 'Pearl', -1, 0, 1),
67 (122, 'pearl_pooch', 'Pochon de Pearl', -1, 0, 1),
68 (125, 'nitro', 'Nitroso', -1, 0, 1),
69 (126, 'cola', 'Coke', 20, 0, 1),
70 (127, 'vegetables', 'YeÅŸillikler', 20, 0, 1),
71 (129, 'tacos', 'Kokoreç', 20, 0, 1),
72 (130, 'burger', 'Tavuk Döner', 20, 0, 1),
73 (131, 'silencieux', 'Silah Susturucu', -1, 0, 1),
74 (132, 'flashlight', 'Silah Feneri', -1, 0, 1),
75 (133, 'grip', 'Silah Kabza', -1, 0, 1),
76 (135, 'binoculars', 'Dürbün', 1, 0, 1),
77 (136, 'croquettes', 'Mama', 50, 0, 1),
78 (137, 'blackberry', 'Böğürtlen', -1, 0, 1),
79 (138, 'lighter', 'Çakmak', -1, 0, 1),
80 (139, 'cigarett', 'Sigara', 25, 0, 1),
81 (153, 'petrol', 'Petrol', 140, 0, 1),
82 (200, 'kimlik', 'kimlik', -1, 0, 1),
83 (201, 'kola', 'Coca-Cola', 25, 0, 1),
84 (202, 'su', 'Su', 25, 0, 1),
85 (203, 'meyvesuyu', 'Meyve Suyu', 100, 0, 1),
86 (204, 'sarap', 'Åžarap', 25, 0, 1),
87 (205, 'viski', 'Viski', 25, 0, 1),
88 (206, 'bira', 'Tuborg', 25, 0, 1),
89 (207, 'cikolata', 'Ülker Çikolata', 25, 0, 1),
90 (208, 'patates', 'Patates Kızartması', 25, 0, 1),
91 (209, 'sandvic', 'Sosisli Sandviç', 25, 0, 1),
92 (210, 'pizza', 'Pizza', 25, 0, 1),
93 (211, 'tost', 'Tost', 25, 0, 1),
94 (212, 'tdoner', 'Tavuk Döner', 25, 0, 1),
95 (213, 'raisin', 'Üzüm', 100, 0, 1),
96 (214, 'jus_raisin', 'Meyve Suyu', 100, 0, 1),
97 (215, 'grand_cru', 'Åžarap ÅžiÅŸesi', 100, 0, 1),
98 (216, 'vine', 'Üzüm Şarabı', 100, 0, 1),
99 (222, 'martini', 'Martini blanc', 100, 0, 1),
100 (227, 'drpepper', 'Dr. Pepper', 100, 0, 1),
101 (230, 'bolnoixcajou', 'Kaju Fıstık Kase', 100, 0, 1),
102 (231, 'bolpistache', 'Antep fıstığı kase', 100, 0, 1),
103 (236, 'golem', 'Golem', 5, 0, 1),
104 (248, 'menthe', 'Nane Yaprağı', 100, 0, 1),
105 (249, 'sruhsat', 'Silah Ruhsatı', -1, 1, 1),
106 (253, 'vodka', 'Vodka', 5, 0, 1),
107 (258, 'soda', 'Soda', 5, 0, 1),
108 (259, 'jusfruit', 'Meyve Suyu', 100, 0, 1),
109 (260, 'icetea', 'Soğuk Çay', 5, 0, 1),
110 (263, 'limonade', 'Limonata', 100, 0, 1),
111 (269, 'grapperaisin', 'Üzüm Demeti', 5, 0, 1),
112 (270, 'jagerbomb', 'Jägerbomb', 100, 0, 1),
113 (272, 'whiskycoca', 'Viski-Kola', 100, 0, 1),
114 (273, 'vodkaenergy', 'Enerji İçecekli Vodka', 100, 0, 1),
115 (274, 'vodkafruit', 'Portakallı Vodka', 100, 0, 1),
116 (275, 'rhumfruit', 'Meyveli Rum', 100, 0, 1),
117 (277, 'rhumcoca', 'Kolalı Rum', 100, 0, 1),
118 (278, 'mojito', 'Mojito', 100, 0, 1),
119 (279, 'ice', 'Buz', 200, 0, 1),
120 (280, 'mixapero', 'Aperatif Kokteyl', 100, 0, 1),
121 (281, 'metreshooter', 'Mètre de shooter', 100, 0, 1),
122 (282, 'jagercerbere', 'Jäger Cerberus', 100, 0, 1),
123 (284, 'cola', 'Coke', 20, 0, 1),
124 (288, 'burger2', 'Ekmek Arası Köfte', 20, 0, 1),
125 (289, 'kofte', 'Köfte', 50, 0, 1),
126 (290, 'bread2', 'Ekmek', 50, 0, 1),
127 (291, 'baharat', 'Baharatlar', 50, 0, 1),
128 (600, 'blindfold', 'Çuval', 5, 0, 1),
129 (601, 'gym_membership', 'GYM Kartı', -1, 0, 1),
130 (602, 'powerade', 'Powerade', -1, 0, 1),
131 (603, 'sportlunch', 'Sportlunch', -1, 0, 1),
132 (604, 'protein_shake', 'Protein Karışımı', -1, 0, 1),
133 (605, 'contrat', 'Makbuz', 100, 0, 1),
134 (607, 'wool', 'Ä°plik', 40, 0, 1),
135 (608, 'fabric', 'KumaÅŸ', 80, 0, 1),
136 (609, 'clothe', 'Kıyafet', 40, 0, 1),
137 (610, 'plongee1', 'Plongee courte', -1, 0, 1),
138 (611, 'plongee2', 'Plongee longue', -1, 0, 1),
139 (612, 'contrat2', 'Kurtarılmış Öğe', 15, 0, 1),
140 (613, 'bottle', 'ÅžiÅŸe', -1, 0, 1),
141 (614, 'meat', 'Et', -1, 0, 1),
142 (615, 'leather', 'Hayvan Derisi', -1, 0, 1),
143 (617, 'kokorec2', 'Ekmek Arası Kokoreç', 20, 0, 1),
144 (618, 'poubelle', 'Çöp', -1, 0, 1),
145 (619, 'colis', 'Paket', -1, 0, 1),
146 (2010, 'yusuf', 'Silah Altın Kaplama', -1, 0, 1),
147 (2011, 'jewels', 'Mücevherler', -1, 0, 1),
148 (2012, 'mash', 'mash', -1, 0, 1),
149 (2013, 'boil_mash', 'boil_mash', -1, 0, 1),
150 (2014, 'jar_mash', 'jar_mash', -1, 0, 1),
151 (2015, 'sell_mash', 'sell_mash', -1, 0, 1),
152 (3000, 'rope', 'Ä°p', 2, 0, 1),
153 (3001, 'cannabis', 'Kenevir', 40, 0, 1),
154 (3002, 'marijuana', 'Marijuana', 14, 0, 1),
155 (3003, 'gps', 'GPS', 1, 0, 0),
156 (3004, 'tidning', 'Gazete', 1, 0, 1),
157 (3005, 'bag', 'Çanta', 1, 0, 1);
158/*!40000 ALTER TABLE `items` ENABLE KEYS */;