· 6 years ago · Apr 13, 2019, 02:10 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Czas generowania: 13 Kwi 2019, 15:51
7-- Wersja serwera: 10.1.29-MariaDB-1~jessie
8-- Wersja PHP: 5.6.30-0+deb8u1
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-- Baza danych: `zap402833-1`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabeli dla tabeli `job_grades`
27--
28
29CREATE TABLE IF NOT EXISTS `job_grades` (
30`id` int(11) NOT NULL,
31 `job_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
32 `grade` int(11) NOT NULL,
33 `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
34 `label` varchar(255) COLLATE utf8mb4_bin NOT NULL,
35 `salary` int(11) NOT NULL,
36 `skin_male` longtext COLLATE utf8mb4_bin NOT NULL,
37 `skin_female` longtext COLLATE utf8mb4_bin NOT NULL
38) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
39
40--
41-- Zrzut danych tabeli `job_grades`
42--
43
44INSERT INTO `job_grades` (`id`, `job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
45(1, 'unemployed', 0, 'rsa', 'Zasilek', 300, '{}', '{}'),
46(2, 'police', 0, 'recruit', 'Kadet', 1000, '{"tshirt_1":57,"torso_1":55,"arms":0,"pants_1":35,"glasses":0,"decals_2":0,"hair_color_2":0,"helmet_2":0,"hair_color_1":5,"face":19,"glasses_2":1,"torso_2":0,"shoes":24,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"pants_2":0,"hair_2":0,"decals_1":0,"tshirt_2":0,"helmet_1":8}', '{"tshirt_1":34,"torso_1":48,"shoes":24,"pants_1":34,"torso_2":0,"decals_2":0,"hair_color_2":0,"glasses":0,"helmet_2":0,"hair_2":3,"face":21,"decals_1":0,"glasses_2":1,"hair_1":11,"skin":34,"sex":1,"glasses_1":5,"pants_2":0,"arms":14,"hair_color_1":10,"tshirt_2":0,"helmet_1":57}'),
47(3, 'police', 1, 'officer', 'Oficer I', 1500, '{"tshirt_1":58,"torso_1":55,"shoes":24,"pants_1":35,"pants_2":0,"decals_2":1,"hair_color_2":0,"face":19,"helmet_2":0,"hair_2":0,"arms":0,"decals_1":8,"torso_2":0,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"glasses_2":1,"hair_color_1":5,"glasses":0,"tshirt_2":0,"helmet_1":11}', '{"tshirt_1":35,"torso_1":48,"arms":14,"pants_1":34,"pants_2":0,"decals_2":1,"hair_color_2":0,"shoes":24,"helmet_2":0,"hair_2":3,"decals_1":7,"torso_2":0,"face":21,"hair_1":11,"skin":34,"sex":1,"glasses_1":5,"glasses_2":1,"hair_color_1":10,"glasses":0,"tshirt_2":0,"helmet_1":57}'),
48(4, 'police', 2, 'officer', 'Oficer II', 2000, '{"tshirt_1":58,"torso_1":55,"shoes":24,"pants_1":35,"pants_2":0,"decals_2":1,"hair_color_2":0,"face":19,"helmet_2":0,"hair_2":0,"arms":0,"decals_1":8,"torso_2":0,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"glasses_2":1,"hair_color_1":5,"glasses":0,"tshirt_2":0,"helmet_1":11}', '{"tshirt_1":35,"torso_1":48,"arms":14,"pants_1":34,"pants_2":0,"decals_2":1,"hair_color_2":0,"shoes":24,"helmet_2":0,"hair_2":3,"decals_1":7,"torso_2":0,"face":21,"hair_1":11,"skin":34,"sex":1,"glasses_1":5,"glasses_2":1,"hair_color_1":10,"glasses":0,"tshirt_2":0,"helmet_1":57}'),
49(5, 'police', 3, 'officer', 'Oficer III', 2250, '{"tshirt_1":58,"torso_1":55,"shoes":24,"pants_1":35,"pants_2":0,"decals_2":2,"hair_color_2":0,"face":19,"helmet_2":0,"hair_2":0,"glasses":0,"decals_1":8,"hair_color_1":5,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"glasses_2":1,"torso_2":0,"arms":41,"tshirt_2":0,"helmet_1":11}', '{"tshirt_1":35,"torso_1":48,"arms":44,"pants_1":34,"hair_2":3,"decals_2":2,"hair_color_2":0,"hair_color_1":10,"helmet_2":0,"face":21,"shoes":24,"torso_2":0,"glasses_2":1,"hair_1":11,"skin":34,"sex":1,"glasses_1":5,"pants_2":0,"decals_1":7,"glasses":0,"tshirt_2":0,"helmet_1":57}'),
50(6, 'police', 14, 'boss', 'Komendant', 5750, '{"tshirt_1":58,"torso_1":55,"shoes":24,"pants_1":35,"pants_2":0,"decals_2":3,"hair_color_2":0,"face":19,"helmet_2":0,"hair_2":0,"arms":41,"torso_2":0,"hair_color_1":5,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"glasses_2":1,"decals_1":8,"glasses":0,"tshirt_2":0,"helmet_1":11}', '{"tshirt_1":35,"torso_1":48,"arms":44,"pants_1":34,"pants_2":0,"decals_2":3,"hair_color_2":0,"face":21,"helmet_2":0,"hair_2":3,"decals_1":7,"torso_2":0,"hair_color_1":10,"hair_1":11,"skin":34,"sex":1,"glasses_1":5,"glasses_2":1,"shoes":24,"glasses":0,"tshirt_2":0,"helmet_1":57}'),
51(7, 'police', 4, 'sergeant', 'Sierżant I', 2500, '{"tshirt_1":58,"torso_1":55,"shoes":24,"pants_1":35,"pants_2":0,"decals_2":3,"hair_color_2":0,"face":19,"helmet_2":0,"hair_2":0,"arms":41,"torso_2":0,"hair_color_1":5,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"glasses_2":1,"decals_1":8,"glasses":0,"tshirt_2":0,"helmet_1":11}', '{"tshirt_1":35,"torso_1":48,"arms":44,"pants_1":34,"pants_2":0,"decals_2":3,"hair_color_2":0,"face":21,"helmet_2":0,"hair_2":3,"decals_1":7,"torso_2":0,"hair_color_1":10,"hair_1":11,"skin":34,"sex":1,"glasses_1":5,"glasses_2":1,"shoes":24,"glasses":0,"tshirt_2":0,"helmet_1":57}'),
52(8, 'police', 5, 'sergeant', 'Sierżant II', 2750, '{"tshirt_1":58,"torso_1":55,"shoes":24,"pants_1":35,"pants_2":0,"decals_2":1,"hair_color_2":0,"face":19,"helmet_2":0,"hair_2":0,"arms":0,"decals_1":8,"torso_2":0,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"glasses_2":1,"hair_color_1":5,"glasses":0,"tshirt_2":0,"helmet_1":11}', '{}'),
53(9, 'police', 6, 'sergeant', 'Sierżant III', 3000, '{"tshirt_1":58,"torso_1":55,"shoes":24,"pants_1":35,"pants_2":0,"decals_2":1,"hair_color_2":0,"face":19,"helmet_2":0,"hair_2":0,"arms":0,"decals_1":8,"torso_2":0,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"glasses_2":1,"hair_color_1":5,"glasses":0,"tshirt_2":0,"helmet_1":11}', '{}'),
54(10, 'police', 7, 'intendent', 'Porucznik I', 3250, '{"tshirt_1":58,"torso_1":55,"shoes":24,"pants_1":35,"pants_2":0,"decals_2":1,"hair_color_2":0,"face":19,"helmet_2":0,"hair_2":0,"arms":0,"decals_1":8,"torso_2":0,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"glasses_2":1,"hair_color_1":5,"glasses":0,"tshirt_2":0,"helmet_1":11}', '{}'),
55(11, 'police', 8, 'intendent', 'Porucznik II', 3500, '{"tshirt_1":58,"torso_1":55,"shoes":24,"pants_1":35,"pants_2":0,"decals_2":1,"hair_color_2":0,"face":19,"helmet_2":0,"hair_2":0,"arms":0,"decals_1":8,"torso_2":0,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"glasses_2":1,"hair_color_1":5,"glasses":0,"tshirt_2":0,"helmet_1":11}', '{}'),
56(12, 'police', 10, 'lieutenant', 'Kapitan I', 4200, '{"tshirt_1":58,"torso_1":55,"shoes":24,"pants_1":35,"pants_2":0,"decals_2":1,"hair_color_2":0,"face":19,"helmet_2":0,"hair_2":0,"arms":0,"decals_1":8,"torso_2":0,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"glasses_2":1,"hair_color_1":5,"glasses":0,"tshirt_2":0,"helmet_1":11}', '{}'),
57(13, 'police', 11, 'lieutenant', 'Kapitan II', 4500, '{"tshirt_1":58,"torso_1":55,"shoes":24,"pants_1":35,"pants_2":0,"decals_2":1,"hair_color_2":0,"face":19,"helmet_2":0,"hair_2":0,"arms":0,"decals_1":8,"torso_2":0,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"glasses_2":1,"hair_color_1":5,"glasses":0,"tshirt_2":0,"helmet_1":11}', '{}'),
58(14, 'police', 17, 'wiecznykadet', 'WiecznyKadet', 2500, '{"tshirt_1":57,"torso_1":55,"arms":0,"pants_1":35,"glasses":0,"decals_2":0,"hair_color_2":0,"helmet_2":0,"hair_color_1":5,"face":19,"glasses_2":1,"torso_2":0,"shoes":24,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"pants_2":0,"hair_2":0,"decals_1":0,"tshirt_2":0,"helmet_1":8}', '{}'),
59(15, 'police', 16, 'swat', 'S.W.A.T', 2250, '{"tshirt_1":58,"torso_1":55,"shoes":24,"pants_1":35,"pants_2":0,"decals_2":1,"hair_color_2":0,"face":19,"helmet_2":0,"hair_2":0,"arms":0,"decals_1":8,"torso_2":0,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"glasses_2":1,"hair_color_1":5,"glasses":0,"tshirt_2":0,"helmet_1":11}', '{}'),
60(16, 'realestateagent', 0, 'location', 'Location', 500, '{}', '{}'),
61(17, 'realestateagent', 1, 'vendeur', 'Seller', 1000, '{}', '{}'),
62(18, 'realestateagent', 2, 'gestion', 'Management', 2000, '{}', '{}'),
63(19, 'realestateagent', 3, 'boss', 'Boss', 2500, '{}', '{}'),
64(20, 'lumberjack', 0, 'interim', 'Zatrudniony', 750, '{}', '{}'),
65(21, 'fisherman', 0, 'interim', 'Zatrudniony', 750, '{}', '{}'),
66(22, 'fuel', 0, 'interim', 'Zatrudniony', 750, '{}', '{}'),
67(23, 'reporter', 0, 'employee', 'Zatrudniony', 750, '{}', '{}'),
68(24, 'textil', 0, 'interim', 'Zatrudniony', 750, '{"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}'),
69(25, 'miner', 0, 'interim', 'Zatrudniony', 750, '{"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}', '{}'),
70(26, 'slaughterer', 0, 'interim', 'Zatrudniony', 750, '{"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}'),
71(27, 'taxi', 0, 'recrue', 'Stażysta', 750, '{}', '{}'),
72(28, 'taxi', 1, 'novice', 'Kierowca', 1500, '{}', '{}'),
73(29, 'taxi', 2, 'experimente', 'Doświadczony', 2000, '{}', '{}'),
74(30, 'taxi', 3, 'uber', 'Zastępca szefa', 2500, '{}', '{}'),
75(31, 'taxi', 4, 'boss', 'Szef', 3000, '{}', '{}'),
76(32, 'cardealer', 0, 'recruit', 'Recruit', 750, '{}', '{}'),
77(33, 'cardealer', 1, 'novice', 'Novice', 1000, '{}', '{}'),
78(34, 'cardealer', 2, 'experienced', 'Experienced', 2000, '{}', '{}'),
79(35, 'cardealer', 3, 'boss', 'Boss', 2500, '{}', '{}'),
80(36, 'banker', 0, 'advisor', 'Adviser', 500, '{}', '{}'),
81(37, 'banker', 1, 'banker', 'Banker', 750, '{}', '{}'),
82(38, 'banker', 2, 'business_banker', 'Business Banker', 1000, '{}', '{}'),
83(39, 'banker', 3, 'trader', 'Trader', 1250, '{}', '{}'),
84(40, 'banker', 4, 'boss', 'Boss', 2500, '{}', '{}'),
85(41, 'mecano', 0, 'recrue', 'Praktykant', 750, '{}', '{}'),
86(42, 'mecano', 1, 'novice', 'Stażysta', 1000, '{}', '{}'),
87(43, 'mecano', 2, 'experimente', 'Mechanik', 2250, '{}', '{}'),
88(44, 'mecano', 3, 'chief', 'Zastępca szefa', 4250, '{}', '{}'),
89(45, 'mecano', 4, 'boss', 'Wlasciciel', 5250, '{}', '{}'),
90(46, 'ambulance', 0, 'ambulance', 'Ratownik', 1700, '{"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}'),
91(47, 'ambulance', 1, 'doctor', 'Lekarz', 2250, '{"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}'),
92(48, 'ambulance', 2, 'chief_doctor', 'Chirurg', 3500, '{"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}'),
93(49, 'ambulance', 3, 'boss', 'Ordynator', 73, '{"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}'),
94(50, 'cardealer', 0, 'recruit', 'Recrue', 10, '{}', '{}'),
95(51, 'cardealer', 1, 'novice', 'Novice', 25, '{}', '{}'),
96(52, 'cardealer', 2, 'experienced', 'Experimente', 40, '{}', '{}'),
97(53, 'cardealer', 3, 'boss', 'Patron', 0, '{}', '{}'),
98(54, 'foodtruck', 0, 'cook', 'Pracownik', 750, '{}', '{}'),
99(55, 'foodtruck', 1, 'boss', 'Szef', 2500, '{}', '{}'),
100(67, 'vagos', 0, 'vagos', 'vagos', 600, '{}', '{}'),
101(70, 'mafia', 0, 'soldato', 'Mieso Armatnie', 1000, '{}', '{}'),
102(71, 'mafia', 1, 'capo', 'Gangster', 2000, '{}', '{}'),
103(72, 'mafia', 2, 'consigliere', 'Strzelec', 3000, '{}', '{}'),
104(73, 'mafia', 3, 'boss', 'Szef', 4000, '{}', '{}'),
105(74, 'cartel', 0, 'soldato', 'La Cosa Nostra- świeży', 1000, '{}', '{}'),
106(75, 'cartel', 1, 'capo', 'La Cosa Nostra-Gangster', 2000, '{}', '{}'),
107(76, 'cartel', 2, 'consigliere', ' La Cosa Nostra -Zabójca', 3000, '', ''),
108(77, 'cartel', 3, 'boss', 'La Cosa Nostra - Szef', 4000, '', ''),
109(78, 'gang', 0, 'soldato', 'la familia- Świeży', 1000, '', ''),
110(79, 'gang', 1, 'capo', 'la familia - gangster', 1500, '', ''),
111(80, 'gang', 2, 'consigliere', 'la familia - zabójca', 2500, '', ''),
112(81, 'gang', 3, 'boss', 'la familia - szef', 3000, '', ''),
113(82, 'pizza', 0, 'employee', 'Pracownik', 750, '', ''),
114(83, 'police', 9, 'intendent', 'Porucznik III', 4000, '', '{}'),
115(84, 'police', 12, 'lieutenant', 'Kapitan III', 4750, '', '{}'),
116(85, 'police', 13, 'boss', 'Zastępca komendanta', 5250, '', '{}'),
117(86, 'rentcar', 3, 'boss', 'szef', 4500, '', '{}'),
118(87, 'rentcar', 2, 'boss', 'Sprzedawca', 3500, '', '{}'),
119(89, 'rentcar', 1, 'boss', 'Rekrut', 1000, '', '{}'),
120(90, 'offpolice', 0, 'recruit', 'kadet', 12, '', '{}'),
121(91, 'offpolice', 1, 'officer', 'Oficer', 24, '', '{}'),
122(92, 'offpolice', 2, 'sergeant', 'Sierzant', 36, '', '{}'),
123(93, 'offpolice', 3, 'lieutenant', 'Porucznik/kapitan', 48, '', '{}'),
124(94, 'offpolice', 4, 'boss', 'Komendant', 56, '', '{}'),
125(95, 'offambulance', 0, 'ambulance', 'Ratownik', 12, '', '{}'),
126(96, 'offambulance', 1, 'doctor', 'Lekarz', 24, '', '{}'),
127(97, 'offambulance', 1, 'chief_doctor', 'Chirurg', 36, '', '{}'),
128(98, 'offambulance', 1, 'boss', 'Ordynator', 48, '', '{}'),
129(99, 'vigne', 0, 'recrue', 'Rekrut', 700, '', '{}'),
130(100, 'vigne', 1, 'novice', 'Nowicjusz', 1000, '', '{}'),
131(101, 'vigne', 2, 'cdisenior', 'Pracownik', 2000, '', '{}'),
132(102, 'vigne', 3, 'boss', 'Szef', 3500, '', '{}'),
133(103, 'gang', 5, 'soldato', 'Islam Furry', 1000, '{}', '{}');
134
135--
136-- Indeksy dla zrzutów tabel
137--
138
139--
140-- Indexes for table `job_grades`
141--
142ALTER TABLE `job_grades`
143 ADD PRIMARY KEY (`id`) USING BTREE;
144
145--
146-- AUTO_INCREMENT for dumped tables
147--
148
149--
150-- AUTO_INCREMENT dla tabeli `job_grades`
151--
152ALTER TABLE `job_grades`
153MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=104;
154/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
155/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
156/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;