· 7 years ago · Dec 28, 2018, 12:00 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.1.22-MariaDB - mariadb.org binary distribution
4-- Server OS: Win64
5-- HeidiSQL Version: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for sql7243177
16
17USE `mosh`;
18
19-- Dumping structure for table sql7243177.users
20CREATE TABLE IF NOT EXISTS `users` (
21 `identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
22 `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
23 `money` int(11) DEFAULT NULL,
24 `bank` int(11) DEFAULT NULL,
25 `permission_level` int(11) DEFAULT NULL,
26 `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL
27) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
28
29-- Data exporting was unselected.
30/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
31/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
32/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
33
34USE `mosh`;
35
36ALTER TABLE `users`
37 ADD COLUMN `name` VARCHAR(255) NULL DEFAULT '' AFTER `money`,
38 ADD COLUMN `skin` LONGTEXT NULL AFTER `name`,
39 ADD COLUMN `job` varchar(255) NULL DEFAULT 'unemployed' AFTER `skin`,
40 ADD COLUMN `job_grade` INT NULL DEFAULT 0 AFTER `job`,
41 ADD COLUMN `loadout` LONGTEXT NULL AFTER `job_grade`,
42 ADD COLUMN `position` VARCHAR(255) NULL AFTER `loadout`
43;
44
45CREATE TABLE `items` (
46 `name` varchar(50) NOT NULL,
47 `label` varchar(255) NOT NULL,
48 `limit` int(11) NOT NULL DEFAULT '-1',
49 `rare` int(11) NOT NULL DEFAULT '0',
50 `can_remove` int(11) NOT NULL DEFAULT '1',
51
52 PRIMARY KEY (`name`)
53);
54
55CREATE TABLE `job_grades` (
56 `id` int(11) NOT NULL AUTO_INCREMENT,
57 `job_name` varchar(255) DEFAULT NULL,
58 `grade` int(11) NOT NULL,
59 `name` varchar(255) NOT NULL,
60 `label` varchar(255) NOT NULL,
61 `salary` int(11) NOT NULL,
62 `skin_male` longtext NOT NULL,
63 `skin_female` longtext NOT NULL,
64
65 PRIMARY KEY (`id`)
66);
67
68INSERT INTO `job_grades` VALUES (1,'unemployed',0,'unemployed','Unemployed',200,'{}','{}');
69
70CREATE TABLE `jobs` (
71 `name` varchar(50) NOT NULL,
72 `label` varchar(255) DEFAULT NULL,
73
74 PRIMARY KEY (`name`)
75);
76
77INSERT INTO `jobs` VALUES ('unemployed','Unemployed');
78
79CREATE TABLE `user_accounts` (
80
81 `id` int(11) NOT NULL AUTO_INCREMENT,
82 `identifier` varchar(255) NOT NULL,
83 `name` varchar(255) NOT NULL,
84 `money` double NOT NULL DEFAULT '0',
85
86 PRIMARY KEY (`id`)
87);
88
89CREATE TABLE `user_inventory` (
90
91 `id` int(11) NOT NULL AUTO_INCREMENT,
92 `identifier` varchar(255) NOT NULL,
93 `item` varchar(255) NOT NULL,
94 `count` int(11) NOT NULL,
95
96 PRIMARY KEY (`id`)
97);
98
99USE `mosh`;
100
101CREATE TABLE `addon_account` (
102 `id` int(11) NOT NULL AUTO_INCREMENT,
103 `name` varchar(255) NOT NULL,
104 `label` varchar(255) NOT NULL,
105 `shared` int(11) NOT NULL,
106 PRIMARY KEY (`id`)
107);
108
109CREATE TABLE `addon_account_data` (
110 `id` int(11) NOT NULL AUTO_INCREMENT,
111 `account_name` varchar(255) DEFAULT NULL,
112 `money` double NOT NULL,
113 `owner` varchar(255) DEFAULT NULL,
114 PRIMARY KEY (`id`)
115);
116
117USE `mosh`;
118
119CREATE TABLE `addon_inventory` (
120 `id` int(11) NOT NULL AUTO_INCREMENT,
121 `name` varchar(255) NOT NULL,
122 `label` varchar(255) NOT NULL,
123 `shared` int(11) NOT NULL,
124 PRIMARY KEY (`id`)
125);
126
127CREATE TABLE `addon_inventory_items` (
128 `id` int(11) NOT NULL AUTO_INCREMENT,
129 `inventory_name` varchar(255) NOT NULL,
130 `name` varchar(255) NOT NULL,
131 `count` int(11) NOT NULL,
132 `owner` varchar(60) DEFAULT NULL,
133 PRIMARY KEY (`id`)
134);
135
136USE `mosh`;
137
138ALTER TABLE `users`
139 ADD COLUMN `firstname` VARCHAR(50) NULL DEFAULT '',
140 ADD COLUMN `lastname` VARCHAR(50) NULL DEFAULT '',
141 ADD COLUMN `dateofbirth` VARCHAR(25) NULL DEFAULT '',
142 ADD COLUMN `sex` VARCHAR(10) NULL DEFAULT '',
143 ADD COLUMN `height` VARCHAR(5) NULL DEFAULT ''
144;
145
146CREATE TABLE `characters` (
147 `id` int(11) NOT NULL AUTO_INCREMENT,
148 `identifier` VARCHAR(255) NOT NULL,
149 `firstname` VARCHAR(255) NOT NULL,
150 `lastname` VARCHAR(255) NOT NULL,
151 `dateofbirth` VARCHAR(255) NOT NULL,
152 `sex` VARCHAR(1) NOT NULL DEFAULT 'M',
153 `height` VARCHAR(128) NOT NULL,
154
155 PRIMARY KEY (`id`)
156);
157
158USE `mosh`;
159
160CREATE TABLE `billing` (
161 `id` int(11) NOT NULL AUTO_INCREMENT,
162 `identifier` varchar(255) NOT NULL,
163 `sender` varchar(255) NOT NULL,
164 `target_type` varchar(50) NOT NULL,
165 `target` varchar(255) NOT NULL,
166 `label` varchar(255) NOT NULL,
167 `amount` int(11) NOT NULL,
168
169 PRIMARY KEY (`id`)
170);
171
172USE `mosh`;
173
174CREATE TABLE `datastore` (
175 `id` int(11) NOT NULL AUTO_INCREMENT,
176 `name` varchar(255) NOT NULL,
177 `label` varchar(255) NOT NULL,
178 `shared` int(11) NOT NULL,
179 PRIMARY KEY (`id`)
180);
181
182CREATE TABLE `datastore_data` (
183 `id` int(11) NOT NULL AUTO_INCREMENT,
184 `name` varchar(255) NOT NULL,
185 `owner` varchar(255),
186 `data` longtext,
187 PRIMARY KEY (`id`)
188);
189
190USE `mosh`;
191
192CREATE TABLE `society_moneywash` (
193 `id` int(11) NOT NULL AUTO_INCREMENT,
194 `identifier` varchar(60) NOT NULL,
195 `society` varchar(60) NOT NULL,
196 `amount` int(11) NOT NULL,
197
198 PRIMARY KEY (`id`)
199);
200
201USE `mosh`;
202
203CREATE TABLE `user_parkings` (
204
205 `id` int(11) NOT NULL AUTO_INCREMENT,
206 `identifier` varchar(60) DEFAULT NULL,
207 `garage` varchar(60) DEFAULT NULL,
208 `zone` int(11) NOT NULL,
209 `vehicle` longtext,
210
211 PRIMARY KEY (`id`)
212);
213
214INSERT INTO `addon_account` (name, label, shared) VALUES
215 ('society_police','Police',1)
216;
217
218INSERT INTO `datastore` (name, label, shared) VALUES
219 ('society_police','Police',1)
220;
221
222INSERT INTO `addon_inventory` (name, label, shared) VALUES
223 ('society_police', 'Police', 1)
224;
225
226INSERT INTO `jobs` (name, label) VALUES
227 ('police','LSPD')
228;
229
230INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
231 ('police',0,'recruit','Recruit',20,'{}','{}'),
232 ('police',1,'officer','Officier',40,'{}','{}'),
233 ('police',2,'sergeant','Sergeant',60,'{}','{}'),
234 ('police',3,'lieutenant','Lieutenant',85,'{}','{}'),
235 ('police',4,'boss','Chief',100,'{}','{}')
236;
237
238CREATE TABLE `fine_types` (
239
240 `id` int(11) NOT NULL AUTO_INCREMENT,
241 `label` varchar(255) DEFAULT NULL,
242 `amount` int(11) DEFAULT NULL,
243 `category` int(11) DEFAULT NULL,
244
245 PRIMARY KEY (`id`)
246);
247
248INSERT INTO `fine_types` (label, amount, category) VALUES
249 ('Misuse of a horn', 30, 0),
250 ('Illegally Crossing a continuous Line', 40, 0),
251 ('Driving on the wrong side of the road', 250, 0),
252 ('Illegal U-Turn', 250, 0),
253 ('Illegally Driving Off-road', 170, 0),
254 ('Refusing a Lawful Command', 30, 0),
255 ('Illegally Stoped of a Vehicle', 150, 0),
256 ('Illegal Parking', 70, 0),
257 ('Failing to Yield to the right', 70, 0),
258 ('Failure to comply with Vehicle Information', 90, 0),
259 ('Failing to stop at a Stop Sign ', 105, 0),
260 ('Failing to stop at a Red Light', 130, 0),
261 ('Illegal Passing', 100, 0),
262 ('Driving an illegal Vehicle', 100, 0),
263 ('Driving without a License', 1500, 0),
264 ('Hit and Run', 800, 0),
265 ('Exceeding Speeds Over < 5 mph', 90, 0),
266 ('Exceeding Speeds Over 5-15 mph', 120, 0),
267 ('Exceeding Speeds Over 15-30 mph', 180, 0),
268 ('Exceeding Speeds Over > 30 mph', 300, 0),
269 ('Impeding traffic flow', 110, 1),
270 ('Public Intoxication', 90, 1),
271 ('Disorderly conduct', 90, 1),
272 ('Obstruction of Justice', 130, 1),
273 ('Insults towards Civilans', 75, 1),
274 ('Disrespecting of an LEO', 110, 1),
275 ('Verbal Threat towards a Civilan', 90, 1),
276 ('Verbal Threat towards an LEO', 150, 1),
277 ('Providing False Information', 250, 1),
278 ('Attempt of Corruption', 1500, 1),
279 ('Brandishing a weapon in city Limits', 120, 2),
280 ('Brandishing a Lethal Weapon in city Limits', 300, 2),
281 ('No Firearms License', 600, 2),
282 ('Possession of an Illegal Weapon', 700, 2),
283 ('Possession of Burglary Tools', 300, 2),
284 ('Grand Theft Auto', 1800, 2),
285 ('Intent to Sell/Distrube of an illegal Substance', 1500, 2),
286 ('Frabrication of an Illegal Substance', 1500, 2),
287 ('Possession of an Illegal Substance ', 650, 2),
288 ('Kidnapping of a Civilan', 1500, 2),
289 ('Kidnapping of an LEO', 2000, 2),
290 ('Robbery', 650, 2),
291 ('Armed Robbery of a Store', 650, 2),
292 ('Armed Robbery of a Bank', 1500, 2),
293 ('Assault on a Civilian', 2000, 3),
294 ('Assault of an LEO', 2500, 3),
295 ('Attempt of Murder of a Civilian', 3000, 3),
296 ('Attempt of Murder of an LEO', 5000, 3),
297 ('Murder of a Civilian', 10000, 3),
298 ('Murder of an LEO', 30000, 3),
299 ('Involuntary manslaughter', 1800, 3),
300 ('Fraud', 2000, 2);
301;
302
303USE `mosh`;
304
305INSERT INTO `addon_account` (name, label, shared) VALUES
306 ('society_ambulance', 'Ambulance', 1)
307;
308
309INSERT INTO `addon_inventory` (name, label, shared) VALUES
310 ('society_ambulance', 'Ambulance', 1)
311;
312
313INSERT INTO `datastore` (name, label, shared) VALUES
314 ('society_ambulance', 'Ambulance', 1)
315;
316
317
318INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
319 ('ambulance',0,'ambulance','Ambulance',20,'{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}','{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
320 ('ambulance',1,'doctor','Doctor',40,'{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}','{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
321 ('ambulance',2,'chief_doctor','Chief doctor',60,'{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}','{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
322 ('ambulance',3,'boss','Surgeon',80,'{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}','{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}')
323;
324
325INSERT INTO `jobs` (name, label) VALUES
326 ('ambulance','Ambulance')
327;
328
329INSERT INTO `items` (name, label, `limit`) VALUES
330 ('bandage','Bandage', 20),
331 ('medikit','Medikit', 5)
332;
333
334ALTER TABLE `users` ADD `isDead` BIT(1) DEFAULT b'0';
335
336CREATE TABLE jail (
337 identifier VARCHAR(100) NOT NULL,
338 jail_time int(10) NOT NULL,
339 PRIMARY KEY (identifier)
340);
341
342CREATE TABLE `user_appartement` (
343 `id` int(11) NOT NULL,
344 `identifier` varchar(60) NOT NULL,
345 `name` varchar(255) NOT NULL,
346 `price` int(11) NOT NULL,
347 `money` int(11) NOT NULL DEFAULT '0',
348 `dirtymoney` int(11) NOT NULL DEFAULT '0'
349) ENGINE=MyISAM DEFAULT CHARSET=latin1;
350
351ALTER TABLE `user_appartement`
352 ADD PRIMARY KEY (`id`);
353
354ALTER TABLE `user_appartement`
355 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
356--
357-- Contenu de la table `jobs`
358--
359
360INSERT INTO `jobs` (`name`, `label`) VALUES
361('garbage', 'Driver');
362
363--
364-- Contenu de la table `job_grades`
365--
366
367INSERT INTO `job_grades` (`job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
368('garbage', 0, 'employee', 'Employee', 750, '{"tshirt_1":59,"torso_1":89,"arms":31,"pants_1":36,"glasses_1":19,"decals_2":0,"hair_color_2":0,"helmet_2":0,"hair_color_1":0,"face":2,"glasses_2":0,"torso_2":1,"shoes":35,"hair_1":0,"skin":0,"sex":0,"glasses_1":19,"pants_2":0,"hair_2":0,"decals_1":0,"tshirt_2":0,"helmet_1":5}', '{"tshirt_1":36,"torso_1":0,"arms":68,"pants_1":30,"glasses_1":15,"decals_2":0,"hair_color_2":0,"helmet_2":0,"hair_color_1":0,"face":27,"glasses_2":0,"torso_2":11,"shoes":26,"hair_1":5,"skin":0,"sex":1,"glasses_1":15,"pants_2":2,"hair_2":0,"decals_1":0,"tshirt_2":0,"helmet_1":19}');
369
370USE `mosh`;
371
372INSERT INTO `addon_account` (name, label, shared) VALUES
373 ('society_banker','Banque',1),
374 ('bank_savings','Livret Bleu',0)
375;
376
377INSERT INTO `jobs` (name, label) VALUES
378 ('banker','Banquier')
379;
380
381INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
382 ('banker',0,'advisor','Conseiller',10,'{}','{}'),
383 ('banker',1,'banker','Banquier',20,'{}','{}'),
384 ('banker',2,'business_banker','Banquier d\'affaire',30,'{}','{}'),
385 ('banker',3,'trader','Trader',40,'{}','{}'),
386 ('banker',4,'boss','Patron',0,'{}','{}')
387;
388
389USE `mosh`;
390
391INSERT INTO `addon_account` (name, label, shared) VALUES
392 ('caution', 'caution', 0)
393;
394
395INSERT INTO `jobs` (name, label) VALUES
396 ('slaughterer', 'Butcher'),
397 ('fisherman', 'Fisherman'),
398 ('miner', 'Miner'),
399 ('lumberjack', 'Lumberjack'),
400 ('fueler', 'Fueler'),
401 ('reporter', 'Reporter'),
402 ('tailor', 'Tailor')
403;
404
405INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
406 ('lumberjack', 0, 'interim', 'Employee', 0, '{}', '{}'),
407 ('fisherman', 0, 'interim', 'Employee', 0, '{}', '{}'),
408 ('fueler', 0, 'interim', 'Employee', 0, '{}', '{}'),
409 ('reporter', 0, 'employee', 'Employee', 0, '{}', '{}'),
410 ('tailor', 0, 'interim', 'Employee', 0, '{\"mask_1\":0,\"arms\":1,\"glasses_1\":0,\"hair_color_2\":4,\"makeup_1\":0,\"face\":19,\"glasses\":0,\"mask_2\":0,\"makeup_3\":0,\"skin\":29,\"helmet_2\":0,\"lipstick_4\":0,\"sex\":0,\"torso_1\":24,\"makeup_2\":0,\"bags_2\":0,\"chain_2\":0,\"ears_1\":-1,\"bags_1\":0,\"bproof_1\":0,\"shoes_2\":0,\"lipstick_2\":0,\"chain_1\":0,\"tshirt_1\":0,\"eyebrows_3\":0,\"pants_2\":0,\"beard_4\":0,\"torso_2\":0,\"beard_2\":6,\"ears_2\":0,\"hair_2\":0,\"shoes_1\":36,\"tshirt_2\":0,\"beard_3\":0,\"hair_1\":2,\"hair_color_1\":0,\"pants_1\":48,\"helmet_1\":-1,\"bproof_2\":0,\"eyebrows_4\":0,\"eyebrows_2\":0,\"decals_1\":0,\"age_2\":0,\"beard_1\":5,\"shoes\":10,\"lipstick_1\":0,\"eyebrows_1\":0,\"glasses_2\":0,\"makeup_4\":0,\"decals_2\":0,\"lipstick_3\":0,\"age_1\":0}','{\"mask_1\":0,\"arms\":5,\"glasses_1\":5,\"hair_color_2\":4,\"makeup_1\":0,\"face\":19,\"glasses\":0,\"mask_2\":0,\"makeup_3\":0,\"skin\":29,\"helmet_2\":0,\"lipstick_4\":0,\"sex\":1,\"torso_1\":52,\"makeup_2\":0,\"bags_2\":0,\"chain_2\":0,\"ears_1\":-1,\"bags_1\":0,\"bproof_1\":0,\"shoes_2\":1,\"lipstick_2\":0,\"chain_1\":0,\"tshirt_1\":23,\"eyebrows_3\":0,\"pants_2\":0,\"beard_4\":0,\"torso_2\":0,\"beard_2\":6,\"ears_2\":0,\"hair_2\":0,\"shoes_1\":42,\"tshirt_2\":4,\"beard_3\":0,\"hair_1\":2,\"hair_color_1\":0,\"pants_1\":36,\"helmet_1\":-1,\"bproof_2\":0,\"eyebrows_4\":0,\"eyebrows_2\":0,\"decals_1\":0,\"age_2\":0,\"beard_1\":5,\"shoes\":10,\"lipstick_1\":0,\"eyebrows_1\":0,\"glasses_2\":0,\"makeup_4\":0,\"decals_2\":0,\"lipstick_3\":0,\"age_1\":0}'),
411 ('miner', 0, 'interim', 'Employee', 0, '{"tshirt_2":1,"ears_1":8,"glasses_1":15,"torso_2":0,"ears_2":2,"glasses_2":3,"shoes_2":1,"pants_1":75,"shoes_1":51,"bags_1":0,"helmet_2":0,"pants_2":7,"torso_1":71,"tshirt_1":59,"arms":2,"bags_2":0,"helmet_1":0}', '{}'),
412 ('slaughterer', 0, 'interim', 'Employee', 0, '{\"age_1\":0,\"glasses_2\":0,\"beard_1\":5,\"decals_2\":0,\"beard_4\":0,\"shoes_2\":0,\"tshirt_2\":0,\"lipstick_2\":0,\"hair_2\":0,\"arms\":67,\"pants_1\":36,\"skin\":29,\"eyebrows_2\":0,\"shoes\":10,\"helmet_1\":-1,\"lipstick_1\":0,\"helmet_2\":0,\"hair_color_1\":0,\"glasses\":0,\"makeup_4\":0,\"makeup_1\":0,\"hair_1\":2,\"bproof_1\":0,\"bags_1\":0,\"mask_1\":0,\"lipstick_3\":0,\"chain_1\":0,\"eyebrows_4\":0,\"sex\":0,\"torso_1\":56,\"beard_2\":6,\"shoes_1\":12,\"decals_1\":0,\"face\":19,\"lipstick_4\":0,\"tshirt_1\":15,\"mask_2\":0,\"age_2\":0,\"eyebrows_3\":0,\"chain_2\":0,\"glasses_1\":0,\"ears_1\":-1,\"bags_2\":0,\"ears_2\":0,\"torso_2\":0,\"bproof_2\":0,\"makeup_2\":0,\"eyebrows_1\":0,\"makeup_3\":0,\"pants_2\":0,\"beard_3\":0,\"hair_color_2\":4}','{\"age_1\":0,\"glasses_2\":0,\"beard_1\":5,\"decals_2\":0,\"beard_4\":0,\"shoes_2\":0,\"tshirt_2\":0,\"lipstick_2\":0,\"hair_2\":0,\"arms\":72,\"pants_1\":45,\"skin\":29,\"eyebrows_2\":0,\"shoes\":10,\"helmet_1\":-1,\"lipstick_1\":0,\"helmet_2\":0,\"hair_color_1\":0,\"glasses\":0,\"makeup_4\":0,\"makeup_1\":0,\"hair_1\":2,\"bproof_1\":0,\"bags_1\":0,\"mask_1\":0,\"lipstick_3\":0,\"chain_1\":0,\"eyebrows_4\":0,\"sex\":1,\"torso_1\":49,\"beard_2\":6,\"shoes_1\":24,\"decals_1\":0,\"face\":19,\"lipstick_4\":0,\"tshirt_1\":9,\"mask_2\":0,\"age_2\":0,\"eyebrows_3\":0,\"chain_2\":0,\"glasses_1\":5,\"ears_1\":-1,\"bags_2\":0,\"ears_2\":0,\"torso_2\":0,\"bproof_2\":0,\"makeup_2\":0,\"eyebrows_1\":0,\"makeup_3\":0,\"pants_2\":0,\"beard_3\":0,\"hair_color_2\":4}')
413;
414
415INSERT INTO `items` (`name`, `label`, `limit`) VALUES
416 ('alive_chicken', 'living chicken', 20),
417 ('slaughtered_chicken', 'slaughtered chicken', 20),
418 ('packaged_chicken', 'chicken fillet', 100),
419 ('fish', 'fish', 100),
420 ('stone', 'stone', 7),
421 ('washed_stone', 'washed stone', 7),
422 ('copper', 'copper', 56),
423 ('iron', 'iron', 42),
424 ('gold', 'gold', 21),
425 ('diamond', 'diamond', 50),
426 ('wood', 'wood', 20),
427 ('cutted_wood', 'cut wood', 20),
428 ('packaged_plank', 'packaged wood', 100),
429 ('petrol', 'oil', 24),
430 ('petrol_raffin', 'processed oil', 24),
431 ('essence', 'gas', 24),
432 ('whool', 'wool', 40),
433 ('fabric', 'fabric', 80),
434 ('clothe', 'cloth', 40)
435;