· 8 years ago · Jan 24, 2018, 02:50 PM
1-- phpMyAdmin SQL Dump
2-- version 4.7.4
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le : mer. 24 jan. 2018 à 14:48
7-- Version du serveur : 5.7.19
8-- Version de PHP : 5.6.31
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Base de données : `fxserver`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `addon_account`
29--
30
31DROP TABLE IF EXISTS `addon_account`;
32CREATE TABLE IF NOT EXISTS `addon_account` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `name` varchar(255) NOT NULL,
35 `label` varchar(255) NOT NULL,
36 `shared` int(11) NOT NULL,
37 PRIMARY KEY (`id`)
38) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
39
40--
41-- Déchargement des données de la table `addon_account`
42--
43
44INSERT INTO `addon_account` (`id`, `name`, `label`, `shared`) VALUES
45(1, 'caution', 'Caution', 0),
46(2, 'society_police', 'Police', 1),
47(3, 'society_police', 'Police', 1),
48(4, 'society_cardealer', 'Concessionnaire', 1),
49(5, 'society_ambulance', 'Ambulance', 1),
50(6, 'property_black_money', 'Argent Sale Propriété', 0);
51
52-- --------------------------------------------------------
53
54--
55-- Structure de la table `addon_account_data`
56--
57
58DROP TABLE IF EXISTS `addon_account_data`;
59CREATE TABLE IF NOT EXISTS `addon_account_data` (
60 `id` int(11) NOT NULL AUTO_INCREMENT,
61 `account_name` varchar(255) DEFAULT NULL,
62 `money` double NOT NULL,
63 `owner` varchar(255) DEFAULT NULL,
64 PRIMARY KEY (`id`)
65) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
66
67--
68-- Déchargement des données de la table `addon_account_data`
69--
70
71INSERT INTO `addon_account_data` (`id`, `account_name`, `money`, `owner`) VALUES
72(1, 'caution', 0, 'steam:110000104e63496'),
73(2, 'society_police', 33150, NULL),
74(3, 'society_cardealer', 0, NULL),
75(4, 'society_ambulance', 50061, NULL),
76(16, 'property_black_money', 0, 'steam:110000104e63496');
77
78-- --------------------------------------------------------
79
80--
81-- Structure de la table `addon_inventory`
82--
83
84DROP TABLE IF EXISTS `addon_inventory`;
85CREATE TABLE IF NOT EXISTS `addon_inventory` (
86 `id` int(11) NOT NULL AUTO_INCREMENT,
87 `name` varchar(255) NOT NULL,
88 `label` varchar(255) NOT NULL,
89 `shared` int(11) NOT NULL,
90 PRIMARY KEY (`id`)
91) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
92
93--
94-- Déchargement des données de la table `addon_inventory`
95--
96
97INSERT INTO `addon_inventory` (`id`, `name`, `label`, `shared`) VALUES
98(1, 'society_police', 'Police', 1),
99(2, 'society_cardealer', 'Concesionnaire', 1),
100(3, 'property', 'Propriété', 0);
101
102-- --------------------------------------------------------
103
104--
105-- Structure de la table `addon_inventory_items`
106--
107
108DROP TABLE IF EXISTS `addon_inventory_items`;
109CREATE TABLE IF NOT EXISTS `addon_inventory_items` (
110 `id` int(11) NOT NULL AUTO_INCREMENT,
111 `inventory_name` varchar(255) NOT NULL,
112 `name` varchar(255) NOT NULL,
113 `count` int(11) NOT NULL,
114 `owner` varchar(60) DEFAULT NULL,
115 PRIMARY KEY (`id`)
116) ENGINE=MyISAM DEFAULT CHARSET=latin1;
117
118-- --------------------------------------------------------
119
120--
121-- Structure de la table `billing`
122--
123
124DROP TABLE IF EXISTS `billing`;
125CREATE TABLE IF NOT EXISTS `billing` (
126 `id` int(11) NOT NULL AUTO_INCREMENT,
127 `identifier` varchar(255) NOT NULL,
128 `sender` varchar(255) NOT NULL,
129 `target_type` varchar(50) NOT NULL,
130 `target` varchar(255) NOT NULL,
131 `label` varchar(255) NOT NULL,
132 `amount` int(11) NOT NULL,
133 PRIMARY KEY (`id`)
134) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
135
136-- --------------------------------------------------------
137
138--
139-- Structure de la table `cardealer_vehicles`
140--
141
142DROP TABLE IF EXISTS `cardealer_vehicles`;
143CREATE TABLE IF NOT EXISTS `cardealer_vehicles` (
144 `id` int(11) NOT NULL AUTO_INCREMENT,
145 `vehicle` varchar(255) NOT NULL,
146 `price` int(11) NOT NULL,
147 PRIMARY KEY (`id`)
148) ENGINE=MyISAM DEFAULT CHARSET=latin1;
149
150-- --------------------------------------------------------
151
152--
153-- Structure de la table `characters`
154--
155
156DROP TABLE IF EXISTS `characters`;
157CREATE TABLE IF NOT EXISTS `characters` (
158 `identifier` varchar(255) NOT NULL,
159 `firstname` varchar(255) NOT NULL,
160 `lastname` varchar(255) NOT NULL,
161 `dateofbirth` varchar(255) NOT NULL,
162 `sex` varchar(1) NOT NULL DEFAULT 'f',
163 `height` varchar(128) NOT NULL
164) ENGINE=MyISAM DEFAULT CHARSET=latin1;
165
166--
167-- Déchargement des données de la table `characters`
168--
169
170INSERT INTO `characters` (`identifier`, `firstname`, `lastname`, `dateofbirth`, `sex`, `height`) VALUES
171('steam:110000104e63496', 'John', 'Ford', '04/06/1996', 'M', '85');
172
173-- --------------------------------------------------------
174
175--
176-- Structure de la table `datastore`
177--
178
179DROP TABLE IF EXISTS `datastore`;
180CREATE TABLE IF NOT EXISTS `datastore` (
181 `id` int(11) NOT NULL AUTO_INCREMENT,
182 `name` varchar(255) NOT NULL,
183 `label` varchar(255) NOT NULL,
184 `shared` int(11) NOT NULL,
185 PRIMARY KEY (`id`)
186) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
187
188--
189-- Déchargement des données de la table `datastore`
190--
191
192INSERT INTO `datastore` (`id`, `name`, `label`, `shared`) VALUES
193(1, 'user_ears', 'Ears', 0),
194(2, 'user_glasses', 'Glasses', 0),
195(3, 'user_helmet', 'Helmet', 0),
196(4, 'user_mask', 'Mask', 0),
197(5, 'user_mask', 'Masque', 0),
198(6, 'society_police', 'Police', 1),
199(7, 'society_police', 'Police', 1),
200(8, 'property', 'Propriété', 0);
201
202-- --------------------------------------------------------
203
204--
205-- Structure de la table `datastore_data`
206--
207
208DROP TABLE IF EXISTS `datastore_data`;
209CREATE TABLE IF NOT EXISTS `datastore_data` (
210 `id` int(11) NOT NULL AUTO_INCREMENT,
211 `name` varchar(255) NOT NULL,
212 `owner` varchar(255) DEFAULT NULL,
213 `data` longtext,
214 PRIMARY KEY (`id`)
215) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;
216
217--
218-- Déchargement des données de la table `datastore_data`
219--
220
221INSERT INTO `datastore_data` (`id`, `name`, `owner`, `data`) VALUES
222(1, 'user_mask', 'steam:110000104e63496', '{}'),
223(2, 'user_ears', 'steam:110000104e63496', '{}'),
224(3, 'user_helmet', 'steam:110000104e63496', '{}'),
225(4, 'user_glasses', 'steam:110000104e63496', '{}'),
226(5, 'society_police', NULL, '{\"weapons\":[{\"name\":\"WEAPON_NIGHTSTICK\",\"count\":5},{\"name\":\"WEAPON_COMBATPISTOL\",\"count\":1},{\"name\":\"WEAPON_ASSAULTSMG\",\"count\":0},{\"name\":\"WEAPON_ASSAULTRIFLE\",\"count\":0},{\"name\":\"WEAPON_PUMPSHOTGUN\",\"count\":0},{\"name\":\"WEAPON_STUNGUN\",\"count\":1},{\"name\":\"WEAPON_FLASHLIGHT\",\"count\":0},{\"name\":\"WEAPON_FIREEXTINGUISHER\",\"count\":0},{\"name\":\"WEAPON_FLAREGUN\",\"count\":0},{\"name\":\"WEAPON_STICKYBOMB\",\"count\":0},{\"name\":\"GADGET_PARACHUTE\",\"count\":1},{\"name\":\"WEAPON_SPECIALCARBINE\",\"count\":0},{\"count\":0,\"name\":\"WEAPON_SMG\"},{\"name\":\"WEAPON_PISTOL\",\"count\":0}]}'),
227(6, 'property', 'steam:110000104e63496', '{}'),
228(7, 'user_glasses', 'steam:11000010368fbea', '{}'),
229(8, 'user_mask', 'steam:11000010368fbea', '{}'),
230(9, 'user_ears', 'steam:11000010368fbea', '{}'),
231(10, 'user_helmet', 'steam:11000010368fbea', '{}'),
232(11, 'property', 'steam:11000010368fbea', '{}'),
233(12, 'property', 'steam:110000104b5fe96', '{\"dressing\":[{\"skin\":{\"hair_2\":0,\"helmet_2\":0,\"makeup_1\":0,\"decals_2\":0,\"beard_2\":10,\"ears_2\":0,\"makeup_2\":0,\"pants_2\":0,\"tshirt_1\":38,\"mask_1\":0,\"ears_1\":-1,\"helmet_1\":-1,\"glasses_1\":5,\"hair_color_1\":0,\"skin\":21,\"hair_color_2\":0,\"bproof_2\":0,\"arms\":0,\"beard_3\":0,\"age_1\":0,\"bags_2\":0,\"lipstick_3\":0,\"lipstick_2\":0,\"shoes_1\":25,\"decals_1\":0,\"mask_2\":0,\"glasses_2\":4,\"beard_1\":10,\"eyebrows_1\":0,\"eyebrows_2\":10,\"pants_1\":1,\"torso_1\":192,\"hair_1\":2,\"chain_2\":0,\"age_2\":0,\"face\":0,\"eyebrows_4\":0,\"tshirt_2\":0,\"sex\":0,\"bproof_1\":0,\"lipstick_1\":0,\"makeup_4\":0,\"bags_1\":0,\"eyebrows_3\":0,\"beard_4\":0,\"chain_1\":0,\"lipstick_4\":0,\"torso_2\":9,\"shoes_2\":0,\"makeup_3\":0},\"label\":\"Tenu1\"}]}'),
234(13, 'user_mask', 'steam:110000104b5fe96', '{}'),
235(14, 'user_ears', 'steam:110000104b5fe96', '{}'),
236(15, 'user_helmet', 'steam:110000104b5fe96', '{}'),
237(16, 'user_glasses', 'steam:110000104b5fe96', '{}'),
238(17, 'property', 'steam:110000103f67018', '{}'),
239(18, 'user_glasses', 'steam:110000103f67018', '{}'),
240(19, 'user_helmet', 'steam:110000103f67018', '{}'),
241(20, 'user_mask', 'steam:110000103f67018', '{}'),
242(21, 'user_ears', 'steam:110000103f67018', '{}'),
243(22, 'property', 'steam:110000103c76dde', '{}'),
244(23, 'user_mask', 'steam:110000103c76dde', '{}'),
245(24, 'user_ears', 'steam:110000103c76dde', '{}'),
246(25, 'user_helmet', 'steam:110000103c76dde', '{}'),
247(26, 'user_glasses', 'steam:110000103c76dde', '{}'),
248(27, 'user_ears', 'steam:1100001159380d5', '{}'),
249(28, 'user_helmet', 'steam:1100001159380d5', '{}'),
250(29, 'user_glasses', 'steam:1100001159380d5', '{}'),
251(30, 'user_mask', 'steam:1100001159380d5', '{}'),
252(31, 'property', 'steam:1100001159380d5', '{}');
253
254-- --------------------------------------------------------
255
256--
257-- Structure de la table `fine_types`
258--
259
260DROP TABLE IF EXISTS `fine_types`;
261CREATE TABLE IF NOT EXISTS `fine_types` (
262 `id` int(11) NOT NULL AUTO_INCREMENT,
263 `label` varchar(255) DEFAULT NULL,
264 `amount` int(11) DEFAULT NULL,
265 `category` int(11) DEFAULT NULL,
266 PRIMARY KEY (`id`)
267) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=latin1;
268
269--
270-- Déchargement des données de la table `fine_types`
271--
272
273INSERT INTO `fine_types` (`id`, `label`, `amount`, `category`) VALUES
274(1, 'Usage abusif du klaxon', 50, 0),
275(2, 'Franchir une ligne continue', 40, 0),
276(3, 'Circulation à contresens', 250, 0),
277(4, 'Demi-tour non autorisé', 250, 0),
278(5, 'Circulation hors-route', 170, 0),
279(6, 'Non-respect des distances de sécurité', 30, 0),
280(7, 'Arrêt dangereux / interdit', 150, 0),
281(8, 'Stationnement gênant / interdit', 70, 0),
282(9, 'Non respect de la priorité à droite', 70, 0),
283(10, 'Non-respect à un véhicule prioritaire', 90, 0),
284(11, 'Non-respect d\'un stop', 105, 0),
285(12, 'Non-respect d\'un feu rouge', 130, 0),
286(13, 'Dépassement dangereux', 100, 0),
287(14, 'Véhicule non en état', 100, 0),
288(15, 'Conduite sans permis', 1500, 0),
289(16, 'Délit de fuite', 800, 0),
290(17, 'Excès de vitesse < 5 kmh', 90, 0),
291(18, 'Excès de vitesse 5-15 kmh', 120, 0),
292(19, 'Excès de vitesse 15-30 kmh', 180, 0),
293(20, 'Excès de vitesse > 30 kmh', 300, 0),
294(21, 'Entrave de la circulation', 110, 1),
295(22, 'Dégradation de la voie publique', 90, 1),
296(23, 'Trouble à l\'ordre publique', 90, 1),
297(24, 'Entrave opération de police', 130, 1),
298(25, 'Insulte envers / entre civils', 75, 1),
299(26, 'Outrage à agent de police', 110, 1),
300(27, 'Menace verbale ou intimidation envers civil', 90, 1),
301(28, 'Menace verbale ou intimidation envers policier', 150, 1),
302(29, 'Manifestation illégale', 250, 1),
303(30, 'Tentative de corruption', 1500, 1),
304(31, 'Arme blanche sortie en ville', 120, 2),
305(32, 'Arme léthale sortie en ville', 300, 2),
306(33, 'Port d\'arme non autorisé (défaut de license)', 600, 2),
307(34, 'Port d\'arme illégal', 700, 2),
308(35, 'Pris en flag lockpick', 300, 2),
309(36, 'Vol de voiture', 1800, 2),
310(37, 'Vente de drogue', 1500, 2),
311(38, 'Fabriquation de drogue', 1500, 2),
312(39, 'Possession de drogue', 650, 2),
313(40, 'Prise d\'ôtage civil', 1500, 2),
314(41, 'Prise d\'ôtage agent de l\'état', 2000, 2),
315(42, 'Braquage particulier', 650, 2),
316(43, 'Braquage magasin', 650, 2),
317(44, 'Braquage de banque', 1500, 2),
318(45, 'Tir sur civil', 2000, 3),
319(46, 'Tir sur agent de l\'état', 2500, 3),
320(47, 'Tentative de meurtre sur civil', 3000, 3),
321(48, 'Tentative de meurtre sur agent de l\'état', 5000, 3),
322(49, 'Meurtre sur civil', 10000, 3),
323(50, 'Meurte sur agent de l\'état', 30000, 3),
324(51, 'Meurtre involontaire', 1800, 3),
325(52, 'Escroquerie à l\'entreprise', 2000, 2),
326(54, 'Blessure supperficiel', 250, 4),
327(55, 'Blessure mortel', 500, 4),
328(56, 'Réanimation', 500, 4),
329(57, 'Réanimation avec héliportage', 1500, 4);
330
331-- --------------------------------------------------------
332
333--
334-- Structure de la table `items`
335--
336
337DROP TABLE IF EXISTS `items`;
338CREATE TABLE IF NOT EXISTS `items` (
339 `id` int(11) NOT NULL AUTO_INCREMENT,
340 `name` varchar(255) NOT NULL,
341 `label` varchar(255) NOT NULL,
342 `limit` int(11) NOT NULL DEFAULT '-1',
343 `rare` int(11) NOT NULL DEFAULT '0',
344 `can_remove` int(11) NOT NULL DEFAULT '1',
345 PRIMARY KEY (`id`)
346) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
347
348--
349-- Déchargement des données de la table `items`
350--
351
352INSERT INTO `items` (`id`, `name`, `label`, `limit`, `rare`, `can_remove`) VALUES
353(1, 'alive_chicken', 'Poulet vivant', 100, 0, 1),
354(2, 'slaughtered_chicken', 'Poulet abattu', 100, 0, 1),
355(3, 'packaged_chicken', 'Poulet en barquette', 100, 0, 1),
356(4, 'fish', 'Poisson', 100, 0, 1),
357(5, 'stone', 'Pierre', 100, 0, 1),
358(6, 'washed_stone', 'Pierre Lavée', 100, 0, 1),
359(7, 'copper', 'Cuivre', 100, 0, 1),
360(8, 'iron', 'Fer', 100, 0, 1),
361(9, 'gold', 'Or', 100, 0, 1),
362(10, 'diamond', 'Diamant', 100, 0, 1),
363(11, 'wood', 'Bois', 100, 0, 1),
364(12, 'cutted_wood', 'Bois coupé', 100, 0, 1),
365(13, 'packaged_plank', 'Paquet de planches', 100, 0, 1),
366(14, 'petrol', 'Pétrole', 100, 0, 1),
367(15, 'petrol_raffin', 'Pétrole Raffiné', 100, 0, 1),
368(16, 'essence', 'Essence', 100, 0, 1),
369(17, 'whool', 'Laine', 100, 0, 1),
370(18, 'fabric', 'Tissu', 200, 0, 1),
371(19, 'clothe', 'Vêtement', 100, 0, 1),
372(20, 'bread', 'Pain', -1, 0, 1),
373(21, 'water', 'Eau', -1, 0, 1),
374(22, 'bandage', 'Bandage', 20, 0, 1),
375(23, 'medikit', 'Medikit', 5, 0, 1);
376
377-- --------------------------------------------------------
378
379--
380-- Structure de la table `jobs`
381--
382
383DROP TABLE IF EXISTS `jobs`;
384CREATE TABLE IF NOT EXISTS `jobs` (
385 `id` int(11) NOT NULL AUTO_INCREMENT,
386 `name` varchar(255) NOT NULL,
387 `label` varchar(255) DEFAULT NULL,
388 `whitelisted` tinyint(1) NOT NULL DEFAULT '0',
389 PRIMARY KEY (`id`)
390) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
391
392--
393-- Déchargement des données de la table `jobs`
394--
395
396INSERT INTO `jobs` (`id`, `name`, `label`, `whitelisted`) VALUES
397(1, 'unemployed', 'Chômeur', 0),
398(2, 'slaughterer', 'Abatteur', 0),
399(3, 'fisherman', 'Pêcheur', 0),
400(4, 'miner', 'Mineur', 0),
401(5, 'lumberjack', 'Bûcheron', 0),
402(6, 'fuel', 'Raffineur', 0),
403(7, 'reporter', 'Journaliste', 0),
404(8, 'textil', 'Couturier', 0),
405(9, 'police', 'LSPD', 1),
406(10, 'cardealer', 'Concessionnaire', 1),
407(11, 'ambulance', 'Ambulance', 1);
408
409-- --------------------------------------------------------
410
411--
412-- Structure de la table `job_grades`
413--
414
415DROP TABLE IF EXISTS `job_grades`;
416CREATE TABLE IF NOT EXISTS `job_grades` (
417 `id` int(11) NOT NULL AUTO_INCREMENT,
418 `job_name` varchar(255) DEFAULT NULL,
419 `grade` int(11) NOT NULL,
420 `name` varchar(255) NOT NULL,
421 `label` varchar(255) NOT NULL,
422 `salary` int(11) NOT NULL,
423 `skin_male` longtext NOT NULL,
424 `skin_female` longtext NOT NULL,
425 PRIMARY KEY (`id`)
426) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
427
428--
429-- Déchargement des données de la table `job_grades`
430--
431
432INSERT INTO `job_grades` (`id`, `job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
433(1, 'unemployed', 0, 'rsa', 'RSA', 50, '{}', '{}'),
434(2, 'lumberjack', 0, 'interim', 'Intérimaire', 0, '{}', '{}'),
435(3, 'fisherman', 0, 'interim', 'Intérimaire', 0, '{}', '{}'),
436(4, 'fuel', 0, 'interim', 'Intérimaire', 0, '{}', '{}'),
437(5, 'reporter', 0, 'employee', 'Intérimaire', 0, '{}', '{}'),
438(6, 'textil', 0, 'interim', '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}'),
439(7, 'miner', 0, 'interim', '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}', '{}'),
440(8, 'slaughterer', 0, 'interim', '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}'),
441(9, 'police', 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}'),
442(10, 'police', 4, 'officer', 'Officier', 40, '{\"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}'),
443(11, 'police', 1, 'sergeant', 'Sergent', 60, '{\"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}'),
444(12, 'police', 2, 'lieutenant', 'Lieutenant', 85, '{\"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}'),
445(13, 'police', 3, 'boss', 'Commandant', 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}'),
446(14, 'cardealer', 0, 'recruit', 'Recrue', 10, '{}', '{}'),
447(15, 'cardealer', 1, 'novice', 'Novice', 25, '{}', '{}'),
448(16, 'cardealer', 2, 'experienced', 'Experimente', 40, '{}', '{}'),
449(17, 'cardealer', 3, 'boss', 'Patron', 0, '{}', '{}'),
450(18, '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}'),
451(19, '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}'),
452(20, '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}'),
453(21, 'ambulance', 3, 'boss', 'Chirurgien', 900, '{\"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}');
454
455-- --------------------------------------------------------
456
457--
458-- Structure de la table `licenses`
459--
460
461DROP TABLE IF EXISTS `licenses`;
462CREATE TABLE IF NOT EXISTS `licenses` (
463 `id` int(11) NOT NULL AUTO_INCREMENT,
464 `type` varchar(255) NOT NULL,
465 `label` varchar(255) NOT NULL,
466 PRIMARY KEY (`id`)
467) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
468
469--
470-- Déchargement des données de la table `licenses`
471--
472
473INSERT INTO `licenses` (`id`, `type`, `label`) VALUES
474(1, 'weapon', 'Permis de port d\'arme'),
475(2, 'dmv', 'Code de la route'),
476(3, 'drive', 'Permis de conduire'),
477(4, 'drive_bike', 'Permis moto'),
478(5, 'drive_truck', 'Permis camion');
479
480-- --------------------------------------------------------
481
482--
483-- Structure de la table `owned_properties`
484--
485
486DROP TABLE IF EXISTS `owned_properties`;
487CREATE TABLE IF NOT EXISTS `owned_properties` (
488 `id` int(11) NOT NULL AUTO_INCREMENT,
489 `name` varchar(255) NOT NULL,
490 `price` double NOT NULL,
491 `rented` int(11) NOT NULL,
492 `owner` varchar(60) NOT NULL,
493 PRIMARY KEY (`id`)
494) ENGINE=MyISAM DEFAULT CHARSET=latin1;
495
496-- --------------------------------------------------------
497
498--
499-- Structure de la table `owned_vehicles`
500--
501
502DROP TABLE IF EXISTS `owned_vehicles`;
503CREATE TABLE IF NOT EXISTS `owned_vehicles` (
504 `id` int(11) NOT NULL AUTO_INCREMENT,
505 `vehicle` longtext NOT NULL,
506 `owner` varchar(60) NOT NULL,
507 PRIMARY KEY (`id`)
508) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
509
510-- --------------------------------------------------------
511
512--
513-- Structure de la table `properties`
514--
515
516DROP TABLE IF EXISTS `properties`;
517CREATE TABLE IF NOT EXISTS `properties` (
518 `id` int(11) NOT NULL AUTO_INCREMENT,
519 `name` varchar(255) DEFAULT NULL,
520 `label` varchar(255) DEFAULT NULL,
521 `entering` varchar(255) DEFAULT NULL,
522 `exit` varchar(255) DEFAULT NULL,
523 `inside` varchar(255) DEFAULT NULL,
524 `outside` varchar(255) DEFAULT NULL,
525 `ipls` varchar(255) DEFAULT '[]',
526 `gateway` varchar(255) DEFAULT NULL,
527 `is_single` int(11) DEFAULT NULL,
528 `is_room` int(11) DEFAULT NULL,
529 `is_gateway` int(11) DEFAULT NULL,
530 `room_menu` varchar(255) DEFAULT NULL,
531 `price` int(11) NOT NULL,
532 PRIMARY KEY (`id`)
533) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;
534
535--
536-- Déchargement des données de la table `properties`
537--
538
539INSERT INTO `properties` (`id`, `name`, `label`, `entering`, `exit`, `inside`, `outside`, `ipls`, `gateway`, `is_single`, `is_room`, `is_gateway`, `room_menu`, `price`) VALUES
540(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),
541(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),
542(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),
543(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),
544(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),
545(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),
546(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),
547(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),
548(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),
549(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),
550(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),
551(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),
552(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),
553(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),
554(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),
555(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),
556(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),
557(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),
558(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),
559(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),
560(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),
561(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),
562(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),
563(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),
564(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),
565(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),
566(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),
567(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),
568(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),
569(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),
570(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),
571(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),
572(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),
573(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),
574(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),
575(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),
576(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),
577(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),
578(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),
579(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),
580(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),
581(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),
582(43, 'MazeBankBuilding', 'Maze Bank Building', '{\"x\":-79.18,\"y\":-795.92,\"z\":43.35}', NULL, NULL, '{\"x\":-72.50,\"y\":-786.92,\"z\":43.40}', '[]', NULL, 0, 0, 1, NULL, 0),
583(44, 'OldSpiceWarm', 'Old Spice Warm', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_01a\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-76.49,\"y\":-826.80,\"z\":243.38}', 5000000),
584(45, 'OldSpiceClassical', 'Old Spice Classical', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_01b\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-76.49,\"y\":-826.80,\"z\":243.38}', 5000000),
585(46, 'OldSpiceVintage', 'Old Spice Vintage', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_01c\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-76.49,\"y\":-826.80,\"z\":243.38}', 5000000),
586(47, 'ExecutiveRich', 'Executive Rich', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_02b\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-76.49,\"y\":-826.80,\"z\":243.38}', 5000000),
587(48, 'ExecutiveCool', 'Executive Cool', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_02c\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-76.49,\"y\":-826.80,\"z\":243.38}', 5000000),
588(49, 'ExecutiveContrast', 'Executive Contrast', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_02a\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-76.49,\"y\":-826.80,\"z\":243.38}', 5000000),
589(50, 'PowerBrokerIce', 'Power Broker Ice', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_03a\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-76.49,\"y\":-826.80,\"z\":243.38}', 5000000),
590(51, 'PowerBrokerConservative', 'Power Broker Conservative', NULL, '', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_03b\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-76.49,\"y\":-826.80,\"z\":243.38}', 5000000),
591(52, 'PowerBrokerPolished', 'Power Broker Polished', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_03c\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-76.49,\"y\":-826.80,\"z\":243.38}', 5000000),
592(53, 'LomBank', 'Lom Bank', '{\"x\":-1581.36,\"y\":-558.23,\"z\":34.07}', NULL, NULL, '{\"x\":-1583.60,\"y\":-555.12,\"z\":34.07}', '[]', NULL, 0, 0, 1, NULL, 0),
593(54, 'LBOldSpiceWarm', 'LB Old Spice Warm', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_01a\"]', 'LomBank', 0, 1, 0, '{\"x\":-1577.68,\"y\":-565.91,\"z\":108.52}', 3500000),
594(55, 'LBOldSpiceClassical', 'LB Old Spice Classical', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_01b\"]', 'LomBank', 0, 1, 0, '{\"x\":-1577.68,\"y\":-565.91,\"z\":108.52}', 3500000),
595(56, 'LBOldSpiceVintage', 'LB Old Spice Vintage', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_01c\"]', 'LomBank', 0, 1, 0, '{\"x\":-1577.68,\"y\":-565.91,\"z\":108.52}', 3500000),
596(57, 'LBExecutiveRich', 'LB Executive Rich', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_02b\"]', 'LomBank', 0, 1, 0, '{\"x\":-1577.68,\"y\":-565.91,\"z\":108.52}', 3500000),
597(58, 'LBExecutiveCool', 'LB Executive Cool', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_02c\"]', 'LomBank', 0, 1, 0, '{\"x\":-1577.68,\"y\":-565.91,\"z\":108.52}', 3500000),
598(59, 'LBExecutiveContrast', 'LB Executive Contrast', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_02a\"]', 'LomBank', 0, 1, 0, '{\"x\":-1577.68,\"y\":-565.91,\"z\":108.52}', 3500000),
599(60, 'LBPowerBrokerIce', 'LB Power Broker Ice', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_03a\"]', 'LomBank', 0, 1, 0, '{\"x\":-1577.68,\"y\":-565.91,\"z\":108.52}', 3500000),
600(61, 'LBPowerBrokerConservative', 'LB Power Broker Conservative', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_03b\"]', 'LomBank', 0, 1, 0, '{\"x\":-1577.68,\"y\":-565.91,\"z\":108.52}', 3500000),
601(62, 'LBPowerBrokerPolished', 'LB Power Broker Polished', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_03c\"]', 'LomBank', 0, 1, 0, '{\"x\":-1577.68,\"y\":-565.91,\"z\":108.52}', 3500000),
602(63, 'MazeBankWest', 'Maze Bank West', '{\"x\":-1379.58,\"y\":-499.63,\"z\":32.22}', NULL, NULL, '{\"x\":-1378.95,\"y\":-502.82,\"z\":32.22}', '[]', NULL, 0, 0, 1, NULL, 0),
603(64, 'MBWOldSpiceWarm', 'MBW Old Spice Warm', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_01a\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
604(65, 'MBWOldSpiceClassical', 'MBW Old Spice Classical', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_01b\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
605(66, 'MBWOldSpiceVintage', 'MBW Old Spice Vintage', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_01c\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
606(67, 'MBWExecutiveRich', 'MBW Executive Rich', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_02b\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
607(68, 'MBWExecutiveCool', 'MBW Executive Cool', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_02c\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
608(69, 'MBWExecutive Contrast', 'MBW Executive Contrast', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_02a\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
609(70, 'MBWPowerBrokerIce', 'MBW Power Broker Ice', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_03a\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
610(71, 'MBWPowerBrokerConvservative', 'MBW Power Broker Convservative', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_03b\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
611(72, 'MBWPowerBrokerPolished', 'MBW Power Broker Polished', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_03c\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000);
612
613-- --------------------------------------------------------
614
615--
616-- Structure de la table `rented_vehicles`
617--
618
619DROP TABLE IF EXISTS `rented_vehicles`;
620CREATE TABLE IF NOT EXISTS `rented_vehicles` (
621 `id` int(11) NOT NULL AUTO_INCREMENT,
622 `vehicle` varchar(60) NOT NULL,
623 `plate` varchar(10) NOT NULL,
624 `player_name` varchar(255) NOT NULL,
625 `base_price` int(11) NOT NULL,
626 `rent_price` int(11) NOT NULL,
627 `owner` varchar(255) NOT NULL,
628 PRIMARY KEY (`id`)
629) ENGINE=MyISAM DEFAULT CHARSET=latin1;
630
631-- --------------------------------------------------------
632
633--
634-- Structure de la table `shops`
635--
636
637DROP TABLE IF EXISTS `shops`;
638CREATE TABLE IF NOT EXISTS `shops` (
639 `id` int(11) NOT NULL AUTO_INCREMENT,
640 `name` varchar(255) NOT NULL,
641 `item` varchar(255) NOT NULL,
642 `price` int(11) NOT NULL,
643 PRIMARY KEY (`id`)
644) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
645
646--
647-- Déchargement des données de la table `shops`
648--
649
650INSERT INTO `shops` (`id`, `name`, `item`, `price`) VALUES
651(1, 'TwentyFourSeven', 'bread', 30),
652(2, 'TwentyFourSeven', 'water', 15),
653(3, 'RobsLiquor', 'bread', 30),
654(4, 'RobsLiquor', 'water', 15),
655(5, 'LTDgasoline', 'bread', 30),
656(6, 'LTDgasoline', 'water', 15);
657
658-- --------------------------------------------------------
659
660--
661-- Structure de la table `society_moneywash`
662--
663
664DROP TABLE IF EXISTS `society_moneywash`;
665CREATE TABLE IF NOT EXISTS `society_moneywash` (
666 `id` int(11) NOT NULL AUTO_INCREMENT,
667 `identifier` varchar(60) NOT NULL,
668 `society` varchar(60) NOT NULL,
669 `amount` int(11) NOT NULL,
670 PRIMARY KEY (`id`)
671) ENGINE=MyISAM DEFAULT CHARSET=latin1;
672
673-- --------------------------------------------------------
674
675--
676-- Structure de la table `users`
677--
678
679DROP TABLE IF EXISTS `users`;
680CREATE TABLE IF NOT EXISTS `users` (
681 `identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
682 `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
683 `money` int(11) DEFAULT NULL,
684 `name` varchar(255) COLLATE utf8mb4_bin DEFAULT '',
685 `skin` longtext COLLATE utf8mb4_bin,
686 `job` varchar(255) COLLATE utf8mb4_bin DEFAULT 'unemployed',
687 `job_grade` int(11) DEFAULT '0',
688 `loadout` longtext COLLATE utf8mb4_bin,
689 `position` varchar(255) COLLATE utf8mb4_bin DEFAULT '"x":-246.45198059082,"z":31.219995498657,"y":-943',
690 `bank` int(11) DEFAULT NULL,
691 `permission_level` int(11) DEFAULT NULL,
692 `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
693 `status` longtext COLLATE utf8mb4_bin,
694 `firstname` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
695 `lastname` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
696 `dateofbirth` varchar(25) COLLATE utf8mb4_bin DEFAULT '',
697 `sex` varchar(10) COLLATE utf8mb4_bin DEFAULT '',
698 `height` varchar(5) COLLATE utf8mb4_bin DEFAULT '',
699 `last_property` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
700 `phone_number` int(11) DEFAULT NULL
701) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
702
703--
704-- Déchargement des données de la table `users`
705--
706
707INSERT INTO `users` (`identifier`, `license`, `money`, `name`, `skin`, `job`, `job_grade`, `loadout`, `position`, `bank`, `permission_level`, `group`, `status`, `firstname`, `lastname`, `dateofbirth`, `sex`, `height`, `last_property`, `phone_number`) VALUES
708('steam:110000104e63496', 'license:570d9c35fa36b21f1dddb2598bc1f42424ac7615', 5700, 'John Ford', '{\"chain_1\":0,\"chain_2\":0,\"pants_2\":12,\"makeup_3\":0,\"pants_1\":9,\"bags_1\":0,\"torso_1\":98,\"shoes_2\":6,\"makeup_4\":0,\"skin\":0,\"lipstick_4\":0,\"helmet_1\":-1,\"ears_1\":-1,\"bproof_1\":0,\"tshirt_1\":15,\"decals_2\":0,\"lipstick_3\":0,\"beard_4\":0,\"glasses_1\":0,\"eyebrows_1\":0,\"age_1\":0,\"makeup_2\":0,\"eyebrows_2\":0,\"bproof_2\":0,\"glasses_2\":0,\"bags_2\":0,\"beard_2\":10,\"lipstick_2\":0,\"mask_2\":0,\"lipstick_1\":0,\"torso_2\":1,\"beard_3\":0,\"age_2\":0,\"hair_color_2\":0,\"shoes_1\":12,\"hair_1\":0,\"helmet_2\":0,\"decals_1\":0,\"mask_1\":0,\"tshirt_2\":0,\"beard_1\":10,\"eyebrows_3\":0,\"hair_color_1\":0,\"ears_2\":0,\"sex\":0,\"eyebrows_4\":0,\"arms\":16,\"face\":0,\"makeup_1\":0,\"hair_2\":0}', 'ambulance', 3, '[{\"name\":\"WEAPON_PISTOL\",\"label\":\"Pistolet\",\"ammo\":250},{\"name\":\"WEAPON_SMG\",\"label\":\"Smg\",\"ammo\":250},{\"name\":\"WEAPON_PUMPSHOTGUN\",\"label\":\"Fusil à pompe\",\"ammo\":250},{\"name\":\"WEAPON_SPECIALCARBINE\",\"label\":\"Carabine spéciale\",\"ammo\":250}]', '{\"z\":82.934219360352,\"y\":242.3426361084,\"x\":-548.77575683594}', 300, 3, 'superadmin', '[{\"name\":\"hunger\",\"val\":559400,\"percent\":55.94},{\"name\":\"thirst\",\"val\":448250,\"percent\":44.825}]', 'John', 'Ford', '04/06/1996', 'M', '85', NULL, 27396);
709
710-- --------------------------------------------------------
711
712--
713-- Structure de la table `user_accounts`
714--
715
716DROP TABLE IF EXISTS `user_accounts`;
717CREATE TABLE IF NOT EXISTS `user_accounts` (
718 `id` int(11) NOT NULL AUTO_INCREMENT,
719 `identifier` varchar(255) NOT NULL,
720 `name` varchar(255) NOT NULL,
721 `money` double NOT NULL DEFAULT '0',
722 PRIMARY KEY (`id`)
723) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
724
725--
726-- Déchargement des données de la table `user_accounts`
727--
728
729INSERT INTO `user_accounts` (`id`, `identifier`, `name`, `money`) VALUES
730(1, 'steam:110000104e63496', 'black_money', 0);
731
732-- --------------------------------------------------------
733
734--
735-- Structure de la table `user_contacts`
736--
737
738DROP TABLE IF EXISTS `user_contacts`;
739CREATE TABLE IF NOT EXISTS `user_contacts` (
740 `id` int(11) NOT NULL AUTO_INCREMENT,
741 `identifier` varchar(255) NOT NULL,
742 `name` varchar(255) NOT NULL,
743 `number` int(11) NOT NULL,
744 PRIMARY KEY (`id`)
745) ENGINE=MyISAM DEFAULT CHARSET=latin1;
746
747-- --------------------------------------------------------
748
749--
750-- Structure de la table `user_inventory`
751--
752
753DROP TABLE IF EXISTS `user_inventory`;
754CREATE TABLE IF NOT EXISTS `user_inventory` (
755 `id` int(11) NOT NULL AUTO_INCREMENT,
756 `identifier` varchar(255) NOT NULL,
757 `item` varchar(255) NOT NULL,
758 `count` int(11) NOT NULL,
759 PRIMARY KEY (`id`)
760) ENGINE=MyISAM AUTO_INCREMENT=140 DEFAULT CHARSET=latin1;
761
762--
763-- Déchargement des données de la table `user_inventory`
764--
765
766INSERT INTO `user_inventory` (`id`, `identifier`, `item`, `count`) VALUES
767(1, 'steam:110000104e63496', 'copper', 0),
768(2, 'steam:110000104e63496', 'diamond', 0),
769(3, 'steam:110000104e63496', 'clothe', 0),
770(4, 'steam:110000104e63496', 'alive_chicken', 0),
771(5, 'steam:110000104e63496', 'fabric', 0),
772(6, 'steam:110000104e63496', 'slaughtered_chicken', 0),
773(7, 'steam:110000104e63496', 'essence', 0),
774(8, 'steam:110000104e63496', 'fish', 0),
775(9, 'steam:110000104e63496', 'washed_stone', 0),
776(10, 'steam:110000104e63496', 'gold', 0),
777(11, 'steam:110000104e63496', 'iron', 0),
778(12, 'steam:110000104e63496', 'wood', 0),
779(13, 'steam:110000104e63496', 'packaged_plank', 0),
780(14, 'steam:110000104e63496', 'stone', 0),
781(15, 'steam:110000104e63496', 'petrol', 0),
782(16, 'steam:110000104e63496', 'cutted_wood', 0),
783(17, 'steam:110000104e63496', 'whool', 0),
784(18, 'steam:110000104e63496', 'packaged_chicken', 0),
785(19, 'steam:110000104e63496', 'petrol_raffin', 0),
786(22, 'steam:110000104e63496', 'bandage', 0),
787(20, 'steam:110000104e63496', 'bread', 3),
788(21, 'steam:110000104e63496', 'water', 5),
789(23, 'steam:110000104e63496', 'medikit', 0),
790(24, 'steam:11000010368fbea', 'petrol_raffin', 0),
791(25, 'steam:11000010368fbea', 'slaughtered_chicken', 0),
792(26, 'steam:11000010368fbea', 'petrol', 0),
793(27, 'steam:11000010368fbea', 'fabric', 0),
794(28, 'steam:11000010368fbea', 'diamond', 0),
795(29, 'steam:11000010368fbea', 'copper', 0),
796(30, 'steam:11000010368fbea', 'water', 0),
797(31, 'steam:11000010368fbea', 'alive_chicken', 0),
798(32, 'steam:11000010368fbea', 'gold', 0),
799(33, 'steam:11000010368fbea', 'washed_stone', 0),
800(34, 'steam:11000010368fbea', 'bread', 0),
801(35, 'steam:11000010368fbea', 'bandage', 0),
802(36, 'steam:11000010368fbea', 'cutted_wood', 0),
803(37, 'steam:11000010368fbea', 'medikit', 0),
804(38, 'steam:11000010368fbea', 'clothe', 0),
805(39, 'steam:11000010368fbea', 'whool', 0),
806(40, 'steam:11000010368fbea', 'iron', 0),
807(41, 'steam:11000010368fbea', 'essence', 0),
808(42, 'steam:11000010368fbea', 'packaged_chicken', 0),
809(43, 'steam:11000010368fbea', 'packaged_plank', 0),
810(44, 'steam:11000010368fbea', 'stone', 0),
811(45, 'steam:11000010368fbea', 'wood', 0),
812(46, 'steam:11000010368fbea', 'fish', 0),
813(47, 'steam:110000104b5fe96', 'copper', 0),
814(48, 'steam:110000104b5fe96', 'wood', 0),
815(49, 'steam:110000104b5fe96', 'packaged_chicken', 0),
816(50, 'steam:110000104b5fe96', 'slaughtered_chicken', 0),
817(51, 'steam:110000104b5fe96', 'clothe', 0),
818(52, 'steam:110000104b5fe96', 'essence', 0),
819(53, 'steam:110000104b5fe96', 'stone', 0),
820(54, 'steam:110000104b5fe96', 'fish', 0),
821(55, 'steam:110000104b5fe96', 'water', 22),
822(56, 'steam:110000104b5fe96', 'medikit', 0),
823(57, 'steam:110000104b5fe96', 'petrol_raffin', 0),
824(58, 'steam:110000104b5fe96', 'alive_chicken', 0),
825(59, 'steam:110000104b5fe96', 'iron', 0),
826(60, 'steam:110000104b5fe96', 'packaged_plank', 0),
827(61, 'steam:110000104b5fe96', 'bandage', 0),
828(62, 'steam:110000104b5fe96', 'gold', 0),
829(63, 'steam:110000104b5fe96', 'diamond', 0),
830(64, 'steam:110000104b5fe96', 'petrol', 0),
831(65, 'steam:110000104b5fe96', 'whool', 0),
832(66, 'steam:110000104b5fe96', 'fabric', 0),
833(67, 'steam:110000104b5fe96', 'washed_stone', 0),
834(68, 'steam:110000104b5fe96', 'cutted_wood', 0),
835(69, 'steam:110000104b5fe96', 'bread', 21),
836(70, 'steam:110000103f67018', 'bandage', 0),
837(71, 'steam:110000103f67018', 'water', 22),
838(72, 'steam:110000103f67018', 'cutted_wood', 0),
839(73, 'steam:110000103f67018', 'packaged_chicken', 0),
840(74, 'steam:110000103f67018', 'bread', 20),
841(75, 'steam:110000103f67018', 'washed_stone', 0),
842(76, 'steam:110000103f67018', 'essence', 0),
843(77, 'steam:110000103f67018', 'clothe', 0),
844(78, 'steam:110000103f67018', 'gold', 0),
845(79, 'steam:110000103f67018', 'diamond', 0),
846(80, 'steam:110000103f67018', 'copper', 0),
847(81, 'steam:110000103f67018', 'iron', 0),
848(82, 'steam:110000103f67018', 'alive_chicken', 0),
849(83, 'steam:110000103f67018', 'fabric', 0),
850(84, 'steam:110000103f67018', 'medikit', 0),
851(85, 'steam:110000103f67018', 'petrol_raffin', 0),
852(86, 'steam:110000103f67018', 'packaged_plank', 0),
853(87, 'steam:110000103f67018', 'wood', 0),
854(88, 'steam:110000103f67018', 'whool', 0),
855(89, 'steam:110000103f67018', 'stone', 0),
856(90, 'steam:110000103f67018', 'slaughtered_chicken', 0),
857(91, 'steam:110000103f67018', 'petrol', 0),
858(92, 'steam:110000103f67018', 'fish', 0),
859(93, 'steam:110000103c76dde', 'bread', 15),
860(94, 'steam:110000103c76dde', 'cutted_wood', 0),
861(95, 'steam:110000103c76dde', 'water', 14),
862(96, 'steam:110000103c76dde', 'bandage', 0),
863(97, 'steam:110000103c76dde', 'packaged_chicken', 0),
864(98, 'steam:110000103c76dde', 'essence', 0),
865(99, 'steam:110000103c76dde', 'diamond', 0),
866(100, 'steam:110000103c76dde', 'gold', 0),
867(101, 'steam:110000103c76dde', 'washed_stone', 0),
868(102, 'steam:110000103c76dde', 'clothe', 0),
869(103, 'steam:110000103c76dde', 'fabric', 0),
870(104, 'steam:110000103c76dde', 'iron', 0),
871(105, 'steam:110000103c76dde', 'medikit', 0),
872(106, 'steam:110000103c76dde', 'copper', 0),
873(107, 'steam:110000103c76dde', 'alive_chicken', 0),
874(108, 'steam:110000103c76dde', 'packaged_plank', 0),
875(109, 'steam:110000103c76dde', 'wood', 0),
876(110, 'steam:110000103c76dde', 'whool', 0),
877(111, 'steam:110000103c76dde', 'stone', 0),
878(112, 'steam:110000103c76dde', 'petrol_raffin', 0),
879(113, 'steam:110000103c76dde', 'slaughtered_chicken', 0),
880(114, 'steam:110000103c76dde', 'petrol', 0),
881(115, 'steam:110000103c76dde', 'fish', 0),
882(116, 'steam:1100001159380d5', 'water', 0),
883(117, 'steam:1100001159380d5', 'wood', 0),
884(118, 'steam:1100001159380d5', 'fish', 0),
885(119, 'steam:1100001159380d5', 'slaughtered_chicken', 0),
886(120, 'steam:1100001159380d5', 'alive_chicken', 0),
887(121, 'steam:1100001159380d5', 'iron', 0),
888(122, 'steam:1100001159380d5', 'packaged_plank', 0),
889(123, 'steam:1100001159380d5', 'cutted_wood', 0),
890(124, 'steam:1100001159380d5', 'diamond', 0),
891(125, 'steam:1100001159380d5', 'gold', 0),
892(126, 'steam:1100001159380d5', 'copper', 0),
893(127, 'steam:1100001159380d5', 'packaged_chicken', 0),
894(128, 'steam:1100001159380d5', 'whool', 0),
895(129, 'steam:1100001159380d5', 'bread', 0),
896(130, 'steam:1100001159380d5', 'petrol', 0),
897(131, 'steam:1100001159380d5', 'essence', 0),
898(132, 'steam:1100001159380d5', 'fabric', 0),
899(133, 'steam:1100001159380d5', 'clothe', 0),
900(134, 'steam:1100001159380d5', 'medikit', 0),
901(135, 'steam:1100001159380d5', 'washed_stone', 0),
902(136, 'steam:1100001159380d5', 'petrol_raffin', 0),
903(137, 'steam:1100001159380d5', 'bandage', 0),
904(138, 'steam:1100001159380d5', 'stone', 0),
905(139, 'steam:110000104e63496', 'jumelles', 1);
906
907-- --------------------------------------------------------
908
909--
910-- Structure de la table `user_licenses`
911--
912
913DROP TABLE IF EXISTS `user_licenses`;
914CREATE TABLE IF NOT EXISTS `user_licenses` (
915 `id` int(11) NOT NULL AUTO_INCREMENT,
916 `type` varchar(255) NOT NULL,
917 `owner` varchar(255) NOT NULL,
918 PRIMARY KEY (`id`)
919) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
920
921-- --------------------------------------------------------
922
923--
924-- Structure de la table `user_parkings`
925--
926
927DROP TABLE IF EXISTS `user_parkings`;
928CREATE TABLE IF NOT EXISTS `user_parkings` (
929 `id` int(11) NOT NULL AUTO_INCREMENT,
930 `identifier` varchar(60) DEFAULT NULL,
931 `garage` varchar(60) DEFAULT NULL,
932 `zone` int(11) NOT NULL,
933 `vehicle` longtext,
934 PRIMARY KEY (`id`)
935) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
936
937-- --------------------------------------------------------
938
939--
940-- Structure de la table `vehicles`
941--
942
943DROP TABLE IF EXISTS `vehicles`;
944CREATE TABLE IF NOT EXISTS `vehicles` (
945 `id` int(11) NOT NULL AUTO_INCREMENT,
946 `name` varchar(60) NOT NULL,
947 `model` varchar(60) NOT NULL,
948 `price` int(11) NOT NULL,
949 `category` varchar(60) DEFAULT NULL,
950 PRIMARY KEY (`id`)
951) ENGINE=MyISAM AUTO_INCREMENT=212 DEFAULT CHARSET=latin1;
952
953--
954-- Déchargement des données de la table `vehicles`
955--
956
957INSERT INTO `vehicles` (`id`, `name`, `model`, `price`, `category`) VALUES
958(1, 'Blade', 'blade', 15000, 'muscle'),
959(2, 'Buccaneer', 'buccaneer', 18000, 'muscle'),
960(3, 'Buccaneer Rider', 'buccaneer2', 24000, 'muscle'),
961(4, 'Chino', 'chino', 15000, 'muscle'),
962(5, 'Chino Luxe', 'chino2', 19000, 'muscle'),
963(6, 'Coquette BlackFin', 'coquette3', 55000, 'muscle'),
964(7, 'Dominator', 'dominator', 35000, 'muscle'),
965(8, 'Dukes', 'dukes', 28000, 'muscle'),
966(9, 'Gauntlet', 'gauntlet', 30000, 'muscle'),
967(10, 'Hotknife', 'hotknife', 125000, 'muscle'),
968(11, 'Faction', 'faction', 20000, 'muscle'),
969(12, 'Faction Rider', 'faction2', 30000, 'muscle'),
970(13, 'Faction XL', 'faction3', 40000, 'muscle'),
971(14, 'Nightshade', 'nightshade', 65000, 'muscle'),
972(15, 'Phoenix', 'phoenix', 12500, 'muscle'),
973(16, 'Picador', 'picador', 18000, 'muscle'),
974(17, 'Sabre Turbo', 'sabregt', 20000, 'muscle'),
975(18, 'Sabre GT', 'sabregt2', 25000, 'muscle'),
976(19, 'Slam Van', 'slamvan3', 11500, 'muscle'),
977(20, 'Tampa', 'tampa', 16000, 'muscle'),
978(21, 'Virgo', 'virgo', 14000, 'muscle'),
979(22, 'Vigero', 'vigero', 12500, 'muscle'),
980(23, 'Voodoo', 'voodoo', 7200, 'muscle'),
981(24, 'Blista', 'blista', 8000, 'compacts'),
982(25, 'Brioso R/A', 'brioso', 18000, 'compacts'),
983(26, 'Issi', 'issi2', 10000, 'compacts'),
984(27, 'Panto', 'panto', 10000, 'compacts'),
985(28, 'Prairie', 'prairie', 12000, 'compacts'),
986(29, 'Bison', 'bison', 45000, 'vans'),
987(30, 'Bobcat XL', 'bobcatxl', 32000, 'vans'),
988(31, 'Burrito', 'burrito3', 19000, 'vans'),
989(32, 'Burrito', 'gburrito2', 29000, 'vans'),
990(33, 'Camper', 'camper', 42000, 'vans'),
991(34, 'Gang Burrito', 'gburrito', 45000, 'vans'),
992(35, 'Journey', 'journey', 6500, 'vans'),
993(36, 'Minivan', 'minivan', 13000, 'vans'),
994(37, 'Moonbeam', 'moonbeam', 18000, 'vans'),
995(38, 'Moonbeam Rider', 'moonbeam2', 35000, 'vans'),
996(39, 'Paradise', 'paradise', 19000, 'vans'),
997(40, 'Rumpo', 'rumpo', 15000, 'vans'),
998(41, 'Rumpo Trail', 'rumpo3', 19500, 'vans'),
999(42, 'Surfer', 'surfer', 12000, 'vans'),
1000(43, 'Youga', 'youga', 10800, 'vans'),
1001(44, 'Youga Luxuary', 'youga2', 14500, 'vans'),
1002(45, 'Asea', 'asea', 5500, 'sedans'),
1003(46, 'Cognoscenti', 'cognoscenti', 55000, 'sedans'),
1004(47, 'Emperor', 'emperor', 8500, 'sedans'),
1005(48, 'Fugitive', 'fugitive', 12000, 'sedans'),
1006(49, 'Glendale', 'glendale', 6500, 'sedans'),
1007(50, 'Intruder', 'intruder', 7500, 'sedans'),
1008(51, 'Premier', 'premier', 8000, 'sedans'),
1009(52, 'Primo Custom', 'primo2', 14000, 'sedans'),
1010(53, 'Regina', 'regina', 5000, 'sedans'),
1011(54, 'Schafter', 'schafter2', 25000, 'sedans'),
1012(55, 'Stretch', 'stretch', 90000, 'sedans'),
1013(56, 'Super Diamond', 'superd', 130000, 'sedans'),
1014(57, 'Tailgater', 'tailgater', 30000, 'sedans'),
1015(58, 'Warrener', 'warrener', 4000, 'sedans'),
1016(59, 'Washington', 'washington', 9000, 'sedans'),
1017(60, 'Baller', 'baller2', 40000, 'suvs'),
1018(61, 'Baller Sport', 'baller3', 60000, 'suvs'),
1019(62, 'Cavalcade', 'cavalcade2', 55000, 'suvs'),
1020(63, 'Contender', 'contender', 70000, 'suvs'),
1021(64, 'Dubsta', 'dubsta', 45000, 'suvs'),
1022(65, 'Dubsta Luxuary', 'dubsta2', 60000, 'suvs'),
1023(66, 'Fhantom', 'fq2', 17000, 'suvs'),
1024(67, 'Grabger', 'granger', 50000, 'suvs'),
1025(68, 'Gresley', 'gresley', 47500, 'suvs'),
1026(69, 'Huntley S', 'huntley', 40000, 'suvs'),
1027(70, 'Landstalker', 'landstalker', 35000, 'suvs'),
1028(71, 'Mesa', 'mesa', 16000, 'suvs'),
1029(72, 'Mesa Trail', 'mesa3', 40000, 'suvs'),
1030(73, 'Patriot', 'patriot', 55000, 'suvs'),
1031(74, 'Radius', 'radi', 29000, 'suvs'),
1032(75, 'Rocoto', 'rocoto', 45000, 'suvs'),
1033(76, 'Seminole', 'seminole', 25000, 'suvs'),
1034(77, 'XLS', 'xls', 32000, 'suvs'),
1035(78, 'Btype', 'btype', 62000, 'sportsclassics'),
1036(79, 'Btype Luxe', 'btype3', 85000, 'sportsclassics'),
1037(80, 'Btype Hotroad', 'btype2', 155000, 'sportsclassics'),
1038(81, 'Casco', 'casco', 30000, 'sportsclassics'),
1039(82, 'Coquette Classic', 'coquette2', 40000, 'sportsclassics'),
1040(83, 'Manana', 'manana', 12800, 'sportsclassics'),
1041(84, 'Monroe', 'monroe', 55000, 'sportsclassics'),
1042(85, 'Pigalle', 'pigalle', 20000, 'sportsclassics'),
1043(86, 'Stinger', 'stinger', 80000, 'sportsclassics'),
1044(87, 'Stinger GT', 'stingergt', 75000, 'sportsclassics'),
1045(88, 'Stirling GT', 'feltzer3', 65000, 'sportsclassics'),
1046(89, 'Z-Type', 'ztype', 220000, 'sportsclassics'),
1047(90, 'Bifta', 'bifta', 12000, 'offroad'),
1048(91, 'Bf Injection', 'bfinjection', 16000, 'offroad'),
1049(92, 'Blazer', 'blazer', 6500, 'offroad'),
1050(93, 'Blazer Sport', 'blazer4', 8500, 'offroad'),
1051(94, 'Brawler', 'brawler', 45000, 'offroad'),
1052(95, 'Bubsta 6x6', 'dubsta3', 120000, 'offroad'),
1053(96, 'Dune Buggy', 'dune', 8000, 'offroad'),
1054(97, 'Guardian', 'guardian', 45000, 'offroad'),
1055(98, 'Rebel', 'rebel2', 35000, 'offroad'),
1056(99, 'Sandking', 'sandking', 55000, 'offroad'),
1057(100, 'The Liberator', 'monster', 210000, 'offroad'),
1058(101, 'Trophy Truck', 'trophytruck', 60000, 'offroad'),
1059(102, 'Trophy Truck Limited', 'trophytruck2', 80000, 'offroad'),
1060(103, 'Cognoscenti Cabrio', 'cogcabrio', 55000, 'coupes'),
1061(104, 'Exemplar', 'exemplar', 32000, 'coupes'),
1062(105, 'F620', 'f620', 40000, 'coupes'),
1063(106, 'Felon', 'felon', 42000, 'coupes'),
1064(107, 'Felon GT', 'felon2', 55000, 'coupes'),
1065(108, 'Jackal', 'jackal', 38000, 'coupes'),
1066(109, 'Oracle XS', 'oracle2', 35000, 'coupes'),
1067(110, 'Sentinel', 'sentinel', 32000, 'coupes'),
1068(111, 'Sentinel XS', 'sentinel2', 40000, 'coupes'),
1069(112, 'Windsor', 'windsor', 95000, 'coupes'),
1070(113, 'Windsor Drop', 'windsor2', 125000, 'coupes'),
1071(114, 'Zion', 'zion', 36000, 'coupes'),
1072(115, 'Zion Cabrio', 'zion2', 45000, 'coupes'),
1073(116, '9F', 'ninef', 65000, 'sports'),
1074(117, '9F Cabrio', 'ninef2', 80000, 'sports'),
1075(118, 'Alpha', 'alpha', 60000, 'sports'),
1076(119, 'Banshee', 'banshee', 70000, 'sports'),
1077(120, 'Bestia GTS', 'bestiagts', 55000, 'sports'),
1078(121, 'Buffalo', 'buffalo', 12000, 'sports'),
1079(122, 'Buffalo S', 'buffalo2', 20000, 'sports'),
1080(123, 'Carbonizzare', 'carbonizzare', 75000, 'sports'),
1081(124, 'Comet', 'comet2', 65000, 'sports'),
1082(125, 'Coquette', 'coquette', 65000, 'sports'),
1083(126, 'Drift Tampa', 'tampa2', 80000, 'sports'),
1084(127, 'Elegy', 'elegy2', 38500, 'sports'),
1085(128, 'Feltzer', 'feltzer2', 55000, 'sports'),
1086(129, 'Furore GT', 'furoregt', 45000, 'sports'),
1087(130, 'Fusilade', 'fusilade', 40000, 'sports'),
1088(131, 'Jester', 'jester', 65000, 'sports'),
1089(132, 'Jester(Racecar)', 'jester2', 135000, 'sports'),
1090(133, 'Khamelion', 'khamelion', 38000, 'sports'),
1091(134, 'Kuruma', 'kuruma', 30000, 'sports'),
1092(135, 'Lynx', 'lynx', 40000, 'sports'),
1093(136, 'Mamba', 'mamba', 70000, 'sports'),
1094(137, 'Massacro', 'massacro', 65000, 'sports'),
1095(138, 'Massacro(Racecar)', 'massacro2', 130000, 'sports'),
1096(139, 'Omnis', 'omnis', 35000, 'sports'),
1097(140, 'Penumbra', 'penumbra', 28000, 'sports'),
1098(141, 'Rapid GT', 'rapidgt', 35000, 'sports'),
1099(142, 'Rapid GT Convertible', 'rapidgt2', 45000, 'sports'),
1100(143, 'Schafter V12', 'schafter3', 50000, 'sports'),
1101(144, 'Seven 70', 'seven70', 39500, 'sports'),
1102(145, 'Sultan', 'sultan', 15000, 'sports'),
1103(146, 'Surano', 'surano', 50000, 'sports'),
1104(147, 'Tropos', 'tropos', 40000, 'sports'),
1105(148, 'Verlierer', 'verlierer2', 70000, 'sports'),
1106(149, 'Adder', 'adder', 900000, 'super'),
1107(150, 'Banshee 900R', 'banshee2', 255000, 'super'),
1108(151, 'Bullet', 'bullet', 90000, 'super'),
1109(152, 'Cheetah', 'cheetah', 375000, 'super'),
1110(153, 'Entity XF', 'entityxf', 425000, 'super'),
1111(154, 'ETR1', 'sheava', 220000, 'super'),
1112(155, 'FMJ', 'fmj', 185000, 'super'),
1113(156, 'Infernus', 'infernus', 180000, 'super'),
1114(157, 'Osiris', 'osiris', 160000, 'super'),
1115(158, 'Pfister', 'pfister811', 85000, 'super'),
1116(159, 'RE-7B', 'le7b', 325000, 'super'),
1117(160, 'Reaper', 'reaper', 150000, 'super'),
1118(161, 'Sultan RS', 'sultanrs', 65000, 'super'),
1119(162, 'T20', 't20', 300000, 'super'),
1120(163, 'Turismo R', 'turismor', 350000, 'super'),
1121(164, 'Tyrus', 'tyrus', 600000, 'super'),
1122(165, 'Vacca', 'vacca', 120000, 'super'),
1123(166, 'Voltic', 'voltic', 90000, 'super'),
1124(167, 'X80 Proto', 'prototipo', 2500000, 'super'),
1125(168, 'Zentorno', 'zentorno', 1500000, 'super'),
1126(169, 'Akuma', 'AKUMA', 7500, 'motorcycles'),
1127(170, 'Avarus', 'avarus', 18000, 'motorcycles'),
1128(171, 'Bagger', 'bagger', 13500, 'motorcycles'),
1129(172, 'Bati 801', 'bati', 12000, 'motorcycles'),
1130(173, 'Bati 801RR', 'bati2', 19000, 'motorcycles'),
1131(174, 'BF400', 'bf400', 6500, 'motorcycles'),
1132(175, 'BMX (velo)', 'bmx', 160, 'motorcycles'),
1133(176, 'Carbon RS', 'carbonrs', 18000, 'motorcycles'),
1134(177, 'Chimera', 'chimera', 38000, 'motorcycles'),
1135(178, 'Cliffhanger', 'cliffhanger', 9500, 'motorcycles'),
1136(179, 'Cruiser (velo)', 'cruiser', 510, 'motorcycles'),
1137(180, 'Daemon', 'daemon', 11500, 'motorcycles'),
1138(181, 'Daemon High', 'daemon2', 13500, 'motorcycles'),
1139(182, 'Defiler', 'defiler', 9800, 'motorcycles'),
1140(183, 'Double T', 'double', 28000, 'motorcycles'),
1141(184, 'Enduro', 'enduro', 5500, 'motorcycles'),
1142(185, 'Esskey', 'esskey', 4200, 'motorcycles'),
1143(186, 'Faggio', 'faggio', 1900, 'motorcycles'),
1144(187, 'Vespa', 'faggio2', 2800, 'motorcycles'),
1145(188, 'Fixter (velo)', 'fixter', 225, 'motorcycles'),
1146(189, 'Gargoyle', 'gargoyle', 16500, 'motorcycles'),
1147(190, 'Hakuchou', 'hakuchou', 31000, 'motorcycles'),
1148(191, 'Hakuchou Sport', 'hakuchou2', 55000, 'motorcycles'),
1149(192, 'Hexer', 'hexer', 12000, 'motorcycles'),
1150(193, 'Innovation', 'innovation', 23500, 'motorcycles'),
1151(194, 'Manchez', 'manchez', 5300, 'motorcycles'),
1152(195, 'Nemesis', 'nemesis', 5800, 'motorcycles'),
1153(196, 'Nightblade', 'nightblade', 35000, 'motorcycles'),
1154(197, 'PCJ-600', 'pcj', 6200, 'motorcycles'),
1155(198, 'Ruffian', 'ruffian', 6800, 'motorcycles'),
1156(199, 'Sanchez', 'sanchez', 5300, 'motorcycles'),
1157(200, 'Sanchez Sport', 'sanchez2', 5300, 'motorcycles'),
1158(201, 'Sanctus', 'sanctus', 25000, 'motorcycles'),
1159(202, 'Scorcher (velo)', 'scorcher', 280, 'motorcycles'),
1160(203, 'Sovereign', 'sovereign', 22000, 'motorcycles'),
1161(204, 'Shotaro Concept', 'shotaro', 320000, 'motorcycles'),
1162(205, 'Thrust', 'thrust', 24000, 'motorcycles'),
1163(206, 'Tri bike (velo)', 'tribike3', 520, 'motorcycles'),
1164(207, 'Vader', 'vader', 7200, 'motorcycles'),
1165(208, 'Vortex', 'vortex', 9800, 'motorcycles'),
1166(209, 'Woflsbane', 'wolfsbane', 9000, 'motorcycles'),
1167(210, 'Zombie', 'zombiea', 9500, 'motorcycles'),
1168(211, 'Zombie Luxuary', 'zombieb', 12000, 'motorcycles');
1169
1170-- --------------------------------------------------------
1171
1172--
1173-- Structure de la table `vehicle_categories`
1174--
1175
1176DROP TABLE IF EXISTS `vehicle_categories`;
1177CREATE TABLE IF NOT EXISTS `vehicle_categories` (
1178 `id` int(11) NOT NULL AUTO_INCREMENT,
1179 `name` varchar(60) NOT NULL,
1180 `label` varchar(60) NOT NULL,
1181 PRIMARY KEY (`id`)
1182) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
1183
1184--
1185-- Déchargement des données de la table `vehicle_categories`
1186--
1187
1188INSERT INTO `vehicle_categories` (`id`, `name`, `label`) VALUES
1189(1, 'compacts', 'Compacts'),
1190(2, 'coupes', 'Coupés'),
1191(3, 'sedans', 'Sedans'),
1192(4, 'sports', 'Sports'),
1193(5, 'sportsclassics', 'Sports Classics'),
1194(6, 'super', 'Super'),
1195(7, 'muscle', 'Muscle'),
1196(8, 'offroad', 'Off Road'),
1197(9, 'suvs', 'SUVs'),
1198(10, 'vans', 'Vans'),
1199(11, 'motorcycles', 'Motos');
1200
1201-- --------------------------------------------------------
1202
1203--
1204-- Structure de la table `weashops`
1205--
1206
1207DROP TABLE IF EXISTS `weashops`;
1208CREATE TABLE IF NOT EXISTS `weashops` (
1209 `id` int(11) NOT NULL AUTO_INCREMENT,
1210 `name` varchar(255) NOT NULL,
1211 `item` varchar(255) NOT NULL,
1212 `price` int(11) NOT NULL,
1213 PRIMARY KEY (`id`)
1214) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;
1215
1216--
1217-- Déchargement des données de la table `weashops`
1218--
1219
1220INSERT INTO `weashops` (`id`, `name`, `item`, `price`) VALUES
1221(1, 'GunShop', 'WEAPON_PISTOL', 2500),
1222(41, 'GunShop', 'WEAPON_KNIFE', 1000),
1223(42, 'GunShop', 'WEAPON_CROWBAR', 1000),
1224(9, 'GunShop', 'WEAPON_BAT', 1000),
1225(14, 'BlackWeashop', 'WEAPON_MICROSMG', 25000),
1226(16, 'BlackWeashop', 'WEAPON_PUMPSHOTGUN', 50000),
1227(18, 'BlackWeashop', 'WEAPON_ASSAULTRIFLE', 75000),
1228(35, 'BlackWeashop', 'WEAPON_APPISTOL', 7500);
1229COMMIT;
1230
1231/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1232/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1233/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;