· 5 years ago · May 09, 2020, 08:32 AM
1/* EsPlugin_Mysql */
2
3CREATE TABLE IF NOT EXISTS `users` (
4 `identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
5 `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
6 `money` int(11) DEFAULT NULL,
7 `bank` int(11) DEFAULT NULL,
8 `permission_level` int(11) DEFAULT NULL,
9 `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL
10) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
11
12
13
14/* Es Extended */
15ALTER TABLE `users`
16 ADD COLUMN `name` VARCHAR(50) NULL DEFAULT '' AFTER `money`,
17 ADD COLUMN `skin` LONGTEXT NULL AFTER `name`,
18 ADD COLUMN `job` VARCHAR(50) NULL DEFAULT 'unemployed' AFTER `skin`,
19 ADD COLUMN `job_grade` INT NULL DEFAULT 0 AFTER `job`,
20 ADD COLUMN `loadout` LONGTEXT NULL AFTER `job_grade`,
21 ADD COLUMN `position` VARCHAR(36) NULL AFTER `loadout`
22;
23
24CREATE TABLE `items` (
25 `name` VARCHAR(50) NOT NULL,
26 `label` VARCHAR(50) NOT NULL,
27 `weight` INT(11) NOT NULL DEFAULT 1,
28 `rare` TINYINT(1) NOT NULL DEFAULT 0,
29 `can_remove` TINYINT(1) NOT NULL DEFAULT 1,
30 `limit`VARCHAR(50) NOT NULL,
31
32 PRIMARY KEY (`name`)
33);
34
35CREATE TABLE `job_grades` (
36 `id` INT(11) NOT NULL AUTO_INCREMENT,
37 `job_name` VARCHAR(50) DEFAULT NULL,
38 `grade` INT(11) NOT NULL,
39 `name` VARCHAR(50) NOT NULL,
40 `label` VARCHAR(50) NOT NULL,
41 `salary` INT(11) NOT NULL,
42 `skin_male` LONGTEXT NOT NULL,
43 `skin_female` LONGTEXT NOT NULL,
44
45 PRIMARY KEY (`id`)
46);
47
48INSERT INTO `job_grades` VALUES (1,'unemployed',0,'unemployed',' ',200,'{}','{}');
49
50CREATE TABLE `jobs` (
51 `name` VARCHAR(50) NOT NULL,
52 `label` VARCHAR(50) DEFAULT NULL,
53
54 PRIMARY KEY (`name`)
55);
56
57INSERT INTO `jobs` VALUES ('unemployed','Unemployed');
58
59CREATE TABLE `user_accounts` (
60 `id` INT(11) NOT NULL AUTO_INCREMENT,
61 `identifier` VARCHAR(22) NOT NULL,
62 `name` VARCHAR(50) NOT NULL,
63 `money` INT(11) NOT NULL DEFAULT '0',
64
65 PRIMARY KEY (`id`)
66);
67
68CREATE TABLE `user_inventory` (
69 `id` INT(11) NOT NULL AUTO_INCREMENT,
70 `identifier` VARCHAR(22) NOT NULL,
71 `item` VARCHAR(50) NOT NULL,
72 `count` INT(11) NOT NULL,
73
74 PRIMARY KEY (`id`)
75);
76
77
78
79
80/*GcPhone-Base*/
81ALTER TABLE `users` ADD COLUMN `phone_number` VARCHAR(10) NULL;
82
83CREATE TABLE IF NOT EXISTS `phone_app_chat` (
84 `id` int(11) NOT NULL AUTO_INCREMENT,
85 `channel` varchar(20) NOT NULL,
86 `message` varchar(255) NOT NULL,
87 `time` timestamp NOT NULL DEFAULT current_timestamp(),
88 PRIMARY KEY (`id`)
89) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
90
91CREATE TABLE IF NOT EXISTS `phone_calls` (
92 `id` int(11) NOT NULL AUTO_INCREMENT,
93 `owner` varchar(10) NOT NULL COMMENT 'Num tel proprio',
94 `num` varchar(10) NOT NULL COMMENT 'Num reférence du contact',
95 `incoming` int(11) NOT NULL COMMENT 'Défini si on est à l''origine de l''appels',
96 `time` timestamp NOT NULL DEFAULT current_timestamp(),
97 `accepts` int(11) NOT NULL COMMENT 'Appels accepter ou pas',
98 PRIMARY KEY (`id`)
99) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8;
100
101
102CREATE TABLE IF NOT EXISTS `phone_messages` (
103 `id` int(11) NOT NULL AUTO_INCREMENT,
104 `transmitter` varchar(10) NOT NULL,
105 `receiver` varchar(10) NOT NULL,
106 `message` varchar(255) NOT NULL DEFAULT '0',
107 `time` timestamp NOT NULL DEFAULT current_timestamp(),
108 `isRead` int(11) NOT NULL DEFAULT 0,
109 `owner` int(11) NOT NULL DEFAULT 0,
110 PRIMARY KEY (`id`)
111) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=utf8;
112
113CREATE TABLE IF NOT EXISTS `phone_users_contacts` (
114 `id` int(11) NOT NULL AUTO_INCREMENT,
115 `identifier` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
116 `number` varchar(10) CHARACTER SET utf8mb4 DEFAULT NULL,
117 `display` varchar(64) CHARACTER SET utf8mb4 NOT NULL DEFAULT '-1',
118 PRIMARY KEY (`id`)
119) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
120
121
122
123
124/*GcPhone-Twitter*/
125
126CREATE TABLE IF NOT EXISTS `twitter_accounts` (
127 `id` int(11) NOT NULL AUTO_INCREMENT,
128 `username` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '0',
129 `password` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '0',
130 `avatar_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
131 PRIMARY KEY (`id`),
132 UNIQUE KEY `username` (`username`)
133) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
134
135CREATE TABLE IF NOT EXISTS `twitter_tweets` (
136 `id` int(11) NOT NULL AUTO_INCREMENT,
137 `authorId` int(11) NOT NULL,
138 `realUser` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
139 `message` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
140 `time` timestamp NOT NULL DEFAULT current_timestamp(),
141 `likes` int(11) NOT NULL DEFAULT 0,
142 PRIMARY KEY (`id`),
143 KEY `FK_twitter_tweets_twitter_accounts` (`authorId`),
144 CONSTRAINT `FK_twitter_tweets_twitter_accounts` FOREIGN KEY (`authorId`) REFERENCES `twitter_accounts` (`id`)
145) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
146
147CREATE TABLE IF NOT EXISTS `twitter_likes` (
148 `id` int(11) NOT NULL AUTO_INCREMENT,
149 `authorId` int(11) DEFAULT NULL,
150 `tweetId` int(11) DEFAULT NULL,
151 PRIMARY KEY (`id`),
152 KEY `FK_twitter_likes_twitter_accounts` (`authorId`),
153 KEY `FK_twitter_likes_twitter_tweets` (`tweetId`),
154 CONSTRAINT `FK_twitter_likes_twitter_accounts` FOREIGN KEY (`authorId`) REFERENCES `twitter_accounts` (`id`),
155 CONSTRAINT `FK_twitter_likes_twitter_tweets` FOREIGN KEY (`tweetId`) REFERENCES `twitter_tweets` (`id`) ON DELETE CASCADE
156) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
157
158
159
160/*Esx Status*/
161ALTER TABLE `users` ADD COLUMN `status` LONGTEXT NULL;
162
163
164/*Esx Basicneeds*/
165INSERT INTO `items` (`name`, `label`, `limit`) VALUES
166 ('bread', 'Pain', 10),
167 ('water', 'Eau', 5)
168;
169
170/*Esx Supermarket*/
171
172CREATE TABLE `shops` (
173 `id` int(11) NOT NULL AUTO_INCREMENT,
174 `store` varchar(100) NOT NULL,
175 `item` varchar(100) NOT NULL,
176 `price` int(11) NOT NULL,
177
178 PRIMARY KEY (`id`)
179);
180
181INSERT INTO `shops` (store, item, price) VALUES
182 ('TwentyFourSeven','bread',30),
183 ('TwentyFourSeven','water',15),
184 ('RobsLiquor','bread',30),
185 ('RobsLiquor','water',15),
186 ('LTDgasoline','bread',30),
187 ('LTDgasoline','water',15)
188;
189
190/*Esx Identity*/
191
192ALTER TABLE `users`
193 ADD COLUMN `firstname` VARCHAR(50) NULL DEFAULT '',
194 ADD COLUMN `lastname` VARCHAR(50) NULL DEFAULT '',
195 ADD COLUMN `dateofbirth` VARCHAR(25) NULL DEFAULT '',
196 ADD COLUMN `sex` VARCHAR(10) NULL DEFAULT '',
197 ADD COLUMN `height` VARCHAR(5) NULL DEFAULT ''
198;
199
200CREATE TABLE `characters` (
201 `id` int(11) NOT NULL AUTO_INCREMENT,
202 `identifier` VARCHAR(255) NOT NULL,
203 `firstname` VARCHAR(255) NOT NULL,
204 `lastname` VARCHAR(255) NOT NULL,
205 `dateofbirth` VARCHAR(255) NOT NULL,
206 `sex` VARCHAR(1) NOT NULL DEFAULT 'M',
207 `height` VARCHAR(128) NOT NULL,
208
209 PRIMARY KEY (`id`)
210);
211
212/*Esx Addonaccount*/
213
214CREATE TABLE `addon_account` (
215 `name` VARCHAR(60) NOT NULL,
216 `label` VARCHAR(100) NOT NULL,
217 `shared` INT(11) NOT NULL,
218
219 PRIMARY KEY (`name`)
220);
221
222CREATE TABLE `addon_account_data` (
223 `id` INT(11) NOT NULL AUTO_INCREMENT,
224 `account_name` VARCHAR(100) DEFAULT NULL,
225 `money` INT(11) NOT NULL,
226 `owner` VARCHAR(100) DEFAULT NULL,
227
228 PRIMARY KEY (`id`),
229 UNIQUE INDEX `index_addon_account_data_account_name_owner` (`account_name`, `owner`),
230 INDEX `index_addon_account_data_account_name` (`account_name`)
231);
232
233
234
235/*Esx Job*/
236
237INSERT INTO `addon_account` (name, label, shared) VALUES
238 ('caution', 'Caution', 0)
239;
240
241INSERT INTO `jobs` (name, label) VALUES
242 ('slaughterer', 'Abatteur'),
243 ('fisherman', 'Pêcheur'),
244 ('miner', 'Mineur'),
245 ('lumberjack', 'Bûcheron'),
246 ('fueler', 'Raffineur'),
247 ('reporter', 'Journaliste'),
248 ('tailor', 'Couturier')
249;
250
251INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
252 ('lumberjack', 0, 'employee', 'Intérim', 0, '{}', '{}'),
253 ('fisherman', 0, 'employee', 'Intérim', 0, '{}', '{}'),
254 ('fueler', 0, 'employee', 'Intérim', 0, '{}', '{}'),
255 ('reporter', 0, 'employee', 'Intérim', 0, '{}', '{}'),
256 ('tailor',0,'employee','Intérim',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}'),
257 ('miner', 0, 'employee', 'Intérim', 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}', '{}'),
258 ('slaughterer',0,'employee','Intérim',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}')
259;
260
261INSERT INTO `items` (`name`, `label`, `limit`) VALUES
262 ('alive_chicken', 'Poulet vivant', 20),
263 ('slaughtered_chicken', 'Poulet abattu', 20),
264 ('packaged_chicken', 'Poulet en barquette', 100),
265 ('fish', 'Poisson', 100),
266 ('stone', 'Pierre', 7),
267 ('washed_stone', 'Pierre Lavée', 7),
268 ('copper', 'Cuivre', 56),
269 ('iron', 'Fer', 42),
270 ('gold', 'Or', 21),
271 ('diamond', 'Diamant', 50),
272 ('wood', 'Bois', 20),
273 ('cutted_wood', 'Bois coupé', 20),
274 ('packaged_plank', 'Paquet de planches', 100),
275 ('petrol', 'Pétrole', 24),
276 ('petrol_raffin', 'Pétrole Raffiné', 24),
277 ('essence', 'Essence', 24),
278 ('wool', 'Laine', 40),
279 ('fabric', 'Tissu', 80),
280 ('clothe', 'Vêtement', 40)
281;
282
283/*Esx JobListing*/
284
285ALTER TABLE jobs add whitelisted BOOLEAN NOT NULL DEFAULT FALSE;
286
287/*Esx Drugs*/
288
289INSERT INTO `items` (name, label, `limit`) VALUES
290 ('weed', 'Weed', 50),
291 ('weed_pooch', 'Pochon de weed', 10),
292 ('coke', 'Coke', 50),
293 ('coke_pooch', 'Pochon de coke', 10),
294 ('meth', 'Meth', 50),
295 ('meth_pooch', 'Pochon de meth', 10),
296 ('opium', 'Opium', 50),
297 ('opium_pooch', 'Pochon de opium', 10)
298;
299
300
301
302/*Esx Addoninventory */
303
304CREATE TABLE `addon_inventory` (
305 `name` VARCHAR(60) NOT NULL,
306 `label` VARCHAR(100) NOT NULL,
307 `shared` INT(11) NOT NULL,
308
309 PRIMARY KEY (`name`)
310);
311
312CREATE TABLE `addon_inventory_items` (
313 `id` INT(11) NOT NULL AUTO_INCREMENT,
314 `inventory_name` VARCHAR(100) NOT NULL,
315 `name` VARCHAR(100) NOT NULL,
316 `count` INT(11) NOT NULL,
317 `owner` VARCHAR(60) DEFAULT NULL,
318
319 PRIMARY KEY (`id`),
320 INDEX `index_addon_inventory_items_inventory_name_name` (`inventory_name`, `name`),
321 INDEX `index_addon_inventory_items_inventory_name_name_owner` (`inventory_name`, `name`, `owner`),
322 INDEX `index_addon_inventory_inventory_name` (`inventory_name`)
323);
324
325
326
327/*Esx Datastore*/
328
329CREATE TABLE `datastore` (
330 `name` VARCHAR(60) NOT NULL,
331 `label` VARCHAR(100) NOT NULL,
332 `shared` INT(11) NOT NULL,
333
334 PRIMARY KEY (`name`)
335);
336
337CREATE TABLE `datastore_data` (
338 `id` INT(11) NOT NULL AUTO_INCREMENT,
339 `name` VARCHAR(60) NOT NULL,
340 `owner` VARCHAR(60),
341 `data` LONGTEXT,
342
343 PRIMARY KEY (`id`),
344 UNIQUE INDEX `index_datastore_data_name_owner` (`name`, `owner`),
345 INDEX `index_datastore_data_name` (`name`)
346);
347
348
349
350/*Esx License*/
351
352CREATE TABLE `licenses` (
353 `type` varchar(60) NOT NULL,
354 `label` varchar(60) NOT NULL,
355
356 PRIMARY KEY (`type`)
357);
358
359CREATE TABLE `user_licenses` (
360 `id` int(11) NOT NULL AUTO_INCREMENT,
361 `type` varchar(60) NOT NULL,
362 `owner` varchar(60) NOT NULL,
363
364 PRIMARY KEY (`id`)
365);
366
367
368
369/* Esx Billing*/
370
371CREATE TABLE `billing` (
372 `id` int(11) NOT NULL AUTO_INCREMENT,
373 `identifier` varchar(255) NOT NULL,
374 `sender` varchar(255) NOT NULL,
375 `target_type` varchar(50) NOT NULL,
376 `target` varchar(255) NOT NULL,
377 `label` varchar(255) NOT NULL,
378 `amount` int(11) NOT NULL,
379
380 PRIMARY KEY (`id`)
381);
382
383
384
385/*Esx PoliceJob */
386
387INSERT INTO `addon_account` (name, label, shared) VALUES
388 ('society_police', 'Police', 1)
389;
390
391INSERT INTO `datastore` (name, label, shared) VALUES
392 ('society_police', 'Police', 1)
393;
394
395INSERT INTO `addon_inventory` (name, label, shared) VALUES
396 ('society_police', 'Police', 1)
397;
398
399INSERT INTO `jobs` (name, label) VALUES
400 ('police','LSPD')
401;
402
403INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
404 ('police',0,'recruit','Recrue',20,'{}','{}'),
405 ('police',1,'officer','Officier',40,'{}','{}'),
406 ('police',2,'sergeant','Sergent',60,'{}','{}'),
407 ('police',3,'lieutenant','Lieutenant',85,'{}','{}'),
408 ('police',4,'boss','Commandant',100,'{}','{}')
409;
410
411CREATE TABLE `fine_types` (
412 `id` int(11) NOT NULL AUTO_INCREMENT,
413 `label` varchar(255) DEFAULT NULL,
414 `amount` int(11) DEFAULT NULL,
415 `category` int(11) DEFAULT NULL,
416
417 PRIMARY KEY (`id`)
418);
419
420INSERT INTO `fine_types` (label, amount, category) VALUES
421 ('Usage abusif du klaxon',30,0),
422 ('Franchir une ligne continue',40,0),
423 ('Circulation à contresens',250,0),
424 ('Demi-tour non autorisé',250,0),
425 ('Circulation hors-route',170,0),
426 ('Non-respect des distances de sécurité',30,0),
427 ('Arrêt dangereux / interdit',150,0),
428 ('Stationnement gênant / interdit',70,0),
429 ('Non respect de la priorité à droite',70,0),
430 ('Non-respect à un véhicule prioritaire',90,0),
431 ('Non-respect d\'un stop',105,0),
432 ('Non-respect d\'un feu rouge',130,0),
433 ('Dépassement dangereux',100,0),
434 ('Véhicule non en état',100,0),
435 ('Conduite sans permis',1500,0),
436 ('Délit de fuite',800,0),
437 ('Excès de vitesse < 5 kmh',90,0),
438 ('Excès de vitesse 5-15 kmh',120,0),
439 ('Excès de vitesse 15-30 kmh',180,0),
440 ('Excès de vitesse > 30 kmh',300,0),
441 ('Entrave de la circulation',110,1),
442 ('Dégradation de la voie publique',90,1),
443 ('Trouble à l\'ordre publique',90,1),
444 ('Entrave opération de police',130,1),
445 ('Insulte envers / entre civils',75,1),
446 ('Outrage à agent de police',110,1),
447 ('Menace verbale ou intimidation envers civil',90,1),
448 ('Menace verbale ou intimidation envers policier',150,1),
449 ('Manifestation illégale',250,1),
450 ('Tentative de corruption',1500,1),
451 ('Arme blanche sortie en ville',120,2),
452 ('Arme léthale sortie en ville',300,2),
453 ('Port d\'arme non autorisé (défaut de license)',600,2),
454 ('Port d\'arme illégal',700,2),
455 ('Pris en flag lockpick',300,2),
456 ('Vol de voiture',1800,2),
457 ('Vente de drogue',1500,2),
458 ('Fabriquation de drogue',1500,2),
459 ('Possession de drogue',650,2),
460 ('Prise d\'ôtage civil',1500,2),
461 ('Prise d\'ôtage agent de l\'état',2000,2),
462 ('Braquage particulier',650,2),
463 ('Braquage magasin',650,2),
464 ('Braquage de banque',1500,2),
465 ('Tir sur civil',2000,3),
466 ('Tir sur agent de l\'état',2500,3),
467 ('Tentative de meurtre sur civil',3000,3),
468 ('Tentative de meurtre sur agent de l\'état',5000,3),
469 ('Meurtre sur civil',10000,3),
470 ('Meurte sur agent de l\'état',30000,3),
471 ('Meurtre involontaire',1800,3),
472 ('Escroquerie à l\'entreprise',2000,2)
473;
474
475/*Esx Ambulance*/
476
477
478INSERT INTO `addon_account` (name, label, shared) VALUES
479 ('society_ambulance', 'Ambulance', 1)
480;
481
482INSERT INTO `addon_inventory` (name, label, shared) VALUES
483 ('society_ambulance', 'Ambulance', 1)
484;
485
486INSERT INTO `datastore` (name, label, shared) VALUES
487 ('society_ambulance', 'Ambulance', 1)
488;
489
490INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
491 ('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}'),
492 ('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}'),
493 ('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}'),
494 ('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}')
495;
496
497INSERT INTO `jobs` (name, label) VALUES
498 ('ambulance','Ambulance')
499;
500
501INSERT INTO `items` (name, label, `limit`) VALUES
502 ('bandage','Bandage', 20),
503 ('medikit','Medikit', 5)
504;
505
506ALTER TABLE `users`
507 ADD `is_dead` TINYINT(1) NULL DEFAULT '0'
508;
509
510
511
512/*Esx Vehicleshop*/
513
514INSERT INTO `addon_account` (name, label, shared) VALUES
515 ('society_cardealer','Concessionnaire',1)
516;
517
518INSERT INTO `addon_inventory` (name, label, shared) VALUES
519 ('society_cardealer','Concesionnaire',1)
520;
521
522INSERT INTO `jobs` (name, label) VALUES
523 ('cardealer','Concessionnaire')
524;
525
526INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
527 ('cardealer',0,'recruit','Recrue',10,'{}','{}'),
528 ('cardealer',1,'novice','Novice',25,'{}','{}'),
529 ('cardealer',2,'experienced','Experimente',40,'{}','{}'),
530 ('cardealer',3,'boss','Patron',0,'{}','{}')
531;
532
533CREATE TABLE `cardealer_vehicles` (
534 `id` int(11) NOT NULL AUTO_INCREMENT,
535 `vehicle` varchar(255) NOT NULL,
536 `price` int(11) NOT NULL,
537
538 PRIMARY KEY (`id`)
539);
540
541CREATE TABLE `vehicle_sold` (
542 `client` VARCHAR(50) NOT NULL,
543 `model` VARCHAR(50) NOT NULL,
544 `plate` VARCHAR(50) NOT NULL,
545 `soldby` VARCHAR(50) NOT NULL,
546 `date` VARCHAR(50) NOT NULL,
547
548 PRIMARY KEY (`plate`)
549);
550
551CREATE TABLE `owned_vehicles` (
552 `owner` varchar(22) NOT NULL,
553 `plate` varchar(12) NOT NULL,
554 `vehicle` longtext,
555 `type` VARCHAR(20) NOT NULL DEFAULT 'car',
556 `job` VARCHAR(20) NULL DEFAULT NULL,
557 `stored` TINYINT(1) NOT NULL DEFAULT '0',
558
559 PRIMARY KEY (`plate`)
560);
561
562CREATE TABLE `rented_vehicles` (
563 `vehicle` varchar(60) NOT NULL,
564 `plate` varchar(12) NOT NULL,
565 `player_name` varchar(255) NOT NULL,
566 `base_price` int(11) NOT NULL,
567 `rent_price` int(11) NOT NULL,
568 `owner` varchar(22) NOT NULL,
569
570 PRIMARY KEY (`plate`)
571);
572
573CREATE TABLE `vehicle_categories` (
574 `name` varchar(60) NOT NULL,
575 `label` varchar(60) NOT NULL,
576
577 PRIMARY KEY (`name`)
578);
579
580INSERT INTO `vehicle_categories` (name, label) VALUES
581 ('compacts','Compacts'),
582 ('coupes','Coupés'),
583 ('sedans','Sedans'),
584 ('sports','Sports'),
585 ('sportsclassics','Sports Classics'),
586 ('super','Super'),
587 ('muscle','Muscle'),
588 ('offroad','Off Road'),
589 ('suvs','SUVs'),
590 ('vans','Vans'),
591 ('motorcycles','Motos')
592;
593
594CREATE TABLE `vehicles` (
595 `name` varchar(60) NOT NULL,
596 `model` varchar(60) NOT NULL,
597 `price` int(11) NOT NULL,
598 `category` varchar(60) DEFAULT NULL,
599
600 PRIMARY KEY (`model`)
601);
602
603INSERT INTO `vehicles` (name, model, price, category) VALUES
604 ('Blade','blade',15000,'muscle'),
605 ('Buccaneer','buccaneer',18000,'muscle'),
606 ('Buccaneer Rider','buccaneer2',24000,'muscle'),
607 ('Chino','chino',15000,'muscle'),
608 ('Chino Luxe','chino2',19000,'muscle'),
609 ('Coquette BlackFin','coquette3',55000,'muscle'),
610 ('Dominator','dominator',35000,'muscle'),
611 ('Dukes','dukes',28000,'muscle'),
612 ('Gauntlet','gauntlet',30000,'muscle'),
613 ('Hotknife','hotknife',125000,'muscle'),
614 ('Faction','faction',20000,'muscle'),
615 ('Faction Rider','faction2',30000,'muscle'),
616 ('Faction XL','faction3',40000,'muscle'),
617 ('Nightshade','nightshade',65000,'muscle'),
618 ('Phoenix','phoenix',12500,'muscle'),
619 ('Picador','picador',18000,'muscle'),
620 ('Sabre Turbo','sabregt',20000,'muscle'),
621 ('Sabre GT','sabregt2',25000,'muscle'),
622 ('Slam Van','slamvan3',11500,'muscle'),
623 ('Tampa','tampa',16000,'muscle'),
624 ('Virgo','virgo',14000,'muscle'),
625 ('Vigero','vigero',12500,'muscle'),
626 ('Voodoo','voodoo',7200,'muscle'),
627 ('Blista','blista',8000,'compacts'),
628 ('Brioso R/A','brioso',18000,'compacts'),
629 ('Issi','issi2',10000,'compacts'),
630 ('Panto','panto',10000,'compacts'),
631 ('Prairie','prairie',12000,'compacts'),
632 ('Bison','bison',45000,'vans'),
633 ('Bobcat XL','bobcatxl',32000,'vans'),
634 ('Burrito','burrito3',19000,'vans'),
635 ('Burrito','gburrito2',29000,'vans'),
636 ('Camper','camper',42000,'vans'),
637 ('Gang Burrito','gburrito',45000,'vans'),
638 ('Journey','journey',6500,'vans'),
639 ('Minivan','minivan',13000,'vans'),
640 ('Moonbeam','moonbeam',18000,'vans'),
641 ('Moonbeam Rider','moonbeam2',35000,'vans'),
642 ('Paradise','paradise',19000,'vans'),
643 ('Rumpo','rumpo',15000,'vans'),
644 ('Rumpo Trail','rumpo3',19500,'vans'),
645 ('Surfer','surfer',12000,'vans'),
646 ('Youga','youga',10800,'vans'),
647 ('Youga Luxuary','youga2',14500,'vans'),
648 ('Asea','asea',5500,'sedans'),
649 ('Cognoscenti','cognoscenti',55000,'sedans'),
650 ('Emperor','emperor',8500,'sedans'),
651 ('Fugitive','fugitive',12000,'sedans'),
652 ('Glendale','glendale',6500,'sedans'),
653 ('Intruder','intruder',7500,'sedans'),
654 ('Premier','premier',8000,'sedans'),
655 ('Primo Custom','primo2',14000,'sedans'),
656 ('Regina','regina',5000,'sedans'),
657 ('Schafter','schafter2',25000,'sedans'),
658 ('Stretch','stretch',90000,'sedans'),
659 ('Super Diamond','superd',130000,'sedans'),
660 ('Tailgater','tailgater',30000,'sedans'),
661 ('Warrener','warrener',4000,'sedans'),
662 ('Washington','washington',9000,'sedans'),
663 ('Baller','baller2',40000,'suvs'),
664 ('Baller Sport','baller3',60000,'suvs'),
665 ('Cavalcade','cavalcade2',55000,'suvs'),
666 ('Contender','contender',70000,'suvs'),
667 ('Dubsta','dubsta',45000,'suvs'),
668 ('Dubsta Luxuary','dubsta2',60000,'suvs'),
669 ('Fhantom','fq2',17000,'suvs'),
670 ('Grabger','granger',50000,'suvs'),
671 ('Gresley','gresley',47500,'suvs'),
672 ('Huntley S','huntley',40000,'suvs'),
673 ('Landstalker','landstalker',35000,'suvs'),
674 ('Mesa','mesa',16000,'suvs'),
675 ('Mesa Trail','mesa3',40000,'suvs'),
676 ('Patriot','patriot',55000,'suvs'),
677 ('Radius','radi',29000,'suvs'),
678 ('Rocoto','rocoto',45000,'suvs'),
679 ('Seminole','seminole',25000,'suvs'),
680 ('XLS','xls',32000,'suvs'),
681 ('Btype','btype',62000,'sportsclassics'),
682 ('Btype Luxe','btype3',85000,'sportsclassics'),
683 ('Btype Hotroad','btype2',155000,'sportsclassics'),
684 ('Casco','casco',30000,'sportsclassics'),
685 ('Coquette Classic','coquette2',40000,'sportsclassics'),
686 ('Manana','manana',12800,'sportsclassics'),
687 ('Monroe','monroe',55000,'sportsclassics'),
688 ('Pigalle','pigalle',20000,'sportsclassics'),
689 ('Stinger','stinger',80000,'sportsclassics'),
690 ('Stinger GT','stingergt',75000,'sportsclassics'),
691 ('Stirling GT','feltzer3',65000,'sportsclassics'),
692 ('Z-Type','ztype',220000,'sportsclassics'),
693 ('Bifta','bifta',12000,'offroad'),
694 ('Bf Injection','bfinjection',16000,'offroad'),
695 ('Blazer','blazer',6500,'offroad'),
696 ('Blazer Sport','blazer4',8500,'offroad'),
697 ('Brawler','brawler',45000,'offroad'),
698 ('Bubsta 6x6','dubsta3',120000,'offroad'),
699 ('Dune Buggy','dune',8000,'offroad'),
700 ('Guardian','guardian',45000,'offroad'),
701 ('Rebel','rebel2',35000,'offroad'),
702 ('Sandking','sandking',55000,'offroad'),
703 ('The Liberator','monster',210000,'offroad'),
704 ('Trophy Truck','trophytruck',60000,'offroad'),
705 ('Trophy Truck Limited','trophytruck2',80000,'offroad'),
706 ('Cognoscenti Cabrio','cogcabrio',55000,'coupes'),
707 ('Exemplar','exemplar',32000,'coupes'),
708 ('F620','f620',40000,'coupes'),
709 ('Felon','felon',42000,'coupes'),
710 ('Felon GT','felon2',55000,'coupes'),
711 ('Jackal','jackal',38000,'coupes'),
712 ('Oracle XS','oracle2',35000,'coupes'),
713 ('Sentinel','sentinel',32000,'coupes'),
714 ('Sentinel XS','sentinel2',40000,'coupes'),
715 ('Windsor','windsor',95000,'coupes'),
716 ('Windsor Drop','windsor2',125000,'coupes'),
717 ('Zion','zion',36000,'coupes'),
718 ('Zion Cabrio','zion2',45000,'coupes'),
719 ('9F','ninef',65000,'sports'),
720 ('9F Cabrio','ninef2',80000,'sports'),
721 ('Alpha','alpha',60000,'sports'),
722 ('Banshee','banshee',70000,'sports'),
723 ('Bestia GTS','bestiagts',55000,'sports'),
724 ('Buffalo','buffalo',12000,'sports'),
725 ('Buffalo S','buffalo2',20000,'sports'),
726 ('Carbonizzare','carbonizzare',75000,'sports'),
727 ('Comet','comet2',65000,'sports'),
728 ('Coquette','coquette',65000,'sports'),
729 ('Drift Tampa','tampa2',80000,'sports'),
730 ('Elegy','elegy2',38500,'sports'),
731 ('Feltzer','feltzer2',55000,'sports'),
732 ('Furore GT','furoregt',45000,'sports'),
733 ('Fusilade','fusilade',40000,'sports'),
734 ('Jester','jester',65000,'sports'),
735 ('Jester(Racecar)','jester2',135000,'sports'),
736 ('Khamelion','khamelion',38000,'sports'),
737 ('Kuruma','kuruma',30000,'sports'),
738 ('Lynx','lynx',40000,'sports'),
739 ('Mamba','mamba',70000,'sports'),
740 ('Massacro','massacro',65000,'sports'),
741 ('Massacro(Racecar)','massacro2',130000,'sports'),
742 ('Omnis','omnis',35000,'sports'),
743 ('Penumbra','penumbra',28000,'sports'),
744 ('Rapid GT','rapidgt',35000,'sports'),
745 ('Rapid GT Convertible','rapidgt2',45000,'sports'),
746 ('Schafter V12','schafter3',50000,'sports'),
747 ('Seven 70','seven70',39500,'sports'),
748 ('Sultan','sultan',15000,'sports'),
749 ('Surano','surano',50000,'sports'),
750 ('Tropos','tropos',40000,'sports'),
751 ('Verlierer','verlierer2',70000,'sports'),
752 ('Adder','adder',900000,'super'),
753 ('Banshee 900R','banshee2',255000,'super'),
754 ('Bullet','bullet',90000,'super'),
755 ('Cheetah','cheetah',375000,'super'),
756 ('Entity XF','entityxf',425000,'super'),
757 ('ETR1','sheava',220000,'super'),
758 ('FMJ','fmj',185000,'super'),
759 ('Infernus','infernus',180000,'super'),
760 ('Osiris','osiris',160000,'super'),
761 ('Pfister','pfister811',85000,'super'),
762 ('RE-7B','le7b',325000,'super'),
763 ('Reaper','reaper',150000,'super'),
764 ('Sultan RS','sultanrs',65000,'super'),
765 ('T20','t20',300000,'super'),
766 ('Turismo R','turismor',350000,'super'),
767 ('Tyrus','tyrus',600000,'super'),
768 ('Vacca','vacca',120000,'super'),
769 ('Voltic','voltic',90000,'super'),
770 ('X80 Proto','prototipo',2500000,'super'),
771 ('Zentorno','zentorno',1500000,'super'),
772 ('Akuma','AKUMA',7500,'motorcycles'),
773 ('Avarus','avarus',18000,'motorcycles'),
774 ('Bagger','bagger',13500,'motorcycles'),
775 ('Bati 801','bati',12000,'motorcycles'),
776 ('Bati 801RR','bati2',19000,'motorcycles'),
777 ('BF400','bf400',6500,'motorcycles'),
778 ('BMX (velo)','bmx',160,'motorcycles'),
779 ('Carbon RS','carbonrs',18000,'motorcycles'),
780 ('Chimera','chimera',38000,'motorcycles'),
781 ('Cliffhanger','cliffhanger',9500,'motorcycles'),
782 ('Cruiser (velo)','cruiser',510,'motorcycles'),
783 ('Daemon','daemon',11500,'motorcycles'),
784 ('Daemon High','daemon2',13500,'motorcycles'),
785 ('Defiler','defiler',9800,'motorcycles'),
786 ('Double T','double',28000,'motorcycles'),
787 ('Enduro','enduro',5500,'motorcycles'),
788 ('Esskey','esskey',4200,'motorcycles'),
789 ('Faggio','faggio',1900,'motorcycles'),
790 ('Vespa','faggio2',2800,'motorcycles'),
791 ('Fixter (velo)','fixter',225,'motorcycles'),
792 ('Gargoyle','gargoyle',16500,'motorcycles'),
793 ('Hakuchou','hakuchou',31000,'motorcycles'),
794 ('Hakuchou Sport','hakuchou2',55000,'motorcycles'),
795 ('Hexer','hexer',12000,'motorcycles'),
796 ('Innovation','innovation',23500,'motorcycles'),
797 ('Manchez','manchez',5300,'motorcycles'),
798 ('Nemesis','nemesis',5800,'motorcycles'),
799 ('Nightblade','nightblade',35000,'motorcycles'),
800 ('PCJ-600','pcj',6200,'motorcycles'),
801 ('Ruffian','ruffian',6800,'motorcycles'),
802 ('Sanchez','sanchez',5300,'motorcycles'),
803 ('Sanchez Sport','sanchez2',5300,'motorcycles'),
804 ('Sanctus','sanctus',25000,'motorcycles'),
805 ('Scorcher (velo)','scorcher',280,'motorcycles'),
806 ('Sovereign','sovereign',22000,'motorcycles'),
807 ('Shotaro Concept','shotaro',320000,'motorcycles'),
808 ('Thrust','thrust',24000,'motorcycles'),
809 ('Tri bike (velo)','tribike3',520,'motorcycles'),
810 ('Vader','vader',7200,'motorcycles'),
811 ('Vortex','vortex',9800,'motorcycles'),
812 ('Woflsbane','wolfsbane',9000,'motorcycles'),
813 ('Zombie','zombiea',9500,'motorcycles'),
814 ('Zombie Luxuary','zombieb',12000,'motorcycles'),
815 ('blazer5', 'blazer5', 1755600, 'offroad'),
816 ('Ruiner 2', 'ruiner2', 5745600, 'muscle'),
817 ('Voltic 2', 'voltic2', 3830400, 'super'),
818 ('Ardent', 'ardent', 1150000, 'sportsclassics'),
819 ('Oppressor', 'oppressor', 3524500, 'super'),
820 ('Visione', 'visione', 2250000, 'super'),
821 ('Retinue', 'retinue', 615000, 'sportsclassics'),
822 ('Cyclone', 'cyclone', 1890000, 'super'),
823 ('Rapid GT3', 'rapidgt3', 885000, 'sportsclassics'),
824 ('raiden', 'raiden', 1375000, 'sports'),
825 ('Yosemite', 'yosemite', 485000, 'muscle'),
826 ('Deluxo', 'deluxo', 4721500, 'sportsclassics'),
827 ('Pariah', 'pariah', 1420000, 'sports'),
828 ('Stromberg', 'stromberg', 3185350, 'sports'),
829 ('SC 1', 'sc1', 1603000, 'super'),
830 ('riata', 'riata', 380000, 'offroad'),
831 ('Hermes', 'hermes', 535000, 'muscle'),
832 ('Savestra', 'savestra', 990000, 'sportsclassics'),
833 ('Streiter', 'streiter', 500000, 'sports'),
834 ('Kamacho', 'kamacho', 345000, 'offroad'),
835 ('GT 500', 'gt500', 785000, 'sportsclassics'),
836 ('Z190', 'z190', 900000, 'sportsclassics'),
837 ('Viseris', 'viseris', 875000, 'sportsclassics'),
838 ('Autarch', 'autarch', 1955000, 'super'),
839 ('Comet 5', 'comet5', 1145000, 'sports'),
840 ('Neon', 'neon', 1500000, 'sports'),
841 ('Revolter', 'revolter', 1610000, 'sports'),
842 ('Sentinel3', 'sentinel3', 650000, 'sports'),
843 ('Hustler', 'hustler', 625000, 'muscle')
844;
845
846/*Esx Vehiclelock*/
847CREATE TABLE IF NOT EXISTS `open_car` (
848 `id` int(11) NOT NULL AUTO_INCREMENT,
849 `identifier` varchar(255) DEFAULT NULL,
850 `label` varchar(255) DEFAULT NULL,
851 `value` varchar(50) DEFAULT NULL,
852 `got` varchar(50) DEFAULT NULL,
853 `NB` int(11) DEFAULT '0',
854 PRIMARY KEY (`id`)
855) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;
856
857/*Esx Garage2*/
858
859ALTER TABLE `owned_vehicles` ADD `state` BOOLEAN NOT NULL DEFAULT FALSE COMMENT 'Etat de la voiture' AFTER `owner`;
860
861DROP TABLE IF EXISTS `owned_vehicles`;
862CREATE TABLE IF NOT EXISTS `owned_vehicles` (
863 `vehicle` longtext NOT NULL,
864 `owner` varchar(60) NOT NULL,
865 `stored` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Etat de la voiture',
866 `garage_name` varchar(50) NOT NULL DEFAULT 'Garage_Centre',
867 `fourrieremecano` tinyint(1) NOT NULL DEFAULT '0',
868 `vehiclename` varchar(50) NOT NULL DEFAULT 'voiture',
869 `plate` varchar(50) NOT NULL,
870 `type` varchar(10) NOT NULL DEFAULT 'car',
871 `job` varchar(50),
872 PRIMARY KEY (`plate`),
873 KEY `vehsowned` (`owner`)
874) ENGINE=InnoDB DEFAULT CHARSET=latin1;
875COMMIT;
876
877/*Esx MechanicJob*/
878
879INSERT INTO `addon_account` (name, label, shared) VALUES
880 ('society_mechanic', 'Mécano', 1)
881;
882
883INSERT INTO `addon_inventory` (name, label, shared) VALUES
884 ('society_mechanic', 'Mécano', 1)
885;
886
887INSERT INTO `jobs` (name, label) VALUES
888 ('mechanic', 'Mécano')
889;
890
891INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
892 ('mechanic',0,'recrue','Recrue',12,'{}','{}'),
893 ('mechanic',1,'novice','Novice',24,'{}','{}'),
894 ('mechanic',2,'experimente','Experimente',36,'{}','{}'),
895 ('mechanic',3,'chief',"Chef d\'équipe",48,'{}','{}'),
896 ('mechanic',4,'boss','Patron',0,'{}','{}')
897;
898
899INSERT INTO `items` (name, label, weight) VALUES
900 ('gazbottle', 'bouteille de gaz', 2),
901 ('fixtool', 'outils réparation', 2),
902 ('carotool', 'outils carosserie', 2),
903 ('blowpipe', 'Chalumeaux', 2),
904 ('fixkit', 'Kit réparation', 3),
905 ('carokit', 'Kit carosserie', 3)
906;
907
908/*Esx Property*/
909
910ALTER TABLE `users`
911 ADD COLUMN `last_property` VARCHAR(255) NULL
912;
913
914INSERT INTO `addon_account` (name, label, shared) VALUES
915 ('property_black_money','Argent Sale Propriété',0)
916;
917
918INSERT INTO `addon_inventory` (name, label, shared) VALUES
919 ('property','Propriété',0)
920;
921
922INSERT INTO `datastore` (name, label, shared) VALUES
923 ('property','Propriété',0)
924;
925
926CREATE TABLE `owned_properties` (
927
928 `id` int(11) NOT NULL AUTO_INCREMENT,
929 `name` varchar(255) NOT NULL,
930 `price` double NOT NULL,
931 `rented` int(11) NOT NULL,
932 `owner` varchar(60) NOT NULL,
933
934 PRIMARY KEY (`id`)
935);
936
937CREATE TABLE `properties` (
938
939 `id` int(11) NOT NULL AUTO_INCREMENT,
940 `name` varchar(255) DEFAULT NULL,
941 `label` varchar(255) DEFAULT NULL,
942 `entering` varchar(255) DEFAULT NULL,
943 `exit` varchar(255) DEFAULT NULL,
944 `inside` varchar(255) DEFAULT NULL,
945 `outside` varchar(255) DEFAULT NULL,
946 `ipls` varchar(255) DEFAULT '[]',
947 `gateway` varchar(255) DEFAULT NULL,
948 `is_single` int(11) DEFAULT NULL,
949 `is_room` int(11) DEFAULT NULL,
950 `is_gateway` int(11) DEFAULT NULL,
951 `room_menu` varchar(255) DEFAULT NULL,
952 `price` int(11) NOT NULL,
953
954 PRIMARY KEY (`id`)
955);
956
957INSERT INTO `properties` VALUES
958 (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),
959 (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),
960 (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),
961 (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),
962 (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),
963 (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),
964 (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),
965 (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),
966 (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),
967 (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),
968 (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),
969 (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),
970 (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),
971 (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),
972 (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),
973 (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),
974 (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),
975 (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),
976 (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),
977 (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),
978 (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),
979 (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),
980 (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),
981 (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),
982 (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),
983 (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),
984 (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),
985 (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),
986 (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),
987 (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),
988 (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),
989 (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),
990 (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),
991 (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),
992 (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),
993 (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),
994 (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),
995 (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),
996 (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),
997 (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),
998 (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),
999 (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)
1000;
1001
1002/*Esx RealestateagentJob*/
1003
1004INSERT INTO `addon_account` (name, label, shared) VALUES
1005 ('society_realestateagent','Agent immobilier',1)
1006;
1007
1008INSERT INTO `jobs` (name, label) VALUES
1009 ('realestateagent','Agent immobilier')
1010;
1011
1012INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
1013 ('realestateagent',0,'location','Location',10,'{}','{}'),
1014 ('realestateagent',1,'vendeur','Vendeur',25,'{}','{}'),
1015 ('realestateagent',2,'gestion','Gestion',40,'{}','{}'),
1016 ('realestateagent',3,'boss','Patron',0,'{}','{}')
1017;
1018
1019
1020/*Esx Accessories*/
1021INSERT INTO `datastore` (name, label, shared) VALUES
1022 ('user_ears', 'Ears', 0),
1023 ('user_glasses', 'Glasses', 0),
1024 ('user_helmet', 'Helmet', 0),
1025 ('user_mask', 'Mask', 0)
1026;
1027
1028/*Esx Weaponshop*/
1029
1030CREATE TABLE `weashops` (
1031 `id` int(11) NOT NULL AUTO_INCREMENT,
1032 `zone` varchar(255) NOT NULL,
1033 `item` varchar(255) NOT NULL,
1034 `price` int(11) NOT NULL,
1035
1036 PRIMARY KEY (`id`)
1037);
1038
1039INSERT INTO `licenses` (`type`, `label`) VALUES
1040 ('weapon', "Permis de port d'arme")
1041;
1042
1043INSERT INTO `weashops` (`zone`, `item`, `price`) VALUES
1044 ('GunShop','WEAPON_PISTOL', 300),
1045 ('BlackWeashop','WEAPON_PISTOL', 500),
1046 ('GunShop', 'WEAPON_FLASHLIGHT', 60),
1047 ('BlackWeashop', 'WEAPON_FLASHLIGHT', 70),
1048 ('BlackWeashop', 'WEAPON_MACHETE', 110),
1049 ('BlackWeashop', 'WEAPON_BAT', 100),
1050 ('BlackWeashop', 'WEAPON_MICROSMG', 1700),
1051 ('BlackWeashop', 'WEAPON_PUMPSHOTGUN', 3500),
1052 ('BlackWeashop', 'WEAPON_ASSAULTRIFLE', 11000),
1053 ('BlackWeashop', 'WEAPON_SPECIALCARBINE', 16500),
1054 ('BlackWeashop', 'WEAPON_SNIPERRIFLE', 24000),
1055 ('BlackWeashop', 'WEAPON_GRENADE', 650),
1056 ('GunShop', 'WEAPON_FIREEXTINGUISHER', 100),
1057 ('BlackWeashop', 'WEAPON_APPISTOL', 1100),
1058 ('BlackWeashop', 'WEAPON_CARBINERIFLE', 12000),
1059 ('BlackWeashop', 'WEAPON_HEAVYSNIPER', 30000)
1060
1061;
1062
1063/*Esx Tattooshop*/
1064
1065ALTER TABLE `users`
1066 ADD COLUMN `tattoos` LONGTEXT
1067;
1068
1069/*Esx Dmvschool*/
1070
1071INSERT INTO `licenses` (`type`, `label`) VALUES
1072 ('dmv', 'Code de la route'),
1073 ('drive', 'Permis de conduire'),
1074 ('drive_bike', 'Permis moto'),
1075 ('drive_truck', 'Permis camion')
1076;
1077
1078/*Esx Organisation*/
1079
1080ALTER TABLE `users`
1081 ADD COLUMN `org` varchar(50) NULL DEFAULT 'rsa' AFTER `job_grade`,
1082 ADD COLUMN `org_gradeorg` INT NULL DEFAULT 0 AFTER `org`
1083;
1084
1085
1086CREATE TABLE `organisation_moneywash` (
1087
1088 `id` int(11) NOT NULL AUTO_INCREMENT,
1089 `identifier` varchar(60) NOT NULL,
1090 `organisation` varchar(60) NOT NULL,
1091 `amount` int(11) NOT NULL,
1092
1093 PRIMARY KEY (`id`)
1094);
1095
1096
1097/*Es extended2*/
1098
1099CREATE TABLE `org_gradeorg` (
1100 `id` int(11) NOT NULL AUTO_INCREMENT,
1101 `org_name` varchar(50) DEFAULT NULL,
1102 `gradeorg` int(11) NOT NULL,
1103 `name` varchar(50) NOT NULL,
1104 `label` varchar(50) NOT NULL,
1105 `salary` int(11) NOT NULL,
1106 `skin_male` longtext NOT NULL,
1107 `skin_female` longtext NOT NULL,
1108
1109 PRIMARY KEY (`id`)
1110);
1111
1112INSERT INTO `org_gradeorg` VALUES (1,'rsa',0,'rsa','RSA',200,'{}','{}');
1113
1114CREATE TABLE `org` (
1115 `name` varchar(50) NOT NULL,
1116 `label` varchar(50) DEFAULT NULL,
1117
1118 PRIMARY KEY (`name`)
1119);
1120
1121INSERT INTO `org` VALUES ('rsa','Chômeur');
1122
1123
1124
1125
1126
1127
1128
1129/*Esx BallasJob*/
1130
1131INSERT INTO `addon_account` (name, label, shared) VALUES
1132 ('organisation_ballas','ballas',1)
1133;
1134
1135INSERT INTO `datastore` (name, label, shared) VALUES
1136 ('organisation_ballas','ballas',1)
1137;
1138
1139INSERT INTO `addon_inventory` (name, label, shared) VALUES
1140 ('organisation_ballas', 'ballas', 1)
1141;
1142
1143INSERT INTO `org` (`name`, `label`) VALUES
1144('ballas', 'ballas');
1145
1146
1147INSERT INTO `org_gradeorg` (`org_name`, `gradeorg`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
1148('ballas', 0, 'soldato', 'Ptite-Frappe', 1500, '{}', '{}'),
1149('ballas', 1, 'capo', 'Capo', 1800, '{}', '{}'),
1150('ballas', 2, 'consigliere', 'Chef', 2100, '{}', '{}'),
1151('ballas', 3, 'boss', 'Patron', 2700, '{}', '{}');
1152
1153CREATE TABLE `fine_types_ballas` (
1154
1155 `id` int(11) NOT NULL AUTO_INCREMENT,
1156 `label` varchar(255) DEFAULT NULL,
1157 `amount` int(11) DEFAULT NULL,
1158 `category` int(11) DEFAULT NULL,
1159
1160 PRIMARY KEY (`id`)
1161);
1162
1163INSERT INTO `fine_types_ballas` (label, amount, category) VALUES
1164 ('Raket',3000,0),
1165 ('Raket',5000,0),
1166 ('Raket',10000,1),
1167 ('Raket',20000,1),
1168 ('Raket',50000,2),
1169 ('Raket',150000,3),
1170 ('Raket',350000,3)
1171;
1172
1173/*Esx Tabac*/
1174
1175INSERT INTO `addon_account` (name, label, shared) VALUES
1176 ('society_tabac','Tabac',1)
1177;
1178
1179INSERT INTO `datastore` (name, label, shared) VALUES
1180 ('society_tabac','Tabac',1)
1181;
1182
1183INSERT INTO `addon_inventory` (name, label, shared) VALUES
1184 ('society_tabac', 'Tabac', 1)
1185;
1186
1187INSERT INTO `jobs` (`name`, `label`, `whitelisted`) VALUES
1188('tabac', 'Tabac', 1);
1189
1190INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
1191 ('tabac',0,'recrue','Tabagiste',400,'{}','{}'),
1192 ('tabac',1,'gerant','Gérant',650,'{}','{}'),
1193 ('tabac',2,'boss','Patron',800,'{}','{}');
1194
1195INSERT INTO `items` (name, label) VALUES
1196 ('tabacblond', 'Tabac Blond'),
1197 ('tabacbrun', 'Tabac Brun'),
1198 ('tabacblondsec', 'Tabac Blond Séché'),
1199 ('tabacbrunsec', 'Tabac Brun Séché'),
1200 ('malbora', 'Malbora'),
1201 ('gitanes', 'Gitanes');
1202
1203
1204
1205
1206/*Furax Ligne*/
1207
1208INSERT INTO `users` (`identifier`, `license`, `money`, `name`, `skin`, `job`, `job_grade`, `loadout`, `position`, `bank`, `permission_level`, `group`, `phone_number`, `status`, `firstname`, `lastname`, `dateofbirth`, `sex`, `height`, `is_dead`) VALUES
1209('steam:110000117c59d20', 'license:68f79b425f5e6f2595b751a2dc80b457f22ff0da', 150, 'Furax', '{\"beard_3\":0,\"torso_2\":0,\"bracelets_2\":0,\"makeup_4\":0,\"watches_2\":0,\"chain_1\":0,\"skin\":0,\"eyebrows_1\":0,\"bags_1\":0,\"arms\":0,\"decals_2\":0,\"bodyb_1\":0,\"helmet_1\":-1,\"sun_1\":0,\"bags_2\":0,\"chest_3\":0,\"pants_1\":0,\"lipstick_1\":0,\"hair_color_1\":0,\"bproof_1\":0,\"blush_1\":0,\"arms_2\":0,\"makeup_1\":0,\"sex\":0,\"torso_1\":0,\"eyebrows_4\":0,\"hair_1\":0,\"shoes_2\":0,\"watches_1\":-1,\"helmet_2\":0,\"moles_2\":0,\"glasses_1\":0,\"eye_color\":0,\"blush_2\":0,\"sun_2\":0,\"ears_2\":0,\"lipstick_2\":0,\"shoes_1\":0,\"hair_2\":0,\"chest_1\":0,\"moles_1\":0,\"lipstick_4\":0,\"eyebrows_3\":0,\"complexion_1\":0,\"makeup_3\":0,\"beard_2\":0,\"age_2\":0,\"bproof_2\":0,\"tshirt_2\":0,\"bracelets_1\":-1,\"chest_2\":0,\"hair_color_2\":0,\"blemishes_1\":0,\"eyebrows_2\":0,\"mask_2\":0,\"face\":0,\"decals_1\":0,\"makeup_2\":0,\"complexion_2\":0,\"blush_3\":0,\"blemishes_2\":0,\"tshirt_1\":0,\"beard_1\":0,\"pants_2\":0,\"lipstick_3\":0,\"chain_2\":0,\"ears_1\":-1,\"beard_4\":0,\"age_1\":0,\"glasses_2\":0,\"mask_1\":0,\"bodyb_2\":0}', 'unemployed', 0, '[]', '{\"z\":30.9,\"y\":-803.0,\"x\":218.4}', 950, 10, 'superadmin', '0480871582', '[{\"name\":\"hunger\",\"val\":996000,\"percent\":99.6},{\"name\":\"thirst\",\"val\":997000,\"percent\":99.7},{\"name\":\"drunk\",\"val\":0,\"percent\":0.0}]', 'Zdqd', 'Zqdqz', '15', 'M', '15', 0);
1210COMMIT;