· 7 years ago · Nov 29, 2018, 12:22 PM
1-- --------------------------------------------------------
2-- Hôte : 127.0.0.1
3-- Version du serveur: 10.3.10-MariaDB - mariadb.org binary distribution
4-- SE du serveur: Win64
5-- HeidiSQL Version: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Export de la structure de la base pour altislife
16CREATE DATABASE IF NOT EXISTS `altislife` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
17USE `altislife`;
18
19-- Export de la structure de la table altislife. advanced_identity
20CREATE TABLE IF NOT EXISTS `advanced_identity` (
21 `pid` varchar(64) NOT NULL,
22 `name_player` varchar(32) NOT NULL,
23 `nom` varchar(32) NOT NULL,
24 `prenom` varchar(32) NOT NULL,
25 `naissance` text NOT NULL,
26 `lieu_naissance` text NOT NULL,
27 `taille` int(10) NOT NULL,
28 `sexe` int(1) NOT NULL,
29 PRIMARY KEY (`pid`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
31
32-- Export de données de la table altislife.advanced_identity : ~3 rows (environ)
33/*!40000 ALTER TABLE `advanced_identity` DISABLE KEYS */;
34INSERT INTO `advanced_identity` (`pid`, `name_player`, `nom`, `prenom`, `naissance`, `lieu_naissance`, `taille`, `sexe`) VALUES
35 ('76561198127878352', 'Fernando Gomez', 'Gomez', 'Fernando', '"[9,9,1975]"', '"Altis"', 180, 1),
36 ('76561198289832461', 'Ezio Reese', 'Reese', 'Ezio', '"[3,2,1995]"', '"Altis"', 186, 1),
37 ('76561198347670255', 'Steven Afroman', 'Afroman', 'Steven', '"[16,8,1995]"', '"Altis"', 185, 1);
38/*!40000 ALTER TABLE `advanced_identity` ENABLE KEYS */;
39
40-- Export de la structure de la table altislife. cellphone
41CREATE TABLE IF NOT EXISTS `cellphone` (
42 `pid` varchar(64) NOT NULL,
43 `name` varchar(32) NOT NULL,
44 `messages` text NOT NULL,
45 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
46 PRIMARY KEY (`pid`)
47) ENGINE=InnoDB DEFAULT CHARSET=utf8;
48
49-- Export de données de la table altislife.cellphone : ~3 rows (environ)
50/*!40000 ALTER TABLE `cellphone` DISABLE KEYS */;
51INSERT INTO `cellphone` (`pid`, `name`, `messages`, `insert_time`) VALUES
52 ('76561198127878352', 'Fernando Gomez', '"[[`Gouvernement`,`Le vote présidentiel est terminé, Ezio Reese remporte avec 0% des voix et prend ses fonctions dès maintenant.`,[1,[2018,11,12,18,59,47]]],[`Gouvernement`,`Le vote présidentiel à été lancé, rendez vous dans les locaux du gouvernement pour pouvoir voter.`,[1,[2018,11,12,18,59,7]]]]"', '2018-11-12 18:47:23'),
53 ('76561198289832461', 'Ezio Reese', '"[[`Sécurité gouvernementale(Steven Afroman)`,`Le gouvernement à besoin de votre aide, rendez vous vite à la position donnée !`,[1,[2018,11,12,19,1,37]]],[`Sécurité gouvernementale(Steven Afroman)`,`Le gouvernement à besoin de votre aide, rendez vous vite à la position donnée !`,[1,[2018,11,12,19,1,13]]],[`Sécurité gouvernementale(Steven Afroman)`,`Le gouvernement à besoin de votre aide, rendez vous vite à la position donnée !`,[1,[2018,11,12,19,1,13]]],[`Sécurité gouvernementale(Steven Afroman)`,`Le gouvernement à besoin de votre aide, rendez vous vite à la position donnée !`,[1,[2018,11,12,19,1,12]]],[`Sécurité gouvernementale(Steven Afroman)`,`Le gouvernement à besoin de votre aide, rendez vous vite à la position donnée !`,[1,[2018,11,12,19,1,12]]],[`Sécurité gouvernementale(Steven Afroman)`,`Le gouvernement à besoin de votre aide, rendez vous vite à la position donnée !`,[1,[2018,11,12,19,1,11]]],[`Sécurité gouvernementale(Steven Afroman)`,`Le gouvernement à besoin de votre aide, rendez vous vite à la position donnée !`,[1,[2018,11,12,19,1,10]]]]"', '2018-11-12 17:01:41'),
54 ('76561198347670255', 'Steven Afroman', '"[[`Gouvernement`,`Le vote présidentiel est terminé, Ezio Reese remporte avec 0% des voix et prend ses fonctions dès maintenant.`,[1,[2018,11,12,18,59,47]]],[`Gouvernement`,`Le vote présidentiel à été lancé, rendez vous dans les locaux du gouvernement pour pouvoir voter.`,[1,[2018,11,12,18,59,7]]]]"', '2018-11-12 18:16:55');
55/*!40000 ALTER TABLE `cellphone` ENABLE KEYS */;
56
57-- Export de la structure de la table altislife. containers
58CREATE TABLE IF NOT EXISTS `containers` (
59 `id` int(6) NOT NULL AUTO_INCREMENT,
60 `pid` varchar(17) NOT NULL,
61 `classname` varchar(32) NOT NULL,
62 `pos` varchar(64) DEFAULT NULL,
63 `inventory` text NOT NULL,
64 `gear` text NOT NULL,
65 `dir` varchar(128) DEFAULT NULL,
66 `active` tinyint(1) NOT NULL DEFAULT 0,
67 `owned` tinyint(1) DEFAULT 0,
68 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
69 PRIMARY KEY (`id`,`pid`)
70) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
71
72-- Export de données de la table altislife.containers : ~0 rows (environ)
73/*!40000 ALTER TABLE `containers` DISABLE KEYS */;
74/*!40000 ALTER TABLE `containers` ENABLE KEYS */;
75
76-- Export de la structure de la procédure altislife. deleteDeadVehicles
77DELIMITER //
78CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
79BEGIN
80 DELETE FROM `vehicles` WHERE `alive` = 0;
81END//
82DELIMITER ;
83
84-- Export de la structure de la procédure altislife. deleteOldContainers
85DELIMITER //
86CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldContainers`()
87BEGIN
88 DELETE FROM `containers` WHERE `owned` = 0;
89END//
90DELIMITER ;
91
92-- Export de la structure de la procédure altislife. deleteOldGangs
93DELIMITER //
94CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
95BEGIN
96 DELETE FROM `gangs` WHERE `active` = 0;
97END//
98DELIMITER ;
99
100-- Export de la structure de la procédure altislife. deleteOldHouses
101DELIMITER //
102CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
103BEGIN
104 DELETE FROM `houses` WHERE `owned` = 0;
105END//
106DELIMITER ;
107
108-- Export de la structure de la procédure altislife. deleteOldWanted
109DELIMITER //
110CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldWanted`()
111BEGIN
112 DELETE FROM `wanted` WHERE `active` = 0;
113END//
114DELIMITER ;
115
116-- Export de la structure de la table altislife. entreprises
117CREATE TABLE IF NOT EXISTS `entreprises` (
118 `id` int(6) NOT NULL AUTO_INCREMENT,
119 `name` varchar(32) NOT NULL,
120 `pdg_pid` varchar(17) NOT NULL DEFAULT '0',
121 `pdg_name` varchar(32) NOT NULL,
122 `members` text NOT NULL,
123 `prices` text NOT NULL,
124 `items_stock` text NOT NULL,
125 `max_stock` int(3) NOT NULL DEFAULT 0,
126 `items_stock_2` text NOT NULL,
127 `max_stock_2` int(3) NOT NULL DEFAULT 0,
128 `bankacc` int(100) NOT NULL DEFAULT 0,
129 `position` varchar(32) DEFAULT NULL,
130 `objects` text NOT NULL,
131 `type` varchar(32) NOT NULL,
132 `active` tinyint(1) NOT NULL DEFAULT 1,
133 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
134 PRIMARY KEY (`id`)
135) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
136
137-- Export de données de la table altislife.entreprises : ~0 rows (environ)
138/*!40000 ALTER TABLE `entreprises` DISABLE KEYS */;
139/*!40000 ALTER TABLE `entreprises` ENABLE KEYS */;
140
141-- Export de la structure de la table altislife. entreprises_logs
142CREATE TABLE IF NOT EXISTS `entreprises_logs` (
143 `id` int(6) NOT NULL AUTO_INCREMENT,
144 `entreprise_id` int(6) NOT NULL DEFAULT 0,
145 `name` varchar(32) NOT NULL,
146 `value` int(6) NOT NULL DEFAULT 0,
147 `type` int(1) NOT NULL DEFAULT 0,
148 `other` int(1) NOT NULL DEFAULT 0,
149 `insert_time` text NOT NULL,
150 PRIMARY KEY (`id`)
151) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
152
153-- Export de données de la table altislife.entreprises_logs : ~0 rows (environ)
154/*!40000 ALTER TABLE `entreprises_logs` DISABLE KEYS */;
155/*!40000 ALTER TABLE `entreprises_logs` ENABLE KEYS */;
156
157-- Export de la structure de la table altislife. factures
158CREATE TABLE IF NOT EXISTS `factures` (
159 `id` int(6) NOT NULL AUTO_INCREMENT,
160 `from_pid` varchar(17) NOT NULL,
161 `to_pid` varchar(17) NOT NULL,
162 `to_name` varchar(32) NOT NULL,
163 `company` text NOT NULL,
164 `text` text NOT NULL,
165 `price` int(100) NOT NULL DEFAULT 0,
166 `payed` int(10) NOT NULL DEFAULT 0,
167 `insert_time` datetime NOT NULL DEFAULT current_timestamp(),
168 `last_update` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
169 PRIMARY KEY (`id`)
170) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
171
172-- Export de données de la table altislife.factures : ~0 rows (environ)
173/*!40000 ALTER TABLE `factures` DISABLE KEYS */;
174/*!40000 ALTER TABLE `factures` ENABLE KEYS */;
175
176-- Export de la structure de la table altislife. gangs
177CREATE TABLE IF NOT EXISTS `gangs` (
178 `id` int(6) NOT NULL AUTO_INCREMENT,
179 `owner` varchar(32) DEFAULT NULL,
180 `name` varchar(32) DEFAULT NULL,
181 `members` text DEFAULT NULL,
182 `maxmembers` int(3) DEFAULT 8,
183 `bank` int(100) DEFAULT 0,
184 `active` tinyint(1) DEFAULT 1,
185 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
186 PRIMARY KEY (`id`),
187 UNIQUE KEY `name_UNIQUE` (`name`)
188) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
189
190-- Export de données de la table altislife.gangs : ~1 rows (environ)
191/*!40000 ALTER TABLE `gangs` DISABLE KEYS */;
192INSERT INTO `gangs` (`id`, `owner`, `name`, `members`, `maxmembers`, `bank`, `active`, `insert_time`) VALUES
193 (1, '76561198289832461', 'Gouvernement', '"[`76561198289832461`,`76561198347670255`]"', 8, 0, 1, '2018-11-12 21:19:25');
194/*!40000 ALTER TABLE `gangs` ENABLE KEYS */;
195
196-- Export de la structure de la table altislife. gouvernement
197CREATE TABLE IF NOT EXISTS `gouvernement` (
198 `id` int(6) NOT NULL DEFAULT 1,
199 `vote_proccessing` int(1) NOT NULL DEFAULT 0,
200 `candidats` text NOT NULL,
201 `voters` text NOT NULL,
202 `compte_gouv` int(100) NOT NULL DEFAULT 0,
203 `compte_cop` int(100) NOT NULL DEFAULT 0,
204 `compte_med` int(100) NOT NULL DEFAULT 0,
205 `gouverneur` text NOT NULL,
206 `ministres` text NOT NULL,
207 `security` text NOT NULL,
208 `taxes` text NOT NULL,
209 `laws` text NOT NULL,
210 PRIMARY KEY (`id`)
211) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
212
213-- Export de données de la table altislife.gouvernement : ~1 rows (environ)
214/*!40000 ALTER TABLE `gouvernement` DISABLE KEYS */;
215INSERT INTO `gouvernement` (`id`, `vote_proccessing`, `candidats`, `voters`, `compte_gouv`, `compte_cop`, `compte_med`, `gouverneur`, `ministres`, `security`, `taxes`, `laws`) VALUES
216 (1, 0, '"[[`Ezio Reese`,`76561198289832461`,2,66.6667,1],[`Steven Afroman`,`76561198347670255`,1,33.3333,0],[`Fernando Gomez`,`76561198127878352`,0,0,0]]"', '"[]"', 30030, 0, 0, '"[[`Ezio Reese`,`76561198289832461`]]"', '"[[`Fernando Gomez`,`76561198127878352`]]"', '"[[`Steven Afroman`,`76561198347670255`]]"', '"[0,0,0]"', '"[]"');
217/*!40000 ALTER TABLE `gouvernement` ENABLE KEYS */;
218
219-- Export de la structure de la table altislife. gouvernement_logs
220CREATE TABLE IF NOT EXISTS `gouvernement_logs` (
221 `id` int(6) NOT NULL AUTO_INCREMENT,
222 `name` varchar(32) NOT NULL,
223 `value` int(6) NOT NULL DEFAULT 0,
224 `from_id` int(1) NOT NULL,
225 `to_id` int(1) NOT NULL,
226 `type` int(1) NOT NULL,
227 `insert_time` text NOT NULL,
228 PRIMARY KEY (`id`)
229) ENGINE=InnoDB AUTO_INCREMENT=319 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
230
231-- Export de données de la table altislife.gouvernement_logs : ~17 rows (environ)
232/*!40000 ALTER TABLE `gouvernement_logs` DISABLE KEYS */;
233INSERT INTO `gouvernement_logs` (`id`, `name`, `value`, `from_id`, `to_id`, `type`, `insert_time`) VALUES
234 (302, 'Fernando Gomez', 525, 3, 0, 2, '"[2018,11,12,19,2,26]"'),
235 (303, 'Steven Afroman', 525, 3, 0, 2, '"[2018,11,12,19,3,29]"'),
236 (304, 'Ezio Reese', 6000, 3, 0, 2, '"[2018,11,12,19,4,23]"'),
237 (305, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,12,19,51,24]"'),
238 (306, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,12,19,56,24]"'),
239 (307, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,12,20,8,45]"'),
240 (308, 'Fernando Gomez', 6000, 3, 0, 2, '"[2018,11,12,20,13,18]"'),
241 (309, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,12,20,13,44]"'),
242 (310, 'Fernando Gomez', 6000, 3, 0, 2, '"[2018,11,12,20,18,25]"'),
243 (311, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,12,20,18,48]"'),
244 (312, 'Fernando Gomez', 6000, 3, 0, 2, '"[2018,11,12,20,23,28]"'),
245 (313, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,12,20,23,47]"'),
246 (314, 'Steven Afroman', 260, 3, 0, 1, '"[2018,11,13,18,46,0]"'),
247 (315, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,13,18,46,33]"'),
248 (316, 'Steven Afroman', 525, 3, 0, 2, '"[2018,11,13,18,46,57]"'),
249 (317, 'Steven Afroman', 260, 3, 0, 1, '"[2018,11,13,18,47,14]"'),
250 (318, 'Steven Afroman', 260, 3, 0, 1, '"[2018,11,13,18,48,31]"');
251/*!40000 ALTER TABLE `gouvernement_logs` ENABLE KEYS */;
252
253-- Export de la structure de la table altislife. houses
254CREATE TABLE IF NOT EXISTS `houses` (
255 `id` int(6) NOT NULL AUTO_INCREMENT,
256 `pid` varchar(17) NOT NULL,
257 `pos` varchar(64) DEFAULT NULL,
258 `owned` tinyint(1) DEFAULT 0,
259 `garage` tinyint(1) NOT NULL DEFAULT 0,
260 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
261 PRIMARY KEY (`id`,`pid`)
262) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
263
264-- Export de données de la table altislife.houses : ~2 rows (environ)
265/*!40000 ALTER TABLE `houses` DISABLE KEYS */;
266INSERT INTO `houses` (`id`, `pid`, `pos`, `owned`, `garage`, `insert_time`) VALUES
267 (4, '76561198347670255', '[12129.3,14058.2,0.14]', 1, 0, '2018-11-10 17:51:02'),
268 (5, '76561198289832461', '[12129.3,14058.2,0.14]', 1, 0, '2018-11-10 17:51:02');
269/*!40000 ALTER TABLE `houses` ENABLE KEYS */;
270
271-- Export de la structure de la table altislife. interpol
272CREATE TABLE IF NOT EXISTS `interpol` (
273 `id` int(6) NOT NULL AUTO_INCREMENT,
274 `prenom` varchar(32) NOT NULL,
275 `nom` varchar(32) NOT NULL,
276 `naissance` text NOT NULL,
277 `adresse` text NOT NULL,
278 `ville` text NOT NULL,
279 `numero` varchar(32) NOT NULL DEFAULT '0',
280 `yeux` text NOT NULL,
281 `details` text NOT NULL,
282 `insert_time` text NOT NULL,
283 PRIMARY KEY (`id`)
284) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
285
286-- Export de données de la table altislife.interpol : ~0 rows (environ)
287/*!40000 ALTER TABLE `interpol` DISABLE KEYS */;
288/*!40000 ALTER TABLE `interpol` ENABLE KEYS */;
289
290-- Export de la structure de la table altislife. interpol_crimes
291CREATE TABLE IF NOT EXISTS `interpol_crimes` (
292 `id` int(6) NOT NULL AUTO_INCREMENT,
293 `interpol_id` int(6) NOT NULL,
294 `crime` varchar(64) NOT NULL,
295 `price` int(100) NOT NULL,
296 `payed` tinyint(1) NOT NULL DEFAULT 0,
297 `insert_time` text NOT NULL,
298 PRIMARY KEY (`id`)
299) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
300
301-- Export de données de la table altislife.interpol_crimes : ~3 rows (environ)
302/*!40000 ALTER TABLE `interpol_crimes` DISABLE KEYS */;
303INSERT INTO `interpol_crimes` (`id`, `interpol_id`, `crime`, `price`, `payed`, `insert_time`) VALUES
304 (2, 2, 'Actes terroristes', 5000000, 1, '"[2018,11,6,21,20,6]"'),
305 (3, 2, 'asdasd', 99999, 1, '"[2018,11,6,21,21,20]"'),
306 (4, 3, 'Actes terroristes', 5000000, 1, '"[2018,11,10,2,55,5]"');
307/*!40000 ALTER TABLE `interpol_crimes` ENABLE KEYS */;
308
309-- Export de la structure de la table altislife. permis
310CREATE TABLE IF NOT EXISTS `permis` (
311 `id` int(8) NOT NULL AUTO_INCREMENT,
312 `pid` varchar(17) NOT NULL DEFAULT '0',
313 `reason` varchar(255) NOT NULL DEFAULT '0',
314 `insert_time` datetime NOT NULL DEFAULT current_timestamp(),
315 PRIMARY KEY (`id`)
316) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
317
318-- Export de données de la table altislife.permis : ~10 rows (environ)
319/*!40000 ALTER TABLE `permis` DISABLE KEYS */;
320INSERT INTO `permis` (`id`, `pid`, `reason`, `insert_time`) VALUES
321 (1, '76561198347670255', 'car il a une petit bite', '2018-11-12 18:34:33'),
322 (2, '76561198127878352', 'Suce pas ma bite', '2018-11-12 18:51:35'),
323 (3, '76561198289832461', 'Radar mobile (38km/h)', '2018-11-12 20:14:32'),
324 (4, '76561198289832461', 'Radar mobile (68km/h)', '2018-11-12 20:14:49'),
325 (5, '76561198289832461', 'Radar mobile (42km/h)', '2018-11-12 20:15:09'),
326 (6, '76561198127878352', 'Radar mobile (35km/h)', '2018-11-12 20:15:57'),
327 (7, '76561198289832461', 'Radar mobile (81km/h)', '2018-11-12 20:23:55'),
328 (8, '76561198127878352', 'Radar mobile (83km/h)', '2018-11-12 20:24:23'),
329 (9, '76561198127878352', 'Radar mobile (55km/h)', '2018-11-12 20:24:56'),
330 (10, '76561198127878352', 'Radar mobile (61km/h)', '2018-11-12 21:48:20');
331/*!40000 ALTER TABLE `permis` ENABLE KEYS */;
332
333-- Export de la structure de la table altislife. players
334CREATE TABLE IF NOT EXISTS `players` (
335 `uid` int(6) NOT NULL AUTO_INCREMENT,
336 `name` varchar(32) NOT NULL,
337 `aliases` text NOT NULL,
338 `pid` varchar(17) NOT NULL,
339 `cash` int(100) NOT NULL DEFAULT 0,
340 `bankacc` int(100) NOT NULL DEFAULT 0,
341 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
342 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
343 `civ_licenses` text NOT NULL,
344 `cop_licenses` text NOT NULL,
345 `med_licenses` text NOT NULL,
346 `civ_gear` text NOT NULL,
347 `cop_gear` text NOT NULL,
348 `med_gear` text NOT NULL,
349 `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
350 `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
351 `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
352 `arrested` tinyint(1) NOT NULL DEFAULT 0,
353 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
354 `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
355 `blacklist` tinyint(1) NOT NULL DEFAULT 0,
356 `civ_alive` tinyint(1) NOT NULL DEFAULT 0,
357 `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
358 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
359 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
360 `last_seen` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
361 `num` varchar(10) NOT NULL DEFAULT '0',
362 `contact` text DEFAULT NULL,
363 `sms` int(10) NOT NULL DEFAULT 0,
364 `appel` int(10) NOT NULL DEFAULT 0,
365 `annuaire` enum('0','1') NOT NULL DEFAULT '1',
366 `pointsPermis` enum('0','1','2','3','4','5','6','7','8','9','10','11','12') NOT NULL DEFAULT '0',
367 PRIMARY KEY (`uid`),
368 UNIQUE KEY `pid` (`pid`),
369 KEY `name` (`name`),
370 KEY `blacklist` (`blacklist`)
371) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4;
372
373-- Export de données de la table altislife.players : ~3 rows (environ)
374/*!40000 ALTER TABLE `players` DISABLE KEYS */;
375INSERT INTO `players` (`uid`, `name`, `aliases`, `pid`, `cash`, `bankacc`, `coplevel`, `mediclevel`, `civ_licenses`, `cop_licenses`, `med_licenses`, `civ_gear`, `cop_gear`, `med_gear`, `civ_stats`, `cop_stats`, `med_stats`, `arrested`, `adminlevel`, `donorlevel`, `blacklist`, `civ_alive`, `civ_position`, `playtime`, `insert_time`, `last_seen`, `num`, `contact`, `sms`, `appel`, `annuaire`, `pointsPermis`) VALUES
376 (19, 'Ezio Reese', '"[`Ezio Reese`]"', '76561198289832461', 6964545, 693730, '7', '5', '"[[`license_civ_driver`,1],[`license_civ_DIR`,1],[`license_civ_gouv`,1],[`license_civ_bustaxi`,1],[`license_civ_Bus`,1],[`license_civ_Taxi`,1],[`license_civ_boat`,1],[`license_civ_donation1`,1],[`license_civ_donation2`,1],[`license_civ_donation3`,1],[`license_civ_donateurrebelle`,1],[`license_civ_BTS`,1],[`license_civ_pilot`,1],[`license_civ_trucking`,1],[`license_civ_gun`,1],[`license_civ_dive`,1],[`license_civ_home`,1],[`license_civ_oil`,1],[`license_civ_diamond`,1],[`license_civ_salt`,1],[`license_civ_sand`,1],[`license_civ_iron`,1],[`license_civ_copper`,1],[`license_civ_cement`,1],[`license_civ_medmarijuana`,1],[`license_civ_NOUVELLERESSOURCE`,1],[`license_civ_cocaine`,1],[`license_civ_heroin`,1],[`license_civ_marijuana`,1],[`license_civ_rebel`,0],[`license_civ_tabac`,1],[`license_civ_meth`,1],[`license_civ_vodka`,1]]"', '"[[`license_cop_cAir`,1],[`license_cop_cg`,1]]"', '"[]"', '"[`TRYK_U_B_BLKTAN_CombatUniform`,`TAC_LBT_HL2_B`,``,``,`H_Cap_surfer`,[`ItemMap`,`ItemCompass`,`Itemwatch`],`hlc_rifle_M4`,`hlc_Pistol_M11A1`,[],[`hlc_13Rnd_9x19_B_P228`],[],[],[],[`hlc_30rnd_556x45_EPR`,`hlc_13Rnd_9x19_B_P228`],[``,``,`optic_Hamr`,`bipod_03_F_blk`],[``,``,``,``],[[`pickaxe`,1]]]"', '"[`jack_32n_uniform_1`,`EF_BLT_M1`,``,``,``,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc152_2`,`ItemGPS`],`SMG_03C_khaki`,`BT01_F`,[],[],[],[],[],[`50Rnd_570x28_SMG_03`],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[90,80,0]"', '"[100,100,0]"', '"[100,100,0]"', 0, '5', '5', 0, 1, '"[12449.4,15930,0.00143814]"', '"[73,0,253]"', '2018-11-12 17:26:32', '2018-11-13 19:56:56', '0652874205', '"[[`Gendarmerie`,`17`],[`Médecins`,`18`],[`Gendarmes et médecins`,`112`],[`Adac`,`80`],[`Dépanneurs`,`60`]]"', 1650, 54000, '0', '12'),
377 (20, 'Steven Afroman', '"[`Steven Afroman`]"', '76561198347670255', 109459200, 133570, '7', '5', '"[[`license_civ_driver`,1],[`license_civ_DIR`,0],[`license_civ_gouv`,0],[`license_civ_bustaxi`,0],[`license_civ_Bus`,0],[`license_civ_Taxi`,0],[`license_civ_boat`,0],[`license_civ_donation1`,0],[`license_civ_donation2`,0],[`license_civ_donation3`,0],[`license_civ_donateurrebelle`,0],[`license_civ_BTS`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,1],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_oil`,1],[`license_civ_diamond`,0],[`license_civ_salt`,1],[`license_civ_sand`,1],[`license_civ_iron`,1],[`license_civ_copper`,1],[`license_civ_cement`,1],[`license_civ_medmarijuana`,0],[`license_civ_NOUVELLERESSOURCE`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,1],[`license_civ_rebel`,1],[`license_civ_tabac`,1],[`license_civ_meth`,1],[`license_civ_vodka`,0]]"', '"[[`license_cop_cAir`,1],[`license_cop_cg`,1]]"', '"[[`license_med_mAir`,1]]"', '"[`U_NikosAgedBody`,``,`B_Carryall_oli`,`G_Aviator`,`H_Hat_tan`,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc148jem_1`,`ItemGPS`,`NVGoggles`,`Rangefinder`],``,``,[],[`30Rnd_9x21_Mag`],[],[],[],[],[``,``,``,``],[``,``,``,``],[[`pickaxe`,1],[`peach`,2]]]"', '"[`jack_32n_uniform_1`,`EF_BLT_M1`,``,``,``,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc152_3`,`ItemGPS`],``,`BT01_F`,[],[`Taser_mag`,`Taser_mag`,`Taser_mag`,`Taser_mag`,`Taser_mag`],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`jack_sp_grade_uniform_1`,`jack_gilet_sp_1`,`jack_sac_inter_sp`,`G_Aviator`,`jack_casquette_sp_2`,[`ItemMap`,`ItemCompass`,`Itemwatch`],[],[],[`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`],[],[],[`ACE_M14`],[],[`hlc_200rnd_556x45_B_SAW`],[``,``,``,``],[``,``,``,``],[]]"', '"[100,100,0]"', '"[100,100,0]"', '"[100,100,0]"', 0, '0', '0', 0, 1, '"[3337.5,13040.7,0.00366211]"', '"[28,34,118]"', '2018-11-12 18:16:41', '2018-11-13 18:52:56', '0605224634', '"[[`Gendarmerie`,`17`],[`Médecins`,`18`],[`Gendarmes et médecins`,`112`],[`Adac`,`80`],[`Dépanneurs`,`60`]]"', 11000, 360000, '1', '10'),
378 (21, 'Fernando Gomez', '"[`Fernando Gomez`]"', '76561198127878352', 80004, 954000, '7', '5', '"[[`license_civ_driver`,1],[`license_civ_gouv`,0],[`license_civ_bustaxi`,0],[`license_civ_Bus`,0],[`license_civ_Taxi`,0],[`license_civ_boat`,1],[`license_civ_donation1`,0],[`license_civ_donation2`,0],[`license_civ_donation3`,0],[`license_civ_donateurrebelle`,0],[`license_civ_BTS`,0],[`license_civ_pilot`,1],[`license_civ_trucking`,1],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,1],[`license_civ_oil`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_NOUVELLERESSOURCE`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0],[`license_civ_tabac`,0],[`license_civ_meth`,0],[`license_civ_vodka`,0]]"', '"[[`license_cop_cAir`,1],[`license_cop_cg`,1]]"', '"[]"', '"[`U_C_Poloshirt_stripped`,``,``,``,``,[`ItemMap`,`ItemCompass`,`tf_microdagr`,`ItemGPS`],``,``,[`tf_microdagr`,`ACE_Flashlight_XL50`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`,`ACE_fieldDressing`],[`murshun_cigs_cigpack`,`murshun_cigs_matches`],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`jack_33n_uniform_1`,`jack_gilet_lourd_gend_1`,`jack_sac_invi`,``,``,[`ItemMap`,`ItemCompass`,`Itemwatch`],`R3F_Famas_G2`,``,[`bipod_03_F_blk`],[`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`],[`H_Cap_surfer`],[`R3F_30Rnd_556x45_TRACER_FAMAS`,`R3F_30Rnd_556x45_TRACER_FAMAS`,`R3F_30Rnd_556x45_TRACER_FAMAS`],[`bipod_03_F_blk`],[`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`R3F_30Rnd_556x45_TRACER_FAMAS`,`R3F_30Rnd_556x45_TRACER_FAMAS`,`R3F_30Rnd_556x45_TRACER_FAMAS`,`R3F_30Rnd_556x45_TRACER_FAMAS`,`R3F_30Rnd_556x45_TRACER_FAMAS`,`R3F_30Rnd_556x45_TRACER_FAMAS`,`R3F_30Rnd_556x45_TRACER_FAMAS`,`R3F_30Rnd_556x45_TRACER_FAMAS`],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[100,100,0]"', '"[100,90,0]"', '"[100,100,0]"', 0, '5', '5', 0, 1, '"[9761.9,16278.8,1.17351]"', '"[70,0,23]"', '2018-11-12 18:47:15', '2018-11-12 23:17:03', '0', '"[[`Gendarmerie`,`17`],[`Médecins`,`18`],[`Gendarmes et médecins`,`112`],[`Adac`,`80`],[`Dépanneurs`,`60`]]"', 0, 0, '1', '5');
379/*!40000 ALTER TABLE `players` ENABLE KEYS */;
380
381-- Export de la structure de la procédure altislife. resetLifeVehicles
382DELIMITER //
383CREATE DEFINER=`root`@`localhost` PROCEDURE `resetLifeVehicles`()
384BEGIN
385 UPDATE `vehicles` SET `active`= 0;
386END//
387DELIMITER ;
388
389-- Export de la structure de la table altislife. vehicles
390CREATE TABLE IF NOT EXISTS `vehicles` (
391 `id` int(6) NOT NULL AUTO_INCREMENT,
392 `side` varchar(16) NOT NULL,
393 `classname` varchar(64) NOT NULL,
394 `type` varchar(16) NOT NULL,
395 `pid` varchar(17) NOT NULL,
396 `alive` tinyint(1) NOT NULL DEFAULT 1,
397 `blacklist` tinyint(1) NOT NULL DEFAULT 0,
398 `active` tinyint(1) NOT NULL DEFAULT 0,
399 `plate` int(20) NOT NULL,
400 `color` int(20) NOT NULL,
401 `inventory` text NOT NULL,
402 `gear` text NOT NULL,
403 `fuel` double NOT NULL DEFAULT 1,
404 `damage` varchar(256) NOT NULL,
405 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
406 `entreprise_id` int(10) NOT NULL DEFAULT 0,
407 `immatriculation` text NOT NULL,
408 PRIMARY KEY (`id`),
409 KEY `side` (`side`),
410 KEY `pid` (`pid`),
411 KEY `type` (`type`)
412) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4;
413
414-- Export de données de la table altislife.vehicles : ~28 rows (environ)
415/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
416INSERT INTO `vehicles` (`id`, `side`, `classname`, `type`, `pid`, `alive`, `blacklist`, `active`, `plate`, `color`, `inventory`, `gear`, `fuel`, `damage`, `insert_time`, `entreprise_id`, `immatriculation`) VALUES
417 (2, 'civ', 'C_Heli_Light_01_civil_F', 'Air', '76561198289832461', 1, 0, 0, 166883, 11, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-06 12:42:38', 0, '"VI875OD"'),
418 (3, 'cop', 'B_MRAP_01_F', 'Car', '76561198289832461', 1, 0, 0, 310271, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-06 18:08:39', 0, '"CE510EN"'),
419 (4, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198289832461', 1, 0, 0, 148139, 6, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-06 18:20:32', 0, '"JC376FD"'),
420 (5, 'civ', 'C_Offroad_02_unarmed_F', 'Car', '76561198347670255', 1, 0, 0, 550277, 5, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-06 18:49:46', 0, '"RI522WG"'),
421 (7, 'cop', 'G65lu_B', 'Car', '76561198289832461', 1, 0, 0, 455003, 0, '"[[],0]"', '"[]"', 0.985751, '"[]"', '2018-11-06 21:13:24', 0, '"MR908LL"'),
422 (8, 'cop', 'Gallardolu_Gendarmerie', 'Car', '76561198289832461', 1, 0, 0, 944599, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-06 21:24:28', 0, '"TT265PJ"'),
423 (10, 'civ', 'B_Quadbike_01_F', 'Car', '76561198289832461', 1, 0, 0, 99658, 7, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-07 21:20:26', 0, '"NO152KN"'),
424 (11, 'civ', 'AmaZiinG_Maybach_W222', 'Car', '76561198289832461', 1, 0, 0, 615674, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-09 19:49:31', 0, '"MB783OG"'),
425 (12, 'civ', 'Explorerlu_US', 'Car', '76561198289832461', 1, 0, 0, 804384, 0, '"[[],0]"', '"[]"', 0.999688, '"[]"', '2018-11-09 20:55:57', 0, '"XU319HY"'),
426 (13, 'civ', 'cha110', 'Car', '76561198289832461', 1, 0, 0, 382672, 13, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-09 21:48:53', 0, '"LN216NN"'),
427 (14, 'civ', 'C_Plane_Civil_01_F', 'Air', '76561198289832461', 1, 0, 0, 127220, 4, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-09 23:32:21', 0, '"OP370WF"'),
428 (15, 'civ', 'Model_Slu_civ', 'Car', '76561198347670255', 1, 0, 0, 135682, 7, '"[[],0]"', '"[]"', 0.99208, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2018-11-09 23:46:32', 0, '"TX064FE"'),
429 (18, 'civ', 'Gallardolu_civ', 'Car', '76561198289832461', 1, 0, 0, 717960, 13, '"[[],0]"', '"[]"', 0.818696, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2018-11-09 23:48:06', 3, '"JW621AP"'),
430 (19, 'civ', 'C63Slu_GMK', 'Car', '76561198289832461', 1, 0, 0, 313365, 3, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-09 23:50:49', 0, '"QB542AH"'),
431 (20, 'civ', 'WRXlu_civ', 'Car', '76561198289832461', 1, 0, 0, 894927, 4, '"[[],0]"', '"[]"', 0.99991, '"[]"', '2018-11-10 01:21:58', 0, '"LO368OZ"'),
432 (21, 'civ', 'chclio3_civ', 'Car', '76561198347670255', 1, 0, 0, 543053, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-10 02:35:14', 0, '"EE646SP"'),
433 (22, 'civ', 'V250lu_B', 'Car', '76561198289832461', 1, 0, 0, 928363, 0, '"[[],0]"', '"[]"', 0.999795, '"[]"', '2018-11-10 17:48:32', 0, '"RL543RN"'),
434 (23, 'med', '1200RT_sp_ch', 'Car', '76561198289832461', 1, 0, 0, 760970, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-11 13:57:27', 0, '"DP162KR"'),
435 (24, 'civ', 'subaruch_civ', 'Car', '76561198289832461', 1, 0, 0, 693203, 5, '"[[],0]"', '"[]"', 0.999603, '"[]"', '2018-11-12 02:00:13', 0, '"BN877VP"'),
436 (25, 'cop', 'Macanlu_Gendarmeire', 'Car', '76561198289832461', 1, 0, 0, 419083, 0, '"[[],0]"', '"[]"', 0.987086, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2018-11-12 18:22:03', 0, '"KM065IH"'),
437 (26, 'civ', 'RS3lu_civ', 'Car', '76561198127878352', 1, 0, 0, 991566, 7, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-12 19:00:17', 0, '"KE366GK"'),
438 (28, 'civ', 'RS3lu_civ', 'Car', '76561198127878352', 1, 0, 0, 481394, 11, '"[[],0]"', '"[]"', 0.883388, '"[]"', '2018-11-12 20:31:03', 0, '"NK553OD"'),
439 (29, 'civ', '1200RT_ch', 'Car', '76561198127878352', 1, 0, 0, 707922, 6, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-12 20:34:08', 0, '"PU515MX"'),
440 (31, 'cop', 'Tahoelu_Gendarmerie', 'Car', '76561198127878352', 1, 0, 0, 703370, 0, '"[[],0]"', '"[]"', 0.998738, '"[1,1,1,1,0,1,0,1,1,1,1,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]"', '2018-11-12 21:22:49', 0, '"VI525KP"'),
441 (32, 'cop', 'B_Heli_Transport_01_F', 'Air', '76561198127878352', 1, 0, 0, 553035, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-12 21:45:01', 0, '"MX943IW"'),
442 (34, 'cop', 'V250lu_B', 'Car', '76561198127878352', 1, 0, 0, 633644, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-12 23:11:58', 0, '"DB316CP"'),
443 (35, 'cop', 'Gallardolu_Gendarmerie', 'Car', '76561198347670255', 1, 0, 0, 551718, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-13 00:25:19', 0, '"UT282EQ"'),
444 (36, 'med', 'chMaster3_vtp', 'Car', '76561198347670255', 1, 0, 0, 811520, 0, '"[[],0]"', '"[]"', 0.997889, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2018-11-13 01:23:31', 0, '"RJ414MN"');
445/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
446
447-- Export de la structure de la table altislife. wanted
448CREATE TABLE IF NOT EXISTS `wanted` (
449 `wantedID` varchar(64) NOT NULL,
450 `wantedName` varchar(32) NOT NULL,
451 `wantedCrimes` text NOT NULL,
452 `wantedBounty` int(100) NOT NULL,
453 `active` tinyint(1) NOT NULL DEFAULT 0,
454 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
455 PRIMARY KEY (`wantedID`)
456) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
457
458-- Export de données de la table altislife.wanted : ~2 rows (environ)
459/*!40000 ALTER TABLE `wanted` DISABLE KEYS */;
460INSERT INTO `wanted` (`wantedID`, `wantedName`, `wantedCrimes`, `wantedBounty`, `active`, `insert_time`) VALUES
461 ('76561198289832461', 'Ezio Reese', '"[`187`,`187`,`187`,`187`,`187`]"', 10000, 1, '2018-11-12 19:55:08'),
462 ('76561198347670255', 'Steven Afroman', '"[`187`,`187`,`187`,`187`,`187`,`187`,`187`]"', 14000, 1, '2018-11-12 21:37:13');
463/*!40000 ALTER TABLE `wanted` ENABLE KEYS */;
464
465/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
466/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
467/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;