j3ksKj2y

1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u6
3-- http://www.phpmyadmin.net
4--
5-- Client :  localhost
6-- Généré le :  Lun 12 Août 2019 à 18:16
7-- Version du serveur :  5.5.62-0+deb8u1
8-- Version de PHP :  5.6.40-0+deb8u4
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-- Base de données :  `essentialmode`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `addon_account`
27--
28
29CREATE TABLE IF NOT EXISTS `addon_account` (
30  `name` varchar(60) NOT NULL,
31  `label` varchar(100) NOT NULL,
32  `shared` int(11) NOT NULL
33) ENGINE=MyISAM DEFAULT CHARSET=latin1;
34
35--
36-- Contenu de la table `addon_account`
37--
38
39INSERT INTO `addon_account` (`name`, `label`, `shared`) VALUES
40('caution', 'Caution', 0),
41('society_police', 'Police', 1),
42('society_mecano', 'Mécano', 1),
43('society_ambulance', 'Ambulance', 1),
44('society_cardealer', 'Concessionnaire', 1),
45('society_motodealer', 'Concessionnaire', 1),
46('society_tabac', 'Tabac', 1),
47('society_taxi', 'Taxi', 1),
48('society_vigne', 'Vigneron', 1),
49('property_black_money', 'Argent Sale Propriété', 0),
50('society_realestateagent', 'Agent immobilier', 1),
51('society_bac', 'BAC', 1),
52('society_banker', 'Banque', 1),
53('bank_savings', 'Livret Bleu', 0),
54('society_avocat', 'Avocat', 1),
55('society_bahama', 'Bahama Mas', 1),
56('society_unicorn', 'Unicorn', 1),
57('society_Securitas', 'Securitas', 1),
58('society_fib', 'Fib', 1),
59('society_ammu', 'ammu', 1),
60('society_journaliste', 'journaliste', 1),
61('society_gouvernement', 'Gouvernement', 1),
62('organisation_biker', 'biker', 1),
63('organisation_vagos', 'vagos', 1),
64('organisation_ballas', 'ballas', 1),
65('organisation_families', 'families', 1),
66('society_sheriff', 'Sheriff', 1),
67('organisation_bloods', 'bloods', 1);
68
69-- --------------------------------------------------------
70
71--
72-- Structure de la table `addon_account_data`
73--
74
75CREATE TABLE IF NOT EXISTS `addon_account_data` (
76`id` int(11) NOT NULL,
77  `account_name` varchar(100) DEFAULT NULL,
78  `money` int(11) NOT NULL,
79  `owner` varchar(100) DEFAULT NULL
80) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=latin1;
81
82--
83-- Contenu de la table `addon_account_data`
84--
85
86INSERT INTO `addon_account_data` (`id`, `account_name`, `money`, `owner`) VALUES
87(1, 'caution', 0, ''),
88(2, 'society_police', 100000, NULL),
89(60, 'society_mecano', 2147483647, NULL),
90(4, 'society_ambulance', 100000, NULL),
91(36, 'society_motodealer', 100000, NULL),
92(9, 'society_cardealer', 443544446, NULL),
93(11, 'society_tabac', 100000, NULL),
94(12, 'society_taxi', 100000, NULL),
95(13, 'society_vigne', 100000, NULL),
96(14, 'society_realestateagent', 100000, NULL),
97(15, 'property_black_money', 0, ''),
98(23, 'society_bac', 100000, NULL),
99(17, 'society_banker', 100000, NULL),
100(18, 'society_avocat', 100000, NULL),
101(19, 'society_bahama', 100000, NULL),
102(20, 'society_unicorn', 100000, NULL),
103(21, 'bank_savings', 0, ''),
104(22, 'society_Securitas', 100000, NULL),
105(24, 'society_fib', 100000, NULL),
106(27, 'society_ammu', 100000, NULL),
107(28, 'society_journaliste', 100000, NULL),
108(29, 'society_gouvernement', 100000, NULL),
109(52, 'organisation_ballas', 100000, NULL),
110(38, 'caution', 2000, 'steam:110000118e987a2'),
111(39, 'property_black_money', 0, 'steam:110000118e987a2'),
112(40, 'bank_savings', 0, 'steam:110000118e987a2'),
113(54, 'organisation_vagos', 100000, NULL),
114(53, 'organisation_biker', 100000, NULL),
115(51, 'organisation_families', 100000, NULL),
116(57, 'society_sheriff', 0, NULL),
117(61, 'organisation_bloods', 0, NULL),
118(62, 'caution', 0, 'steam:1100001136d9a1e'),
119(63, 'property_black_money', 0, 'steam:1100001136d9a1e'),
120(64, 'bank_savings', 0, 'steam:1100001136d9a1e'),
121(65, 'caution', 0, 'steam:11000010f6f23c8'),
122(66, 'property_black_money', 0, 'steam:11000010f6f23c8'),
123(67, 'bank_savings', 0, 'steam:11000010f6f23c8');
124
125-- --------------------------------------------------------
126
127--
128-- Structure de la table `addon_inventory`
129--
130
131CREATE TABLE IF NOT EXISTS `addon_inventory` (
132  `name` varchar(60) NOT NULL,
133  `label` varchar(100) NOT NULL,
134  `shared` int(11) NOT NULL
135) ENGINE=MyISAM DEFAULT CHARSET=latin1;
136
137--
138-- Contenu de la table `addon_inventory`
139--
140
141INSERT INTO `addon_inventory` (`name`, `label`, `shared`) VALUES
142('society_police', 'Police', 1),
143('society_mecano', 'Mécano', 1),
144('society_ambulance', 'Ambulance', 1),
145('society_tabac', 'Tabac', 1),
146('society_motodealer', 'Concesionnaire', 1),
147('society_cardealer', 'Concesionnaire', 1),
148('society_vigne', 'Vigneron', 1),
149('property', 'Propriété', 0),
150('society_bac', 'BAC', 1),
151('society_avocat', 'Avocat', 1),
152('society_bahama', 'Bahama Mas', 1),
153('society_unicorn', 'Unicorn', 1),
154('society_unicorn_fridge', 'Unicorn (frigo)', 1),
155('society_Securitas', 'Securitas', 1),
156('society_fib', 'Fib', 1),
157('society_ammu', 'Ammu', 1),
158('society_journaliste', 'journaliste', 1),
159('society_gouvernement', 'Gouvernement', 1),
160('organisation_biker', 'biker', 1),
161('organisation_vagos', 'vagos', 1),
162('organisation_ballas', 'ballas', 1),
163('organisation_families', 'Families', 1),
164('organisation_bloods', 'bloods', 1),
165('society_sheriff', 'Sheriff', 1);
166
167-- --------------------------------------------------------
168
169--
170-- Structure de la table `addon_inventory_items`
171--
172
173CREATE TABLE IF NOT EXISTS `addon_inventory_items` (
174`id` int(11) NOT NULL,
175  `inventory_name` varchar(100) NOT NULL,
176  `name` varchar(100) NOT NULL,
177  `count` int(11) NOT NULL,
178  `owner` varchar(60) DEFAULT NULL
179) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
180
181--
182-- Contenu de la table `addon_inventory_items`
183--
184
185INSERT INTO `addon_inventory_items` (`id`, `inventory_name`, `name`, `count`, `owner`) VALUES
186(1, 'society_police', 'water', 27, NULL),
187(2, 'society_ammu', 'clip', 1, NULL);
188
189-- --------------------------------------------------------
190
191--
192-- Structure de la table `billing`
193--
194
195CREATE TABLE IF NOT EXISTS `billing` (
196`id` int(11) NOT NULL,
197  `identifier` varchar(255) NOT NULL,
198  `sender` varchar(255) NOT NULL,
199  `target_type` varchar(50) NOT NULL,
200  `target` varchar(255) NOT NULL,
201  `label` varchar(255) NOT NULL,
202  `amount` int(11) NOT NULL
203) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
204
205-- --------------------------------------------------------
206
207--
208-- Structure de la table `cardealer_vehicles`
209--
210
211CREATE TABLE IF NOT EXISTS `cardealer_vehicles` (
212`id` int(11) NOT NULL,
213  `vehicle` varchar(255) NOT NULL,
214  `price` int(11) NOT NULL
215) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
216
217--
218-- Contenu de la table `cardealer_vehicles`
219--
220
221INSERT INTO `cardealer_vehicles` (`id`, `vehicle`, `price`) VALUES
222(2, 'blade', 15000);
223
224-- --------------------------------------------------------
225
226--
227-- Structure de la table `characters`
228--
229
230CREATE TABLE IF NOT EXISTS `characters` (
231`id` int(11) NOT NULL,
232  `identifier` varchar(255) NOT NULL,
233  `firstname` varchar(255) NOT NULL,
234  `lastname` varchar(255) NOT NULL,
235  `dateofbirth` varchar(255) NOT NULL,
236  `sex` varchar(1) NOT NULL DEFAULT 'M',
237  `height` varchar(128) NOT NULL
238) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
239
240--
241-- Contenu de la table `characters`
242--
243
244INSERT INTO `characters` (`id`, `identifier`, `firstname`, `lastname`, `dateofbirth`, `sex`, `height`) VALUES
245(1, 'steam:110000118e987a2', 'Tony', 'Anderson', '24 09 1996', 'm', '200'),
246(15, 'steam:11000010f6f23c8', 'Adrien', 'Mayers', '15-12-1997', 'm', '189'),
247(14, 'steam:1100001136d9a1e', 'Ninho', 'Luciano', '30/08/1997', 'm', '183'),
248(12, 'steam:11000010f6f23c8', 'Adrien', 'Mayers', '15-12-1997', 'm', '189'),
249(13, 'steam:1100001136d9a1e', 'Ninho', 'Luciano', '30/08/1997', 'm', '183'),
250(11, 'steam:1100001136d9a1e', 'Ninho', 'Luciano', '30/08/1997', 'm', '183');
251
252-- --------------------------------------------------------
253
254--
255-- Structure de la table `datastore`
256--
257
258CREATE TABLE IF NOT EXISTS `datastore` (
259  `name` varchar(60) NOT NULL,
260  `label` varchar(100) NOT NULL,
261  `shared` int(11) NOT NULL
262) ENGINE=MyISAM DEFAULT CHARSET=latin1;
263
264--
265-- Contenu de la table `datastore`
266--
267
268INSERT INTO `datastore` (`name`, `label`, `shared`) VALUES
269('society_police', 'Police', 1),
270('society_ambulance', 'Ambulance', 1),
271('user_ears', 'Oreilles', 0),
272('user_glasses', 'Lunettes ', 0),
273('user_helmet', 'Casque', 0),
274('user_mask', 'Masque', 0),
275('society_tabac', 'Tabac', 1),
276('society_vigne', 'Vigneron', 1),
277('property', 'Propriété', 0),
278('society_bac', 'BAC', 1),
279('society_avocat', 'Avocat', 1),
280('society_unicorn', 'Unicorn', 1),
281('society_Securitas', 'Securitas', 1),
282('society_fib', 'Fib', 1),
283('society_ammu', 'Ammu', 1),
284('society_journaliste', 'journaliste', 1),
285('society_gouvernement', 'Gouvernement', 1),
286('organisation_vagos', 'vagos', 1),
287('organisation_ballas', 'ballas', 1),
288('organisation_families', 'families', 1),
289('organisation_biker', 'biker', 1),
290('society_sheriff', 'Sheriff', 1),
291('organisation_bloods', 'bloods', 1);
292
293-- --------------------------------------------------------
294
295--
296-- Structure de la table `datastore_data`
297--
298
299CREATE TABLE IF NOT EXISTS `datastore_data` (
300`id` int(11) NOT NULL,
301  `name` varchar(60) NOT NULL,
302  `owner` varchar(60) DEFAULT NULL,
303  `data` longtext
304) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;
305
306--
307-- Contenu de la table `datastore_data`
308--
309
310INSERT INTO `datastore_data` (`id`, `name`, `owner`, `data`) VALUES
311(1, 'society_police', NULL, '{"weapons":[{"name":"WEAPON_VINTAGEPISTOL","count":0},{"name":"WEAPON_KNIFE","count":3},{"name":"WEAPON_COMBATPISTOL","count":0},{"name":"WEAPON_HEAVYSNIPER","count":0},{"name":"WEAPON_MICROSMG","count":1},{"name":"WEAPON_PISTOL","count":0},{"name":"WEAPON_PISTOL50","count":0},{"name":"WEAPON_FLAREGUN","count":0},{"name":"WEAPON_ASSAULTRIFLE","count":3},{"name":"WEAPON_CARBINERIFLE","count":0},{"name":"WEAPON_RPG","count":0}]}'),
312(2, 'society_ambulance', NULL, '{}'),
313(11, 'society_tabac', NULL, '{}'),
314(4, 'user_ears', '', '{}'),
315(5, 'user_glasses', '', '{}'),
316(6, 'user_helmet', '', '{}'),
317(7, 'user_mask', '', '{}'),
318(12, 'society_vigne', NULL, '{}'),
319(13, 'property', '', '{}'),
320(18, 'society_bac', NULL, '{}'),
321(15, 'society_avocat', NULL, '{}'),
322(16, 'society_unicorn', NULL, '{}'),
323(17, 'society_Securitas', NULL, '{}'),
324(19, 'society_fib', NULL, '{}'),
325(34, 'property', 'steam:110000118e987a2', '{}'),
326(35, 'society_black', NULL, '{}'),
327(22, 'society_ammu', NULL, '{"weapons":[{"name":"WEAPON_ASSAULTRIFLE","count":0},{"name":"WEAPON_CARBINERIFLE","count":0},{"name":"WEAPON_SAWNOFFSHOTGUN","count":0},{"name":"WEAPON_MICROSMG","count":0},{"name":"WEAPON_COMPACTRIFLE","count":0}]}'),
328(30, 'user_ears', 'steam:110000118e987a2', '{}'),
329(31, 'user_glasses', 'steam:110000118e987a2', '{}'),
330(32, 'user_helmet', 'steam:110000118e987a2', '{}'),
331(33, 'user_mask', 'steam:110000118e987a2', '{}'),
332(23, 'society_journaliste', NULL, '{}'),
333(24, 'society_gouvernement', NULL, '{}'),
334(45, 'organisation_ballas', NULL, '{}'),
335(44, 'organisation_families', NULL, '{"weapons":[{"count":1,"name":"WEAPON_COMBATPISTOL"}]}'),
336(43, 'organisation_gang', NULL, '{}'),
337(46, 'organisation_vagos', NULL, '{}'),
338(47, 'organisation_biker', NULL, '{}'),
339(50, 'society_sheriff', NULL, '{}'),
340(53, 'organisation_bloods', NULL, '{}'),
341(54, 'user_glasses', 'steam:1100001136d9a1e', '{}'),
342(55, 'user_helmet', 'steam:1100001136d9a1e', '{}'),
343(56, 'user_ears', 'steam:1100001136d9a1e', '{}'),
344(57, 'user_mask', 'steam:1100001136d9a1e', '{"skin":{"mask_2":0,"mask_1":35},"hasMask":true}'),
345(58, 'property', 'steam:1100001136d9a1e', '{}'),
346(59, 'user_glasses', 'steam:11000010f6f23c8', '{}'),
347(60, 'user_helmet', 'steam:11000010f6f23c8', '{}'),
348(61, 'user_ears', 'steam:11000010f6f23c8', '{}'),
349(62, 'property', 'steam:11000010f6f23c8', '{}'),
350(63, 'user_mask', 'steam:11000010f6f23c8', '{}');
351
352-- --------------------------------------------------------
353
354--
355-- Structure de la table `fine_types`
356--
357
358CREATE TABLE IF NOT EXISTS `fine_types` (
359`id` int(11) NOT NULL,
360  `label` varchar(255) DEFAULT NULL,
361  `amount` int(11) DEFAULT NULL,
362  `category` int(11) DEFAULT NULL
363) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
364
365--
366-- Contenu de la table `fine_types`
367--
368
369INSERT INTO `fine_types` (`id`, `label`, `amount`, `category`) VALUES
370(1, 'Usage abusif du klaxon', 150, 0),
371(2, 'Circulation à contresens-offroad', 800, 0),
372(3, 'Demi-tour non autorisé', 650, 0),
373(4, 'Stationnement gênant / interdit', 370, 0),
374(5, 'Non-respect d''un stop-feu rouge', 300, 0),
375(6, 'Véhicule non en état', 300, 0),
376(7, 'Conduite sans permis', 2500, 0),
377(8, 'Délit de fuite', 1200, 0),
378(9, 'Excès de vitesse > 50 kmh', 300, 0),
379(10, 'Entrave de la circulation-de la police', 210, 1),
380(11, 'Dégradation de la voie publique-vehicules', 450, 1),
381(12, 'Trouble à l''ordre publique', 250, 1),
382(13, 'Insulte envers / entre civils', 75, 1),
383(14, 'Outrage à agent de police', 200, 1),
384(15, 'Menace verbale ou intimidation envers civil-policier', 90, 1),
385(16, 'Tentative de corruption', 1500, 1),
386(17, 'Port d''arme non autorisé (défaut de license)', 800, 2),
387(18, 'Port d''arme illégal', 700, 2),
388(19, 'Vol de voiture', 900, 2),
389(20, 'Vente de drogue', 1700, 2),
390(21, 'Fabriquation de drogue', 2500, 2),
391(22, 'Possession de drogue', 650, 2),
392(23, 'Prise d''ôtage civil', 2500, 2),
393(24, 'Prise d''ôtage agent de l''état', 3000, 2),
394(25, 'Braquage magasin', 1650, 2),
395(26, 'Braquage de banque', 3500, 2),
396(27, 'Agression civil-agent de l''état', 1200, 3),
397(28, 'Tentative de meurtre sur civil', 3000, 3),
398(29, 'Tentative de meurtre sur agent de l''état', 4000, 3),
399(30, 'Meurtre sur civil', 20000, 3),
400(31, 'Meurte sur agent de l''état', 40000, 3),
401(32, 'Escroquerie à l''entreprise', 1000, 2);
402
403-- --------------------------------------------------------
404
405--
406-- Structure de la table `fine_types_bac`
407--
408
409CREATE TABLE IF NOT EXISTS `fine_types_bac` (
410`id` int(11) NOT NULL,
411  `label` varchar(255) DEFAULT NULL,
412  `amount` int(11) DEFAULT NULL,
413  `category` int(11) DEFAULT NULL
414) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;
415
416--
417-- Contenu de la table `fine_types_bac`
418--
419
420INSERT INTO `fine_types_bac` (`id`, `label`, `amount`, `category`) VALUES
421(1, 'Usage abusif du klaxon', 30, 0),
422(2, 'Franchir une ligne continue', 40, 0),
423(3, 'Circulation à contresens', 250, 0),
424(4, 'Demi-tour non autorisé', 250, 0),
425(5, 'Circulation hors-route', 170, 0),
426(6, 'Non-respect des distances de sécurité', 30, 0),
427(7, 'Arrêt dangereux / interdit', 150, 0),
428(8, 'Stationnement gênant / interdit', 70, 0),
429(9, 'Non respect  de la priorité à droite', 70, 0),
430(10, 'Non-respect à un véhicule prioritaire', 90, 0),
431(11, 'Non-respect d''un stop', 105, 0),
432(12, 'Non-respect d''un feu rouge', 130, 0),
433(13, 'Dépassement dangereux', 100, 0),
434(14, 'Véhicule non en état', 100, 0),
435(15, 'Conduite sans permis', 1500, 0),
436(16, 'Délit de fuite', 800, 0),
437(17, 'Excès de vitesse < 5 kmh', 90, 0),
438(18, 'Excès de vitesse 5-15 kmh', 120, 0),
439(19, 'Excès de vitesse 15-30 kmh', 180, 0),
440(20, 'Excès de vitesse > 30 kmh', 300, 0),
441(21, 'Entrave de la circulation', 110, 1),
442(22, 'Dégradation de la voie publique', 90, 1),
443(23, 'Trouble à l''ordre publique', 90, 1),
444(24, 'Entrave opération de bac', 130, 1),
445(25, 'Insulte envers / entre civils', 75, 1),
446(26, 'Outrage à agent de bac', 110, 1),
447(27, 'Menace verbale ou intimidation envers civil', 90, 1),
448(28, 'Menace verbale ou intimidation envers policier', 150, 1),
449(29, 'Manifestation illégale', 250, 1),
450(30, 'Tentative de corruption', 1500, 1),
451(31, 'Arme blanche sortie en ville', 120, 2),
452(32, 'Arme léthale sortie en ville', 300, 2),
453(33, 'Port d''arme non autorisé (défaut de license)', 600, 2),
454(34, 'Port d''arme illégal', 700, 2),
455(35, 'Pris en flag lockpick', 300, 2),
456(36, 'Vol de voiture', 1800, 2),
457(37, 'Vente de drogue', 1500, 2),
458(38, 'Fabriquation de drogue', 1500, 2),
459(39, 'Possession de drogue', 650, 2),
460(40, 'Prise d''ôtage civil', 1500, 2),
461(41, 'Prise d''ôtage agent de l''état', 2000, 2),
462(42, 'Braquage particulier', 650, 2),
463(43, 'Braquage magasin', 650, 2),
464(44, 'Braquage de banque', 1500, 2),
465(45, 'Tir sur civil', 2000, 3),
466(46, 'Tir sur agent de l''état', 2500, 3),
467(47, 'Tentative de meurtre sur civil', 3000, 3),
468(48, 'Tentative de meurtre sur agent de l''état', 5000, 3),
469(49, 'Meurtre sur civil', 10000, 3),
470(50, 'Meurte sur agent de l''état', 30000, 3),
471(51, 'Meurtre involontaire', 1800, 3),
472(52, 'Escroquerie à l''entreprise', 2000, 2);
473
474-- --------------------------------------------------------
475
476--
477-- Structure de la table `fine_types_ballas`
478--
479
480CREATE TABLE IF NOT EXISTS `fine_types_ballas` (
481`id` int(11) NOT NULL,
482  `label` varchar(255) DEFAULT NULL,
483  `amount` int(11) DEFAULT NULL,
484  `category` int(11) DEFAULT NULL
485) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
486
487--
488-- Contenu de la table `fine_types_ballas`
489--
490
491INSERT INTO `fine_types_ballas` (`id`, `label`, `amount`, `category`) VALUES
492(1, 'Raket', 3000, 0),
493(2, 'Raket', 5000, 0),
494(3, 'Raket', 10000, 1),
495(4, 'Raket', 20000, 1),
496(5, 'Raket', 50000, 2),
497(6, 'Raket', 150000, 3),
498(7, 'Raket', 350000, 3);
499
500-- --------------------------------------------------------
501
502--
503-- Structure de la table `fine_types_biker`
504--
505
506CREATE TABLE IF NOT EXISTS `fine_types_biker` (
507`id` int(11) NOT NULL,
508  `label` varchar(255) DEFAULT NULL,
509  `amount` int(11) DEFAULT NULL,
510  `category` int(11) DEFAULT NULL
511) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
512
513--
514-- Contenu de la table `fine_types_biker`
515--
516
517INSERT INTO `fine_types_biker` (`id`, `label`, `amount`, `category`) VALUES
518(1, 'Raket', 3000, 0),
519(2, 'Raket', 5000, 0),
520(3, 'Raket', 10000, 1),
521(4, 'Raket', 20000, 1),
522(5, 'Raket', 50000, 2),
523(6, 'Raket', 150000, 3),
524(7, 'Raket', 350000, 3);
525
526-- --------------------------------------------------------
527
528--
529-- Structure de la table `fine_types_bloods`
530--
531
532CREATE TABLE IF NOT EXISTS `fine_types_bloods` (
533`id` int(11) NOT NULL,
534  `label` varchar(255) DEFAULT NULL,
535  `amount` int(11) DEFAULT NULL,
536  `category` int(11) DEFAULT NULL
537) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
538
539--
540-- Contenu de la table `fine_types_bloods`
541--
542
543INSERT INTO `fine_types_bloods` (`id`, `label`, `amount`, `category`) VALUES
544(1, 'Raket', 3000, 0),
545(2, 'Raket', 5000, 0),
546(3, 'Raket', 10000, 1),
547(4, 'Raket', 20000, 1),
548(5, 'Raket', 50000, 2),
549(6, 'Raket', 150000, 3),
550(7, 'Raket', 350000, 3);
551
552-- --------------------------------------------------------
553
554--
555-- Structure de la table `fine_types_families`
556--
557
558CREATE TABLE IF NOT EXISTS `fine_types_families` (
559`id` int(11) NOT NULL,
560  `label` varchar(255) DEFAULT NULL,
561  `amount` int(11) DEFAULT NULL,
562  `category` int(11) DEFAULT NULL
563) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
564
565--
566-- Contenu de la table `fine_types_families`
567--
568
569INSERT INTO `fine_types_families` (`id`, `label`, `amount`, `category`) VALUES
570(1, 'Raket', 3000, 0),
571(2, 'Raket', 5000, 0),
572(3, 'Raket', 10000, 1),
573(4, 'Raket', 20000, 1),
574(5, 'Raket', 50000, 2),
575(6, 'Raket', 150000, 3),
576(7, 'Raket', 350000, 3);
577
578-- --------------------------------------------------------
579
580--
581-- Structure de la table `fine_types_securitas`
582--
583
584CREATE TABLE IF NOT EXISTS `fine_types_securitas` (
585`id` int(11) NOT NULL,
586  `label` varchar(255) DEFAULT NULL,
587  `amount` int(11) DEFAULT NULL,
588  `category` int(11) DEFAULT NULL
589) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;
590
591--
592-- Contenu de la table `fine_types_securitas`
593--
594
595INSERT INTO `fine_types_securitas` (`id`, `label`, `amount`, `category`) VALUES
596(1, 'Missbruk av tuta', 30, 0),
597(2, 'Köra över heldragen linje', 40, 0),
598(3, 'Kört i motsatt riktning i rondell', 250, 0),
599(4, 'Olaglig u-sväng', 250, 0),
600(5, 'Olovlig körning i terräng', 170, 0),
601(6, 'Kört för nära bil framför', 30, 0),
602(7, 'Trafikfarlig stopp', 150, 0),
603(8, 'Olaglig parkering', 70, 0),
604(9, 'Använder inte högerregeln', 70, 0),
605(10, 'Aktar sig inte för tjänstefordon i utryckning', 90, 0),
606(11, 'Kört förbi stoppskylt', 105, 0),
607(12, 'Kört mot rött', 130, 0),
608(13, 'Farlig omkörning', 100, 0),
609(14, 'Fordon i dåligt skick', 100, 0),
610(15, 'Kört utan körkort', 1500, 0),
611(16, 'Smitning från olycka', 800, 0),
612(17, 'Kört för fort < 5 kmh', 90, 0),
613(18, 'Kört för fort 5-15 kmh', 120, 0),
614(19, 'Kört för fort 15-30 kmh', 180, 0),
615(20, 'Kört för fort > 30 kmh', 300, 0),
616(21, 'Blockerar trafiken', 110, 1),
617(22, 'Förstört allmän egendom', 90, 1),
618(23, 'Olaga diskriminering', 90, 1),
619(24, 'förhindrar polisens verksamhet', 130, 1),
620(25, 'Hets mot folkgrupp', 75, 1),
621(26, 'Dåligt beteende mot tjänsteman', 110, 1),
622(27, 'Verbalt hot mot annan person', 90, 1),
623(28, 'Verbalt hot mot en tjänsteman', 150, 1),
624(29, 'Olaglig protest', 250, 1),
625(30, 'Försök till mutning', 1500, 1),
626(31, 'Icke livshotande vapen på allmän plats ex. Hammare', 120, 2),
627(32, 'Dödligt vapen på allmän plats', 300, 2),
628(33, 'Vapen på allmän plats med licens (Licens Fel)', 600, 2),
629(34, 'Innehaft olaga vapen', 700, 2),
630(35, 'Försökt bryta sig in', 300, 2),
631(36, 'Bilstöld', 1800, 2),
632(37, 'Försäljning av droger', 1500, 2),
633(38, 'Tillverkning av droger', 1500, 2),
634(39, 'Innehav av droger', 650, 2),
635(40, 'Hålla gisslan/Hålla person mot dess vilja', 1500, 2),
636(41, 'Kidnappa en tjänsteman', 2000, 2),
637(42, 'Rån', 650, 2),
638(43, 'Butiksrån', 650, 2),
639(44, 'Bankrån', 1500, 2),
640(45, 'Skjutit en person', 2000, 3),
641(46, 'Skjutit en tjänsteman', 2500, 3),
642(47, 'Mordförsök', 3000, 3),
643(48, 'Mordförsök på tjänsteman', 6000, 3),
644(49, 'Mord', 10000, 3),
645(50, 'Mord på tjänsteman', 30000, 3),
646(51, 'Dråp', 1800, 3),
647(52, 'Olagliga aktiviteter inom ett företag', 2000, 2);
648
649-- --------------------------------------------------------
650
651--
652-- Structure de la table `fine_types_vagos`
653--
654
655CREATE TABLE IF NOT EXISTS `fine_types_vagos` (
656`id` int(11) NOT NULL,
657  `label` varchar(255) DEFAULT NULL,
658  `amount` int(11) DEFAULT NULL,
659  `category` int(11) DEFAULT NULL
660) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
661
662--
663-- Contenu de la table `fine_types_vagos`
664--
665
666INSERT INTO `fine_types_vagos` (`id`, `label`, `amount`, `category`) VALUES
667(1, 'Raket', 3000, 0),
668(2, 'Raket', 5000, 0),
669(3, 'Raket', 10000, 1),
670(4, 'Raket', 20000, 1),
671(5, 'Raket', 50000, 2),
672(6, 'Raket', 150000, 3),
673(7, 'Raket', 350000, 3);
674
675-- --------------------------------------------------------
676
677--
678-- Structure de la table `items`
679--
680
681CREATE TABLE IF NOT EXISTS `items` (
682  `name` varchar(50) NOT NULL,
683  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
684  `limit` int(11) NOT NULL DEFAULT '-1',
685  `rare` int(11) NOT NULL DEFAULT '0',
686  `can_remove` int(11) NOT NULL DEFAULT '1'
687) ENGINE=MyISAM DEFAULT CHARSET=latin1;
688
689--
690-- Contenu de la table `items`
691--
692
693INSERT INTO `items` (`name`, `label`, `limit`, `rare`, `can_remove`) VALUES
694('beer', 'Biere', 15, 0, 1),
695('bread', 'Pain', 15, 0, 1),
696('chocolate', 'Chocolat', 10, 0, 1),
697('cigarett', 'Cigarete', 20, 0, 1),
698('cocacola', 'Coca', 15, 0, 1),
699('coffe', 'Café', 15, 0, 1),
700('cupcake', 'Cupcake', 15, 0, 1),
701('hamburger', 'Hamburger', 15, 0, 1),
702('icetea', 'Ice-tea', 15, 0, 1),
703('lighter', 'Briquet', 1, 0, 1),
704('milk', 'Lait', 15, 0, 1),
705('sandwich', 'Sandwich', 15, 0, 1),
706('tequila', 'Tequila', 15, 0, 1),
707('vodka', 'Vodka', 15, 0, 1),
708('water', 'Eau', 5, 0, 1),
709('whisky', 'Whisky', 15, 0, 1),
710('wine', 'Vin', 15, 0, 1),
711('alive_chicken', 'Poulet vivant', 20, 0, 1),
712('slaughtered_chicken', 'Poulet abattu', 20, 0, 1),
713('packaged_chicken', 'Poulet en barquette', 100, 0, 1),
714('fish', 'Poisson', 100, 0, 1),
715('stone', 'Pierre', 7, 0, 1),
716('washed_stone', 'Pierre Lavee', 7, 0, 1),
717('copper', 'Cuivre', 56, 0, 1),
718('iron', 'Fer', 42, 0, 1),
719('gold', 'Or', 21, 0, 1),
720('diamond', 'Diamant', 50, 0, 1),
721('wood', 'Bois', 20, 0, 1),
722('cutted_wood', 'Bois coupe', 20, 0, 1),
723('packaged_plank', 'Paquet de planches', 100, 0, 1),
724('petrol', 'Petrole', 24, 0, 1),
725('petrol_raffin', 'Petrole Raffine', 24, 0, 1),
726('essence', 'Essence', 24, 0, 1),
727('wool', 'Laine', 40, 0, 1),
728('fabric', 'Tissu', 80, 0, 1),
729('clothe', 'Vetement', 40, 0, 1),
730('blowpipe', 'Chalumeaux', -1, 0, 1),
731('carotool', 'outils carosserie', -1, 0, 1),
732('fixtool', 'outils réparation', -1, 0, 1),
733('gazbottle', 'bouteille de gaz', -1, 0, 1),
734('bandage', 'Bandage', 20, 0, 1),
735('medikit', 'Medikit', 5, 0, 1),
736('jager', 'Jagermeister', 5, 0, 1),
737('tabacblond', 'Tabac Blond', -1, 0, 1),
738('tabacbrun', 'Tabac Brun', -1, 0, 1),
739('tabacblondsec', 'Tabac Blond Séché', -1, 0, 1),
740('tabacbrunsec', 'Tabac Brun Séché', -1, 0, 1),
741('malbora', 'Malbora', -1, 0, 1),
742('gitanes', 'Gitanes', -1, 0, 1),
743('raisin', 'Raisin', -1, 0, 1),
744('jus_raisin', 'Jus de raisin', -1, 0, 1),
745('grand_cru', 'Grand cru', -1, 0, 1),
746('vine', 'Vin', -1, 0, 1),
747('myrtealcool', 'alcool de myrte', -1, 0, 1),
748('alcool', 'alcool', -1, 0, 1),
749('myrte', 'myrte', -1, 0, 1),
750('whiskycoc', 'Whisky CorsicaCola', -1, 0, 1),
751('redbull', 'RedBull', -1, 0, 1),
752('vodkrb', 'Vodka RedBull', -1, 0, 1),
753('alcool_cargo', 'Cargaison d''alcool', -1, 0, 1),
754('redbull_cargo', 'Cargaison de RedBull', -1, 0, 1),
755('myrte_cargo', 'Cargaison de Myrte', -1, 0, 1),
756('croquettes', 'Croquettes', -1, 0, 1),
757('yusuf', 'Skin de luxe', -1, 0, 1),
758('grip', 'Poignée', -1, 0, 1),
759('flashlight', 'Lampe', -1, 0, 1),
760('silencieux', 'Silencieux', -1, 0, 1),
761('clip', 'Chargeur', -1, 0, 1),
762('cerveau', 'Cerveau', -1, 0, 1),
763('coeur', 'Coeur', -1, 0, 1),
764('moelle', 'grammes de Moelle', -1, 0, 1),
765('intestin', 'Intestin', -1, 0, 1),
766('os', 'Os', -1, 0, 1),
767('organ_pooch', 'Corps humain', -1, 0, 1),
768('lsd', 'Lsd', -1, 0, 1),
769('lsd_pooch', 'Pochon de LSD', -1, 0, 1),
770('tacos', 'Tacos', 20, 0, 1),
771('meat', 'Viande', 20, 0, 1),
772('vegetables', 'Légume', 20, 0, 1),
773('cola', 'Cola', 20, 0, 1),
774('burger', 'Burger', 20, 0, 1),
775('codeine', 'cl de codéine', -1, 0, 1),
776('disolvant', 'cl de dissolvant peinture', -1, 0, 1),
777('phosphorerouge', 'gr de phosphore Rouge', -1, 0, 1),
778('heroine', 'Héroine', -1, 0, 1),
779('iode', 'gr D''iode', -1, 0, 1),
780('kroko_pooch', 'Seringue de Krokodil', -1, 0, 1),
781('cagoule', 'Cagoule', -1, 0, 1),
782('pizza', 'Pizza', -1, 0, 1),
783('nitro', 'Nitro', -1, 0, 1),
784('licenseplate', 'Changement Plaque', -1, 0, 1),
785('gym_membership', 'Membre Gym', -1, 0, 1),
786('powerade', 'Powerade', -1, 0, 1),
787('sportlunch', 'Dejeuner', -1, 0, 1),
788('protein_shake', 'Proteines', -1, 0, 1),
789('xanax', 'Xanax', -1, 0, 1),
790('weed', 'Weed', 50, 0, 1),
791('weed_pooch', 'Pochon de weed', 10, 0, 1),
792('coke', 'Coke', 50, 0, 1),
793('coke_pooch', 'Pochon de coke', 10, 0, 1),
794('meth', 'Meth', 50, 0, 1),
795('meth_pooch', 'Pochon de meth', 10, 0, 1),
796('opium', 'Opium', 50, 0, 1),
797('opium_pooch', 'Pochon de opium', 10, 0, 1),
798('sausage-eat', 'Saucisse & Pain', -1, 0, 1),
799('hazmat1', 'Combinaison Hazmat Noir', 10, 0, 1),
800('hazmat2', 'Combinaison Hazmat Bleu', 10, 0, 1),
801('hazmat3', 'Combinaison Hazmat Jaune', 10, 0, 1),
802('hazmat4', 'Combinaison Hazmat Blanche', 10, 0, 1),
803('handcuff', 'Serflex', -1, 0, 1),
804('cutting_pliers', 'Pince coupante', -1, 0, 1),
805('silence_pistol', 'Silencieux Pistolet', -1, 0, 1),
806('silence_pistol50', 'Silencieux cal.50', -1, 0, 1),
807('silence_sniperrifle', 'Silencieux SniperRifle', -1, 0, 1),
808('advancedscoped_sniperrifle', 'Lunette de Visée', -1, 0, 1),
809('flashlight_assaultsmg', 'Lampe AssaultSMG', -1, 0, 1),
810('clip_heavypistol', 'Chargeur Heavy Pistol', -1, 0, 1),
811('supp_heavypistol', 'Silençieux Heavy Pistol', -1, 0, 1),
812('scope_smg', 'Lunette SMG', -1, 0, 1),
813('lowrider_smg', 'LowRider SMG', -1, 0, 1),
814('supp_smg', 'Silençieux SMG', -1, 0, 1),
815('grip_smg', 'Poignée SMG', -1, 0, 1),
816('flash_cp', 'Lampe Glock-17', -1, 0, 1),
817('supp_cp', 'Silençieux Glock-17', -1, 0, 1),
818('lowrider_cp', 'LowRider Glock-17', -1, 0, 1),
819('clip_sc', 'Chargeur SCAR', -1, 0, 1),
820('grip_sc', 'Poignée SCAR', -1, 0, 1),
821('clip_gus', 'Chargeur Gusenberg', -1, 0, 1),
822('supp_sc', 'Silençieux SCAR', -1, 0, 1),
823('radio', 'radio', 1, 0, 1),
824('tenuebraquage', 'Tenue Braguage', -1, 0, 1),
825('fixkit', 'Kit réparation', -1, 0, 1),
826('carokit', 'Kit carosserie', -1, 0, 1);
827
828-- --------------------------------------------------------
829
830--
831-- Structure de la table `jobs`
832--
833
834CREATE TABLE IF NOT EXISTS `jobs` (
835  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
836  `label` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
837  `whitelisted` tinyint(1) NOT NULL DEFAULT '0'
838) ENGINE=MyISAM DEFAULT CHARSET=latin1;
839
840--
841-- Contenu de la table `jobs`
842--
843
844INSERT INTO `jobs` (`name`, `label`, `whitelisted`) VALUES
845('unemployed', 'Chomeur ', 0),
846('slaughterer', 'Abatteur', 0),
847('fisherman', 'Pecheur', 1),
848('miner', 'Mineur', 0),
849('lumberjack', 'Bucheron', 1),
850('fueler', 'Raffineur', 1),
851('reporter', 'Journaliste', 1),
852('tailor', 'Couturier', 0),
853('police', 'LSPD', 1),
854('mecano', 'Mécano', 0),
855('ambulance', 'Ambulance', 1),
856('cardealer', 'Concessionnaire', 1),
857('motodealer', 'Concess Moto', 1),
858('tabac', 'Tabac', 1),
859('taxi', 'Taxi', 1),
860('vigne', 'Vigneron', 1),
861('realestateagent', 'Agent immobilier', 1),
862('banker', 'Banquier', 1),
863('avocat', 'AVOCAT', 1),
864('bahama', 'Bahama Mas', 1),
865('unicorn', 'Unicorn', 1),
866('Securitas', 'Securiter', 1),
867('bac', 'BAC', 1),
868('fib', 'FIB', 1),
869('ammu', 'Ammu', 1),
870('journaliste', 'journaliste', 1),
871('gouvernement', 'Gouvernement', 1),
872('sheriff', 'Sheriff', 1);
873
874-- --------------------------------------------------------
875
876--
877-- Structure de la table `job_grades`
878--
879
880CREATE TABLE IF NOT EXISTS `job_grades` (
881`id` int(11) NOT NULL,
882  `job_name` varchar(50) DEFAULT NULL,
883  `grade` int(11) NOT NULL,
884  `name` varchar(50) NOT NULL,
885  `label` varchar(50) NOT NULL,
886  `salary` int(11) NOT NULL,
887  `skin_male` longtext NOT NULL,
888  `skin_female` longtext NOT NULL
889) ENGINE=MyISAM AUTO_INCREMENT=155 DEFAULT CHARSET=latin1;
890
891--
892-- Contenu de la table `job_grades`
893--
894
895INSERT INTO `job_grades` (`id`, `job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
896(1, 'unemployed', 0, 'unemployed', 'RSA', 200, '{}', '{}'),
897(2, 'lumberjack', 0, 'employee', 'Intérimaire', 0, '{}', '{}'),
898(3, 'fisherman', 0, 'employee', 'Intérimaire', 0, '{}', '{}'),
899(4, 'fueler', 0, 'employee', 'Intérimaire', 0, '{}', '{}'),
900(5, 'reporter', 0, 'employee', 'Intérimaire', 0, '{}', '{}'),
901(6, 'tailor', 0, 'employee', 'Intérimaire', 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}'),
902(7, 'miner', 0, 'employee', 'Intérimaire', 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}', '{}'),
903(8, 'slaughterer', 0, 'employee', 'Intérimaire', 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}'),
904(9, 'police', 0, 'recruit', 'Cadet', 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}'),
905(10, 'police', 1, 'officer', 'Officier', 1250, '{"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}'),
906(11, 'police', 2, 'sergeant', 'Sergent', 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}'),
907(12, 'police', 3, 'lieutenant', 'Lieutenant', 1700, '{"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}'),
908(13, 'police', 4, 'boss', 'Commandant', 2000, '{"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}'),
909(152, 'mecano', 2, 'experimente', 'Experimente', 36, '{}', '{}'),
910(151, 'mecano', 1, 'novice', 'Novice', 24, '{}', '{}'),
911(150, 'mecano', 0, 'recrue', 'Recrue', 12, '{}', '{}'),
912(19, 'ambulance', 0, 'ambulance', 'Ambulancier', 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}'),
913(20, 'ambulance', 1, 'doctor', 'Medecin', 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}'),
914(21, 'ambulance', 2, 'chief_doctor', 'Medecin-chef', 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}'),
915(22, 'ambulance', 3, 'boss', 'Chirurgien', 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}'),
916(129, 'motodealer', 0, 'recruit', 'Recrue', 10, '{}', '{}'),
917(130, 'motodealer', 1, 'novice', 'Novice', 25, '{}', '{}'),
918(131, 'motodealer', 2, 'experienced', 'Experimente', 40, '{}', '{}'),
919(39, 'cardealer', 3, 'boss', 'Patron', 0, '{}', '{}'),
920(38, 'cardealer', 2, 'experienced', 'Experimente', 40, '{}', '{}'),
921(36, 'cardealer', 0, 'recruit', 'Recrue', 10, '{}', '{}'),
922(37, 'cardealer', 1, 'novice', 'Novice', 25, '{}', '{}'),
923(44, 'tabac', 0, 'recrue', 'Tabagiste', 400, '{}', '{}'),
924(45, 'tabac', 1, 'novice', 'Tabagiste', 500, '{}', '{}'),
925(46, 'tabac', 1, 'gerant', 'Gérant', 650, '{}', '{}'),
926(47, 'tabac', 2, 'boss', 'Patron', 800, '{}', '{}'),
927(48, 'taxi', 0, 'recrue', 'Recrue', 12, '{}', '{}'),
928(49, 'taxi', 1, 'novice', 'Novice', 24, '{}', '{}'),
929(50, 'taxi', 2, 'experimente', 'Experimente', 36, '{}', '{}'),
930(51, 'taxi', 3, 'uber', 'Uber', 48, '{}', '{}'),
931(52, 'taxi', 4, 'boss', 'Patron', 0, '{}', '{}'),
932(53, 'vigne', 0, 'recrue', 'Intérimaire', 500, '{"tshirt_1":59,"tshirt_2":0,"torso_1":12,"torso_2":5,"shoes_1":7,"shoes_2":2,"pants_1":9, "pants_2":7, "arms":1, "helmet_1":11, "helmet_2":0,"bags_1":0,"bags_2":0,"ears_1":0,"glasses_1":0,"ears_2":0,"glasses_2":0}', '{"tshirt_1":0,"tshirt_2":0,"torso_1":56,"torso_2":0,"shoes_1":27,"shoes_2":0,"pants_1":36, "pants_2":0, "arms":63, "helmet_1":11, "helmet_2":0,"bags_1":0,"bags_2":0,"ears_1":0,"glasses_1":0,"ears_2":0,"glasses_2":0}'),
933(54, 'vigne', 1, 'novice', 'Vigneron', 750, '{"tshirt_1":57,"tshirt_2":0,"torso_1":13,"torso_2":5,"shoes_1":7,"shoes_2":2,"pants_1":9, "pants_2":7, "arms":11, "helmet_1":11, "helmet_2":0,"bags_1":0,"bags_2":0,"ears_1":0,"glasses_1":0,"ears_2":0,"glasses_2":0}', '{"tshirt_1":0,"tshirt_2":0,"torso_1":56,"torso_2":0,"shoes_1":27,"shoes_2":0,"pants_1":36, "pants_2":0, "arms":63, "helmet_1":11, "helmet_2":0,"bags_1":0,"bags_2":0,"ears_1":0,"glasses_1":0,"ears_2":0,"glasses_2":0}'),
934(55, 'vigne', 2, 'cdisenior', 'Chef de chai', 1200, '{"tshirt_1":57,"tshirt_2":0,"torso_1":13,"torso_2":5,"shoes_1":7,"shoes_2":2,"pants_1":9, "pants_2":7, "arms":11, "helmet_1":11, "helmet_2":0,"bags_1":0,"bags_2":0,"ears_1":0,"glasses_1":0,"ears_2":0,"glasses_2":0}', '{"tshirt_1":0,"tshirt_2":0,"torso_1":56,"torso_2":0,"shoes_1":27,"shoes_2":0,"pants_1":36, "pants_2":0, "arms":63, "helmet_1":11, "helmet_2":0,"bags_1":0,"bags_2":0,"ears_1":0,"glasses_1":0,"ears_2":0,"glasses_2":0}'),
935(56, 'vigne', 3, 'boss', 'Patron', 1600, '{"tshirt_1":57,"tshirt_2":0,"torso_1":13,"torso_2":5,"shoes_1":7,"shoes_2":2,"pants_1":9, "pants_2":7, "arms":11, "helmet_1":11, "helmet_2":0,"bags_1":0,"bags_2":0,"ears_1":0,"glasses_1":0,"ears_2":0,"glasses_2":0}', '{"tshirt_1":15,"tshirt_2":0,"torso_1":14,"torso_2":15,"shoes_1":12,"shoes_2":0,"pants_1":9, "pants_2":5, "arms":1, "helmet_1":11, "helmet_2":0,"bags_1":0,"bags_2":0,"ears_1":0,"glasses_1":0,"ears_2":0,"glasses_2":0}'),
936(57, 'realestateagent', 0, 'location', 'Location', 10, '{}', '{}'),
937(58, 'realestateagent', 1, 'vendeur', 'Vendeur', 25, '{}', '{}'),
938(59, 'realestateagent', 2, 'gestion', 'Gestion', 40, '{}', '{}'),
939(60, 'realestateagent', 3, 'boss', 'Patron', 0, '{}', '{}'),
940(61, 'banker', 0, 'advisor', 'Conseiller', 10, '{}', '{}'),
941(62, 'banker', 1, 'banker', 'Banquier', 20, '{}', '{}'),
942(63, 'banker', 2, 'business_banker', 'Banquier d''affaire', 30, '{}', '{}'),
943(64, 'banker', 3, 'trader', 'Trader', 40, '{}', '{}'),
944(65, 'banker', 4, 'boss', 'Patron', 0, '{}', '{}'),
945(66, 'avocat', 0, 'recruit', 'Recrue', 20, '{"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}'),
946(67, 'avocat', 1, 'boss', 'Patron', 100, '{"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}'),
947(68, 'bahama', 0, 'recrue', 'Recrue', 0, '{}', '{}'),
948(69, 'bahama', 1, 'novice', 'Novice', 0, '{}', '{}'),
949(70, 'bahama', 2, 'experimente', 'Experimente', 0, '{}', '{}'),
950(71, 'bahama', 3, 'boss', 'Patron', 0, '{}', '{}'),
951(72, 'unicorn', 0, 'barman', 'Barman', 300, '{}', '{}'),
952(73, 'unicorn', 1, 'dancer', 'Danseur', 300, '{}', '{}'),
953(74, 'unicorn', 2, 'viceboss', 'Co-gérant', 500, '{}', '{}'),
954(75, 'unicorn', 3, 'boss', 'Gérant', 600, '{}', '{}'),
955(76, 'Securitas', 0, 'recruit', 'vakt', 50, '{}', '{}'),
956(77, 'Securitas', 1, 'officer', 'Biträdande veteran vakt', 60, '{}', '{}'),
957(78, 'Securitas', 2, 'sergeant', 'Assistent', 70, '{}', '{}'),
958(79, 'Securitas', 3, 'lieutenant', 'vice chef', 80, '{}', '{}'),
959(80, 'Securitas', 4, 'boss', 'chef', 90, '{}', '{}'),
960(81, 'bac', 0, 'recruit', 'Recru', 200, '{}', '{}'),
961(82, 'bac', 1, 'officer', 'Experimente', 400, '{}', '{}'),
962(83, 'bac', 2, 'sergeant', 'Sergent', 600, '{}', '{}'),
963(84, 'bac', 3, 'lieutenant', 'Lieutenant', 850, '{}', '{}'),
964(85, 'bac', 4, 'boss', 'Chef BAC', 1000, '{}', '{}'),
965(86, 'fib', 0, 'recruit', 'Recrue', 1000, '{"eyebrows_4":27,"beard_1":18,"hair_color_2":0,"torso_1":13,"hair_2":0,"glasses_2":3,"skin":1,"eyebrows_2":10,"glasses_1":5,"makeup_2":1,"mask_2":0,"beard_4":7,"hair_color_1":2,"mask_1":0,"beard_2":10,"bproof_1":0,"shoes_1":21,"face":0,"bags_1":0,"pants_1":10,"helmet_1":8,"pants_2":0,"makeup_4":1,"chain_1":38,"sex":0,"tshirt_1":15,"makeup_3":0,"tshirt_2":0,"shoes":10,"bproof_2":0,"arms":11,"decals_2":0,"ears_2":0,"helmet_2":0,"ears_1":2,"lipstick_4":0,"glasses":0,"torso_2":0,"lipstick_1":0,"decals_1":0,"beard_3":2,"makeup_1":0,"shoes_2":0,"chain_2":0,"eyebrows_3":27,"bags_2":0,"age_2":2,"hair_1":39,"age_1":4,"lipstick_3":0,"lipstick_2":0,"eyebrows_1":12}', '{"eyebrows_4":27,"beard_1":18,"hair_color_2":0,"torso_1":27,"hair_2":0,"glasses_2":0,"skin":0,"eyebrows_2":10,"glasses_1":19,"makeup_2":1,"mask_2":0,"beard_4":4,"hair_color_1":2,"mask_1":0,"beard_2":0,"bproof_1":0,"shoes_1":13,"face":6,"bags_1":0,"pants_1":6,"helmet_1":57,"pants_2":0,"makeup_4":1,"chain_1":0,"sex":1,"tshirt_1":3,"makeup_3":0,"tshirt_2":0,"shoes":10,"bproof_2":0,"arms":0,"decals_2":0,"ears_2":0,"helmet_2":0,"ears_1":-1,"lipstick_4":0,"glasses":0,"torso_2":0,"lipstick_1":0,"decals_1":1,"beard_3":0,"makeup_1":0,"shoes_2":0,"chain_2":0,"eyebrows_3":27,"bags_2":0,"age_2":2,"hair_1":73,"age_1":4,"lipstick_3":0,"lipstick_2":0,"eyebrows_1":13}'),
966(87, 'fib', 1, 'agent', 'Agent', 2500, '{"eyebrows_1":10,"beard_1":0,"hair_color_2":0,"torso_1":28,"hair_2":0,"glasses_2":6,"skin":0,"eyebrows_2":10,"hair_1":10,"makeup_2":0,"mask_2":0,"beard_4":0,"hair_color_1":3,"sex":0,"beard_2":0,"bproof_1":0,"mask_1":0,"face":44,"decals_1":0,"bags_1":0,"helmet_1":-1,"pants_2":0,"lipstick_1":0,"chain_1":10,"decals_2":0,"tshirt_1":10,"makeup_3":0,"tshirt_2":0,"shoes":24,"bproof_2":0,"arms":1,"age_2":0,"ears_2":0,"helmet_2":0,"ears_1":-1,"lipstick_4":0,"pants_1":10,"shoes_1":21,"beard_3":0,"lipstick_2":0,"eyebrows_4":0,"makeup_1":0,"shoes_2":0,"chain_2":2,"eyebrows_3":1,"bags_2":0,"glasses":0,"torso_2":0,"age_1":0,"lipstick_3":0,"makeup_4":0,"glasses_1":17}', '{"eyebrows_1":13,"beard_1":18,"hair_color_2":0,"torso_1":7,"hair_2":0,"glasses_2":0,"skin":0,"makeup_4":1,"hair_1":73,"makeup_2":1,"mask_2":0,"beard_4":4,"hair_color_1":2,"mask_1":0,"torso_2":0,"bproof_1":0,"decals_1":1,"glasses":0,"sex":1,"bags_1":0,"helmet_1":57,"pants_2":0,"face":6,"chain_1":0,"beard_2":0,"tshirt_1":39,"makeup_3":0,"tshirt_2":0,"shoes":10,"bproof_2":0,"arms":7,"eyebrows_2":10,"ears_2":0,"helmet_2":0,"ears_1":-1,"lipstick_4":0,"beard_3":0,"chain_2":0,"pants_1":6,"lipstick_2":0,"eyebrows_4":27,"makeup_1":0,"shoes_2":0,"decals_2":0,"shoes_1":13,"bags_2":0,"age_2":2,"glasses_1":19,"age_1":4,"lipstick_3":0,"lipstick_1":0,"eyebrows_3":27}'),
967(88, 'fib', 2, 'specialagent', 'Agent Spécial', 3500, '{"eyebrows_1":10,"beard_1":0,"hair_color_2":0,"torso_1":28,"hair_2":0,"glasses_2":6,"skin":0,"eyebrows_2":10,"hair_1":10,"makeup_2":0,"mask_2":0,"beard_4":0,"hair_color_1":3,"sex":0,"beard_2":0,"bproof_1":0,"mask_1":0,"face":44,"decals_1":0,"bags_1":0,"helmet_1":-1,"pants_2":0,"lipstick_1":0,"chain_1":10,"decals_2":0,"tshirt_1":10,"makeup_3":0,"tshirt_2":0,"shoes":24,"bproof_2":0,"arms":1,"age_2":0,"ears_2":0,"helmet_2":0,"ears_1":-1,"lipstick_4":0,"pants_1":10,"shoes_1":21,"beard_3":0,"lipstick_2":0,"eyebrows_4":0,"makeup_1":0,"shoes_2":0,"chain_2":2,"eyebrows_3":1,"bags_2":0,"glasses":0,"torso_2":0,"age_1":0,"lipstick_3":0,"makeup_4":0,"glasses_1":17}', '{"eyebrows_1":13,"beard_1":18,"hair_color_2":0,"torso_1":7,"hair_2":0,"glasses_2":0,"skin":0,"makeup_4":1,"hair_1":73,"makeup_2":1,"mask_2":0,"beard_4":4,"hair_color_1":2,"mask_1":0,"torso_2":0,"bproof_1":0,"decals_1":1,"glasses":0,"sex":1,"bags_1":0,"helmet_1":57,"pants_2":0,"face":6,"chain_1":0,"beard_2":0,"tshirt_1":39,"makeup_3":0,"tshirt_2":0,"shoes":10,"bproof_2":0,"arms":7,"eyebrows_2":10,"ears_2":0,"helmet_2":0,"ears_1":-1,"lipstick_4":0,"beard_3":0,"chain_2":0,"pants_1":6,"lipstick_2":0,"eyebrows_4":27,"makeup_1":0,"shoes_2":0,"decals_2":0,"shoes_1":13,"bags_2":0,"age_2":2,"glasses_1":19,"age_1":4,"lipstick_3":0,"lipstick_1":0,"eyebrows_3":27}'),
968(89, 'fib', 3, 'boss', 'Directeur', 4000, '{"eyebrows_1":10,"beard_1":0,"hair_color_2":0,"torso_1":4,"hair_2":0,"glasses_2":6,"skin":0,"eyebrows_2":10,"hair_1":10,"makeup_2":0,"mask_2":0,"beard_4":0,"hair_color_1":3,"sex":0,"beard_2":0,"bproof_1":0,"mask_1":0,"face":44,"decals_1":0,"bags_1":0,"helmet_1":-1,"pants_2":0,"lipstick_1":0,"chain_1":10,"decals_2":0,"tshirt_1":10,"makeup_3":0,"tshirt_2":0,"shoes":24,"bproof_2":0,"arms":4,"age_2":0,"ears_2":0,"helmet_2":0,"ears_1":-1,"lipstick_4":0,"pants_1":10,"shoes_1":21,"beard_3":0,"lipstick_2":0,"eyebrows_4":0,"makeup_1":0,"shoes_2":0,"chain_2":2,"eyebrows_3":1,"bags_2":0,"glasses":0,"torso_2":0,"age_1":0,"lipstick_3":0,"makeup_4":0,"glasses_1":17}', '{"eyebrows_1":13,"beard_1":18,"hair_color_2":0,"torso_1":7,"hair_2":0,"glasses_2":0,"skin":0,"makeup_4":1,"hair_1":73,"makeup_2":1,"mask_2":0,"beard_4":4,"hair_color_1":2,"mask_1":0,"torso_2":0,"bproof_1":0,"decals_1":1,"glasses":0,"sex":1,"bags_1":0,"helmet_1":57,"pants_2":0,"face":6,"chain_1":0,"beard_2":0,"tshirt_1":39,"makeup_3":0,"tshirt_2":0,"shoes":10,"bproof_2":0,"arms":7,"eyebrows_2":10,"ears_2":0,"helmet_2":0,"ears_1":-1,"lipstick_4":0,"beard_3":0,"chain_2":0,"pants_1":6,"lipstick_2":0,"eyebrows_4":27,"makeup_1":0,"shoes_2":0,"decals_2":0,"shoes_1":13,"bags_2":0,"age_2":2,"glasses_1":19,"age_1":4,"lipstick_3":0,"lipstick_1":0,"eyebrows_3":27}'),
969(90, 'ammu', 0, 'soldato', 'Recrue', 1000, '{}', '{}'),
970(91, 'ammu', 1, 'capo', 'Employé', 1200, '{}', '{}'),
971(92, 'ammu', 2, 'consigliere', 'Responsable', 1500, '{}', '{}'),
972(93, 'ammu', 3, 'righthand', 'Bras droite', 2100, '{}', '{}'),
973(94, 'ammu', 4, 'boss', 'Patron', 2700, '{"tshirt_1":15,"torso_1":42,"shoes":8,"pants_1":24,"pants_2":0,"decals_2":0,"hair_color_2":0,"face":19,"helmet_2":0,"hair_2":0,"arms":8,"torso_2":0,"hair_color_1":5,"hair_1":2,"skin":34,"sex":0,"glasses_1":0,"glasses_2":1,"decals_1":0,"glasses":0,"tshirt_2":0,"helmet_1":-1}', '{}'),
974(95, 'journaliste', 0, 'stagiaire', 'Stagiaire', 250, '{}', '{}'),
975(96, 'journaliste', 1, 'reporter', 'Reporter', 350, '{}', '{}'),
976(97, 'journaliste', 2, 'investigator', 'Enquêteur', 400, '{}', '{}'),
977(98, 'journaliste', 3, 'boss', 'Rédac'' chef', 450, '{}', '{}'),
978(99, 'gouvernement', 1, 'recruit', 'Fils gouverneur', 20, '{}', '{}'),
979(100, 'gouvernement', 2, 'boss', 'Gouverneur', 100, '{}', '{}'),
980(132, 'motodealer', 3, 'boss', 'Patron', 0, '{}', '{}'),
981(135, 'sheriff', 0, 'recruit', 'Recrue', 20, '{}', '{}'),
982(136, 'sheriff', 1, 'officer', 'Officier', 40, '{}', '{}'),
983(137, 'sheriff', 2, 'sergeant', 'Sergent', 60, '{}', '{}'),
984(138, 'sheriff', 3, 'lieutenant', 'Lieutenant', 85, '{}', '{}'),
985(139, 'sheriff', 4, 'boss', 'Commandant', 100, '{}', '{}'),
986(153, 'mecano', 3, 'chief', 'Chef d''équipe', 48, '{}', '{}'),
987(154, 'mecano', 4, 'boss', 'Patron', 0, '{}', '{}');
988
989-- --------------------------------------------------------
990
991--
992-- Structure de la table `licenses`
993--
994
995CREATE TABLE IF NOT EXISTS `licenses` (
996  `type` varchar(60) NOT NULL,
997  `label` varchar(60) NOT NULL
998) ENGINE=MyISAM DEFAULT CHARSET=latin1;
999
1000--
1001-- Contenu de la table `licenses`
1002--
1003
1004INSERT INTO `licenses` (`type`, `label`) VALUES
1005('dmv', 'Code de la route'),
1006('drive', 'Permis de conduire'),
1007('drive_bike', 'Permis moto'),
1008('drive_truck', 'Permis camion'),
1009('weapon', 'Permis de port d''arme');
1010
1011-- --------------------------------------------------------
1012
1013--
1014-- Structure de la table `motodealer_motos`
1015--
1016
1017CREATE TABLE IF NOT EXISTS `motodealer_motos` (
1018`id` int(11) NOT NULL,
1019  `vehicle` varchar(255) NOT NULL,
1020  `price` int(11) NOT NULL
1021) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
1022
1023--
1024-- Contenu de la table `motodealer_motos`
1025--
1026
1027INSERT INTO `motodealer_motos` (`id`, `vehicle`, `price`) VALUES
1028(1, 'AKUMA', 7500),
1029(2, 'manchez', 5300);
1030
1031-- --------------------------------------------------------
1032
1033--
1034-- Structure de la table `motos`
1035--
1036
1037CREATE TABLE IF NOT EXISTS `motos` (
1038`id` int(11) NOT NULL,
1039  `name` varchar(60) NOT NULL,
1040  `model` varchar(60) NOT NULL,
1041  `price` int(11) NOT NULL,
1042  `category` varchar(60) DEFAULT NULL
1043) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;
1044
1045--
1046-- Contenu de la table `motos`
1047--
1048
1049INSERT INTO `motos` (`id`, `name`, `model`, `price`, `category`) VALUES
1050(1, 'Akuma', 'AKUMA', 7500, 'motorcycles'),
1051(2, 'Avarus', 'avarus', 18000, 'motorcycles'),
1052(3, 'Bagger', 'bagger', 13500, 'motorcycles'),
1053(4, 'Bati 801', 'bati', 12000, 'motorcycles'),
1054(5, 'Bati 801RR', 'bati2', 19000, 'motorcycles'),
1055(6, 'BF400', 'bf400', 6500, 'motorcycles'),
1056(7, 'BMX (velo)', 'bmx', 160, 'motorcycles'),
1057(8, 'Carbon RS', 'carbonrs', 18000, 'motorcycles'),
1058(9, 'Chimera', 'chimera', 38000, 'motorcycles'),
1059(10, 'Cliffhanger', 'cliffhanger', 9500, 'motorcycles'),
1060(11, 'Cruiser (velo)', 'cruiser', 510, 'motorcycles'),
1061(12, 'Daemon', 'daemon', 11500, 'motorcycles'),
1062(13, 'Daemon High', 'daemon2', 13500, 'motorcycles'),
1063(14, 'Defiler', 'defiler', 9800, 'motorcycles'),
1064(15, 'Double T', 'double', 28000, 'motorcycles'),
1065(16, 'Enduro', 'enduro', 5500, 'motorcycles'),
1066(17, 'Esskey', 'esskey', 4200, 'motorcycles'),
1067(18, 'Faggio', 'faggio', 1900, 'motorcycles'),
1068(19, 'Vespa', 'faggio2', 2800, 'motorcycles'),
1069(20, 'Fixter (velo)', 'fixter', 225, 'motorcycles'),
1070(21, 'Gargoyle', 'gargoyle', 16500, 'motorcycles'),
1071(22, 'Hakuchou', 'hakuchou', 31000, 'motorcycles'),
1072(23, 'Hakuchou Sport', 'hakuchou2', 55000, 'motorcycles'),
1073(24, 'Hexer', 'hexer', 12000, 'motorcycles'),
1074(25, 'Innovation', 'innovation', 23500, 'motorcycles'),
1075(26, 'Manchez', 'manchez', 5300, 'motorcycles'),
1076(27, 'Nemesis', 'nemesis', 5800, 'motorcycles'),
1077(28, 'Nightblade', 'nightblade', 35000, 'motorcycles'),
1078(29, 'PCJ-600', 'pcj', 6200, 'motorcycles'),
1079(30, 'Ruffian', 'ruffian', 6800, 'motorcycles'),
1080(31, 'Sanchez', 'sanchez', 5300, 'motorcycles'),
1081(32, 'Sanchez Sport', 'sanchez2', 5300, 'motorcycles'),
1082(33, 'Sanctus', 'sanctus', 25000, 'motorcycles'),
1083(34, 'Scorcher (velo)', 'scorcher', 280, 'motorcycles'),
1084(35, 'Sovereign', 'sovereign', 22000, 'motorcycles'),
1085(36, 'Shotaro Concept', 'shotaro', 320000, 'motorcycles'),
1086(37, 'Thrust', 'thrust', 24000, 'motorcycles'),
1087(38, 'Tri bike (velo)', 'tribike3', 520, 'motorcycles'),
1088(39, 'Vader', 'vader', 7200, 'motorcycles'),
1089(40, 'Vortex', 'vortex', 9800, 'motorcycles'),
1090(41, 'Woflsbane', 'wolfsbane', 9000, 'motorcycles'),
1091(42, 'Zombie', 'zombiea', 9500, 'motorcycles'),
1092(43, 'Zombie Luxuary', 'zombieb', 12000, 'motorcycles');
1093
1094-- --------------------------------------------------------
1095
1096--
1097-- Structure de la table `motos_categories`
1098--
1099
1100CREATE TABLE IF NOT EXISTS `motos_categories` (
1101`id` int(11) NOT NULL,
1102  `name` varchar(60) NOT NULL,
1103  `label` varchar(60) NOT NULL
1104) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1105
1106--
1107-- Contenu de la table `motos_categories`
1108--
1109
1110INSERT INTO `motos_categories` (`id`, `name`, `label`) VALUES
1111(1, 'motorcycles', 'Motos');
1112
1113-- --------------------------------------------------------
1114
1115--
1116-- Structure de la table `open_car`
1117--
1118
1119CREATE TABLE IF NOT EXISTS `open_car` (
1120`id` int(11) NOT NULL,
1121  `identifier` varchar(255) DEFAULT NULL,
1122  `label` varchar(255) DEFAULT NULL,
1123  `value` varchar(50) DEFAULT NULL,
1124  `got` varchar(50) DEFAULT NULL,
1125  `NB` int(11) DEFAULT '0'
1126) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
1127
1128--
1129-- Contenu de la table `open_car`
1130--
1131
1132INSERT INTO `open_car` (`id`, `identifier`, `label`, `value`, `got`, `NB`) VALUES
1133(3, 'steam:110000118e987a2', 'Cles', 'Z4E01D9Q', 'true', 1),
1134(4, 'steam:1100001136d9a1e', 'Cles', 'MLLZO2IA', 'true', 1),
1135(5, 'steam:11000010f6f23c8', 'Cles', 'LSPD167', 'true', 2),
1136(6, 'steam:1100001136d9a1e', 'Cles', 'LSPD507', 'true', 2),
1137(7, 'steam:11000010f6f23c8', 'Cles', 'LSPD178', 'true', 2),
1138(8, 'steam:1100001136d9a1e', 'Cles', 'LSPD768', 'true', 2),
1139(9, 'steam:1100001136d9a1e', 'Cles', 'LSPD773', 'true', 2),
1140(10, 'steam:11000010f6f23c8', 'Cles', 'LSPD677', 'true', 2),
1141(11, 'steam:11000010f6f23c8', 'Cles', 'LSPD114', 'true', 2),
1142(12, 'steam:1100001136d9a1e', 'Cles', 'LSPD635', 'true', 2),
1143(13, 'steam:11000010f6f23c8', 'Cles', 'LSPD251', 'true', 2),
1144(14, 'steam:1100001136d9a1e', 'Cles', 'LSPD870', 'true', 2),
1145(15, 'steam:11000010f6f23c8', 'Cles', 'LSPD786', 'true', 2);
1146
1147-- --------------------------------------------------------
1148
1149--
1150-- Structure de la table `org`
1151--
1152
1153CREATE TABLE IF NOT EXISTS `org` (
1154  `name` varchar(50) NOT NULL,
1155  `label` varchar(50) DEFAULT NULL
1156) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1157
1158--
1159-- Contenu de la table `org`
1160--
1161
1162INSERT INTO `org` (`name`, `label`) VALUES
1163('rsa', 'Chômeur'),
1164('vagos', 'vagos'),
1165('families', 'Families'),
1166('bloods', 'bloods'),
1167('biker', 'biker'),
1168('ballas', 'ballas');
1169
1170-- --------------------------------------------------------
1171
1172--
1173-- Structure de la table `organisation_moneywash`
1174--
1175
1176CREATE TABLE IF NOT EXISTS `organisation_moneywash` (
1177`id` int(11) NOT NULL,
1178  `identifier` varchar(60) NOT NULL,
1179  `organisation` varchar(60) NOT NULL,
1180  `amount` int(11) NOT NULL
1181) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1182
1183-- --------------------------------------------------------
1184
1185--
1186-- Structure de la table `org_gradeorg`
1187--
1188
1189CREATE TABLE IF NOT EXISTS `org_gradeorg` (
1190`id` int(11) NOT NULL,
1191  `org_name` varchar(50) DEFAULT NULL,
1192  `gradeorg` int(11) NOT NULL,
1193  `name` varchar(50) NOT NULL,
1194  `label` varchar(50) NOT NULL,
1195  `salary` int(11) NOT NULL,
1196  `skin_male` longtext NOT NULL,
1197  `skin_female` longtext NOT NULL
1198) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
1199
1200--
1201-- Contenu de la table `org_gradeorg`
1202--
1203
1204INSERT INTO `org_gradeorg` (`id`, `org_name`, `gradeorg`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
1205(1, 'rsa', 0, 'rsa', 'RSA', 200, '{}', '{}'),
1206(2, 'vagos', 0, 'soldato', 'Ptite-Frappe', 1500, '{}', '{}'),
1207(3, 'vagos', 1, 'capo', 'Capo', 1800, '{}', '{}'),
1208(4, 'vagos', 2, 'consigliere', 'Chef', 2100, '{}', '{}'),
1209(5, 'vagos', 3, 'boss', 'Patron', 2700, '{}', '{}'),
1210(6, 'families', 0, 'soldato', 'Ptite-Frappe', 1500, '{}', '{}'),
1211(7, 'families', 1, 'capo', 'Capo', 1800, '{}', '{}'),
1212(8, 'families', 2, 'consigliere', 'Chef', 2100, '{}', '{}'),
1213(9, 'families', 3, 'boss', 'Patron', 2700, '{}', '{}'),
1214(10, 'bloods', 0, 'soldato', 'Ptite-Frappe', 1500, '{}', '{}'),
1215(11, 'bloods', 1, 'capo', 'Capo', 1800, '{}', '{}'),
1216(12, 'bloods', 2, 'consigliere', 'Chef', 2100, '{}', '{}'),
1217(13, 'bloods', 3, 'boss', 'Patron', 2700, '{}', '{}'),
1218(14, 'biker', 0, 'soldato', 'Ptite-Frappe', 1500, '{}', '{}'),
1219(15, 'biker', 1, 'capo', 'Capo', 1800, '{}', '{}'),
1220(16, 'biker', 2, 'consigliere', 'Chef', 2100, '{}', '{}'),
1221(17, 'biker', 3, 'boss', 'Patron', 2700, '{}', '{}'),
1222(18, 'ballas', 0, 'soldato', 'Ptite-Frappe', 1500, '{}', '{}'),
1223(19, 'ballas', 1, 'capo', 'Capo', 1800, '{}', '{}'),
1224(20, 'ballas', 2, 'consigliere', 'Chef', 2100, '{}', '{}'),
1225(21, 'ballas', 3, 'boss', 'Patron', 2700, '{}', '{}');
1226
1227-- --------------------------------------------------------
1228
1229--
1230-- Structure de la table `owned_properties`
1231--
1232
1233CREATE TABLE IF NOT EXISTS `owned_properties` (
1234`id` int(11) NOT NULL,
1235  `name` varchar(255) NOT NULL,
1236  `price` double NOT NULL,
1237  `rented` int(11) NOT NULL,
1238  `owner` varchar(60) NOT NULL,
1239  `type` varchar(20) DEFAULT NULL
1240) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
1241
1242-- --------------------------------------------------------
1243
1244--
1245-- Structure de la table `owned_vehicles`
1246--
1247
1248CREATE TABLE IF NOT EXISTS `owned_vehicles` (
1249`id` int(11) NOT NULL,
1250  `vehicle` longtext NOT NULL,
1251  `owner` varchar(60) NOT NULL,
1252  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Etat de la voiture'
1253) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
1254
1255--
1256-- Contenu de la table `owned_vehicles`
1257--
1258
1259INSERT INTO `owned_vehicles` (`id`, `vehicle`, `owner`, `state`) VALUES
1260(1, '{"wheels":2,"modDoorSpeaker":-1,"modArchCover":-1,"modHydrolic":-1,"modTrunk":-1,"modTurbo":false,"dirtLevel":0.11065354198218,"modAerials":-1,"modRearBumper":-1,"modEngine":-1,"modSideSkirt":-1,"extras":[],"modDashboard":-1,"modSeats":-1,"health":999,"modFrontWheels":-1,"modLivery":-1,"neonEnabled":[false,false,false,false],"color1":5,"modBrakes":-1,"tyreSmokeColor":[255,255,255],"modGrille":-1,"modHood":-1,"modSpoilers":-1,"model":-602287871,"modSpeakers":-1,"plateIndex":1,"modTank":-1,"modTrimA":-1,"modVanityPlate":-1,"modAPlate":-1,"wheelColor":156,"modBackWheels":-1,"modSuspension":-1,"modShifterLeavers":-1,"modRightFender":-1,"modWindows":-1,"modHorns":-1,"modOrnaments":-1,"modAirFilter":-1,"modSmokeEnabled":false,"neonColor":[255,0,255],"modFrontBumper":-1,"modEngineBlock":-1,"pearlescentColor":0,"modTrimB":-1,"modFender":-1,"modPlateHolder":-1,"modRoof":-1,"plate":"Z4E01D9Q","windowTint":-1,"modFrame":-1,"color2":2,"modSteeringWheel":-1,"modTransmission":-1,"modArmor":-1,"modStruts":-1,"modExhaust":-1,"modDial":-1,"modXenon":false}', 'steam:110000118e987a2', 0),
1261(2, '{"pearlescentColor":111,"modFrontBumper":-1,"modAerials":-1,"plateIndex":1,"tyreSmokeColor":[255,255,255],"modDoorSpeaker":-1,"modWindows":-1,"modSeats":-1,"modRearBumper":-1,"modAirFilter":-1,"modHorns":43,"wheelColor":156,"modLivery":-1,"modVanityPlate":-1,"wheels":7,"dirtLevel":7.5170221328736,"modPlateHolder":-1,"modTrunk":-1,"model":-1216765807,"modAPlate":-1,"modSpeakers":-1,"modBrakes":2,"windowTint":1,"modTransmission":2,"modArchCover":-1,"modSpoilers":-1,"modArmor":4,"modFrame":-1,"modFrontWheels":-1,"plate":"MLLZO2IA","modFender":-1,"modTrimA":-1,"modBackWheels":-1,"modXenon":1,"modSmokeEnabled":1,"color2":12,"modDial":-1,"color1":148,"modRoof":-1,"modTurbo":false,"modOrnaments":-1,"modSuspension":3,"modHood":-1,"modSteeringWheel":-1,"neonEnabled":[1,1,1,1],"modTrimB":-1,"modExhaust":-1,"modStruts":-1,"modHydrolic":-1,"modEngineBlock":-1,"modEngine":3,"modDashboard":-1,"modSideSkirt":-1,"modTank":-1,"extras":[],"modShifterLeavers":-1,"health":1000,"modGrille":-1,"neonColor":[153,0,153],"modRightFender":-1}', 'steam:1100001136d9a1e', 0);
1262
1263-- --------------------------------------------------------
1264
1265--
1266-- Structure de la table `peage_flash`
1267--
1268
1269CREATE TABLE IF NOT EXISTS `peage_flash` (
1270`id` int(11) NOT NULL,
1271  `plate` varchar(10) NOT NULL,
1272  `speed` int(11) NOT NULL,
1273  `modele` varchar(25) NOT NULL,
1274  `station` int(11) NOT NULL
1275) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
1276
1277--
1278-- Contenu de la table `peage_flash`
1279--
1280
1281INSERT INTO `peage_flash` (`id`, `plate`, `speed`, `modele`, `station`) VALUES
1282(1, '67ULU788', 297, 'DIVO 2019', 1),
1283(2, '67STX001', 239, 'DIVO 2019', 1),
1284(3, '43MYQ847', 165, 'Buffalo', 1);
1285
1286-- --------------------------------------------------------
1287
1288--
1289-- Structure de la table `phone_app_chat`
1290--
1291
1292CREATE TABLE IF NOT EXISTS `phone_app_chat` (
1293`id` int(11) NOT NULL,
1294  `channel` varchar(20) NOT NULL,
1295  `message` varchar(255) NOT NULL,
1296  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
1297) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1298
1299-- --------------------------------------------------------
1300
1301--
1302-- Structure de la table `phone_calls`
1303--
1304
1305CREATE TABLE IF NOT EXISTS `phone_calls` (
1306`id` int(11) NOT NULL,
1307  `owner` varchar(10) NOT NULL COMMENT 'Num tel proprio',
1308  `num` varchar(10) NOT NULL COMMENT 'Num reférence du contact',
1309  `incoming` int(11) NOT NULL COMMENT 'Défini si on est à l''origine de l''appels',
1310  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1311  `accepts` int(11) NOT NULL COMMENT 'Appels accepter ou pas'
1312) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1313
1314-- --------------------------------------------------------
1315
1316--
1317-- Structure de la table `phone_messages`
1318--
1319
1320CREATE TABLE IF NOT EXISTS `phone_messages` (
1321`id` int(11) NOT NULL,
1322  `transmitter` varchar(10) NOT NULL,
1323  `receiver` varchar(10) NOT NULL,
1324  `message` varchar(255) NOT NULL DEFAULT '0',
1325  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1326  `isRead` int(11) NOT NULL DEFAULT '0',
1327  `owner` int(11) NOT NULL DEFAULT '0'
1328) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1329
1330--
1331-- Contenu de la table `phone_messages`
1332--
1333
1334INSERT INTO `phone_messages` (`id`, `transmitter`, `receiver`, `message`, `time`, `isRead`, `owner`) VALUES
1335(2, '9988', '0642323622', 'GPS: 227.85331726074, -804.76647949219', '2019-08-12 16:22:18', 1, 1);
1336
1337-- --------------------------------------------------------
1338
1339--
1340-- Structure de la table `phone_users_contacts`
1341--
1342
1343CREATE TABLE IF NOT EXISTS `phone_users_contacts` (
1344`id` int(11) NOT NULL,
1345  `identifier` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
1346  `number` varchar(10) CHARACTER SET utf8mb4 DEFAULT NULL,
1347  `display` varchar(64) CHARACTER SET utf8mb4 NOT NULL DEFAULT '-1'
1348) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
1349
1350-- --------------------------------------------------------
1351
1352--
1353-- Structure de la table `players`
1354--
1355
1356CREATE TABLE IF NOT EXISTS `players` (
1357  `username` varchar(255) DEFAULT NULL,
1358  `password` varchar(255) DEFAULT NULL
1359) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1360
1361-- --------------------------------------------------------
1362
1363--
1364-- Structure de la table `properties`
1365--
1366
1367CREATE TABLE IF NOT EXISTS `properties` (
1368`id` int(11) NOT NULL,
1369  `name` varchar(255) DEFAULT NULL,
1370  `label` varchar(255) DEFAULT NULL,
1371  `entering` varchar(255) DEFAULT NULL,
1372  `exit` varchar(255) DEFAULT NULL,
1373  `inside` varchar(255) DEFAULT NULL,
1374  `outside` varchar(255) DEFAULT NULL,
1375  `ipls` varchar(255) DEFAULT '[]',
1376  `gateway` varchar(255) DEFAULT NULL,
1377  `is_single` int(11) DEFAULT NULL,
1378  `is_room` int(11) DEFAULT NULL,
1379  `is_gateway` int(11) DEFAULT NULL,
1380  `room_menu` varchar(255) DEFAULT NULL,
1381  `price` int(11) NOT NULL
1382) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;
1383
1384--
1385-- Contenu de la table `properties`
1386--
1387
1388INSERT INTO `properties` (`id`, `name`, `label`, `entering`, `exit`, `inside`, `outside`, `ipls`, `gateway`, `is_single`, `is_room`, `is_gateway`, `room_menu`, `price`) VALUES
1389(1, 'WhispymoundDrive', '2677 Whispymound Drive', '{"y":564.89,"z":182.959,"x":119.384}', '{"x":117.347,"y":559.506,"z":183.304}', '{"y":557.032,"z":183.301,"x":118.037}', '{"y":567.798,"z":182.131,"x":119.249}', '[]', NULL, 1, 1, 0, '{"x":118.748,"y":566.573,"z":175.697}', 1500000),
1390(2, 'NorthConkerAvenue2045', '2045 North Conker Avenue', '{"x":372.796,"y":428.327,"z":144.685}', '{"x":373.548,"y":422.982,"z":144.907},', '{"y":420.075,"z":145.904,"x":372.161}', '{"x":372.454,"y":432.886,"z":143.443}', '[]', NULL, 1, 1, 0, '{"x":377.349,"y":429.422,"z":137.3}', 1500000),
1391(3, 'RichardMajesticApt2', 'Richard Majestic, Apt 2', '{"y":-379.165,"z":37.961,"x":-936.363}', '{"y":-365.476,"z":113.274,"x":-913.097}', '{"y":-367.637,"z":113.274,"x":-918.022}', '{"y":-382.023,"z":37.961,"x":-943.626}', '[]', NULL, 1, 1, 0, '{"x":-927.554,"y":-377.744,"z":112.674}', 1700000),
1392(4, 'NorthConkerAvenue2044', '2044 North Conker Avenue', '{"y":440.8,"z":146.702,"x":346.964}', '{"y":437.456,"z":148.394,"x":341.683}', '{"y":435.626,"z":148.394,"x":339.595}', '{"x":350.535,"y":443.329,"z":145.764}', '[]', NULL, 1, 1, 0, '{"x":337.726,"y":436.985,"z":140.77}', 1500000),
1393(5, 'WildOatsDrive', '3655 Wild Oats Drive', '{"y":502.696,"z":136.421,"x":-176.003}', '{"y":497.817,"z":136.653,"x":-174.349}', '{"y":495.069,"z":136.666,"x":-173.331}', '{"y":506.412,"z":135.0664,"x":-177.927}', '[]', NULL, 1, 1, 0, '{"x":-174.725,"y":493.095,"z":129.043}', 1500000),
1394(6, 'HillcrestAvenue2862', '2862 Hillcrest Avenue', '{"y":596.58,"z":142.641,"x":-686.554}', '{"y":591.988,"z":144.392,"x":-681.728}', '{"y":590.608,"z":144.392,"x":-680.124}', '{"y":599.019,"z":142.059,"x":-689.492}', '[]', NULL, 1, 1, 0, '{"x":-680.46,"y":588.6,"z":136.769}', 1500000),
1395(7, 'LowEndApartment', 'Appartement de base', '{"y":-1078.735,"z":28.4031,"x":292.528}', '{"y":-1007.152,"z":-102.002,"x":265.845}', '{"y":-1002.802,"z":-100.008,"x":265.307}', '{"y":-1078.669,"z":28.401,"x":296.738}', '[]', NULL, 1, 1, 0, '{"x":265.916,"y":-999.38,"z":-100.008}', 562500),
1396(8, 'MadWayneThunder', '2113 Mad Wayne Thunder', '{"y":454.955,"z":96.462,"x":-1294.433}', '{"x":-1289.917,"y":449.541,"z":96.902}', '{"y":446.322,"z":96.899,"x":-1289.642}', '{"y":455.453,"z":96.517,"x":-1298.851}', '[]', NULL, 1, 1, 0, '{"x":-1287.306,"y":455.901,"z":89.294}', 1500000),
1397(9, 'HillcrestAvenue2874', '2874 Hillcrest Avenue', '{"x":-853.346,"y":696.678,"z":147.782}', '{"y":690.875,"z":151.86,"x":-859.961}', '{"y":688.361,"z":151.857,"x":-859.395}', '{"y":701.628,"z":147.773,"x":-855.007}', '[]', NULL, 1, 1, 0, '{"x":-858.543,"y":697.514,"z":144.253}', 1500000),
1398(10, 'HillcrestAvenue2868', '2868 Hillcrest Avenue', '{"y":620.494,"z":141.588,"x":-752.82}', '{"y":618.62,"z":143.153,"x":-759.317}', '{"y":617.629,"z":143.153,"x":-760.789}', '{"y":621.281,"z":141.254,"x":-750.919}', '[]', NULL, 1, 1, 0, '{"x":-762.504,"y":618.992,"z":135.53}', 1500000),
1399(11, 'TinselTowersApt12', 'Tinsel Towers, Apt 42', '{"y":37.025,"z":42.58,"x":-618.299}', '{"y":58.898,"z":97.2,"x":-603.301}', '{"y":58.941,"z":97.2,"x":-608.741}', '{"y":30.603,"z":42.524,"x":-620.017}', '[]', NULL, 1, 1, 0, '{"x":-622.173,"y":54.585,"z":96.599}', 1700000),
1400(12, 'MiltonDrive', 'Milton Drive', '{"x":-775.17,"y":312.01,"z":84.658}', NULL, NULL, '{"x":-775.346,"y":306.776,"z":84.7}', '[]', NULL, 0, 0, 1, NULL, 0),
1401(13, 'Modern1Apartment', 'Appartement Moderne 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_01_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-766.661,"y":327.672,"z":210.396}', 1300000),
1402(14, 'Modern2Apartment', 'Appartement Moderne 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_01_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.735,"y":326.757,"z":186.313}', 1300000),
1403(15, 'Modern3Apartment', 'Appartement Moderne 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_01_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.386,"y":330.782,"z":195.08}', 1300000),
1404(16, 'Mody1Apartment', 'Appartement Mode 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_02_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-766.615,"y":327.878,"z":210.396}', 1300000),
1405(17, 'Mody2Apartment', 'Appartement Mode 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_02_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.297,"y":327.092,"z":186.313}', 1300000),
1406(18, 'Mody3Apartment', 'Appartement Mode 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_02_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.303,"y":330.932,"z":195.085}', 1300000),
1407(19, 'Vibrant1Apartment', 'Appartement Vibrant 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_03_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.885,"y":327.641,"z":210.396}', 1300000),
1408(20, 'Vibrant2Apartment', 'Appartement Vibrant 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_03_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.607,"y":327.344,"z":186.313}', 1300000),
1409(21, 'Vibrant3Apartment', 'Appartement Vibrant 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_03_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.525,"y":330.851,"z":195.085}', 1300000),
1410(22, 'Sharp1Apartment', 'Appartement Persan 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_04_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-766.527,"y":327.89,"z":210.396}', 1300000),
1411(23, 'Sharp2Apartment', 'Appartement Persan 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_04_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.642,"y":326.497,"z":186.313}', 1300000),
1412(24, 'Sharp3Apartment', 'Appartement Persan 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_04_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.503,"y":331.318,"z":195.085}', 1300000),
1413(25, 'Monochrome1Apartment', 'Appartement Monochrome 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_05_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-766.289,"y":328.086,"z":210.396}', 1300000),
1414(26, 'Monochrome2Apartment', 'Appartement Monochrome 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_05_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.692,"y":326.762,"z":186.313}', 1300000),
1415(27, 'Monochrome3Apartment', 'Appartement Monochrome 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_05_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.094,"y":330.976,"z":195.085}', 1300000),
1416(28, 'Seductive1Apartment', 'Appartement Séduisant 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_06_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-766.263,"y":328.104,"z":210.396}', 1300000),
1417(29, 'Seductive2Apartment', 'Appartement Séduisant 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_06_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.655,"y":326.611,"z":186.313}', 1300000),
1418(30, 'Seductive3Apartment', 'Appartement Séduisant 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_06_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.3,"y":331.414,"z":195.085}', 1300000),
1419(31, 'Regal1Apartment', 'Appartement Régal 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_07_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.956,"y":328.257,"z":210.396}', 1300000),
1420(32, 'Regal2Apartment', 'Appartement Régal 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_07_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.545,"y":326.659,"z":186.313}', 1300000),
1421(33, 'Regal3Apartment', 'Appartement Régal 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_07_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.087,"y":331.429,"z":195.123}', 1300000),
1422(34, 'Aqua1Apartment', 'Appartement Aqua 1', NULL, '{"x":-784.194,"y":323.636,"z":210.997}', '{"x":-779.751,"y":323.385,"z":210.997}', NULL, '["apa_v_mp_h_08_a"]', 'MiltonDrive', 0, 1, 0, '{"x":-766.187,"y":328.47,"z":210.396}', 1300000),
1423(35, 'Aqua2Apartment', 'Appartement Aqua 2', NULL, '{"x":-786.8663,"y":315.764,"z":186.913}', '{"x":-781.808,"y":315.866,"z":186.913}', NULL, '["apa_v_mp_h_08_c"]', 'MiltonDrive', 0, 1, 0, '{"x":-795.658,"y":326.563,"z":186.313}', 1300000),
1424(36, 'Aqua3Apartment', 'Appartement Aqua 3', NULL, '{"x":-774.012,"y":342.042,"z":195.686}', '{"x":-779.057,"y":342.063,"z":195.686}', NULL, '["apa_v_mp_h_08_b"]', 'MiltonDrive', 0, 1, 0, '{"x":-765.287,"y":331.084,"z":195.086}', 1300000),
1425(37, 'IntegrityWay', '4 Integrity Way', '{"x":-47.804,"y":-585.867,"z":36.956}', NULL, NULL, '{"x":-54.178,"y":-583.762,"z":35.798}', '[]', NULL, 0, 0, 1, NULL, 0),
1426(38, 'IntegrityWay28', '4 Integrity Way - Apt 28', NULL, '{"x":-31.409,"y":-594.927,"z":79.03}', '{"x":-26.098,"y":-596.909,"z":79.03}', NULL, '[]', 'IntegrityWay', 0, 1, 0, '{"x":-11.923,"y":-597.083,"z":78.43}', 1700000),
1427(39, 'IntegrityWay30', '4 Integrity Way - Apt 30', NULL, '{"x":-17.702,"y":-588.524,"z":89.114}', '{"x":-16.21,"y":-582.569,"z":89.114}', NULL, '[]', 'IntegrityWay', 0, 1, 0, '{"x":-26.327,"y":-588.384,"z":89.123}', 1700000),
1428(40, 'DellPerroHeights', 'Dell Perro Heights', '{"x":-1447.06,"y":-538.28,"z":33.74}', NULL, NULL, '{"x":-1440.022,"y":-548.696,"z":33.74}', '[]', NULL, 0, 0, 1, NULL, 0),
1429(41, 'DellPerroHeightst4', 'Dell Perro Heights - Apt 28', NULL, '{"x":-1452.125,"y":-540.591,"z":73.044}', '{"x":-1455.435,"y":-535.79,"z":73.044}', NULL, '[]', 'DellPerroHeights', 0, 1, 0, '{"x":-1467.058,"y":-527.571,"z":72.443}', 1700000),
1430(42, 'DellPerroHeightst7', 'Dell Perro Heights - Apt 30', NULL, '{"x":-1451.562,"y":-523.535,"z":55.928}', '{"x":-1456.02,"y":-519.209,"z":55.929}', NULL, '[]', 'DellPerroHeights', 0, 1, 0, '{"x":-1457.026,"y":-530.219,"z":55.937}', 1700000);
1431
1432-- --------------------------------------------------------
1433
1434--
1435-- Structure de la table `rented_vehicles`
1436--
1437
1438CREATE TABLE IF NOT EXISTS `rented_vehicles` (
1439`id` int(11) NOT NULL,
1440  `vehicle` varchar(60) NOT NULL,
1441  `plate` varchar(10) NOT NULL,
1442  `player_name` varchar(255) NOT NULL,
1443  `base_price` int(11) NOT NULL,
1444  `rent_price` int(11) NOT NULL,
1445  `owner` varchar(255) NOT NULL
1446) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1447
1448-- --------------------------------------------------------
1449
1450--
1451-- Structure de la table `shops`
1452--
1453
1454CREATE TABLE IF NOT EXISTS `shops` (
1455`id` int(11) NOT NULL,
1456  `store` varchar(100) NOT NULL,
1457  `item` varchar(100) NOT NULL,
1458  `price` int(11) NOT NULL
1459) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;
1460
1461--
1462-- Contenu de la table `shops`
1463--
1464
1465INSERT INTO `shops` (`id`, `store`, `item`, `price`) VALUES
1466(1, 'TwentyFourSeven', 'bread', 30),
1467(2, 'TwentyFourSeven', 'water', 15),
1468(3, 'RobsLiquor', 'bread', 30),
1469(4, 'RobsLiquor', 'water', 15),
1470(5, 'LTDgasoline', 'bread', 30),
1471(6, 'LTDgasoline', 'water', 15),
1472(7, 'TwentyFourSeven', 'chocolate', 10),
1473(8, 'RobsLiquor', 'chocolate', 10),
1474(9, 'LTDgasoline', 'chocolate', 10),
1475(10, 'TwentyFourSeven', 'sandwich', 10),
1476(11, 'RobsLiquor', 'sandwich', 10),
1477(12, 'LTDgasoline', 'sandwich', 10),
1478(13, 'TwentyFourSeven', 'hamburger', 15),
1479(14, 'RobsLiquor', 'hamburger', 15),
1480(15, 'LTDgasoline', 'hamburger', 15),
1481(16, 'TwentyFourSeven', 'cupcake', 10),
1482(17, 'RobsLiquor', 'cupcake', 10),
1483(18, 'LTDgasoline', 'cupcake', 10),
1484(19, 'TwentyFourSeven', 'cocacola', 15),
1485(20, 'RobsLiquor', 'cocacola', 15),
1486(21, 'LTDgasoline', 'cocacola', 15),
1487(22, 'TwentyFourSeven', 'icetea', 10),
1488(23, 'RobsLiquor', 'icetea', 10),
1489(24, 'LTDgasoline', 'icetea', 10),
1490(25, 'TwentyFourSeven', 'coffe', 10),
1491(26, 'RobsLiquor', 'coffe', 10),
1492(27, 'LTDgasoline', 'coffe', 10),
1493(28, 'TwentyFourSeven', 'milk', 15),
1494(29, 'RobsLiquor', 'milk', 15),
1495(30, 'LTDgasoline', 'milk', 15),
1496(31, 'RobsLiquor', 'cigarett', 15),
1497(32, 'RobsLiquor', 'lighter', 10),
1498(33, 'LTDgasoline', 'cigarett', 15),
1499(34, 'LTDgasoline', 'lighter', 10),
1500(35, 'TwentyFourSeven', 'cigarett', 15),
1501(36, 'TwentyFourSeven', 'lighter', 10),
1502(37, 'Bar', 'beer', 30),
1503(38, 'Bar', 'wine', 25),
1504(39, 'Bar', 'vodka', 60),
1505(40, 'Bar', 'tequila', 40),
1506(41, 'Bar', 'whisky', 50),
1507(42, 'Bar', 'cigarett', 30),
1508(43, 'Bar', 'lighter', 25),
1509(44, 'Disco', 'beer', 30),
1510(45, 'Disco', 'wine', 25),
1511(46, 'Disco', 'vodka', 60),
1512(47, 'Disco', 'tequila', 40),
1513(48, 'Disco', 'whisky', 50),
1514(49, 'Disco', 'cigarett', 30),
1515(50, 'Disco', 'lighter', 25),
1516(51, 'LTDgasoline', 'croquettes', 100);
1517
1518-- --------------------------------------------------------
1519
1520--
1521-- Structure de la table `shops2`
1522--
1523
1524CREATE TABLE IF NOT EXISTS `shops2` (
1525`id` int(11) NOT NULL,
1526  `store` varchar(100) NOT NULL,
1527  `item` varchar(100) NOT NULL,
1528  `price` int(11) NOT NULL
1529) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
1530
1531--
1532-- Contenu de la table `shops2`
1533--
1534
1535INSERT INTO `shops2` (`id`, `store`, `item`, `price`) VALUES
1536(1, 'narekshop', 'clip', 15),
1537(2, 'narekshop', 'yusuf', 30),
1538(3, 'narekshop', 'grip', 30),
1539(4, 'narekshop', 'flashlight', 30),
1540(5, 'narekshop', 'silencieux', 15);
1541
1542-- --------------------------------------------------------
1543
1544--
1545-- Structure de la table `society_moneywash`
1546--
1547
1548CREATE TABLE IF NOT EXISTS `society_moneywash` (
1549`id` int(11) NOT NULL,
1550  `identifier` varchar(60) NOT NULL,
1551  `society` varchar(60) NOT NULL,
1552  `amount` int(11) NOT NULL
1553) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1554
1555-- --------------------------------------------------------
1556
1557--
1558-- Structure de la table `transfer`
1559--
1560
1561CREATE TABLE IF NOT EXISTS `transfer` (
1562  `Sender` varchar(50) DEFAULT NULL,
1563  `Type` varchar(50) DEFAULT NULL,
1564  `Amount` int(11) DEFAULT NULL,
1565  `Reciever` varchar(50) DEFAULT NULL
1566) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Money Transfer Information';
1567
1568-- --------------------------------------------------------
1569
1570--
1571-- Structure de la table `truck_inventory`
1572--
1573
1574CREATE TABLE IF NOT EXISTS `truck_inventory` (
1575`id` int(11) NOT NULL,
1576  `item` varchar(100) NOT NULL,
1577  `count` int(11) NOT NULL,
1578  `plate` varchar(8) NOT NULL,
1579  `name` varchar(255) NOT NULL,
1580  `owned` varchar(255) NOT NULL
1581) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1582
1583-- --------------------------------------------------------
1584
1585--
1586-- Structure de la table `twitter_accounts`
1587--
1588
1589CREATE TABLE IF NOT EXISTS `twitter_accounts` (
1590`id` int(11) NOT NULL,
1591  `username` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '0',
1592  `password` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '0',
1593  `avatar_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL
1594) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
1595
1596-- --------------------------------------------------------
1597
1598--
1599-- Structure de la table `twitter_likes`
1600--
1601
1602CREATE TABLE IF NOT EXISTS `twitter_likes` (
1603`id` int(11) NOT NULL,
1604  `authorId` int(11) DEFAULT NULL,
1605  `tweetId` int(11) DEFAULT NULL
1606) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
1607
1608-- --------------------------------------------------------
1609
1610--
1611-- Structure de la table `twitter_tweets`
1612--
1613
1614CREATE TABLE IF NOT EXISTS `twitter_tweets` (
1615`id` int(11) NOT NULL,
1616  `authorId` int(11) NOT NULL,
1617  `realUser` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
1618  `message` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
1619  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1620  `likes` int(11) NOT NULL DEFAULT '0'
1621) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1622
1623-- --------------------------------------------------------
1624
1625--
1626-- Structure de la table `users`
1627--
1628
1629CREATE TABLE IF NOT EXISTS `users` (
1630  `identifier` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
1631  `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
1632  `money` int(11) DEFAULT NULL,
1633  `name` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
1634  `skin` longtext COLLATE utf8mb4_bin,
1635  `job` varchar(50) COLLATE utf8mb4_bin DEFAULT 'unemployed',
1636  `job_grade` int(11) DEFAULT '0',
1637  `org` varchar(50) COLLATE utf8mb4_bin DEFAULT 'rsa',
1638  `org_gradeorg` int(11) DEFAULT '0',
1639  `loadout` longtext COLLATE utf8mb4_bin,
1640  `position` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
1641  `bank` int(11) DEFAULT NULL,
1642  `permission_level` int(11) DEFAULT NULL,
1643  `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
1644  `isDead` bit(1) DEFAULT b'0',
1645  `firstname` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
1646  `lastname` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
1647  `dateofbirth` varchar(25) COLLATE utf8mb4_bin DEFAULT '',
1648  `sex` varchar(10) COLLATE utf8mb4_bin DEFAULT '',
1649  `height` varchar(5) COLLATE utf8mb4_bin DEFAULT '',
1650  `phone_number` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL,
1651  `status` longtext COLLATE utf8mb4_bin
1652) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
1653
1654--
1655-- Contenu de la table `users`
1656--
1657
1658INSERT INTO `users` (`identifier`, `license`, `money`, `name`, `skin`, `job`, `job_grade`, `org`, `org_gradeorg`, `loadout`, `position`, `bank`, `permission_level`, `group`, `isDead`, `firstname`, `lastname`, `dateofbirth`, `sex`, `height`, `phone_number`, `status`) VALUES
1659('steam:11000010f6f23c8', 'license:5959e69ec3c83b96f7a9c12edca67f04f26913dd', 100000000, 'Adrien Mayers', '{"lipstick_3":0,"lipstick_4":0,"ears_2":0,"shoes_1":25,"beard_1":0,"helmet_2":0,"blush_1":0,"chest_1":0,"chest_2":0,"arms":31,"watches_2":0,"complexion_2":0,"bags_2":0,"age_1":0,"eye_color":0,"moles_2":0,"pants_1":31,"decals_1":0,"chain_1":8,"eyebrows_1":0,"blemishes_1":0,"tshirt_1":130,"mask_2":0,"makeup_1":0,"eyebrows_3":0,"bags_1":0,"bproof_2":9,"ears_1":-1,"beard_4":0,"eyebrows_4":0,"hair_2":0,"bracelets_1":-1,"decals_2":0,"glasses_1":9,"bracelets_2":0,"mask_1":35,"makeup_4":0,"age_2":0,"torso_1":53,"tshirt_2":0,"sun_2":0,"eyebrows_2":0,"chest_3":0,"lipstick_1":0,"bodyb_1":0,"sun_1":0,"pants_2":0,"arms_2":0,"blemishes_2":0,"bproof_1":17,"hair_color_2":0,"makeup_3":0,"shoes_2":0,"moles_1":0,"blush_3":0,"blush_2":0,"skin":0,"makeup_2":0,"glasses_2":0,"helmet_1":124,"watches_1":3,"face":0,"hair_color_1":0,"torso_2":0,"hair_1":0,"sex":0,"bodyb_2":0,"beard_2":0,"complexion_1":0,"chain_2":0,"lipstick_2":0,"beard_3":0}', 'gouvernement', 3, 'rsa', 0, '[{"label":"Couteau","name":"WEAPON_KNIFE","components":[],"ammo":0},{"label":"Pistolet","name":"WEAPON_PISTOL","components":["clip_default"],"ammo":242},{"label":"Pistolet de combat","name":"WEAPON_COMBATPISTOL","components":["clip_default"],"ammo":242},{"label":"Pistolet calibre 50","name":"WEAPON_PISTOL50","components":["clip_default"],"ammo":242},{"label":"Micro smg","name":"WEAPON_MICROSMG","components":["clip_default"],"ammo":0},{"label":"Fusil d''assaut","name":"WEAPON_ASSAULTRIFLE","components":["clip_default"],"ammo":55},{"label":"Fusil de sniper lourd","name":"WEAPON_HEAVYSNIPER","components":["scope_advanced"],"ammo":218},{"label":"Lance-rocket","name":"WEAPON_RPG","components":[],"ammo":6},{"label":"Bombe collante","name":"WEAPON_STICKYBOMB","components":[],"ammo":12},{"label":"Extincteur","name":"WEAPON_FIREEXTINGUISHER","components":[],"ammo":214},{"label":"Lance fusée de détresse","name":"WEAPON_FLAREGUN","components":[],"ammo":16}]', '{"z":249.79999999998,"y":2515.0,"x":-2074.4000000004}', 35000, 4, 'superadmin', b'0', 'Adrien', 'Mayers', '15-12-1997', 'm', '189', '0671635835', '[{"val":0,"name":"nage","percent":0.0},{"val":0,"name":"force","percent":0.0},{"val":52050,"name":"drive","percent":5.205},{"val":0,"name":"tir","percent":0.0},{"val":139850,"name":"endu","percent":13.985},{"val":0,"name":"drug","percent":0.0},{"val":439700,"name":"hunger","percent":43.97},{"val":454775,"name":"thirst","percent":45.4775},{"val":0,"name":"drunk","percent":0.0},{"val":0,"name":"drunk","percent":0.0}]'),
1660('steam:1100001136d9a1e', 'license:6980ce225df80ab569c983e8f35dafd2bcf8689f', 444443984, 'Ninho Luciano', '{"lipstick_3":0,"blemishes_2":0,"ears_2":0,"helmet_1":124,"beard_1":0,"sun_2":0,"blush_1":0,"chest_1":0,"chest_2":0,"arms":31,"watches_2":0,"complexion_2":0,"bags_2":0,"age_1":0,"eye_color":0,"moles_2":0,"pants_1":31,"decals_1":0,"chain_1":8,"eyebrows_1":0,"blemishes_1":0,"tshirt_1":58,"mask_2":0,"makeup_1":0,"eyebrows_3":0,"bags_1":0,"bproof_2":9,"ears_1":-1,"blush_3":0,"eyebrows_4":0,"hair_color_2":0,"bracelets_1":-1,"tshirt_2":0,"glasses_1":0,"bracelets_2":0,"mask_1":35,"makeup_4":0,"age_2":0,"torso_1":53,"lipstick_4":0,"glasses_2":2,"chain_2":0,"chest_3":0,"lipstick_1":0,"bodyb_1":0,"sun_1":0,"pants_2":0,"arms_2":0,"shoes_1":25,"bproof_1":18,"beard_4":0,"complexion_1":0,"shoes_2":0,"moles_1":0,"torso_2":0,"blush_2":0,"skin":3,"makeup_2":0,"decals_2":0,"lipstick_2":0,"hair_2":0,"watches_1":3,"hair_color_1":0,"helmet_2":0,"makeup_3":0,"sex":0,"bodyb_2":0,"beard_2":0,"hair_1":14,"eyebrows_2":0,"face":0,"beard_3":0}', 'police', 4, 'ballas', 4, '[{"label":"Carabine d''assaut","name":"WEAPON_CARBINERIFLE","ammo":30,"components":["clip_default","flashlight","suppressor","grip","luxary_finish"]}]', '{"z":32.399999999994,"y":3258.5999999996,"x":-2337.7999999998}', 22000, 4, 'superadmin', b'0', 'Ninho', 'Luciano', '30/08/1997', 'm', '183', '0748820888', '[{"val":0,"name":"nage","percent":0.0},{"val":0,"name":"force","percent":0.0},{"val":50250,"name":"drive","percent":5.025},{"val":0,"name":"tir","percent":0.0},{"val":258150,"name":"endu","percent":25.815},{"val":0,"name":"drug","percent":0.0},{"val":94900,"name":"hunger","percent":9.49},{"val":196175,"name":"thirst","percent":19.6175},{"val":0,"name":"drunk","percent":0.0},{"val":0,"name":"drunk","percent":0.0}]'),
1661('steam:110000118e987a2', 'license:c05e70c134bfa03abc5c1594a6c9778ef96a4f10', 4712, '【Tony. 】', '{"lipstick_3":0,"lipstick_4":0,"ears_2":0,"shoes_1":0,"beard_1":0,"sun_2":0,"blush_1":0,"chest_1":0,"chest_2":0,"arms":0,"watches_2":0,"complexion_2":0,"bags_2":0,"age_1":0,"eye_color":0,"moles_2":0,"pants_1":0,"decals_1":0,"chain_1":0,"eyebrows_1":0,"blemishes_1":0,"tshirt_1":0,"mask_2":0,"makeup_1":0,"eyebrows_3":0,"bags_1":0,"bproof_2":0,"ears_1":-1,"blush_3":0,"eyebrows_4":0,"hair_color_2":0,"bracelets_1":-1,"tshirt_2":0,"glasses_1":0,"bracelets_2":0,"eyebrows_2":0,"makeup_4":0,"age_2":0,"hair_1":0,"makeup_2":0,"sun_1":0,"decals_2":0,"chest_3":0,"lipstick_1":0,"bodyb_1":0,"complexion_1":0,"pants_2":0,"arms_2":0,"makeup_3":0,"bproof_1":0,"beard_4":0,"lipstick_2":0,"shoes_2":0,"moles_1":0,"sex":0,"blush_2":0,"skin":2,"chain_2":0,"blemishes_2":0,"helmet_1":-1,"watches_1":-1,"hair_2":0,"hair_color_1":0,"helmet_2":0,"torso_2":0,"face":0,"bodyb_2":0,"beard_2":0,"torso_1":0,"mask_1":0,"beard_3":0,"glasses_2":0}', 'cardealer', 3, 'ballas', 3, '[]', '{"z":17.599999999998,"y":-787.3999999999,"x":-935.6000000001}', 5800, 0, 'superadmin', b'0', 'Tony', 'Anderson', '24 09 1996', 'm', '200', '0642323622', '[{"val":0,"name":"nage","percent":0.0},{"val":0,"name":"force","percent":0.0},{"val":0,"name":"drive","percent":0.0},{"val":0,"name":"tir","percent":0.0},{"val":0,"name":"endu","percent":0.0},{"val":0,"name":"drug","percent":0.0},{"val":342500,"name":"hunger","percent":34.25},{"val":381875,"name":"thirst","percent":38.1875},{"val":0,"name":"drunk","percent":0.0},{"val":0,"name":"drunk","percent":0.0}]');
1662
1663-- --------------------------------------------------------
1664
1665--
1666-- Structure de la table `user_accounts`
1667--
1668
1669CREATE TABLE IF NOT EXISTS `user_accounts` (
1670`id` int(11) NOT NULL,
1671  `identifier` varchar(22) NOT NULL,
1672  `name` varchar(50) NOT NULL,
1673  `money` double NOT NULL DEFAULT '0'
1674) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
1675
1676--
1677-- Contenu de la table `user_accounts`
1678--
1679
1680INSERT INTO `user_accounts` (`id`, `identifier`, `name`, `money`) VALUES
1681(1, 'steam:110000118e987a2', 'black_money', 0),
1682(2, 'steam:1100001136d9a1e', 'black_money', 0),
1683(3, 'steam:11000010f6f23c8', 'black_money', 0);
1684
1685-- --------------------------------------------------------
1686
1687--
1688-- Structure de la table `user_contacts`
1689--
1690
1691CREATE TABLE IF NOT EXISTS `user_contacts` (
1692`id` int(11) NOT NULL,
1693  `identifier` varchar(255) NOT NULL,
1694  `name` varchar(255) NOT NULL,
1695  `number` int(11) NOT NULL
1696) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1697
1698-- --------------------------------------------------------
1699
1700--
1701-- Structure de la table `user_inventory`
1702--
1703
1704CREATE TABLE IF NOT EXISTS `user_inventory` (
1705`id` int(11) NOT NULL,
1706  `identifier` varchar(22) NOT NULL,
1707  `item` varchar(50) NOT NULL,
1708  `count` int(11) NOT NULL
1709) ENGINE=MyISAM AUTO_INCREMENT=400 DEFAULT CHARSET=latin1;
1710
1711--
1712-- Contenu de la table `user_inventory`
1713--
1714
1715INSERT INTO `user_inventory` (`id`, `identifier`, `item`, `count`) VALUES
1716(1, 'steam:110000118e987a2', 'wool', 0),
1717(2, 'steam:110000118e987a2', 'silencieux', 0),
1718(3, 'steam:110000118e987a2', 'gitanes', 0),
1719(4, 'steam:110000118e987a2', 'vodka', 0),
1720(5, 'steam:110000118e987a2', 'clothe', 0),
1721(6, 'steam:110000118e987a2', 'fabric', 0),
1722(7, 'steam:110000118e987a2', 'bandage', 0),
1723(8, 'steam:110000118e987a2', 'malbora', 0),
1724(9, 'steam:110000118e987a2', 'radio', 0),
1725(10, 'steam:110000118e987a2', 'tabacblond', 0),
1726(11, 'steam:110000118e987a2', 'sausage-eat', 0),
1727(12, 'steam:110000118e987a2', 'hazmat3', 0),
1728(13, 'steam:110000118e987a2', 'tabacbrun', 0),
1729(14, 'steam:110000118e987a2', 'silence_pistol', 0),
1730(15, 'steam:110000118e987a2', 'chocolate', 0),
1731(16, 'steam:110000118e987a2', 'icetea', 0),
1732(17, 'steam:110000118e987a2', 'meat', 0),
1733(18, 'steam:110000118e987a2', 'coke_pooch', 0),
1734(19, 'steam:110000118e987a2', 'cola', 0),
1735(20, 'steam:110000118e987a2', 'carokit', 0),
1736(21, 'steam:110000118e987a2', 'opium', 0),
1737(22, 'steam:110000118e987a2', 'kroko_pooch', 0),
1738(23, 'steam:110000118e987a2', 'yusuf', 0),
1739(24, 'steam:110000118e987a2', 'grip', 0),
1740(25, 'steam:110000118e987a2', 'intestin', 0),
1741(26, 'steam:110000118e987a2', 'silence_sniperrifle', 0),
1742(27, 'steam:110000118e987a2', 'lsd', 0),
1743(28, 'steam:110000118e987a2', 'croquettes', 0),
1744(29, 'steam:110000118e987a2', 'carotool', 0),
1745(30, 'steam:110000118e987a2', 'coke', 0),
1746(31, 'steam:110000118e987a2', 'supp_smg', 0),
1747(32, 'steam:110000118e987a2', 'nitro', 0),
1748(33, 'steam:110000118e987a2', 'sandwich', 0),
1749(34, 'steam:110000118e987a2', 'coeur', 0),
1750(35, 'steam:110000118e987a2', 'petrol', 0),
1751(36, 'steam:110000118e987a2', 'fixkit', 0),
1752(37, 'steam:110000118e987a2', 'xanax', 0),
1753(38, 'steam:110000118e987a2', 'clip_heavypistol', 0),
1754(39, 'steam:110000118e987a2', 'grand_cru', 0),
1755(40, 'steam:110000118e987a2', 'phosphorerouge', 0),
1756(41, 'steam:110000118e987a2', 'cagoule', 0),
1757(42, 'steam:110000118e987a2', 'grip_sc', 0),
1758(43, 'steam:110000118e987a2', 'heroine', 0),
1759(44, 'steam:110000118e987a2', 'bread', 0),
1760(45, 'steam:110000118e987a2', 'disolvant', 0),
1761(46, 'steam:110000118e987a2', 'lighter', 0),
1762(47, 'steam:110000118e987a2', 'alcool_cargo', 0),
1763(48, 'steam:110000118e987a2', 'supp_sc', 0),
1764(49, 'steam:110000118e987a2', 'meth_pooch', 0),
1765(50, 'steam:110000118e987a2', 'iron', 0),
1766(51, 'steam:110000118e987a2', 'cutted_wood', 0),
1767(52, 'steam:110000118e987a2', 'weed', 0),
1768(53, 'steam:110000118e987a2', 'diamond', 0),
1769(54, 'steam:110000118e987a2', 'flashlight_assaultsmg', 0),
1770(55, 'steam:110000118e987a2', 'water', 0),
1771(56, 'steam:110000118e987a2', 'protein_shake', 0),
1772(57, 'steam:110000118e987a2', 'hazmat1', 0),
1773(58, 'steam:110000118e987a2', 'whiskycoc', 0),
1774(59, 'steam:110000118e987a2', 'advancedscoped_sniperrifle', 0),
1775(60, 'steam:110000118e987a2', 'silence_pistol50', 0),
1776(61, 'steam:110000118e987a2', 'stone', 0),
1777(62, 'steam:110000118e987a2', 'grip_smg', 0),
1778(63, 'steam:110000118e987a2', 'washed_stone', 0),
1779(64, 'steam:110000118e987a2', 'flashlight', 0),
1780(65, 'steam:110000118e987a2', 'weed_pooch', 0),
1781(66, 'steam:110000118e987a2', 'lowrider_cp', 0),
1782(67, 'steam:110000118e987a2', 'vegetables', 0),
1783(68, 'steam:110000118e987a2', 'os', 0),
1784(69, 'steam:110000118e987a2', 'tabacblondsec', 0),
1785(70, 'steam:110000118e987a2', 'lsd_pooch', 0),
1786(71, 'steam:110000118e987a2', 'pizza', 0),
1787(72, 'steam:110000118e987a2', 'blowpipe', 0),
1788(73, 'steam:110000118e987a2', 'wood', 0),
1789(74, 'steam:110000118e987a2', 'petrol_raffin', 0),
1790(75, 'steam:110000118e987a2', 'cigarett', 0),
1791(76, 'steam:110000118e987a2', 'copper', 0),
1792(77, 'steam:110000118e987a2', 'tenuebraquage', 0),
1793(78, 'steam:110000118e987a2', 'fixtool', 0),
1794(79, 'steam:110000118e987a2', 'wine', 0),
1795(80, 'steam:110000118e987a2', 'slaughtered_chicken', 0),
1796(81, 'steam:110000118e987a2', 'clip_gus', 0),
1797(82, 'steam:110000118e987a2', 'redbull', 0),
1798(83, 'steam:110000118e987a2', 'jus_raisin', 0),
1799(84, 'steam:110000118e987a2', 'vine', 0),
1800(85, 'steam:110000118e987a2', 'alcool', 0),
1801(86, 'steam:110000118e987a2', 'whisky', 0),
1802(87, 'steam:110000118e987a2', 'myrtealcool', 0),
1803(88, 'steam:110000118e987a2', 'clip_sc', 0),
1804(89, 'steam:110000118e987a2', 'fish', 0),
1805(90, 'steam:110000118e987a2', 'supp_cp', 0),
1806(91, 'steam:110000118e987a2', 'coffe', 0),
1807(92, 'steam:110000118e987a2', 'lowrider_smg', 0),
1808(93, 'steam:110000118e987a2', 'organ_pooch', 0),
1809(94, 'steam:110000118e987a2', 'flash_cp', 0),
1810(95, 'steam:110000118e987a2', 'supp_heavypistol', 0),
1811(96, 'steam:110000118e987a2', 'powerade', 0),
1812(97, 'steam:110000118e987a2', 'beer', 0),
1813(98, 'steam:110000118e987a2', 'gazbottle', 0),
1814(99, 'steam:110000118e987a2', 'scope_smg', 0),
1815(100, 'steam:110000118e987a2', 'tequila', 0),
1816(101, 'steam:110000118e987a2', 'cocacola', 0),
1817(102, 'steam:110000118e987a2', 'cupcake', 0),
1818(103, 'steam:110000118e987a2', 'alive_chicken', 0),
1819(104, 'steam:110000118e987a2', 'myrte_cargo', 0),
1820(105, 'steam:110000118e987a2', 'gym_membership', 0),
1821(106, 'steam:110000118e987a2', 'essence', 0),
1822(107, 'steam:110000118e987a2', 'cutting_pliers', 0),
1823(108, 'steam:110000118e987a2', 'tacos', 0),
1824(109, 'steam:110000118e987a2', 'hamburger', 0),
1825(110, 'steam:110000118e987a2', 'cerveau', 0),
1826(111, 'steam:110000118e987a2', 'myrte', 0),
1827(112, 'steam:110000118e987a2', 'packaged_plank', 0),
1828(113, 'steam:110000118e987a2', 'handcuff', 0),
1829(114, 'steam:110000118e987a2', 'hazmat2', 0),
1830(115, 'steam:110000118e987a2', 'opium_pooch', 0),
1831(116, 'steam:110000118e987a2', 'gold', 0),
1832(117, 'steam:110000118e987a2', 'meth', 0),
1833(118, 'steam:110000118e987a2', 'sportlunch', 0),
1834(119, 'steam:110000118e987a2', 'tabacbrunsec', 0),
1835(120, 'steam:110000118e987a2', 'iode', 0),
1836(121, 'steam:110000118e987a2', 'raisin', 0),
1837(122, 'steam:110000118e987a2', 'codeine', 0),
1838(123, 'steam:110000118e987a2', 'clip', 0),
1839(124, 'steam:110000118e987a2', 'vodkrb', 0),
1840(125, 'steam:110000118e987a2', 'licenseplate', 0),
1841(126, 'steam:110000118e987a2', 'jager', 0),
1842(127, 'steam:110000118e987a2', 'burger', 0),
1843(128, 'steam:110000118e987a2', 'milk', 0),
1844(129, 'steam:110000118e987a2', 'packaged_chicken', 0),
1845(130, 'steam:110000118e987a2', 'moelle', 0),
1846(131, 'steam:110000118e987a2', 'redbull_cargo', 0),
1847(132, 'steam:110000118e987a2', 'medikit', 0),
1848(133, 'steam:110000118e987a2', 'hazmat4', 0),
1849(134, 'steam:1100001136d9a1e', 'wool', 0),
1850(135, 'steam:1100001136d9a1e', 'silencieux', 1),
1851(136, 'steam:1100001136d9a1e', 'vodka', 0),
1852(137, 'steam:1100001136d9a1e', 'gitanes', 0),
1853(138, 'steam:1100001136d9a1e', 'clothe', 0),
1854(139, 'steam:1100001136d9a1e', 'fabric', 0),
1855(140, 'steam:1100001136d9a1e', 'bandage', 0),
1856(141, 'steam:1100001136d9a1e', 'malbora', 0),
1857(142, 'steam:1100001136d9a1e', 'radio', 0),
1858(143, 'steam:1100001136d9a1e', 'tabacblond', 0),
1859(144, 'steam:1100001136d9a1e', 'sausage-eat', 0),
1860(145, 'steam:1100001136d9a1e', 'hazmat3', 0),
1861(146, 'steam:1100001136d9a1e', 'tabacbrun', 0),
1862(147, 'steam:1100001136d9a1e', 'silence_pistol', 0),
1863(148, 'steam:1100001136d9a1e', 'chocolate', 0),
1864(149, 'steam:1100001136d9a1e', 'icetea', 0),
1865(150, 'steam:1100001136d9a1e', 'meat', 0),
1866(151, 'steam:1100001136d9a1e', 'carokit', 0),
1867(152, 'steam:1100001136d9a1e', 'coke_pooch', 0),
1868(153, 'steam:1100001136d9a1e', 'cola', 0),
1869(154, 'steam:1100001136d9a1e', 'kroko_pooch', 0),
1870(155, 'steam:1100001136d9a1e', 'yusuf', 1),
1871(156, 'steam:1100001136d9a1e', 'opium', 0),
1872(157, 'steam:1100001136d9a1e', 'grip', 1),
1873(158, 'steam:1100001136d9a1e', 'intestin', 0),
1874(159, 'steam:1100001136d9a1e', 'lsd', 0),
1875(160, 'steam:1100001136d9a1e', 'silence_sniperrifle', 0),
1876(161, 'steam:1100001136d9a1e', 'croquettes', 0),
1877(162, 'steam:1100001136d9a1e', 'carotool', 0),
1878(163, 'steam:1100001136d9a1e', 'coke', 0),
1879(164, 'steam:1100001136d9a1e', 'supp_smg', 0),
1880(165, 'steam:1100001136d9a1e', 'petrol', 0),
1881(166, 'steam:1100001136d9a1e', 'nitro', 0),
1882(167, 'steam:1100001136d9a1e', 'sandwich', 0),
1883(168, 'steam:1100001136d9a1e', 'coeur', 0),
1884(169, 'steam:1100001136d9a1e', 'fixkit', 0),
1885(170, 'steam:1100001136d9a1e', 'xanax', 0),
1886(171, 'steam:1100001136d9a1e', 'clip_heavypistol', 0),
1887(172, 'steam:1100001136d9a1e', 'grand_cru', 0),
1888(173, 'steam:1100001136d9a1e', 'phosphorerouge', 0),
1889(174, 'steam:1100001136d9a1e', 'cagoule', 0),
1890(175, 'steam:1100001136d9a1e', 'grip_sc', 0),
1891(176, 'steam:1100001136d9a1e', 'heroine', 0),
1892(177, 'steam:1100001136d9a1e', 'bread', 0),
1893(178, 'steam:1100001136d9a1e', 'disolvant', 0),
1894(179, 'steam:1100001136d9a1e', 'lighter', 0),
1895(180, 'steam:1100001136d9a1e', 'alcool_cargo', 0),
1896(181, 'steam:1100001136d9a1e', 'supp_sc', 0),
1897(182, 'steam:1100001136d9a1e', 'meth_pooch', 0),
1898(183, 'steam:1100001136d9a1e', 'iron', 0),
1899(184, 'steam:1100001136d9a1e', 'cutted_wood', 0),
1900(185, 'steam:1100001136d9a1e', 'weed', 0),
1901(186, 'steam:1100001136d9a1e', 'diamond', 0),
1902(187, 'steam:1100001136d9a1e', 'flashlight_assaultsmg', 0),
1903(188, 'steam:1100001136d9a1e', 'water', 0),
1904(189, 'steam:1100001136d9a1e', 'protein_shake', 0),
1905(190, 'steam:1100001136d9a1e', 'whiskycoc', 0),
1906(191, 'steam:1100001136d9a1e', 'advancedscoped_sniperrifle', 0),
1907(192, 'steam:1100001136d9a1e', 'silence_pistol50', 0),
1908(193, 'steam:1100001136d9a1e', 'hazmat1', 0),
1909(194, 'steam:1100001136d9a1e', 'stone', 0),
1910(195, 'steam:1100001136d9a1e', 'grip_smg', 0),
1911(196, 'steam:1100001136d9a1e', 'washed_stone', 0),
1912(197, 'steam:1100001136d9a1e', 'flashlight', 1),
1913(198, 'steam:1100001136d9a1e', 'weed_pooch', 0),
1914(199, 'steam:1100001136d9a1e', 'lowrider_cp', 0),
1915(200, 'steam:1100001136d9a1e', 'vegetables', 0),
1916(201, 'steam:1100001136d9a1e', 'os', 0),
1917(202, 'steam:1100001136d9a1e', 'tabacblondsec', 0),
1918(203, 'steam:1100001136d9a1e', 'lsd_pooch', 0),
1919(204, 'steam:1100001136d9a1e', 'pizza', 0),
1920(205, 'steam:1100001136d9a1e', 'blowpipe', 0),
1921(206, 'steam:1100001136d9a1e', 'petrol_raffin', 0),
1922(207, 'steam:1100001136d9a1e', 'cigarett', 0),
1923(208, 'steam:1100001136d9a1e', 'wood', 0),
1924(209, 'steam:1100001136d9a1e', 'copper', 0),
1925(210, 'steam:1100001136d9a1e', 'fixtool', 0),
1926(211, 'steam:1100001136d9a1e', 'tenuebraquage', 0),
1927(212, 'steam:1100001136d9a1e', 'slaughtered_chicken', 0),
1928(213, 'steam:1100001136d9a1e', 'wine', 0),
1929(214, 'steam:1100001136d9a1e', 'clip_gus', 0),
1930(215, 'steam:1100001136d9a1e', 'redbull', 0),
1931(216, 'steam:1100001136d9a1e', 'jus_raisin', 0),
1932(217, 'steam:1100001136d9a1e', 'alcool', 0),
1933(218, 'steam:1100001136d9a1e', 'vine', 0),
1934(219, 'steam:1100001136d9a1e', 'myrtealcool', 0),
1935(220, 'steam:1100001136d9a1e', 'fish', 0),
1936(221, 'steam:1100001136d9a1e', 'whisky', 0),
1937(222, 'steam:1100001136d9a1e', 'clip_sc', 0),
1938(223, 'steam:1100001136d9a1e', 'supp_cp', 0),
1939(224, 'steam:1100001136d9a1e', 'lowrider_smg', 0),
1940(225, 'steam:1100001136d9a1e', 'coffe', 0),
1941(226, 'steam:1100001136d9a1e', 'flash_cp', 0),
1942(227, 'steam:1100001136d9a1e', 'organ_pooch', 0),
1943(228, 'steam:1100001136d9a1e', 'supp_heavypistol', 0),
1944(229, 'steam:1100001136d9a1e', 'powerade', 0),
1945(230, 'steam:1100001136d9a1e', 'beer', 0),
1946(231, 'steam:1100001136d9a1e', 'scope_smg', 0),
1947(232, 'steam:1100001136d9a1e', 'gazbottle', 0),
1948(233, 'steam:1100001136d9a1e', 'tequila', 0),
1949(234, 'steam:1100001136d9a1e', 'alive_chicken', 0),
1950(235, 'steam:1100001136d9a1e', 'cocacola', 0),
1951(236, 'steam:1100001136d9a1e', 'gym_membership', 0),
1952(237, 'steam:1100001136d9a1e', 'myrte_cargo', 0),
1953(238, 'steam:1100001136d9a1e', 'cupcake', 0),
1954(239, 'steam:1100001136d9a1e', 'essence', 0),
1955(240, 'steam:1100001136d9a1e', 'cutting_pliers', 0),
1956(241, 'steam:1100001136d9a1e', 'tacos', 0),
1957(242, 'steam:1100001136d9a1e', 'hamburger', 0),
1958(243, 'steam:1100001136d9a1e', 'cerveau', 0),
1959(244, 'steam:1100001136d9a1e', 'myrte', 0),
1960(245, 'steam:1100001136d9a1e', 'packaged_plank', 0),
1961(246, 'steam:1100001136d9a1e', 'handcuff', 0),
1962(247, 'steam:1100001136d9a1e', 'opium_pooch', 0),
1963(248, 'steam:1100001136d9a1e', 'hazmat2', 0),
1964(249, 'steam:1100001136d9a1e', 'sportlunch', 0),
1965(250, 'steam:1100001136d9a1e', 'tabacbrunsec', 0),
1966(251, 'steam:1100001136d9a1e', 'meth', 0),
1967(252, 'steam:1100001136d9a1e', 'gold', 0),
1968(253, 'steam:1100001136d9a1e', 'iode', 0),
1969(254, 'steam:1100001136d9a1e', 'raisin', 0),
1970(255, 'steam:1100001136d9a1e', 'codeine', 0),
1971(256, 'steam:1100001136d9a1e', 'clip', 3),
1972(257, 'steam:1100001136d9a1e', 'vodkrb', 0),
1973(258, 'steam:1100001136d9a1e', 'licenseplate', 0),
1974(259, 'steam:1100001136d9a1e', 'milk', 0),
1975(260, 'steam:1100001136d9a1e', 'packaged_chicken', 0),
1976(261, 'steam:1100001136d9a1e', 'burger', 0),
1977(262, 'steam:1100001136d9a1e', 'jager', 0),
1978(263, 'steam:1100001136d9a1e', 'moelle', 0),
1979(264, 'steam:1100001136d9a1e', 'redbull_cargo', 0),
1980(265, 'steam:1100001136d9a1e', 'hazmat4', 0),
1981(266, 'steam:1100001136d9a1e', 'medikit', 0),
1982(267, 'steam:11000010f6f23c8', 'wool', 0),
1983(268, 'steam:11000010f6f23c8', 'silencieux', 0),
1984(269, 'steam:11000010f6f23c8', 'clothe', 0),
1985(270, 'steam:11000010f6f23c8', 'gitanes', 0),
1986(271, 'steam:11000010f6f23c8', 'vodka', 0),
1987(272, 'steam:11000010f6f23c8', 'fabric', 0),
1988(273, 'steam:11000010f6f23c8', 'bandage', 0),
1989(274, 'steam:11000010f6f23c8', 'malbora', 0),
1990(275, 'steam:11000010f6f23c8', 'radio', 0),
1991(276, 'steam:11000010f6f23c8', 'tabacblond', 0),
1992(277, 'steam:11000010f6f23c8', 'sausage-eat', 0),
1993(278, 'steam:11000010f6f23c8', 'silence_pistol', 0),
1994(279, 'steam:11000010f6f23c8', 'chocolate', 0),
1995(280, 'steam:11000010f6f23c8', 'hazmat3', 0),
1996(281, 'steam:11000010f6f23c8', 'tabacbrun', 0),
1997(282, 'steam:11000010f6f23c8', 'icetea', 0),
1998(283, 'steam:11000010f6f23c8', 'meat', 0),
1999(284, 'steam:11000010f6f23c8', 'carokit', 0),
2000(285, 'steam:11000010f6f23c8', 'coke_pooch', 0),
2001(286, 'steam:11000010f6f23c8', 'cola', 0),
2002(287, 'steam:11000010f6f23c8', 'kroko_pooch', 0),
2003(288, 'steam:11000010f6f23c8', 'yusuf', 0),
2004(289, 'steam:11000010f6f23c8', 'grip', 0),
2005(290, 'steam:11000010f6f23c8', 'intestin', 0),
2006(291, 'steam:11000010f6f23c8', 'opium', 0),
2007(292, 'steam:11000010f6f23c8', 'silence_sniperrifle', 0),
2008(293, 'steam:11000010f6f23c8', 'lsd', 0),
2009(294, 'steam:11000010f6f23c8', 'croquettes', 0),
2010(295, 'steam:11000010f6f23c8', 'carotool', 0),
2011(296, 'steam:11000010f6f23c8', 'coke', 0),
2012(297, 'steam:11000010f6f23c8', 'supp_smg', 0),
2013(298, 'steam:11000010f6f23c8', 'petrol', 0),
2014(299, 'steam:11000010f6f23c8', 'nitro', 0),
2015(300, 'steam:11000010f6f23c8', 'sandwich', 0),
2016(301, 'steam:11000010f6f23c8', 'coeur', 0),
2017(302, 'steam:11000010f6f23c8', 'fixkit', 0),
2018(303, 'steam:11000010f6f23c8', 'xanax', 0),
2019(304, 'steam:11000010f6f23c8', 'clip_heavypistol', 0),
2020(305, 'steam:11000010f6f23c8', 'grand_cru', 0),
2021(306, 'steam:11000010f6f23c8', 'phosphorerouge', 0),
2022(307, 'steam:11000010f6f23c8', 'cagoule', 0),
2023(308, 'steam:11000010f6f23c8', 'grip_sc', 0),
2024(309, 'steam:11000010f6f23c8', 'heroine', 0),
2025(310, 'steam:11000010f6f23c8', 'bread', 0),
2026(311, 'steam:11000010f6f23c8', 'disolvant', 0),
2027(312, 'steam:11000010f6f23c8', 'lighter', 0),
2028(313, 'steam:11000010f6f23c8', 'alcool_cargo', 0),
2029(314, 'steam:11000010f6f23c8', 'supp_sc', 0),
2030(315, 'steam:11000010f6f23c8', 'iron', 0),
2031(316, 'steam:11000010f6f23c8', 'meth_pooch', 0),
2032(317, 'steam:11000010f6f23c8', 'weed', 0),
2033(318, 'steam:11000010f6f23c8', 'diamond', 0),
2034(319, 'steam:11000010f6f23c8', 'flashlight_assaultsmg', 0),
2035(320, 'steam:11000010f6f23c8', 'water', 0),
2036(321, 'steam:11000010f6f23c8', 'cutted_wood', 0),
2037(322, 'steam:11000010f6f23c8', 'protein_shake', 0),
2038(323, 'steam:11000010f6f23c8', 'hazmat1', 0),
2039(324, 'steam:11000010f6f23c8', 'whiskycoc', 0),
2040(325, 'steam:11000010f6f23c8', 'advancedscoped_sniperrifle', 0),
2041(326, 'steam:11000010f6f23c8', 'silence_pistol50', 0),
2042(327, 'steam:11000010f6f23c8', 'stone', 0),
2043(328, 'steam:11000010f6f23c8', 'grip_smg', 0),
2044(329, 'steam:11000010f6f23c8', 'washed_stone', 0),
2045(330, 'steam:11000010f6f23c8', 'flashlight', 0),
2046(331, 'steam:11000010f6f23c8', 'weed_pooch', 0),
2047(332, 'steam:11000010f6f23c8', 'lowrider_cp', 0),
2048(333, 'steam:11000010f6f23c8', 'vegetables', 0),
2049(334, 'steam:11000010f6f23c8', 'os', 0),
2050(335, 'steam:11000010f6f23c8', 'tabacblondsec', 0),
2051(336, 'steam:11000010f6f23c8', 'lsd_pooch', 0),
2052(337, 'steam:11000010f6f23c8', 'pizza', 0),
2053(338, 'steam:11000010f6f23c8', 'blowpipe', 0),
2054(339, 'steam:11000010f6f23c8', 'wood', 0),
2055(340, 'steam:11000010f6f23c8', 'petrol_raffin', 0),
2056(341, 'steam:11000010f6f23c8', 'cigarett', 0),
2057(342, 'steam:11000010f6f23c8', 'copper', 0),
2058(343, 'steam:11000010f6f23c8', 'tenuebraquage', 0),
2059(344, 'steam:11000010f6f23c8', 'fixtool', 0),
2060(345, 'steam:11000010f6f23c8', 'wine', 0),
2061(346, 'steam:11000010f6f23c8', 'slaughtered_chicken', 0),
2062(347, 'steam:11000010f6f23c8', 'clip_gus', 0),
2063(348, 'steam:11000010f6f23c8', 'redbull', 0),
2064(349, 'steam:11000010f6f23c8', 'jus_raisin', 0),
2065(350, 'steam:11000010f6f23c8', 'vine', 0),
2066(351, 'steam:11000010f6f23c8', 'alcool', 0),
2067(352, 'steam:11000010f6f23c8', 'whisky', 0),
2068(353, 'steam:11000010f6f23c8', 'myrtealcool', 0),
2069(354, 'steam:11000010f6f23c8', 'clip_sc', 0),
2070(355, 'steam:11000010f6f23c8', 'fish', 0),
2071(356, 'steam:11000010f6f23c8', 'supp_cp', 0),
2072(357, 'steam:11000010f6f23c8', 'coffe', 0),
2073(358, 'steam:11000010f6f23c8', 'lowrider_smg', 0),
2074(359, 'steam:11000010f6f23c8', 'organ_pooch', 0),
2075(360, 'steam:11000010f6f23c8', 'flash_cp', 0),
2076(361, 'steam:11000010f6f23c8', 'supp_heavypistol', 0),
2077(362, 'steam:11000010f6f23c8', 'powerade', 0),
2078(363, 'steam:11000010f6f23c8', 'beer', 0),
2079(364, 'steam:11000010f6f23c8', 'gazbottle', 0),
2080(365, 'steam:11000010f6f23c8', 'scope_smg', 0),
2081(366, 'steam:11000010f6f23c8', 'tequila', 0),
2082(367, 'steam:11000010f6f23c8', 'cocacola', 0),
2083(368, 'steam:11000010f6f23c8', 'cupcake', 0),
2084(369, 'steam:11000010f6f23c8', 'alive_chicken', 0),
2085(370, 'steam:11000010f6f23c8', 'gym_membership', 0),
2086(371, 'steam:11000010f6f23c8', 'myrte_cargo', 0),
2087(372, 'steam:11000010f6f23c8', 'essence', 0),
2088(373, 'steam:11000010f6f23c8', 'cutting_pliers', 0),
2089(374, 'steam:11000010f6f23c8', 'tacos', 0),
2090(375, 'steam:11000010f6f23c8', 'hamburger', 0),
2091(376, 'steam:11000010f6f23c8', 'cerveau', 0),
2092(377, 'steam:11000010f6f23c8', 'myrte', 0),
2093(378, 'steam:11000010f6f23c8', 'packaged_plank', 0),
2094(379, 'steam:11000010f6f23c8', 'handcuff', 0),
2095(380, 'steam:11000010f6f23c8', 'hazmat2', 0),
2096(381, 'steam:11000010f6f23c8', 'opium_pooch', 0),
2097(382, 'steam:11000010f6f23c8', 'iode', 0),
2098(383, 'steam:11000010f6f23c8', 'tabacbrunsec', 0),
2099(384, 'steam:11000010f6f23c8', 'sportlunch', 0),
2100(385, 'steam:11000010f6f23c8', 'meth', 0),
2101(386, 'steam:11000010f6f23c8', 'gold', 0),
2102(387, 'steam:11000010f6f23c8', 'codeine', 0),
2103(388, 'steam:11000010f6f23c8', 'vodkrb', 0),
2104(389, 'steam:11000010f6f23c8', 'clip', 0),
2105(390, 'steam:11000010f6f23c8', 'licenseplate', 0),
2106(391, 'steam:11000010f6f23c8', 'raisin', 0),
2107(392, 'steam:11000010f6f23c8', 'jager', 0),
2108(393, 'steam:11000010f6f23c8', 'burger', 0),
2109(394, 'steam:11000010f6f23c8', 'milk', 0),
2110(395, 'steam:11000010f6f23c8', 'packaged_chicken', 0),
2111(396, 'steam:11000010f6f23c8', 'moelle', 0),
2112(397, 'steam:11000010f6f23c8', 'redbull_cargo', 0),
2113(398, 'steam:11000010f6f23c8', 'medikit', 0),
2114(399, 'steam:11000010f6f23c8', 'hazmat4', 0);
2115
2116-- --------------------------------------------------------
2117
2118--
2119-- Structure de la table `user_licenses`
2120--
2121
2122CREATE TABLE IF NOT EXISTS `user_licenses` (
2123`id` int(11) NOT NULL,
2124  `type` varchar(60) NOT NULL,
2125  `owner` varchar(60) NOT NULL
2126) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2127
2128-- --------------------------------------------------------
2129
2130--
2131-- Structure de la table `vehicles`
2132--
2133
2134CREATE TABLE IF NOT EXISTS `vehicles` (
2135`id` int(11) NOT NULL,
2136  `name` varchar(60) NOT NULL,
2137  `model` varchar(60) NOT NULL,
2138  `price` int(11) NOT NULL,
2139  `category` varchar(60) DEFAULT NULL
2140) ENGINE=MyISAM AUTO_INCREMENT=169 DEFAULT CHARSET=latin1;
2141
2142--
2143-- Contenu de la table `vehicles`
2144--
2145
2146INSERT INTO `vehicles` (`id`, `name`, `model`, `price`, `category`) VALUES
2147(1, 'Blade', 'blade', 15000, 'muscle'),
2148(2, 'Buccaneer', 'buccaneer', 18000, 'muscle'),
2149(3, 'Buccaneer Rider', 'buccaneer2', 24000, 'muscle'),
2150(4, 'Chino', 'chino', 15000, 'muscle'),
2151(5, 'Chino Luxe', 'chino2', 19000, 'muscle'),
2152(6, 'Coquette BlackFin', 'coquette3', 55000, 'muscle'),
2153(7, 'Dominator', 'dominator', 35000, 'muscle'),
2154(8, 'Dukes', 'dukes', 28000, 'muscle'),
2155(9, 'Gauntlet', 'gauntlet', 30000, 'muscle'),
2156(10, 'Hotknife', 'hotknife', 125000, 'muscle'),
2157(11, 'Faction', 'faction', 20000, 'muscle'),
2158(12, 'Faction Rider', 'faction2', 30000, 'muscle'),
2159(13, 'Faction XL', 'faction3', 40000, 'muscle'),
2160(14, 'Nightshade', 'nightshade', 65000, 'muscle'),
2161(15, 'Phoenix', 'phoenix', 12500, 'muscle'),
2162(16, 'Picador', 'picador', 18000, 'muscle'),
2163(17, 'Sabre Turbo', 'sabregt', 20000, 'muscle'),
2164(18, 'Sabre GT', 'sabregt2', 25000, 'muscle'),
2165(19, 'Slam Van', 'slamvan3', 11500, 'muscle'),
2166(20, 'Tampa', 'tampa', 16000, 'muscle'),
2167(21, 'Virgo', 'virgo', 14000, 'muscle'),
2168(22, 'Vigero', 'vigero', 12500, 'muscle'),
2169(23, 'Voodoo', 'voodoo', 7200, 'muscle'),
2170(29, 'Bison', 'bison', 45000, 'vans'),
2171(30, 'Bobcat XL', 'bobcatxl', 32000, 'vans'),
2172(31, 'Burrito', 'burrito3', 19000, 'vans'),
2173(32, 'Burrito', 'gburrito2', 29000, 'vans'),
2174(33, 'Camper', 'camper', 42000, 'vans'),
2175(34, 'Gang Burrito', 'gburrito', 45000, 'vans'),
2176(35, 'Journey', 'journey', 6500, 'vans'),
2177(36, 'Minivan', 'minivan', 13000, 'vans'),
2178(37, 'Moonbeam', 'moonbeam', 18000, 'vans'),
2179(38, 'Moonbeam Rider', 'moonbeam2', 35000, 'vans'),
2180(39, 'Paradise', 'paradise', 19000, 'vans'),
2181(40, 'Rumpo', 'rumpo', 15000, 'vans'),
2182(41, 'Rumpo Trail', 'rumpo3', 19500, 'vans'),
2183(42, 'Surfer', 'surfer', 12000, 'vans'),
2184(43, 'Youga', 'youga', 10800, 'vans'),
2185(44, 'Youga Luxuary', 'youga2', 14500, 'vans'),
2186(60, 'Baller', 'baller2', 40000, 'suvs'),
2187(61, 'Baller Sport', 'baller3', 60000, 'suvs'),
2188(62, 'Cavalcade', 'cavalcade2', 55000, 'suvs'),
2189(63, 'Contender', 'contender', 70000, 'suvs'),
2190(64, 'Dubsta', 'dubsta', 45000, 'suvs'),
2191(65, 'Dubsta Luxuary', 'dubsta2', 60000, 'suvs'),
2192(66, 'Fhantom', 'fq2', 17000, 'suvs'),
2193(67, 'Grabger', 'granger', 50000, 'suvs'),
2194(68, 'Gresley', 'gresley', 47500, 'suvs'),
2195(69, 'Huntley S', 'huntley', 40000, 'suvs'),
2196(70, 'Landstalker', 'landstalker', 35000, 'suvs'),
2197(71, 'Mesa', 'mesa', 16000, 'suvs'),
2198(72, 'Mesa Trail', 'mesa3', 40000, 'suvs'),
2199(73, 'Patriot', 'patriot', 55000, 'suvs'),
2200(74, 'Radius', 'radi', 29000, 'suvs'),
2201(75, 'Rocoto', 'rocoto', 45000, 'suvs'),
2202(76, 'Seminole', 'seminole', 25000, 'suvs'),
2203(77, 'XLS', 'xls', 32000, 'suvs'),
2204(78, 'Btype', 'btype', 62000, 'sportsclassics'),
2205(79, 'Btype Luxe', 'btype3', 85000, 'sportsclassics'),
2206(80, 'Btype Hotroad', 'btype2', 155000, 'sportsclassics'),
2207(81, 'Casco', 'casco', 30000, 'sportsclassics'),
2208(82, 'Coquette Classic', 'coquette2', 40000, 'sportsclassics'),
2209(83, 'Manana', 'manana', 12800, 'sportsclassics'),
2210(84, 'Monroe', 'monroe', 55000, 'sportsclassics'),
2211(85, 'Pigalle', 'pigalle', 20000, 'sportsclassics'),
2212(86, 'Stinger', 'stinger', 80000, 'sportsclassics'),
2213(87, 'Stinger GT', 'stingergt', 75000, 'sportsclassics'),
2214(88, 'Stirling GT', 'feltzer3', 65000, 'sportsclassics'),
2215(89, 'Z-Type', 'ztype', 220000, 'sportsclassics'),
2216(90, 'Bifta', 'bifta', 12000, 'offroad'),
2217(91, 'Bf Injection', 'bfinjection', 16000, 'offroad'),
2218(92, 'Blazer', 'blazer', 6500, 'offroad'),
2219(93, 'Blazer Sport', 'blazer4', 8500, 'offroad'),
2220(94, 'Brawler', 'brawler', 45000, 'offroad'),
2221(95, 'Bubsta 6x6', 'dubsta3', 120000, 'offroad'),
2222(96, 'Dune Buggy', 'dune', 8000, 'offroad'),
2223(97, 'Guardian', 'guardian', 45000, 'offroad'),
2224(98, 'Rebel', 'rebel2', 35000, 'offroad'),
2225(99, 'Sandking', 'sandking', 55000, 'offroad'),
2226(100, 'The Liberator', 'monster', 210000, 'offroad'),
2227(101, 'Trophy Truck', 'trophytruck', 60000, 'offroad'),
2228(102, 'Trophy Truck Limited', 'trophytruck2', 80000, 'offroad'),
2229(103, 'Cognoscenti Cabrio', 'cogcabrio', 55000, 'coupes'),
2230(104, 'Exemplar', 'exemplar', 32000, 'coupes'),
2231(105, 'F620', 'f620', 40000, 'coupes'),
2232(106, 'Felon', 'felon', 42000, 'coupes'),
2233(107, 'Felon GT', 'felon2', 55000, 'coupes'),
2234(108, 'Jackal', 'jackal', 38000, 'coupes'),
2235(109, 'Oracle XS', 'oracle2', 35000, 'coupes'),
2236(110, 'Sentinel', 'sentinel', 32000, 'coupes'),
2237(111, 'Sentinel XS', 'sentinel2', 40000, 'coupes'),
2238(112, 'Windsor', 'windsor', 95000, 'coupes'),
2239(113, 'Windsor Drop', 'windsor2', 125000, 'coupes'),
2240(114, 'Zion', 'zion', 36000, 'coupes'),
2241(115, 'Zion Cabrio', 'zion2', 45000, 'coupes'),
2242(116, '9F', 'ninef', 65000, 'sports'),
2243(117, '9F Cabrio', 'ninef2', 80000, 'sports'),
2244(118, 'Alpha', 'alpha', 60000, 'sports'),
2245(119, 'Banshee', 'banshee', 70000, 'sports'),
2246(120, 'Bestia GTS', 'bestiagts', 55000, 'sports'),
2247(121, 'Buffalo', 'buffalo', 12000, 'sports'),
2248(122, 'Buffalo S', 'buffalo2', 20000, 'sports'),
2249(123, 'Carbonizzare', 'carbonizzare', 75000, 'sports'),
2250(124, 'Comet', 'comet2', 65000, 'sports'),
2251(125, 'Coquette', 'coquette', 65000, 'sports'),
2252(126, 'Drift Tampa', 'tampa2', 80000, 'sports'),
2253(127, 'Elegy', 'elegy2', 38500, 'sports'),
2254(128, 'Feltzer', 'feltzer2', 55000, 'sports'),
2255(129, 'Furore GT', 'furoregt', 45000, 'sports'),
2256(130, 'Fusilade', 'fusilade', 40000, 'sports'),
2257(131, 'Jester', 'jester', 65000, 'sports'),
2258(132, 'Jester(Racecar)', 'jester2', 135000, 'sports'),
2259(133, 'Khamelion', 'khamelion', 38000, 'sports'),
2260(134, 'Kuruma', 'kuruma', 30000, 'sports'),
2261(135, 'Lynx', 'lynx', 40000, 'sports'),
2262(136, 'Mamba', 'mamba', 70000, 'sports'),
2263(137, 'Massacro', 'massacro', 65000, 'sports'),
2264(138, 'Massacro(Racecar)', 'massacro2', 130000, 'sports'),
2265(139, 'Omnis', 'omnis', 35000, 'sports'),
2266(140, 'Penumbra', 'penumbra', 28000, 'sports'),
2267(141, 'Rapid GT', 'rapidgt', 35000, 'sports'),
2268(142, 'Rapid GT Convertible', 'rapidgt2', 45000, 'sports'),
2269(143, 'Schafter V12', 'schafter3', 50000, 'sports'),
2270(144, 'Seven 70', 'seven70', 39500, 'sports'),
2271(145, 'Sultan', 'sultan', 15000, 'sports'),
2272(146, 'Surano', 'surano', 50000, 'sports'),
2273(147, 'Tropos', 'tropos', 40000, 'sports'),
2274(148, 'Verlierer', 'verlierer2', 70000, 'sports'),
2275(149, 'Adder', 'adder', 900000, 'super'),
2276(150, 'Banshee 900R', 'banshee2', 255000, 'super'),
2277(151, 'Bullet', 'bullet', 90000, 'super'),
2278(152, 'Cheetah', 'cheetah', 480000, 'super'),
2279(153, 'Entity XF', 'entityxf', 500000, 'super'),
2280(154, 'ETR1', 'sheava', 220000, 'super'),
2281(155, 'FMJ', 'fmj', 200000, 'super'),
2282(156, 'Infernus', 'infernus', 180000, 'super'),
2283(157, 'Osiris', 'osiris', 160000, 'super'),
2284(158, 'Pfister', 'pfister811', 85000, 'super'),
2285(159, 'RE-7B', 'le7b', 325000, 'super'),
2286(160, 'Reaper', 'reaper', 150000, 'super'),
2287(161, 'Sultan RS', 'sultanrs', 65000, 'super'),
2288(162, 'T20', 't20', 300000, 'super'),
2289(163, 'Turismo R', 'turismor', 350000, 'super'),
2290(164, 'Tyrus', 'tyrus', 600000, 'super'),
2291(165, 'Vacca', 'vacca', 120000, 'super'),
2292(166, 'Voltic', 'voltic', 90000, 'super'),
2293(167, 'X80 Proto', 'prototipo', 1750000, 'super'),
2294(168, 'Zentorno', 'zentorno', 1200000, 'super');
2295
2296-- --------------------------------------------------------
2297
2298--
2299-- Structure de la table `vehicle_categories`
2300--
2301
2302CREATE TABLE IF NOT EXISTS `vehicle_categories` (
2303  `id` int(11) NOT NULL,
2304  `name` varchar(60) NOT NULL,
2305  `label` varchar(60) NOT NULL
2306) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
2307
2308--
2309-- Contenu de la table `vehicle_categories`
2310--
2311
2312INSERT INTO `vehicle_categories` (`id`, `name`, `label`) VALUES
2313(1, 'coupes', 'Coupés'),
2314(2, 'sports', 'Sports'),
2315(3, 'sportsclassics', 'Sports Classics'),
2316(4, 'super', 'Super'),
2317(5, 'muscle', 'Muscle'),
2318(6, 'offroad', 'Off Road'),
2319(7, 'suvs', 'SUVs'),
2320(8, 'vans', 'Vans');
2321
2322-- --------------------------------------------------------
2323
2324--
2325-- Structure de la table `weashops`
2326--
2327
2328CREATE TABLE IF NOT EXISTS `weashops` (
2329`id` int(11) NOT NULL,
2330  `name` varchar(255) NOT NULL,
2331  `item` varchar(255) NOT NULL,
2332  `price` int(11) NOT NULL
2333) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;
2334
2335--
2336-- Contenu de la table `weashops`
2337--
2338
2339INSERT INTO `weashops` (`id`, `name`, `item`, `price`) VALUES
2340(1, 'GunShop', 'WEAPON_PISTOL', 300),
2341(2, 'BlackWeashop', 'WEAPON_PISTOL', 500),
2342(3, 'GunShop', 'WEAPON_FLASHLIGHT', 60),
2343(4, 'BlackWeashop', 'WEAPON_FLASHLIGHT', 70),
2344(5, 'GunShop', 'WEAPON_MACHETE', 90),
2345(6, 'BlackWeashop', 'WEAPON_MACHETE', 110),
2346(7, 'GunShop', 'WEAPON_NIGHTSTICK', 150),
2347(8, 'BlackWeashop', 'WEAPON_NIGHTSTICK', 150),
2348(9, 'GunShop', 'WEAPON_BAT', 100),
2349(10, 'BlackWeashop', 'WEAPON_BAT', 100),
2350(11, 'GunShop', 'WEAPON_STUNGUN', 50),
2351(12, 'BlackWeashop', 'WEAPON_STUNGUN', 50),
2352(13, 'GunShop', 'WEAPON_MICROSMG', 1400),
2353(14, 'BlackWeashop', 'WEAPON_MICROSMG', 1700),
2354(15, 'GunShop', 'WEAPON_PUMPSHOTGUN', 3400),
2355(16, 'BlackWeashop', 'WEAPON_PUMPSHOTGUN', 3500),
2356(17, 'GunShop', 'WEAPON_ASSAULTRIFLE', 10000),
2357(18, 'BlackWeashop', 'WEAPON_ASSAULTRIFLE', 11000),
2358(19, 'GunShop', 'WEAPON_SPECIALCARBINE', 15000),
2359(20, 'BlackWeashop', 'WEAPON_SPECIALCARBINE', 16500),
2360(21, 'GunShop', 'WEAPON_SNIPERRIFLE', 22000),
2361(22, 'BlackWeashop', 'WEAPON_SNIPERRIFLE', 24000),
2362(23, 'GunShop', 'WEAPON_FIREWORK', 18000),
2363(24, 'BlackWeashop', 'WEAPON_FIREWORK', 20000),
2364(25, 'GunShop', 'WEAPON_GRENADE', 500),
2365(26, 'BlackWeashop', 'WEAPON_GRENADE', 650),
2366(27, 'GunShop', 'WEAPON_BZGAS', 200),
2367(28, 'BlackWeashop', 'WEAPON_BZGAS', 350),
2368(29, 'GunShop', 'WEAPON_FIREEXTINGUISHER', 100),
2369(30, 'BlackWeashop', 'WEAPON_FIREEXTINGUISHER', 100),
2370(31, 'GunShop', 'WEAPON_BALL', 50),
2371(32, 'BlackWeashop', 'WEAPON_BALL', 50),
2372(33, 'GunShop', 'WEAPON_SMOKEGRENADE', 100),
2373(34, 'BlackWeashop', 'WEAPON_SMOKEGRENADE', 100),
2374(35, 'BlackWeashop', 'WEAPON_APPISTOL', 1100),
2375(36, 'BlackWeashop', 'WEAPON_CARBINERIFLE', 12000),
2376(37, 'BlackWeashop', 'WEAPON_HEAVYSNIPER', 30000),
2377(38, 'BlackWeashop', 'WEAPON_MINIGUN', 45000),
2378(39, 'BlackWeashop', 'WEAPON_RAILGUN', 50000),
2379(40, 'BlackWeashop', 'WEAPON_STICKYBOMB', 500);
2380
2381--
2382-- Index pour les tables exportées
2383--
2384
2385--
2386-- Index pour la table `addon_account`
2387--
2388ALTER TABLE `addon_account`
2389 ADD PRIMARY KEY (`name`);
2390
2391--
2392-- Index pour la table `addon_account_data`
2393--
2394ALTER TABLE `addon_account_data`
2395 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `index_addon_account_data_account_name_owner` (`account_name`,`owner`), ADD KEY `index_addon_account_data_account_name` (`account_name`);
2396
2397--
2398-- Index pour la table `addon_inventory`
2399--
2400ALTER TABLE `addon_inventory`
2401 ADD PRIMARY KEY (`name`);
2402
2403--
2404-- Index pour la table `addon_inventory_items`
2405--
2406ALTER TABLE `addon_inventory_items`
2407 ADD PRIMARY KEY (`id`), ADD KEY `index_addon_inventory_items_inventory_name_name` (`inventory_name`,`name`), ADD KEY `index_addon_inventory_items_inventory_name_name_owner` (`inventory_name`,`name`,`owner`), ADD KEY `index_addon_inventory_inventory_name` (`inventory_name`);
2408
2409--
2410-- Index pour la table `billing`
2411--
2412ALTER TABLE `billing`
2413 ADD PRIMARY KEY (`id`);
2414
2415--
2416-- Index pour la table `cardealer_vehicles`
2417--
2418ALTER TABLE `cardealer_vehicles`
2419 ADD PRIMARY KEY (`id`);
2420
2421--
2422-- Index pour la table `characters`
2423--
2424ALTER TABLE `characters`
2425 ADD PRIMARY KEY (`id`);
2426
2427--
2428-- Index pour la table `datastore`
2429--
2430ALTER TABLE `datastore`
2431 ADD PRIMARY KEY (`name`);
2432
2433--
2434-- Index pour la table `datastore_data`
2435--
2436ALTER TABLE `datastore_data`
2437 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `index_datastore_data_name_owner` (`name`,`owner`), ADD KEY `index_datastore_data_name` (`name`);
2438
2439--
2440-- Index pour la table `fine_types`
2441--
2442ALTER TABLE `fine_types`
2443 ADD PRIMARY KEY (`id`);
2444
2445--
2446-- Index pour la table `fine_types_bac`
2447--
2448ALTER TABLE `fine_types_bac`
2449 ADD PRIMARY KEY (`id`);
2450
2451--
2452-- Index pour la table `fine_types_ballas`
2453--
2454ALTER TABLE `fine_types_ballas`
2455 ADD PRIMARY KEY (`id`);
2456
2457--
2458-- Index pour la table `fine_types_biker`
2459--
2460ALTER TABLE `fine_types_biker`
2461 ADD PRIMARY KEY (`id`);
2462
2463--
2464-- Index pour la table `fine_types_bloods`
2465--
2466ALTER TABLE `fine_types_bloods`
2467 ADD PRIMARY KEY (`id`);
2468
2469--
2470-- Index pour la table `fine_types_families`
2471--
2472ALTER TABLE `fine_types_families`
2473 ADD PRIMARY KEY (`id`);
2474
2475--
2476-- Index pour la table `fine_types_securitas`
2477--
2478ALTER TABLE `fine_types_securitas`
2479 ADD PRIMARY KEY (`id`);
2480
2481--
2482-- Index pour la table `fine_types_vagos`
2483--
2484ALTER TABLE `fine_types_vagos`
2485 ADD PRIMARY KEY (`id`);
2486
2487--
2488-- Index pour la table `items`
2489--
2490ALTER TABLE `items`
2491 ADD PRIMARY KEY (`name`);
2492
2493--
2494-- Index pour la table `jobs`
2495--
2496ALTER TABLE `jobs`
2497 ADD PRIMARY KEY (`label`) USING BTREE;
2498
2499--
2500-- Index pour la table `job_grades`
2501--
2502ALTER TABLE `job_grades`
2503 ADD PRIMARY KEY (`id`);
2504
2505--
2506-- Index pour la table `licenses`
2507--
2508ALTER TABLE `licenses`
2509 ADD PRIMARY KEY (`type`);
2510
2511--
2512-- Index pour la table `motodealer_motos`
2513--
2514ALTER TABLE `motodealer_motos`
2515 ADD PRIMARY KEY (`id`);
2516
2517--
2518-- Index pour la table `motos`
2519--
2520ALTER TABLE `motos`
2521 ADD PRIMARY KEY (`id`);
2522
2523--
2524-- Index pour la table `motos_categories`
2525--
2526ALTER TABLE `motos_categories`
2527 ADD PRIMARY KEY (`id`);
2528
2529--
2530-- Index pour la table `open_car`
2531--
2532ALTER TABLE `open_car`
2533 ADD PRIMARY KEY (`id`);
2534
2535--
2536-- Index pour la table `org`
2537--
2538ALTER TABLE `org`
2539 ADD PRIMARY KEY (`name`);
2540
2541--
2542-- Index pour la table `organisation_moneywash`
2543--
2544ALTER TABLE `organisation_moneywash`
2545 ADD PRIMARY KEY (`id`);
2546
2547--
2548-- Index pour la table `org_gradeorg`
2549--
2550ALTER TABLE `org_gradeorg`
2551 ADD PRIMARY KEY (`id`);
2552
2553--
2554-- Index pour la table `owned_properties`
2555--
2556ALTER TABLE `owned_properties`
2557 ADD PRIMARY KEY (`id`);
2558
2559--
2560-- Index pour la table `owned_vehicles`
2561--
2562ALTER TABLE `owned_vehicles`
2563 ADD PRIMARY KEY (`id`);
2564
2565--
2566-- Index pour la table `peage_flash`
2567--
2568ALTER TABLE `peage_flash`
2569 ADD PRIMARY KEY (`id`);
2570
2571--
2572-- Index pour la table `phone_app_chat`
2573--
2574ALTER TABLE `phone_app_chat`
2575 ADD PRIMARY KEY (`id`);
2576
2577--
2578-- Index pour la table `phone_calls`
2579--
2580ALTER TABLE `phone_calls`
2581 ADD PRIMARY KEY (`id`);
2582
2583--
2584-- Index pour la table `phone_messages`
2585--
2586ALTER TABLE `phone_messages`
2587 ADD PRIMARY KEY (`id`);
2588
2589--
2590-- Index pour la table `phone_users_contacts`
2591--
2592ALTER TABLE `phone_users_contacts`
2593 ADD PRIMARY KEY (`id`);
2594
2595--
2596-- Index pour la table `properties`
2597--
2598ALTER TABLE `properties`
2599 ADD PRIMARY KEY (`id`);
2600
2601--
2602-- Index pour la table `rented_vehicles`
2603--
2604ALTER TABLE `rented_vehicles`
2605 ADD PRIMARY KEY (`id`);
2606
2607--
2608-- Index pour la table `shops`
2609--
2610ALTER TABLE `shops`
2611 ADD PRIMARY KEY (`id`);
2612
2613--
2614-- Index pour la table `shops2`
2615--
2616ALTER TABLE `shops2`
2617 ADD PRIMARY KEY (`id`);
2618
2619--
2620-- Index pour la table `society_moneywash`
2621--
2622ALTER TABLE `society_moneywash`
2623 ADD PRIMARY KEY (`id`);
2624
2625--
2626-- Index pour la table `truck_inventory`
2627--
2628ALTER TABLE `truck_inventory`
2629 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `item` (`item`,`plate`);
2630
2631--
2632-- Index pour la table `twitter_accounts`
2633--
2634ALTER TABLE `twitter_accounts`
2635 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`);
2636
2637--
2638-- Index pour la table `twitter_likes`
2639--
2640ALTER TABLE `twitter_likes`
2641 ADD PRIMARY KEY (`id`), ADD KEY `FK_twitter_likes_twitter_accounts` (`authorId`), ADD KEY `FK_twitter_likes_twitter_tweets` (`tweetId`);
2642
2643--
2644-- Index pour la table `twitter_tweets`
2645--
2646ALTER TABLE `twitter_tweets`
2647 ADD PRIMARY KEY (`id`), ADD KEY `FK_twitter_tweets_twitter_accounts` (`authorId`);
2648
2649--
2650-- Index pour la table `users`
2651--
2652ALTER TABLE `users`
2653 ADD PRIMARY KEY (`firstname`);
2654
2655--
2656-- Index pour la table `user_accounts`
2657--
2658ALTER TABLE `user_accounts`
2659 ADD PRIMARY KEY (`id`);
2660
2661--
2662-- Index pour la table `user_contacts`
2663--
2664ALTER TABLE `user_contacts`
2665 ADD PRIMARY KEY (`id`);
2666
2667--
2668-- Index pour la table `user_inventory`
2669--
2670ALTER TABLE `user_inventory`
2671 ADD PRIMARY KEY (`id`);
2672
2673--
2674-- Index pour la table `user_licenses`
2675--
2676ALTER TABLE `user_licenses`
2677 ADD PRIMARY KEY (`id`);
2678
2679--
2680-- Index pour la table `vehicles`
2681--
2682ALTER TABLE `vehicles`
2683 ADD PRIMARY KEY (`id`);
2684
2685--
2686-- Index pour la table `weashops`
2687--
2688ALTER TABLE `weashops`
2689 ADD PRIMARY KEY (`id`);
2690
2691--
2692-- AUTO_INCREMENT pour les tables exportées
2693--
2694
2695--
2696-- AUTO_INCREMENT pour la table `addon_account_data`
2697--
2698ALTER TABLE `addon_account_data`
2699MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=68;
2700--
2701-- AUTO_INCREMENT pour la table `addon_inventory_items`
2702--
2703ALTER TABLE `addon_inventory_items`
2704MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2705--
2706-- AUTO_INCREMENT pour la table `billing`
2707--
2708ALTER TABLE `billing`
2709MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2710--
2711-- AUTO_INCREMENT pour la table `cardealer_vehicles`
2712--
2713ALTER TABLE `cardealer_vehicles`
2714MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
2715--
2716-- AUTO_INCREMENT pour la table `characters`
2717--
2718ALTER TABLE `characters`
2719MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
2720--
2721-- AUTO_INCREMENT pour la table `datastore_data`
2722--
2723ALTER TABLE `datastore_data`
2724MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=64;
2725--
2726-- AUTO_INCREMENT pour la table `fine_types`
2727--
2728ALTER TABLE `fine_types`
2729MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=33;
2730--
2731-- AUTO_INCREMENT pour la table `fine_types_bac`
2732--
2733ALTER TABLE `fine_types_bac`
2734MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=53;
2735--
2736-- AUTO_INCREMENT pour la table `fine_types_ballas`
2737--
2738ALTER TABLE `fine_types_ballas`
2739MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
2740--
2741-- AUTO_INCREMENT pour la table `fine_types_biker`
2742--
2743ALTER TABLE `fine_types_biker`
2744MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
2745--
2746-- AUTO_INCREMENT pour la table `fine_types_bloods`
2747--
2748ALTER TABLE `fine_types_bloods`
2749MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
2750--
2751-- AUTO_INCREMENT pour la table `fine_types_families`
2752--
2753ALTER TABLE `fine_types_families`
2754MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
2755--
2756-- AUTO_INCREMENT pour la table `fine_types_securitas`
2757--
2758ALTER TABLE `fine_types_securitas`
2759MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=53;
2760--
2761-- AUTO_INCREMENT pour la table `fine_types_vagos`
2762--
2763ALTER TABLE `fine_types_vagos`
2764MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
2765--
2766-- AUTO_INCREMENT pour la table `job_grades`
2767--
2768ALTER TABLE `job_grades`
2769MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=155;
2770--
2771-- AUTO_INCREMENT pour la table `motodealer_motos`
2772--
2773ALTER TABLE `motodealer_motos`
2774MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2775--
2776-- AUTO_INCREMENT pour la table `motos`
2777--
2778ALTER TABLE `motos`
2779MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=44;
2780--
2781-- AUTO_INCREMENT pour la table `motos_categories`
2782--
2783ALTER TABLE `motos_categories`
2784MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
2785--
2786-- AUTO_INCREMENT pour la table `open_car`
2787--
2788ALTER TABLE `open_car`
2789MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
2790--
2791-- AUTO_INCREMENT pour la table `organisation_moneywash`
2792--
2793ALTER TABLE `organisation_moneywash`
2794MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2795--
2796-- AUTO_INCREMENT pour la table `org_gradeorg`
2797--
2798ALTER TABLE `org_gradeorg`
2799MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;
2800--
2801-- AUTO_INCREMENT pour la table `owned_properties`
2802--
2803ALTER TABLE `owned_properties`
2804MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2805--
2806-- AUTO_INCREMENT pour la table `owned_vehicles`
2807--
2808ALTER TABLE `owned_vehicles`
2809MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2810--
2811-- AUTO_INCREMENT pour la table `peage_flash`
2812--
2813ALTER TABLE `peage_flash`
2814MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
2815--
2816-- AUTO_INCREMENT pour la table `phone_app_chat`
2817--
2818ALTER TABLE `phone_app_chat`
2819MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2820--
2821-- AUTO_INCREMENT pour la table `phone_calls`
2822--
2823ALTER TABLE `phone_calls`
2824MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2825--
2826-- AUTO_INCREMENT pour la table `phone_messages`
2827--
2828ALTER TABLE `phone_messages`
2829MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2830--
2831-- AUTO_INCREMENT pour la table `phone_users_contacts`
2832--
2833ALTER TABLE `phone_users_contacts`
2834MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
2835--
2836-- AUTO_INCREMENT pour la table `properties`
2837--
2838ALTER TABLE `properties`
2839MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=43;
2840--
2841-- AUTO_INCREMENT pour la table `rented_vehicles`
2842--
2843ALTER TABLE `rented_vehicles`
2844MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2845--
2846-- AUTO_INCREMENT pour la table `shops`
2847--
2848ALTER TABLE `shops`
2849MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=52;
2850--
2851-- AUTO_INCREMENT pour la table `shops2`
2852--
2853ALTER TABLE `shops2`
2854MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
2855--
2856-- AUTO_INCREMENT pour la table `society_moneywash`
2857--
2858ALTER TABLE `society_moneywash`
2859MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2860--
2861-- AUTO_INCREMENT pour la table `truck_inventory`
2862--
2863ALTER TABLE `truck_inventory`
2864MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2865--
2866-- AUTO_INCREMENT pour la table `twitter_accounts`
2867--
2868ALTER TABLE `twitter_accounts`
2869MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2870--
2871-- AUTO_INCREMENT pour la table `twitter_likes`
2872--
2873ALTER TABLE `twitter_likes`
2874MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2875--
2876-- AUTO_INCREMENT pour la table `twitter_tweets`
2877--
2878ALTER TABLE `twitter_tweets`
2879MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2880--
2881-- AUTO_INCREMENT pour la table `user_accounts`
2882--
2883ALTER TABLE `user_accounts`
2884MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
2885--
2886-- AUTO_INCREMENT pour la table `user_contacts`
2887--
2888ALTER TABLE `user_contacts`
2889MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2890--
2891-- AUTO_INCREMENT pour la table `user_inventory`
2892--
2893ALTER TABLE `user_inventory`
2894MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=400;
2895--
2896-- AUTO_INCREMENT pour la table `user_licenses`
2897--
2898ALTER TABLE `user_licenses`
2899MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
2900--
2901-- AUTO_INCREMENT pour la table `vehicles`
2902--
2903ALTER TABLE `vehicles`
2904MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=169;
2905--
2906-- AUTO_INCREMENT pour la table `weashops`
2907--
2908ALTER TABLE `weashops`
2909MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=41;
2910--
2911-- Contraintes pour les tables exportées
2912--
2913
2914--
2915-- Contraintes pour la table `twitter_likes`
2916--
2917ALTER TABLE `twitter_likes`
2918ADD CONSTRAINT `FK_twitter_likes_twitter_accounts` FOREIGN KEY (`authorId`) REFERENCES `twitter_accounts` (`id`),
2919ADD CONSTRAINT `FK_twitter_likes_twitter_tweets` FOREIGN KEY (`tweetId`) REFERENCES `twitter_tweets` (`id`) ON DELETE CASCADE;
2920
2921--
2922-- Contraintes pour la table `twitter_tweets`
2923--
2924ALTER TABLE `twitter_tweets`
2925ADD CONSTRAINT `FK_twitter_tweets_twitter_accounts` FOREIGN KEY (`authorId`) REFERENCES `twitter_accounts` (`id`);
2926
2927/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2928/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2929/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;