· 9 years ago · Jan 25, 2017, 02:42 PM
1-- phpMyAdmin SQL Dump
2-- version 3.4.11.1deb2+deb7u7
3-- http://www.phpmyadmin.net
4--
5-- Client: localhost
6-- Généré le: Mer 25 Janvier 2017 à 14:40
7-- Version du serveur: 5.5.53
8-- Version de PHP: 5.4.45-0+deb7u6
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Base de données: `fair2`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `accounts`
27--
28
29CREATE TABLE IF NOT EXISTS `accounts` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `username` text,
32 `password` text,
33 `registerdate` datetime DEFAULT NULL,
34 `lastlogin` datetime DEFAULT NULL,
35 `ip` text,
36 `admin` tinyint(3) DEFAULT '0',
37 `hiddenadmin` tinyint(3) unsigned DEFAULT '0',
38 `adminduty` tinyint(3) unsigned DEFAULT '0',
39 `adminjail` tinyint(3) unsigned DEFAULT '0',
40 `adminjail_time` int(11) DEFAULT NULL,
41 `adminjail_by` text,
42 `adminjail_reason` text,
43 `banned` tinyint(3) unsigned DEFAULT '0',
44 `banned_by` text,
45 `banned_reason` text,
46 `muted` tinyint(3) unsigned DEFAULT '0',
47 `globalooc` tinyint(3) unsigned DEFAULT '1',
48 `country` text,
49 `friendsmessage` text,
50 `adminjail_permanent` tinyint(3) unsigned DEFAULT '0',
51 `adminreports` int(11) DEFAULT '0',
52 `warns` tinyint(3) unsigned DEFAULT '0',
53 `chatbubbles` tinyint(3) unsigned NOT NULL DEFAULT '1',
54 `adminnote` text,
55 `appstate` tinyint(1) DEFAULT '0',
56 `appdatetime` datetime DEFAULT NULL,
57 `appreason` longtext,
58 `email` text,
59 `help` int(1) NOT NULL DEFAULT '1',
60 `adblocked` int(1) NOT NULL DEFAULT '0',
61 `newsblocked` int(1) NOT NULL DEFAULT '0',
62 `mtaserial` text,
63 `d_addiction` text,
64 `loginhash` varchar(64) DEFAULT NULL,
65 `credits` int(11) DEFAULT '0',
66 `transfers` int(11) DEFAULT '0',
67 `monitored` varchar(255) NOT NULL DEFAULT 'New Player',
68 UNIQUE KEY `id` (`id`)
69) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;
70
71--
72-- Contenu de la table `accounts`
73--
74
75INSERT INTO `accounts` (`id`, `username`, `password`, `registerdate`, `lastlogin`, `ip`, `admin`, `hiddenadmin`, `adminduty`, `adminjail`, `adminjail_time`, `adminjail_by`, `adminjail_reason`, `banned`, `banned_by`, `banned_reason`, `muted`, `globalooc`, `country`, `friendsmessage`, `adminjail_permanent`, `adminreports`, `warns`, `chatbubbles`, `adminnote`, `appstate`, `appdatetime`, `appreason`, `email`, `help`, `adblocked`, `newsblocked`, `mtaserial`, `d_addiction`, `loginhash`, `credits`, `transfers`, `monitored`) VALUES
76(25, 'mickael', '9823eee52f541a18e687d9f78e067f83', '2017-01-15 18:21:43', '2017-01-22 18:39:57', '88.169.219.56', 6, 0, 1, 0, NULL, NULL, NULL, 0, NULL, NULL, 0, 1, NULL, NULL, 0, 0, 0, 1, NULL, 3, NULL, NULL, 'mta59900@gmail.com', 1, 0, 0, 'EF2C653224A5E2B1B0B0A253FAC898A1', NULL, 'MTHSYiwt3OYO7SQN0pgAjiKYN4qUEmUg6sYVAkeuZ29XLPAB5G2eOD2sxjd1wY7t', 0, 0, 'New Player');
77
78-- --------------------------------------------------------
79
80--
81-- Structure de la table `adminhistory`
82--
83
84CREATE TABLE IF NOT EXISTS `adminhistory` (
85 `id` int(10) unsigned NOT NULL,
86 `user` int(10) unsigned NOT NULL,
87 `user_char` text NOT NULL,
88 `admin` int(10) unsigned NOT NULL,
89 `admin_char` text NOT NULL,
90 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
91 `action` tinyint(3) unsigned NOT NULL,
92 `duration` int(10) unsigned NOT NULL,
93 `reason` text NOT NULL,
94 `hiddenadmin` tinyint(3) unsigned NOT NULL,
95 PRIMARY KEY (`id`)
96) ENGINE=InnoDB DEFAULT CHARSET=latin1;
97
98-- --------------------------------------------------------
99
100--
101-- Structure de la table `apb`
102--
103
104CREATE TABLE IF NOT EXISTS `apb` (
105 `id` int(11) NOT NULL AUTO_INCREMENT,
106 `description` text NOT NULL,
107 `doneby` int(11) NOT NULL,
108 `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
109 PRIMARY KEY (`id`)
110) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
111
112-- --------------------------------------------------------
113
114--
115-- Structure de la table `applications`
116--
117
118CREATE TABLE IF NOT EXISTS `applications` (
119 `id` int(11) NOT NULL AUTO_INCREMENT,
120 `accountID` int(11) NOT NULL,
121 `dateposted` datetime NOT NULL,
122 `content` text NOT NULL,
123 `datereviewed` datetime DEFAULT NULL,
124 `adminID` int(11) DEFAULT NULL,
125 `adminNote` text,
126 `adminAction` int(11) NOT NULL DEFAULT '1',
127 PRIMARY KEY (`id`)
128) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
129
130-- --------------------------------------------------------
131
132--
133-- Structure de la table `atms`
134--
135
136CREATE TABLE IF NOT EXISTS `atms` (
137 `id` int(11) NOT NULL AUTO_INCREMENT,
138 `x` decimal(10,6) DEFAULT '0.000000',
139 `y` decimal(10,6) DEFAULT '0.000000',
140 `z` decimal(10,6) DEFAULT '0.000000',
141 `rotation` decimal(10,6) DEFAULT '0.000000',
142 `dimension` int(5) DEFAULT '0',
143 `interior` int(5) DEFAULT '0',
144 `deposit` tinyint(3) unsigned DEFAULT '0',
145 `limit` int(10) unsigned DEFAULT '5000',
146 UNIQUE KEY `id` (`id`)
147) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
148
149-- --------------------------------------------------------
150
151--
152-- Structure de la table `characters`
153--
154
155CREATE TABLE IF NOT EXISTS `characters` (
156 `id` int(11) NOT NULL AUTO_INCREMENT,
157 `charactername` text,
158 `account` int(11) DEFAULT '0',
159 `x` float DEFAULT '1742.19',
160 `y` float DEFAULT '-1861.36',
161 `z` float DEFAULT '13.5776',
162 `rotation` float DEFAULT '0.986053',
163 `interior_id` int(5) DEFAULT '0',
164 `dimension_id` int(5) DEFAULT '0',
165 `health` float DEFAULT '100',
166 `armor` float DEFAULT '0',
167 `skin` int(3) DEFAULT '264',
168 `money` bigint(20) DEFAULT '250',
169 `gender` int(1) DEFAULT '0',
170 `cuffed` int(11) DEFAULT '0',
171 `duty` int(3) DEFAULT '0',
172 `cellnumber` int(30) DEFAULT '0',
173 `fightstyle` int(2) DEFAULT '4',
174 `pdjail` int(1) DEFAULT '0',
175 `pdjail_time` int(11) DEFAULT '0',
176 `job` int(3) DEFAULT '0',
177 `cked` int(1) DEFAULT '0',
178 `lastarea` text,
179 `age` int(3) DEFAULT '18',
180 `faction_id` int(11) DEFAULT '-1',
181 `faction_rank` int(2) DEFAULT '1',
182 `faction_perks` text,
183 `skincolor` int(1) DEFAULT '0',
184 `weight` int(3) DEFAULT '180',
185 `height` int(3) DEFAULT '180',
186 `description` text,
187 `deaths` int(11) DEFAULT '0',
188 `faction_leader` int(1) DEFAULT '0',
189 `fingerprint` text,
190 `casualskin` int(3) DEFAULT '0',
191 `bankmoney` bigint(20) DEFAULT '500',
192 `car_license` int(1) DEFAULT '0',
193 `gun_license` int(1) DEFAULT '0',
194 `tag` int(3) DEFAULT '1',
195 `hoursplayed` int(11) DEFAULT '0',
196 `pdjail_station` int(1) DEFAULT '0',
197 `timeinserver` int(2) DEFAULT '0',
198 `restrainedobj` int(11) DEFAULT '0',
199 `restrainedby` int(11) DEFAULT '0',
200 `dutyskin` int(3) DEFAULT '-1',
201 `fish` int(10) unsigned NOT NULL DEFAULT '0',
202 `truckingruns` int(10) unsigned NOT NULL DEFAULT '0',
203 `truckingwage` int(10) unsigned NOT NULL DEFAULT '0',
204 `blindfold` tinyint(4) NOT NULL DEFAULT '0',
205 `lang1` tinyint(2) DEFAULT '1',
206 `lang1skill` tinyint(3) DEFAULT '100',
207 `lang2` tinyint(2) DEFAULT '0',
208 `lang2skill` tinyint(3) DEFAULT '0',
209 `lang3` tinyint(2) DEFAULT '0',
210 `lang3skill` tinyint(3) DEFAULT '0',
211 `currlang` tinyint(1) DEFAULT '1',
212 `lastlogin` datetime DEFAULT NULL,
213 `creationdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
214 `election_candidate` tinyint(3) unsigned NOT NULL DEFAULT '0',
215 `election_canvote` tinyint(3) unsigned NOT NULL DEFAULT '0',
216 `election_votedfor` int(10) unsigned NOT NULL DEFAULT '0',
217 `jobcontract` tinyint(3) unsigned NOT NULL DEFAULT '0',
218 `marriedto` int(10) unsigned NOT NULL DEFAULT '0',
219 `photos` int(10) unsigned NOT NULL DEFAULT '0',
220 `maxvehicles` int(4) unsigned NOT NULL DEFAULT '5',
221 `ck_info` text,
222 `alcohollevel` float NOT NULL DEFAULT '0',
223 `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
224 `walkingstyle` smallint(4) NOT NULL DEFAULT '0',
225 `hunger` tinyint(4) NOT NULL DEFAULT '100',
226 `thirst` tinyint(4) NOT NULL DEFAULT '100',
227 `endurance` tinyint(4) NOT NULL DEFAULT '100',
228 UNIQUE KEY `id` (`id`)
229) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;
230
231--
232-- Contenu de la table `characters`
233--
234
235INSERT INTO `characters` (`id`, `charactername`, `account`, `x`, `y`, `z`, `rotation`, `interior_id`, `dimension_id`, `health`, `armor`, `skin`, `money`, `gender`, `cuffed`, `duty`, `cellnumber`, `fightstyle`, `pdjail`, `pdjail_time`, `job`, `cked`, `lastarea`, `age`, `faction_id`, `faction_rank`, `faction_perks`, `skincolor`, `weight`, `height`, `description`, `deaths`, `faction_leader`, `fingerprint`, `casualskin`, `bankmoney`, `car_license`, `gun_license`, `tag`, `hoursplayed`, `pdjail_station`, `timeinserver`, `restrainedobj`, `restrainedby`, `dutyskin`, `fish`, `truckingruns`, `truckingwage`, `blindfold`, `lang1`, `lang1skill`, `lang2`, `lang2skill`, `lang3`, `lang3skill`, `currlang`, `lastlogin`, `creationdate`, `election_candidate`, `election_canvote`, `election_votedfor`, `jobcontract`, `marriedto`, `photos`, `maxvehicles`, `ck_info`, `alcohollevel`, `active`, `walkingstyle`, `hunger`, `thirst`, `endurance`) VALUES
236(39, 'Mickael_Adkins', 25, 617.458, -598.102, 22.7258, 261.772, 0, 0, 90, 0, 7, 749, 0, 0, 0, 15039, 4, 0, 0, 2, 0, 'Dillimore', 18, 4, 1, NULL, 0, 50, 150, '', 1, 1, '99E85C72FD0830A68284E6812AAC8D3D', 7, 1007, 0, 0, 1, 2, 0, 94, 0, 0, -1, 0, 0, 0, 0, 1, 100, 0, 0, 0, 0, 1, '2017-01-22 18:39:57', '2017-01-21 14:37:16', 0, 0, 0, 1, 0, 0, 5, NULL, 0, 1, 0, 100, 100, 100);
237
238-- --------------------------------------------------------
239
240--
241-- Structure de la table `character_settings`
242--
243
244CREATE TABLE IF NOT EXISTS `character_settings` (
245 `id` smallint(6) DEFAULT NULL,
246 `showCharacter` tinyint(4) NOT NULL DEFAULT '1',
247 `percentageHUD` tinyint(4) NOT NULL DEFAULT '1',
248 `percentageNeeds` tinyint(4) NOT NULL DEFAULT '1',
249 `hungerColorR` smallint(6) NOT NULL DEFAULT '200',
250 `hungerColorG` smallint(6) NOT NULL DEFAULT '100',
251 `hungerColorB` smallint(6) NOT NULL DEFAULT '0',
252 `hungerColorA` smallint(6) NOT NULL DEFAULT '220',
253 `hungerIconColorR` smallint(6) NOT NULL DEFAULT '0',
254 `hungerIconColorG` smallint(6) NOT NULL DEFAULT '0',
255 `hungerIconColorB` smallint(6) NOT NULL DEFAULT '0',
256 `hungerIconColorA` smallint(6) NOT NULL DEFAULT '255',
257 `thirstColorR` smallint(6) NOT NULL DEFAULT '200',
258 `thirstColorG` smallint(6) NOT NULL DEFAULT '200',
259 `thirstColorB` smallint(6) NOT NULL DEFAULT '0',
260 `thirstColorA` smallint(6) NOT NULL DEFAULT '220',
261 `thirstIconColorR` smallint(6) NOT NULL DEFAULT '0',
262 `thirstIconColorG` smallint(6) NOT NULL DEFAULT '0',
263 `thirstIconColorB` smallint(6) NOT NULL DEFAULT '0',
264 `thirstIconColorA` smallint(6) NOT NULL DEFAULT '255'
265) ENGINE=MyISAM DEFAULT CHARSET=latin1;
266
267--
268-- Contenu de la table `character_settings`
269--
270
271INSERT INTO `character_settings` (`id`, `showCharacter`, `percentageHUD`, `percentageNeeds`, `hungerColorR`, `hungerColorG`, `hungerColorB`, `hungerColorA`, `hungerIconColorR`, `hungerIconColorG`, `hungerIconColorB`, `hungerIconColorA`, `thirstColorR`, `thirstColorG`, `thirstColorB`, `thirstColorA`, `thirstIconColorR`, `thirstIconColorG`, `thirstIconColorB`, `thirstIconColorA`) VALUES
272(12, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
273(13, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
274(14, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
275(15, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
276(16, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
277(17, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
278(18, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
279(20, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
280(21, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
281(22, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
282(23, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
283(24, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
284(26, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
285(27, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
286(28, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
287(29, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
288(32, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
289(33, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
290(34, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
291(35, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
292(36, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
293(37, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
294(38, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
295(39, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
296(40, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255),
297(41, 1, 1, 1, 200, 100, 0, 220, 0, 0, 0, 255, 200, 200, 0, 220, 0, 0, 0, 255);
298
299-- --------------------------------------------------------
300
301--
302-- Structure de la table `computers`
303--
304
305CREATE TABLE IF NOT EXISTS `computers` (
306 `id` int(11) NOT NULL AUTO_INCREMENT,
307 `posX` float(10,5) NOT NULL,
308 `posY` float(10,5) NOT NULL,
309 `posZ` float(10,5) NOT NULL,
310 `rotX` float(10,5) NOT NULL,
311 `rotY` float(10,5) NOT NULL,
312 `rotZ` float(10,5) NOT NULL,
313 `interior` int(8) NOT NULL,
314 `dimension` int(8) NOT NULL,
315 `model` int(8) NOT NULL,
316 PRIMARY KEY (`id`)
317) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
318
319-- --------------------------------------------------------
320
321--
322-- Structure de la table `dancers`
323--
324
325CREATE TABLE IF NOT EXISTS `dancers` (
326 `id` int(10) unsigned NOT NULL,
327 `x` float NOT NULL,
328 `y` float NOT NULL,
329 `z` float NOT NULL,
330 `rotation` float NOT NULL,
331 `skin` smallint(5) unsigned NOT NULL,
332 `type` tinyint(3) unsigned NOT NULL,
333 `interior` int(10) unsigned NOT NULL,
334 `dimension` int(10) unsigned NOT NULL,
335 `offset` tinyint(3) unsigned NOT NULL,
336 PRIMARY KEY (`id`)
337) ENGINE=InnoDB DEFAULT CHARSET=latin1;
338
339-- --------------------------------------------------------
340
341--
342-- Structure de la table `donators`
343--
344
345CREATE TABLE IF NOT EXISTS `donators` (
346 `id` int(11) NOT NULL AUTO_INCREMENT,
347 `accountID` int(11) NOT NULL,
348 `charID` int(11) NOT NULL DEFAULT '-1',
349 `perkID` int(4) NOT NULL,
350 `perkValue` varchar(10) NOT NULL DEFAULT '1',
351 `expirationDate` datetime NOT NULL,
352 PRIMARY KEY (`id`)
353) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
354
355-- --------------------------------------------------------
356
357--
358-- Structure de la table `don_transactions`
359--
360
361CREATE TABLE IF NOT EXISTS `don_transactions` (
362 `id` int(11) NOT NULL AUTO_INCREMENT,
363 `transaction_id` varchar(64) NOT NULL,
364 `donator_email` varchar(255) NOT NULL,
365 `amount` double NOT NULL,
366 `original_request` text,
367 `dt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
368 `handled` smallint(1) DEFAULT '0',
369 `username` varchar(50) NOT NULL,
370 `realamount` double NOT NULL DEFAULT '0',
371 PRIMARY KEY (`id`)
372) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
373
374-- --------------------------------------------------------
375
376--
377-- Structure de la table `don_transaction_failed`
378--
379
380CREATE TABLE IF NOT EXISTS `don_transaction_failed` (
381 `id` int(11) NOT NULL AUTO_INCREMENT,
382 `output` text NOT NULL,
383 `ip` varchar(30) DEFAULT NULL,
384 PRIMARY KEY (`id`)
385) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
386
387-- --------------------------------------------------------
388
389--
390-- Structure de la table `elevators`
391--
392
393CREATE TABLE IF NOT EXISTS `elevators` (
394 `id` int(11) NOT NULL AUTO_INCREMENT,
395 `x` decimal(10,6) DEFAULT '0.000000',
396 `y` decimal(10,6) DEFAULT '0.000000',
397 `z` decimal(10,6) DEFAULT '0.000000',
398 `tpx` decimal(10,6) DEFAULT '0.000000',
399 `tpy` decimal(10,6) DEFAULT '0.000000',
400 `tpz` decimal(10,6) DEFAULT '0.000000',
401 `dimensionwithin` int(5) DEFAULT '0',
402 `interiorwithin` int(5) DEFAULT '0',
403 `dimension` int(5) DEFAULT '0',
404 `interior` int(5) DEFAULT '0',
405 `car` tinyint(3) unsigned DEFAULT '0',
406 `disabled` tinyint(3) unsigned DEFAULT '0',
407 UNIQUE KEY `id` (`id`)
408) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
409
410-- --------------------------------------------------------
411
412--
413-- Structure de la table `emailaccounts`
414--
415
416CREATE TABLE IF NOT EXISTS `emailaccounts` (
417 `id` int(11) NOT NULL AUTO_INCREMENT,
418 `username` text,
419 `password` text,
420 `creator` int(11) DEFAULT NULL,
421 UNIQUE KEY `id` (`id`)
422) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
423
424-- --------------------------------------------------------
425
426--
427-- Structure de la table `emails`
428--
429
430CREATE TABLE IF NOT EXISTS `emails` (
431 `id` int(11) NOT NULL AUTO_INCREMENT,
432 `date` datetime NOT NULL,
433 `sender` text,
434 `receiver` text,
435 `subject` text,
436 `message` text,
437 `inbox` int(1) NOT NULL DEFAULT '0',
438 `outbox` int(1) NOT NULL DEFAULT '0',
439 UNIQUE KEY `id` (`id`)
440) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
441
442-- --------------------------------------------------------
443
444--
445-- Structure de la table `factions`
446--
447
448CREATE TABLE IF NOT EXISTS `factions` (
449 `id` int(11) NOT NULL AUTO_INCREMENT,
450 `name` text,
451 `bankbalance` bigint(20) DEFAULT NULL,
452 `type` int(11) DEFAULT NULL,
453 `rank_1` text,
454 `rank_2` text,
455 `rank_3` text,
456 `rank_4` text,
457 `rank_5` text,
458 `rank_6` text,
459 `rank_7` text,
460 `rank_8` text,
461 `rank_9` text,
462 `rank_10` text,
463 `rank_11` text,
464 `rank_12` text,
465 `rank_13` text,
466 `rank_14` text,
467 `rank_15` text,
468 `rank_16` text,
469 `rank_17` text,
470 `rank_18` text,
471 `rank_19` text,
472 `rank_20` text,
473 `wage_1` int(11) DEFAULT '100',
474 `wage_2` int(11) DEFAULT '100',
475 `wage_3` int(11) DEFAULT '100',
476 `wage_4` int(11) DEFAULT '100',
477 `wage_5` int(11) DEFAULT '100',
478 `wage_6` int(11) DEFAULT '100',
479 `wage_7` int(11) DEFAULT '100',
480 `wage_8` int(11) DEFAULT '100',
481 `wage_9` int(11) DEFAULT '100',
482 `wage_10` int(11) DEFAULT '100',
483 `wage_11` int(11) DEFAULT '100',
484 `wage_12` int(11) DEFAULT '100',
485 `wage_13` int(11) DEFAULT '100',
486 `wage_14` int(11) DEFAULT '100',
487 `wage_15` int(11) DEFAULT '100',
488 `wage_16` int(11) DEFAULT '100',
489 `wage_17` int(11) DEFAULT '100',
490 `wage_18` int(11) DEFAULT '100',
491 `wage_19` int(11) DEFAULT '100',
492 `wage_20` int(11) DEFAULT '100',
493 `motd` text,
494 `note` text,
495 UNIQUE KEY `id` (`id`)
496) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
497
498-- --------------------------------------------------------
499
500--
501-- Structure de la table `forgotdetails`
502--
503
504CREATE TABLE IF NOT EXISTS `forgotdetails` (
505 `uniquekey` varchar(32) NOT NULL,
506 `account` int(11) DEFAULT '0',
507 `keytimestamp` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
508) ENGINE=InnoDB DEFAULT CHARSET=latin1;
509
510-- --------------------------------------------------------
511
512--
513-- Structure de la table `friends`
514--
515
516CREATE TABLE IF NOT EXISTS `friends` (
517 `id` int(10) unsigned NOT NULL,
518 `friend` int(10) unsigned NOT NULL,
519 PRIMARY KEY (`id`,`friend`)
520) ENGINE=InnoDB DEFAULT CHARSET=latin1;
521
522-- --------------------------------------------------------
523
524--
525-- Structure de la table `fuelpeds`
526--
527
528CREATE TABLE IF NOT EXISTS `fuelpeds` (
529 `id` int(11) NOT NULL AUTO_INCREMENT,
530 `posX` float NOT NULL,
531 `posY` float NOT NULL,
532 `posZ` float NOT NULL,
533 `rotZ` float NOT NULL,
534 `skin` int(3) NOT NULL,
535 `priceratio` int(3) NOT NULL,
536 `name` varchar(50) NOT NULL,
537 PRIMARY KEY (`id`)
538) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
539
540-- --------------------------------------------------------
541
542--
543-- Structure de la table `fuelstations`
544--
545
546CREATE TABLE IF NOT EXISTS `fuelstations` (
547 `id` int(11) NOT NULL AUTO_INCREMENT,
548 `x` decimal(10,6) DEFAULT '0.000000',
549 `y` decimal(10,6) DEFAULT '0.000000',
550 `z` decimal(10,6) DEFAULT '0.000000',
551 `interior` int(5) DEFAULT '0',
552 `dimension` int(5) DEFAULT '0',
553 UNIQUE KEY `id` (`id`)
554) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
555
556-- --------------------------------------------------------
557
558--
559-- Structure de la table `gates`
560--
561
562CREATE TABLE IF NOT EXISTS `gates` (
563 `id` int(11) NOT NULL AUTO_INCREMENT,
564 `objectID` int(11) NOT NULL,
565 `startX` float NOT NULL,
566 `startY` float NOT NULL,
567 `startZ` float NOT NULL,
568 `startRX` float NOT NULL,
569 `startRY` float NOT NULL,
570 `startRZ` float NOT NULL,
571 `endX` float NOT NULL,
572 `endY` float NOT NULL,
573 `endZ` float NOT NULL,
574 `endRX` float NOT NULL,
575 `endRY` float NOT NULL,
576 `endRZ` float NOT NULL,
577 `gateType` tinyint(3) unsigned NOT NULL,
578 `autocloseTime` int(4) NOT NULL,
579 `movementTime` int(4) NOT NULL,
580 `objectDimension` int(11) NOT NULL,
581 `objectInterior` int(11) NOT NULL,
582 `gateSecurityParameters` text,
583 PRIMARY KEY (`id`)
584) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
585
586-- --------------------------------------------------------
587
588--
589-- Structure de la table `interiors`
590--
591
592CREATE TABLE IF NOT EXISTS `interiors` (
593 `id` int(11) NOT NULL AUTO_INCREMENT,
594 `x` float DEFAULT '0',
595 `y` float DEFAULT '0',
596 `z` float DEFAULT '0',
597 `type` int(1) DEFAULT '0',
598 `owner` int(11) DEFAULT '-1',
599 `locked` int(1) DEFAULT '0',
600 `cost` int(11) DEFAULT '0',
601 `name` text,
602 `interior` int(5) DEFAULT '0',
603 `interiorx` float DEFAULT '0',
604 `interiory` float DEFAULT '0',
605 `interiorz` float DEFAULT '0',
606 `dimensionwithin` int(5) DEFAULT '0',
607 `interiorwithin` int(5) DEFAULT '0',
608 `angle` float DEFAULT '0',
609 `angleexit` float DEFAULT '0',
610 `supplies` int(11) DEFAULT '100',
611 `safepositionX` float DEFAULT NULL,
612 `safepositionY` float DEFAULT NULL,
613 `safepositionZ` float DEFAULT NULL,
614 `safepositionRZ` float DEFAULT NULL,
615 `fee` int(10) unsigned DEFAULT '0',
616 `disabled` tinyint(3) unsigned DEFAULT '0',
617 `lastused` datetime DEFAULT NULL,
618 UNIQUE KEY `id` (`id`)
619) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
620
621-- --------------------------------------------------------
622
623--
624-- Structure de la table `items`
625--
626
627CREATE TABLE IF NOT EXISTS `items` (
628 `index` int(10) unsigned NOT NULL AUTO_INCREMENT,
629 `type` tinyint(3) unsigned NOT NULL,
630 `owner` int(10) unsigned NOT NULL,
631 `itemID` int(10) NOT NULL,
632 `itemValue` text NOT NULL,
633 PRIMARY KEY (`index`)
634) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
635
636-- --------------------------------------------------------
637
638--
639-- Structure de la table `logtable`
640--
641
642CREATE TABLE IF NOT EXISTS `logtable` (
643 `time` datetime NOT NULL,
644 `action` int(2) NOT NULL,
645 `source` varchar(12) NOT NULL,
646 `affected` text NOT NULL,
647 `content` text
648) ENGINE=InnoDB DEFAULT CHARSET=latin1;
649
650-- --------------------------------------------------------
651
652--
653-- Structure de la table `lottery`
654--
655
656CREATE TABLE IF NOT EXISTS `lottery` (
657 `characterid` int(255) NOT NULL,
658 `ticketnumber` int(3) NOT NULL
659) ENGINE=InnoDB DEFAULT CHARSET=latin1;
660
661-- --------------------------------------------------------
662
663--
664-- Structure de la table `mdcusers`
665--
666
667CREATE TABLE IF NOT EXISTS `mdcusers` (
668 `user_name` varchar(20) NOT NULL,
669 `password` varchar(20) NOT NULL DEFAULT '123',
670 `high_command` int(1) DEFAULT '0'
671) ENGINE=InnoDB DEFAULT CHARSET=latin1;
672
673-- --------------------------------------------------------
674
675--
676-- Structure de la table `objects`
677--
678
679CREATE TABLE IF NOT EXISTS `objects` (
680 `id` int(11) NOT NULL AUTO_INCREMENT,
681 `model` int(6) NOT NULL DEFAULT '0',
682 `posX` float(12,7) NOT NULL DEFAULT '0.0000000',
683 `posY` float(12,7) NOT NULL DEFAULT '0.0000000',
684 `posZ` float(12,7) NOT NULL DEFAULT '0.0000000',
685 `rotX` float(12,7) NOT NULL DEFAULT '0.0000000',
686 `rotY` float(12,7) NOT NULL DEFAULT '0.0000000',
687 `rotZ` float(12,7) NOT NULL DEFAULT '0.0000000',
688 `interior` int(5) NOT NULL,
689 `dimension` int(5) NOT NULL,
690 `comment` varchar(50) DEFAULT NULL,
691 `solid` int(1) NOT NULL DEFAULT '1',
692 `doublesided` int(1) NOT NULL DEFAULT '0',
693 UNIQUE KEY `id` (`id`)
694) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
695
696-- --------------------------------------------------------
697
698--
699-- Structure de la table `paynspray`
700--
701
702CREATE TABLE IF NOT EXISTS `paynspray` (
703 `id` int(11) NOT NULL AUTO_INCREMENT,
704 `x` decimal(10,6) DEFAULT '0.000000',
705 `y` decimal(10,6) DEFAULT '0.000000',
706 `z` decimal(10,6) DEFAULT '0.000000',
707 `dimension` int(5) DEFAULT '0',
708 `interior` int(5) DEFAULT '0',
709 UNIQUE KEY `id` (`id`)
710) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
711
712-- --------------------------------------------------------
713
714--
715-- Structure de la table `phone_contacts`
716--
717
718CREATE TABLE IF NOT EXISTS `phone_contacts` (
719 `phone` int(11) NOT NULL,
720 `entryName` varchar(30) NOT NULL,
721 `entryNumber` int(11) NOT NULL
722) ENGINE=InnoDB DEFAULT CHARSET=latin1;
723
724-- --------------------------------------------------------
725
726--
727-- Structure de la table `phone_settings`
728--
729
730CREATE TABLE IF NOT EXISTS `phone_settings` (
731 `phonenumber` int(1) NOT NULL,
732 `turnedon` smallint(1) unsigned NOT NULL DEFAULT '1',
733 `secretnumber` smallint(1) unsigned NOT NULL DEFAULT '0',
734 `ringtone` smallint(1) NOT NULL DEFAULT '1',
735 `phonebook` varchar(40) DEFAULT NULL,
736 `boughtby` int(11) NOT NULL DEFAULT '-1',
737 PRIMARY KEY (`phonenumber`)
738) ENGINE=InnoDB DEFAULT CHARSET=latin1;
739
740-- --------------------------------------------------------
741
742--
743-- Structure de la table `publicphones`
744--
745
746CREATE TABLE IF NOT EXISTS `publicphones` (
747 `id` int(10) unsigned NOT NULL,
748 `x` float NOT NULL,
749 `y` float NOT NULL,
750 `z` float NOT NULL,
751 `dimension` int(10) unsigned NOT NULL,
752 PRIMARY KEY (`id`)
753) ENGINE=InnoDB DEFAULT CHARSET=latin1;
754
755-- --------------------------------------------------------
756
757--
758-- Structure de la table `settings`
759--
760
761CREATE TABLE IF NOT EXISTS `settings` (
762 `id` int(11) NOT NULL AUTO_INCREMENT,
763 `name` text,
764 `value` text,
765 UNIQUE KEY `id` (`id`)
766) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
767
768-- --------------------------------------------------------
769
770--
771-- Structure de la table `shops`
772--
773
774CREATE TABLE IF NOT EXISTS `shops` (
775 `id` int(11) NOT NULL AUTO_INCREMENT,
776 `x` float DEFAULT '0',
777 `y` float DEFAULT '0',
778 `z` float DEFAULT '0',
779 `dimension` int(5) DEFAULT '0',
780 `interior` int(5) DEFAULT '0',
781 `shoptype` tinyint(4) DEFAULT '0',
782 `rotation` float NOT NULL DEFAULT '0',
783 `skin` int(11) DEFAULT '-1',
784 UNIQUE KEY `id` (`id`)
785) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
786
787-- --------------------------------------------------------
788
789--
790-- Structure de la table `speedcams`
791--
792
793CREATE TABLE IF NOT EXISTS `speedcams` (
794 `id` int(11) NOT NULL AUTO_INCREMENT,
795 `x` float(11,7) NOT NULL DEFAULT '0.0000000',
796 `y` float(11,7) NOT NULL DEFAULT '0.0000000',
797 `z` float(11,7) NOT NULL DEFAULT '0.0000000',
798 `interior` int(3) NOT NULL DEFAULT '0' COMMENT 'Stores the location of the pernament speedcams',
799 `dimension` int(5) NOT NULL DEFAULT '0',
800 `maxspeed` int(4) NOT NULL DEFAULT '120',
801 `radius` int(4) NOT NULL DEFAULT '2',
802 `enabled` smallint(1) DEFAULT '1',
803 PRIMARY KEY (`id`)
804) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
805
806-- --------------------------------------------------------
807
808--
809-- Structure de la table `speedingviolations`
810--
811
812CREATE TABLE IF NOT EXISTS `speedingviolations` (
813 `id` int(11) NOT NULL AUTO_INCREMENT,
814 `carID` int(11) NOT NULL,
815 `time` datetime NOT NULL,
816 `speed` int(5) NOT NULL,
817 `area` varchar(50) NOT NULL,
818 `personVisible` int(11) NOT NULL,
819 PRIMARY KEY (`id`)
820) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
821
822-- --------------------------------------------------------
823
824--
825-- Structure de la table `suspectCrime`
826--
827
828CREATE TABLE IF NOT EXISTS `suspectCrime` (
829 `id` int(11) NOT NULL AUTO_INCREMENT,
830 `suspect_name` text,
831 `time` text,
832 `date` text,
833 `officers` text,
834 `ticket` int(11) DEFAULT NULL,
835 `arrest` int(11) DEFAULT NULL,
836 `fine` int(11) DEFAULT NULL,
837 `ticket_price` text,
838 `arrest_price` text,
839 `fine_price` text,
840 `illegal_items` text,
841 `details` text,
842 `done_by` text,
843 UNIQUE KEY `id` (`id`)
844) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
845
846-- --------------------------------------------------------
847
848--
849-- Structure de la table `suspectDetails`
850--
851
852CREATE TABLE IF NOT EXISTS `suspectDetails` (
853 `suspect_name` text,
854 `birth` text,
855 `gender` text,
856 `ethnicy` text,
857 `cell` int(5) DEFAULT '0',
858 `occupation` text,
859 `address` text,
860 `other` text,
861 `is_wanted` int(1) DEFAULT '0',
862 `wanted_reason` text,
863 `wanted_punishment` text,
864 `wanted_by` text,
865 `photo` text,
866 `done_by` text
867) ENGINE=InnoDB DEFAULT CHARSET=latin1;
868
869-- --------------------------------------------------------
870
871--
872-- Structure de la table `tags`
873--
874
875CREATE TABLE IF NOT EXISTS `tags` (
876 `id` int(11) NOT NULL AUTO_INCREMENT,
877 `x` decimal(10,6) DEFAULT NULL,
878 `y` decimal(10,6) DEFAULT NULL,
879 `z` decimal(10,6) DEFAULT NULL,
880 `interior` int(5) DEFAULT NULL,
881 `dimension` int(5) DEFAULT NULL,
882 `rx` decimal(10,6) DEFAULT NULL,
883 `ry` decimal(10,6) DEFAULT NULL,
884 `rz` decimal(10,6) DEFAULT NULL,
885 `modelid` int(5) DEFAULT NULL,
886 `creationdate` datetime DEFAULT NULL,
887 `creator` int(11) NOT NULL DEFAULT '-1',
888 UNIQUE KEY `id` (`id`)
889) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
890
891-- --------------------------------------------------------
892
893--
894-- Structure de la table `tc_comments`
895--
896
897CREATE TABLE IF NOT EXISTS `tc_comments` (
898 `id` int(11) NOT NULL AUTO_INCREMENT,
899 `poster` int(11) NOT NULL,
900 `ip` varchar(50) NOT NULL,
901 `message` text NOT NULL,
902 `posted` int(25) NOT NULL,
903 `type` int(1) NOT NULL,
904 `ticket` int(11) NOT NULL,
905 PRIMARY KEY (`id`)
906) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
907
908-- --------------------------------------------------------
909
910--
911-- Structure de la table `tc_tickets`
912--
913
914CREATE TABLE IF NOT EXISTS `tc_tickets` (
915 `id` int(11) NOT NULL AUTO_INCREMENT,
916 `creator` int(11) NOT NULL,
917 `posted` int(25) NOT NULL,
918 `subject` varchar(100) NOT NULL,
919 `message` text NOT NULL,
920 `status` int(1) NOT NULL,
921 `lastpost` int(25) NOT NULL,
922 `assigned` int(11) NOT NULL,
923 `IP` varchar(50) NOT NULL,
924 PRIMARY KEY (`id`)
925) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
926
927-- --------------------------------------------------------
928
929--
930-- Structure de la table `tempinteriors`
931--
932
933CREATE TABLE IF NOT EXISTS `tempinteriors` (
934 `id` int(11) NOT NULL AUTO_INCREMENT,
935 `posX` float NOT NULL,
936 `posY` float DEFAULT NULL,
937 `posZ` float DEFAULT NULL,
938 `interior` int(5) DEFAULT NULL,
939 UNIQUE KEY `id` (`id`)
940) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
941
942-- --------------------------------------------------------
943
944--
945-- Structure de la table `tempobjects`
946--
947
948CREATE TABLE IF NOT EXISTS `tempobjects` (
949 `id` int(11) NOT NULL AUTO_INCREMENT,
950 `model` int(6) NOT NULL DEFAULT '0',
951 `posX` float(12,7) NOT NULL DEFAULT '0.0000000',
952 `posY` float(12,7) NOT NULL DEFAULT '0.0000000',
953 `posZ` float(12,7) NOT NULL DEFAULT '0.0000000',
954 `rotX` float(12,7) NOT NULL DEFAULT '0.0000000',
955 `rotY` float(12,7) NOT NULL DEFAULT '0.0000000',
956 `rotZ` float(12,7) NOT NULL DEFAULT '0.0000000',
957 `interior` int(5) NOT NULL,
958 `dimension` int(5) NOT NULL,
959 `comment` varchar(50) DEFAULT NULL,
960 `solid` int(1) NOT NULL DEFAULT '1',
961 `doublesided` int(1) NOT NULL DEFAULT '0',
962 PRIMARY KEY (`id`)
963) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
964
965-- --------------------------------------------------------
966
967--
968-- Structure de la table `vehicles`
969--
970
971CREATE TABLE IF NOT EXISTS `vehicles` (
972 `id` int(11) NOT NULL AUTO_INCREMENT,
973 `model` int(3) DEFAULT '0',
974 `x` decimal(10,6) DEFAULT '0.000000',
975 `y` decimal(10,6) DEFAULT '0.000000',
976 `z` decimal(10,6) DEFAULT '0.000000',
977 `rotx` decimal(10,6) DEFAULT '0.000000',
978 `roty` decimal(10,6) DEFAULT '0.000000',
979 `rotz` decimal(10,6) DEFAULT '0.000000',
980 `currx` decimal(10,6) DEFAULT '0.000000',
981 `curry` decimal(10,6) DEFAULT '0.000000',
982 `currz` decimal(10,6) DEFAULT '0.000000',
983 `currrx` decimal(10,6) DEFAULT '0.000000',
984 `currry` decimal(10,6) DEFAULT '0.000000',
985 `currrz` decimal(10,6) NOT NULL DEFAULT '0.000000',
986 `fuel` int(3) DEFAULT '100',
987 `engine` int(1) DEFAULT '0',
988 `locked` int(1) DEFAULT '0',
989 `lights` int(1) DEFAULT '0',
990 `sirens` int(1) DEFAULT '0',
991 `paintjob` int(11) DEFAULT '0',
992 `hp` float DEFAULT '1000',
993 `color1` varchar(50) DEFAULT '0',
994 `color2` varchar(50) DEFAULT '0',
995 `color3` varchar(50) DEFAULT NULL,
996 `color4` varchar(50) DEFAULT NULL,
997 `plate` text,
998 `faction` int(11) DEFAULT '-1',
999 `owner` int(11) DEFAULT '-1',
1000 `job` int(11) DEFAULT '-1',
1001 `tintedwindows` int(1) DEFAULT '0',
1002 `dimension` int(5) DEFAULT '0',
1003 `interior` int(5) DEFAULT '0',
1004 `currdimension` int(5) DEFAULT '0',
1005 `currinterior` int(5) DEFAULT '0',
1006 `enginebroke` int(1) DEFAULT '0',
1007 `items` text,
1008 `itemvalues` text,
1009 `Impounded` int(3) DEFAULT '0',
1010 `handbrake` int(1) DEFAULT '0',
1011 `safepositionX` float DEFAULT NULL,
1012 `safepositionY` float DEFAULT NULL,
1013 `safepositionZ` float DEFAULT NULL,
1014 `safepositionRZ` float DEFAULT NULL,
1015 `upgrades` varchar(150) DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]',
1016 `wheelStates` varchar(30) DEFAULT '[ [ 0, 0, 0, 0 ] ]',
1017 `panelStates` varchar(40) DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]',
1018 `doorStates` varchar(30) DEFAULT '[ [ 0, 0, 0, 0, 0, 0 ] ]',
1019 `odometer` int(15) DEFAULT '0',
1020 `headlights` varchar(30) DEFAULT '[ [ 255, 255, 255 ] ]',
1021 `variant1` tinyint(3) unsigned NOT NULL DEFAULT '255',
1022 `variant2` tinyint(3) unsigned NOT NULL DEFAULT '255',
1023 UNIQUE KEY `id` (`id`)
1024) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1025
1026-- --------------------------------------------------------
1027
1028--
1029-- Structure de la table `wiretransfers`
1030--
1031
1032CREATE TABLE IF NOT EXISTS `wiretransfers` (
1033 `id` int(10) unsigned NOT NULL,
1034 `from` int(11) NOT NULL,
1035 `to` int(11) NOT NULL,
1036 `amount` int(11) NOT NULL,
1037 `reason` text NOT NULL,
1038 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1039 `type` int(11) NOT NULL,
1040 KEY `id` (`id`)
1041) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1042
1043-- --------------------------------------------------------
1044
1045--
1046-- Structure de la table `worlditems`
1047--
1048
1049CREATE TABLE IF NOT EXISTS `worlditems` (
1050 `id` int(11) NOT NULL AUTO_INCREMENT,
1051 `itemid` int(11) DEFAULT '0',
1052 `itemvalue` text,
1053 `x` float DEFAULT '0',
1054 `y` float DEFAULT '0',
1055 `z` float DEFAULT '0',
1056 `dimension` int(5) DEFAULT '0',
1057 `interior` int(5) DEFAULT '0',
1058 `creationdate` datetime DEFAULT NULL,
1059 `rz` float DEFAULT '0',
1060 `creator` int(10) unsigned DEFAULT '0',
1061 `protected` int(11) NOT NULL DEFAULT '0',
1062 UNIQUE KEY `id` (`id`)
1063) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1064
1065/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1066/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1067/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;