· 7 years ago · Nov 29, 2018, 12:24 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)
33DELETE FROM `advanced_identity`;
34/*!40000 ALTER TABLE `advanced_identity` DISABLE KEYS */;
35INSERT INTO `advanced_identity` (`pid`, `name_player`, `nom`, `prenom`, `naissance`, `lieu_naissance`, `taille`, `sexe`) VALUES
36 ('76561198127878352', 'Fernando Gomez', 'Gomez', 'Fernando', '"[9,9,1975]"', '"Altis"', 180, 1),
37 ('76561198289832461', 'Ezio Reese', 'Reese', 'Ezio', '"[3,2,1995]"', '"Altis"', 186, 1),
38 ('76561198347670255', 'Steven Afroman', 'Afroman', 'Steven', '"[16,8,1995]"', '"Altis"', 185, 1);
39/*!40000 ALTER TABLE `advanced_identity` ENABLE KEYS */;
40
41-- Export de la structure de la table altislife. cellphone
42CREATE TABLE IF NOT EXISTS `cellphone` (
43 `pid` varchar(64) NOT NULL,
44 `name` varchar(32) NOT NULL,
45 `messages` text NOT NULL,
46 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
47 PRIMARY KEY (`pid`)
48) ENGINE=InnoDB DEFAULT CHARSET=utf8;
49
50-- Export de données de la table altislife.cellphone : ~3 rows (environ)
51DELETE FROM `cellphone`;
52/*!40000 ALTER TABLE `cellphone` DISABLE KEYS */;
53INSERT INTO `cellphone` (`pid`, `name`, `messages`, `insert_time`) VALUES
54 ('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'),
55 ('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'),
56 ('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');
57/*!40000 ALTER TABLE `cellphone` ENABLE KEYS */;
58
59-- Export de la structure de la table altislife. containers
60CREATE TABLE IF NOT EXISTS `containers` (
61 `id` int(6) NOT NULL AUTO_INCREMENT,
62 `pid` varchar(17) NOT NULL,
63 `classname` varchar(32) NOT NULL,
64 `pos` varchar(64) DEFAULT NULL,
65 `inventory` text NOT NULL,
66 `gear` text NOT NULL,
67 `dir` varchar(128) DEFAULT NULL,
68 `active` tinyint(1) NOT NULL DEFAULT 0,
69 `owned` tinyint(1) DEFAULT 0,
70 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
71 PRIMARY KEY (`id`,`pid`)
72) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
73
74-- Export de données de la table altislife.containers : ~0 rows (environ)
75DELETE FROM `containers`;
76/*!40000 ALTER TABLE `containers` DISABLE KEYS */;
77/*!40000 ALTER TABLE `containers` ENABLE KEYS */;
78
79-- Export de la structure de la procédure altislife. deleteDeadVehicles
80DELIMITER //
81CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
82BEGIN
83 DELETE FROM `vehicles` WHERE `alive` = 0;
84END//
85DELIMITER ;
86
87-- Export de la structure de la procédure altislife. deleteOldContainers
88DELIMITER //
89CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldContainers`()
90BEGIN
91 DELETE FROM `containers` WHERE `owned` = 0;
92END//
93DELIMITER ;
94
95-- Export de la structure de la procédure altislife. deleteOldGangs
96DELIMITER //
97CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
98BEGIN
99 DELETE FROM `gangs` WHERE `active` = 0;
100END//
101DELIMITER ;
102
103-- Export de la structure de la procédure altislife. deleteOldHouses
104DELIMITER //
105CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
106BEGIN
107 DELETE FROM `houses` WHERE `owned` = 0;
108END//
109DELIMITER ;
110
111-- Export de la structure de la procédure altislife. deleteOldWanted
112DELIMITER //
113CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldWanted`()
114BEGIN
115 DELETE FROM `wanted` WHERE `active` = 0;
116END//
117DELIMITER ;
118
119-- Export de la structure de la table altislife. entreprises
120CREATE TABLE IF NOT EXISTS `entreprises` (
121 `id` int(6) NOT NULL AUTO_INCREMENT,
122 `name` varchar(32) NOT NULL,
123 `pdg_pid` varchar(17) NOT NULL DEFAULT '0',
124 `pdg_name` varchar(32) NOT NULL,
125 `members` text NOT NULL,
126 `prices` text NOT NULL,
127 `items_stock` text NOT NULL,
128 `max_stock` int(3) NOT NULL DEFAULT 0,
129 `items_stock_2` text NOT NULL,
130 `max_stock_2` int(3) NOT NULL DEFAULT 0,
131 `bankacc` int(100) NOT NULL DEFAULT 0,
132 `position` varchar(32) DEFAULT NULL,
133 `objects` text NOT NULL,
134 `type` varchar(32) NOT NULL,
135 `active` tinyint(1) NOT NULL DEFAULT 1,
136 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
137 PRIMARY KEY (`id`)
138) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
139
140-- Export de données de la table altislife.entreprises : ~0 rows (environ)
141DELETE FROM `entreprises`;
142/*!40000 ALTER TABLE `entreprises` DISABLE KEYS */;
143/*!40000 ALTER TABLE `entreprises` ENABLE KEYS */;
144
145-- Export de la structure de la table altislife. entreprises_logs
146CREATE TABLE IF NOT EXISTS `entreprises_logs` (
147 `id` int(6) NOT NULL AUTO_INCREMENT,
148 `entreprise_id` int(6) NOT NULL DEFAULT 0,
149 `name` varchar(32) NOT NULL,
150 `value` int(6) NOT NULL DEFAULT 0,
151 `type` int(1) NOT NULL DEFAULT 0,
152 `other` int(1) NOT NULL DEFAULT 0,
153 `insert_time` text NOT NULL,
154 PRIMARY KEY (`id`)
155) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
156
157-- Export de données de la table altislife.entreprises_logs : ~0 rows (environ)
158DELETE FROM `entreprises_logs`;
159/*!40000 ALTER TABLE `entreprises_logs` DISABLE KEYS */;
160/*!40000 ALTER TABLE `entreprises_logs` ENABLE KEYS */;
161
162-- Export de la structure de la table altislife. factures
163CREATE TABLE IF NOT EXISTS `factures` (
164 `id` int(6) NOT NULL AUTO_INCREMENT,
165 `from_pid` varchar(17) NOT NULL,
166 `to_pid` varchar(17) NOT NULL,
167 `to_name` varchar(32) NOT NULL,
168 `company` text NOT NULL,
169 `text` text NOT NULL,
170 `price` int(100) NOT NULL DEFAULT 0,
171 `payed` int(10) NOT NULL DEFAULT 0,
172 `insert_time` datetime NOT NULL DEFAULT current_timestamp(),
173 `last_update` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
174 PRIMARY KEY (`id`)
175) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
176
177-- Export de données de la table altislife.factures : ~0 rows (environ)
178DELETE FROM `factures`;
179/*!40000 ALTER TABLE `factures` DISABLE KEYS */;
180/*!40000 ALTER TABLE `factures` ENABLE KEYS */;
181
182-- Export de la structure de la table altislife. gangs
183CREATE TABLE IF NOT EXISTS `gangs` (
184 `id` int(6) NOT NULL AUTO_INCREMENT,
185 `owner` varchar(32) DEFAULT NULL,
186 `name` varchar(32) DEFAULT NULL,
187 `members` text DEFAULT NULL,
188 `maxmembers` int(3) DEFAULT 8,
189 `bank` int(100) DEFAULT 0,
190 `active` tinyint(1) DEFAULT 1,
191 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
192 PRIMARY KEY (`id`),
193 UNIQUE KEY `name_UNIQUE` (`name`)
194) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
195
196-- Export de données de la table altislife.gangs : ~1 rows (environ)
197DELETE FROM `gangs`;
198/*!40000 ALTER TABLE `gangs` DISABLE KEYS */;
199INSERT INTO `gangs` (`id`, `owner`, `name`, `members`, `maxmembers`, `bank`, `active`, `insert_time`) VALUES
200 (1, '76561198289832461', 'Gouvernement', '"[`76561198289832461`,`76561198347670255`]"', 8, 0, 1, '2018-11-12 21:19:25');
201/*!40000 ALTER TABLE `gangs` ENABLE KEYS */;
202
203-- Export de la structure de la table altislife. gouvernement
204CREATE TABLE IF NOT EXISTS `gouvernement` (
205 `id` int(6) NOT NULL DEFAULT 1,
206 `vote_proccessing` int(1) NOT NULL DEFAULT 0,
207 `candidats` text NOT NULL,
208 `voters` text NOT NULL,
209 `compte_gouv` int(100) NOT NULL DEFAULT 0,
210 `compte_cop` int(100) NOT NULL DEFAULT 0,
211 `compte_med` int(100) NOT NULL DEFAULT 0,
212 `gouverneur` text NOT NULL,
213 `ministres` text NOT NULL,
214 `security` text NOT NULL,
215 `taxes` text NOT NULL,
216 `laws` text NOT NULL,
217 PRIMARY KEY (`id`)
218) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
219
220-- Export de données de la table altislife.gouvernement : ~1 rows (environ)
221DELETE FROM `gouvernement`;
222/*!40000 ALTER TABLE `gouvernement` DISABLE KEYS */;
223INSERT INTO `gouvernement` (`id`, `vote_proccessing`, `candidats`, `voters`, `compte_gouv`, `compte_cop`, `compte_med`, `gouverneur`, `ministres`, `security`, `taxes`, `laws`) VALUES
224 (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]"', '"[]"');
225/*!40000 ALTER TABLE `gouvernement` ENABLE KEYS */;
226
227-- Export de la structure de la table altislife. gouvernement_logs
228CREATE TABLE IF NOT EXISTS `gouvernement_logs` (
229 `id` int(6) NOT NULL AUTO_INCREMENT,
230 `name` varchar(32) NOT NULL,
231 `value` int(6) NOT NULL DEFAULT 0,
232 `from_id` int(1) NOT NULL,
233 `to_id` int(1) NOT NULL,
234 `type` int(1) NOT NULL,
235 `insert_time` text NOT NULL,
236 PRIMARY KEY (`id`)
237) ENGINE=InnoDB AUTO_INCREMENT=319 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
238
239-- Export de données de la table altislife.gouvernement_logs : ~17 rows (environ)
240DELETE FROM `gouvernement_logs`;
241/*!40000 ALTER TABLE `gouvernement_logs` DISABLE KEYS */;
242INSERT INTO `gouvernement_logs` (`id`, `name`, `value`, `from_id`, `to_id`, `type`, `insert_time`) VALUES
243 (302, 'Fernando Gomez', 525, 3, 0, 2, '"[2018,11,12,19,2,26]"'),
244 (303, 'Steven Afroman', 525, 3, 0, 2, '"[2018,11,12,19,3,29]"'),
245 (304, 'Ezio Reese', 6000, 3, 0, 2, '"[2018,11,12,19,4,23]"'),
246 (305, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,12,19,51,24]"'),
247 (306, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,12,19,56,24]"'),
248 (307, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,12,20,8,45]"'),
249 (308, 'Fernando Gomez', 6000, 3, 0, 2, '"[2018,11,12,20,13,18]"'),
250 (309, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,12,20,13,44]"'),
251 (310, 'Fernando Gomez', 6000, 3, 0, 2, '"[2018,11,12,20,18,25]"'),
252 (311, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,12,20,18,48]"'),
253 (312, 'Fernando Gomez', 6000, 3, 0, 2, '"[2018,11,12,20,23,28]"'),
254 (313, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,12,20,23,47]"'),
255 (314, 'Steven Afroman', 260, 3, 0, 1, '"[2018,11,13,18,46,0]"'),
256 (315, 'Ezio Reese', 525, 3, 0, 2, '"[2018,11,13,18,46,33]"'),
257 (316, 'Steven Afroman', 525, 3, 0, 2, '"[2018,11,13,18,46,57]"'),
258 (317, 'Steven Afroman', 260, 3, 0, 1, '"[2018,11,13,18,47,14]"'),
259 (318, 'Steven Afroman', 260, 3, 0, 1, '"[2018,11,13,18,48,31]"');
260/*!40000 ALTER TABLE `gouvernement_logs` ENABLE KEYS */;
261
262-- Export de la structure de la table altislife. houses
263CREATE TABLE IF NOT EXISTS `houses` (
264 `id` int(6) NOT NULL AUTO_INCREMENT,
265 `pid` varchar(17) NOT NULL,
266 `pos` varchar(64) DEFAULT NULL,
267 `owned` tinyint(1) DEFAULT 0,
268 `garage` tinyint(1) NOT NULL DEFAULT 0,
269 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
270 PRIMARY KEY (`id`,`pid`)
271) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
272
273-- Export de données de la table altislife.houses : ~2 rows (environ)
274DELETE FROM `houses`;
275/*!40000 ALTER TABLE `houses` DISABLE KEYS */;
276INSERT INTO `houses` (`id`, `pid`, `pos`, `owned`, `garage`, `insert_time`) VALUES
277 (4, '76561198347670255', '[12129.3,14058.2,0.14]', 1, 0, '2018-11-10 17:51:02'),
278 (5, '76561198289832461', '[12129.3,14058.2,0.14]', 1, 0, '2018-11-10 17:51:02');
279/*!40000 ALTER TABLE `houses` ENABLE KEYS */;
280
281-- Export de la structure de la table altislife. interpol
282CREATE TABLE IF NOT EXISTS `interpol` (
283 `id` int(6) NOT NULL AUTO_INCREMENT,
284 `prenom` varchar(32) NOT NULL,
285 `nom` varchar(32) NOT NULL,
286 `naissance` text NOT NULL,
287 `adresse` text NOT NULL,
288 `ville` text NOT NULL,
289 `numero` varchar(32) NOT NULL DEFAULT '0',
290 `yeux` text NOT NULL,
291 `details` text NOT NULL,
292 `insert_time` text NOT NULL,
293 PRIMARY KEY (`id`)
294) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
295
296-- Export de données de la table altislife.interpol : ~0 rows (environ)
297DELETE FROM `interpol`;
298/*!40000 ALTER TABLE `interpol` DISABLE KEYS */;
299/*!40000 ALTER TABLE `interpol` ENABLE KEYS */;
300
301-- Export de la structure de la table altislife. interpol_crimes
302CREATE TABLE IF NOT EXISTS `interpol_crimes` (
303 `id` int(6) NOT NULL AUTO_INCREMENT,
304 `interpol_id` int(6) NOT NULL,
305 `crime` varchar(64) NOT NULL,
306 `price` int(100) NOT NULL,
307 `payed` tinyint(1) NOT NULL DEFAULT 0,
308 `insert_time` text NOT NULL,
309 PRIMARY KEY (`id`)
310) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
311
312-- Export de données de la table altislife.interpol_crimes : ~3 rows (environ)
313DELETE FROM `interpol_crimes`;
314/*!40000 ALTER TABLE `interpol_crimes` DISABLE KEYS */;
315INSERT INTO `interpol_crimes` (`id`, `interpol_id`, `crime`, `price`, `payed`, `insert_time`) VALUES
316 (2, 2, 'Actes terroristes', 5000000, 1, '"[2018,11,6,21,20,6]"'),
317 (3, 2, 'asdasd', 99999, 1, '"[2018,11,6,21,21,20]"'),
318 (4, 3, 'Actes terroristes', 5000000, 1, '"[2018,11,10,2,55,5]"');
319/*!40000 ALTER TABLE `interpol_crimes` ENABLE KEYS */;
320
321-- Export de la structure de la table altislife. permis
322CREATE TABLE IF NOT EXISTS `permis` (
323 `id` int(8) NOT NULL AUTO_INCREMENT,
324 `pid` varchar(17) NOT NULL DEFAULT '0',
325 `reason` varchar(255) NOT NULL DEFAULT '0',
326 `insert_time` datetime NOT NULL DEFAULT current_timestamp(),
327 PRIMARY KEY (`id`)
328) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
329
330-- Export de données de la table altislife.permis : ~10 rows (environ)
331DELETE FROM `permis`;
332/*!40000 ALTER TABLE `permis` DISABLE KEYS */;
333INSERT INTO `permis` (`id`, `pid`, `reason`, `insert_time`) VALUES
334 (1, '76561198347670255', 'car il a une petit bite', '2018-11-12 18:34:33'),
335 (2, '76561198127878352', 'Suce pas ma bite', '2018-11-12 18:51:35'),
336 (3, '76561198289832461', 'Radar mobile (38km/h)', '2018-11-12 20:14:32'),
337 (4, '76561198289832461', 'Radar mobile (68km/h)', '2018-11-12 20:14:49'),
338 (5, '76561198289832461', 'Radar mobile (42km/h)', '2018-11-12 20:15:09'),
339 (6, '76561198127878352', 'Radar mobile (35km/h)', '2018-11-12 20:15:57'),
340 (7, '76561198289832461', 'Radar mobile (81km/h)', '2018-11-12 20:23:55'),
341 (8, '76561198127878352', 'Radar mobile (83km/h)', '2018-11-12 20:24:23'),
342 (9, '76561198127878352', 'Radar mobile (55km/h)', '2018-11-12 20:24:56'),
343 (10, '76561198127878352', 'Radar mobile (61km/h)', '2018-11-12 21:48:20');
344/*!40000 ALTER TABLE `permis` ENABLE KEYS */;
345
346-- Export de la structure de la table altislife. players
347CREATE TABLE IF NOT EXISTS `players` (
348 `uid` int(6) NOT NULL AUTO_INCREMENT,
349 `name` varchar(32) NOT NULL,
350 `aliases` text NOT NULL,
351 `pid` varchar(17) NOT NULL,
352 `cash` int(100) NOT NULL DEFAULT 0,
353 `bankacc` int(100) NOT NULL DEFAULT 0,
354 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
355 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
356 `civ_licenses` text NOT NULL,
357 `cop_licenses` text NOT NULL,
358 `med_licenses` text NOT NULL,
359 `civ_gear` text NOT NULL,
360 `cop_gear` text NOT NULL,
361 `med_gear` text NOT NULL,
362 `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
363 `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
364 `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
365 `arrested` tinyint(1) NOT NULL DEFAULT 0,
366 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
367 `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
368 `blacklist` tinyint(1) NOT NULL DEFAULT 0,
369 `civ_alive` tinyint(1) NOT NULL DEFAULT 0,
370 `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
371 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
372 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
373 `last_seen` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
374 `num` varchar(10) NOT NULL DEFAULT '0',
375 `contact` text DEFAULT NULL,
376 `sms` int(10) NOT NULL DEFAULT 0,
377 `appel` int(10) NOT NULL DEFAULT 0,
378 `annuaire` enum('0','1') NOT NULL DEFAULT '1',
379 `pointsPermis` enum('0','1','2','3','4','5','6','7','8','9','10','11','12') NOT NULL DEFAULT '0',
380 PRIMARY KEY (`uid`),
381 UNIQUE KEY `pid` (`pid`),
382 KEY `name` (`name`),
383 KEY `blacklist` (`blacklist`)
384) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4;
385
386-- Export de données de la table altislife.players : ~3 rows (environ)
387DELETE FROM `players`;
388/*!40000 ALTER TABLE `players` DISABLE KEYS */;
389INSERT 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
390 (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'),
391 (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'),
392 (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');
393/*!40000 ALTER TABLE `players` ENABLE KEYS */;
394
395-- Export de la structure de la procédure altislife. resetLifeVehicles
396DELIMITER //
397CREATE DEFINER=`root`@`localhost` PROCEDURE `resetLifeVehicles`()
398BEGIN
399 UPDATE `vehicles` SET `active`= 0;
400END//
401DELIMITER ;
402
403-- Export de la structure de la table altislife. vehicles
404CREATE TABLE IF NOT EXISTS `vehicles` (
405 `id` int(6) NOT NULL AUTO_INCREMENT,
406 `side` varchar(16) NOT NULL,
407 `classname` varchar(64) NOT NULL,
408 `type` varchar(16) NOT NULL,
409 `pid` varchar(17) NOT NULL,
410 `alive` tinyint(1) NOT NULL DEFAULT 1,
411 `blacklist` tinyint(1) NOT NULL DEFAULT 0,
412 `active` tinyint(1) NOT NULL DEFAULT 0,
413 `plate` int(20) NOT NULL,
414 `color` int(20) NOT NULL,
415 `inventory` text NOT NULL,
416 `gear` text NOT NULL,
417 `fuel` double NOT NULL DEFAULT 1,
418 `damage` varchar(256) NOT NULL,
419 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
420 `entreprise_id` int(10) NOT NULL DEFAULT 0,
421 `immatriculation` text NOT NULL,
422 PRIMARY KEY (`id`),
423 KEY `side` (`side`),
424 KEY `pid` (`pid`),
425 KEY `type` (`type`)
426) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4;
427
428-- Export de données de la table altislife.vehicles : ~28 rows (environ)
429DELETE FROM `vehicles`;
430/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
431INSERT INTO `vehicles` (`id`, `side`, `classname`, `type`, `pid`, `alive`, `blacklist`, `active`, `plate`, `color`, `inventory`, `gear`, `fuel`, `damage`, `insert_time`, `entreprise_id`, `immatriculation`) VALUES
432 (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"'),
433 (3, 'cop', 'B_MRAP_01_F', 'Car', '76561198289832461', 1, 0, 0, 310271, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-06 18:08:39', 0, '"CE510EN"'),
434 (4, 'cop', 'C_Hatchback_01_sport_F', 'Car', '76561198289832461', 1, 0, 0, 148139, 6, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-06 18:20:32', 0, '"JC376FD"'),
435 (5, 'civ', 'C_Offroad_02_unarmed_F', 'Car', '76561198347670255', 1, 0, 0, 550277, 5, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-06 18:49:46', 0, '"RI522WG"'),
436 (7, 'cop', 'G65lu_B', 'Car', '76561198289832461', 1, 0, 0, 455003, 0, '"[[],0]"', '"[]"', 0.985751, '"[]"', '2018-11-06 21:13:24', 0, '"MR908LL"'),
437 (8, 'cop', 'Gallardolu_Gendarmerie', 'Car', '76561198289832461', 1, 0, 0, 944599, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-06 21:24:28', 0, '"TT265PJ"'),
438 (10, 'civ', 'B_Quadbike_01_F', 'Car', '76561198289832461', 1, 0, 0, 99658, 7, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-07 21:20:26', 0, '"NO152KN"'),
439 (11, 'civ', 'AmaZiinG_Maybach_W222', 'Car', '76561198289832461', 1, 0, 0, 615674, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-09 19:49:31', 0, '"MB783OG"'),
440 (12, 'civ', 'Explorerlu_US', 'Car', '76561198289832461', 1, 0, 0, 804384, 0, '"[[],0]"', '"[]"', 0.999688, '"[]"', '2018-11-09 20:55:57', 0, '"XU319HY"'),
441 (13, 'civ', 'cha110', 'Car', '76561198289832461', 1, 0, 0, 382672, 13, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-09 21:48:53', 0, '"LN216NN"'),
442 (14, 'civ', 'C_Plane_Civil_01_F', 'Air', '76561198289832461', 1, 0, 0, 127220, 4, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-09 23:32:21', 0, '"OP370WF"'),
443 (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"'),
444 (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"'),
445 (19, 'civ', 'C63Slu_GMK', 'Car', '76561198289832461', 1, 0, 0, 313365, 3, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-09 23:50:49', 0, '"QB542AH"'),
446 (20, 'civ', 'WRXlu_civ', 'Car', '76561198289832461', 1, 0, 0, 894927, 4, '"[[],0]"', '"[]"', 0.99991, '"[]"', '2018-11-10 01:21:58', 0, '"LO368OZ"'),
447 (21, 'civ', 'chclio3_civ', 'Car', '76561198347670255', 1, 0, 0, 543053, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-10 02:35:14', 0, '"EE646SP"'),
448 (22, 'civ', 'V250lu_B', 'Car', '76561198289832461', 1, 0, 0, 928363, 0, '"[[],0]"', '"[]"', 0.999795, '"[]"', '2018-11-10 17:48:32', 0, '"RL543RN"'),
449 (23, 'med', '1200RT_sp_ch', 'Car', '76561198289832461', 1, 0, 0, 760970, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-11 13:57:27', 0, '"DP162KR"'),
450 (24, 'civ', 'subaruch_civ', 'Car', '76561198289832461', 1, 0, 0, 693203, 5, '"[[],0]"', '"[]"', 0.999603, '"[]"', '2018-11-12 02:00:13', 0, '"BN877VP"'),
451 (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"'),
452 (26, 'civ', 'RS3lu_civ', 'Car', '76561198127878352', 1, 0, 0, 991566, 7, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-12 19:00:17', 0, '"KE366GK"'),
453 (28, 'civ', 'RS3lu_civ', 'Car', '76561198127878352', 1, 0, 0, 481394, 11, '"[[],0]"', '"[]"', 0.883388, '"[]"', '2018-11-12 20:31:03', 0, '"NK553OD"'),
454 (29, 'civ', '1200RT_ch', 'Car', '76561198127878352', 1, 0, 0, 707922, 6, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-12 20:34:08', 0, '"PU515MX"'),
455 (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"'),
456 (32, 'cop', 'B_Heli_Transport_01_F', 'Air', '76561198127878352', 1, 0, 0, 553035, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-12 21:45:01', 0, '"MX943IW"'),
457 (34, 'cop', 'V250lu_B', 'Car', '76561198127878352', 1, 0, 0, 633644, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-12 23:11:58', 0, '"DB316CP"'),
458 (35, 'cop', 'Gallardolu_Gendarmerie', 'Car', '76561198347670255', 1, 0, 0, 551718, 0, '"[[],0]"', '"[]"', 1, '"[]"', '2018-11-13 00:25:19', 0, '"UT282EQ"'),
459 (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"');
460/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
461
462-- Export de la structure de la table altislife. wanted
463CREATE TABLE IF NOT EXISTS `wanted` (
464 `wantedID` varchar(64) NOT NULL,
465 `wantedName` varchar(32) NOT NULL,
466 `wantedCrimes` text NOT NULL,
467 `wantedBounty` int(100) NOT NULL,
468 `active` tinyint(1) NOT NULL DEFAULT 0,
469 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
470 PRIMARY KEY (`wantedID`)
471) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
472
473-- Export de données de la table altislife.wanted : ~2 rows (environ)
474DELETE FROM `wanted`;
475/*!40000 ALTER TABLE `wanted` DISABLE KEYS */;
476INSERT INTO `wanted` (`wantedID`, `wantedName`, `wantedCrimes`, `wantedBounty`, `active`, `insert_time`) VALUES
477 ('76561198289832461', 'Ezio Reese', '"[`187`,`187`,`187`,`187`,`187`]"', 10000, 1, '2018-11-12 19:55:08'),
478 ('76561198347670255', 'Steven Afroman', '"[`187`,`187`,`187`,`187`,`187`,`187`,`187`]"', 14000, 1, '2018-11-12 21:37:13');
479/*!40000 ALTER TABLE `wanted` ENABLE KEYS */;
480
481/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
482/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
483/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;