· 8 years ago · May 30, 2018, 08:30 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.2
3-- http://www.phpmyadmin.net
4--
5-- Host: us.hostskool.com
6-- Generation Time: Apr 04, 2016 at 11:16 AM
7-- Server version: 5.5.47-cll-lve
8-- PHP Version: 5.4.45
9
10/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
11/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
12/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
13/*!40101 SET NAMES utf8 */;
14
15--
16-- Database: `test_server`
17--
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `activitylog`
23--
24
25CREATE TABLE IF NOT EXISTS `activitylog` (
26 `ID` int(11) unsigned NOT NULL,
27 `UserID` int(11) unsigned NOT NULL,
28 `Minutes` int(11) unsigned NOT NULL,
29 `Date` date NOT NULL
30) ENGINE=MyISAM DEFAULT CHARSET=latin1;
31
32-- --------------------------------------------------------
33
34--
35-- Table structure for table `banlist`
36--
37
38CREATE TABLE IF NOT EXISTS `banlist` (
39 `ID` int(11) NOT NULL,
40 `Name` varchar(32) NOT NULL,
41 `Key_` varchar(64) NOT NULL,
42 `IP` varchar(32) NOT NULL,
43 `Reason` varchar(255) NOT NULL,
44 `BannedBy` varchar(32) NOT NULL,
45 `Date` date NOT NULL,
46 `Expires` date NOT NULL,
47 `Banned` tinyint(1) NOT NULL,
48 `userID` int(11) unsigned DEFAULT NULL
49) ENGINE=MyISAM AUTO_INCREMENT=6514 DEFAULT CHARSET=latin1;
50
51-- --------------------------------------------------------
52
53--
54-- Table structure for table `crimes`
55--
56
57CREATE TABLE IF NOT EXISTS `crimes` (
58 `ID` int(11) NOT NULL,
59 `Name` varchar(24) NOT NULL,
60 `Officer` varchar(24) NOT NULL,
61 `Crime` varchar(128) NOT NULL,
62 `Active` int(11) NOT NULL DEFAULT '0'
63) ENGINE=MyISAM DEFAULT CHARSET=latin1;
64
65-- --------------------------------------------------------
66
67--
68-- Table structure for table `divisions`
69--
70
71CREATE TABLE IF NOT EXISTS `divisions` (
72 `ID` int(11) NOT NULL,
73 `Faction` int(11) NOT NULL,
74 `Leader` int(11) NOT NULL,
75 `Name` varchar(24) NOT NULL,
76 `Motd` varchar(128) NOT NULL
77) ENGINE=MyISAM DEFAULT CHARSET=latin1;
78
79-- --------------------------------------------------------
80
81--
82-- Table structure for table `factionbanks`
83--
84
85CREATE TABLE IF NOT EXISTS `factionbanks` (
86 `ID` int(11) NOT NULL,
87 `LSPD` int(11) NOT NULL,
88 `FBI` int(11) NOT NULL,
89 `SAST` int(11) NOT NULL,
90 `FMD` int(11) NOT NULL,
91 `SANG` int(11) NOT NULL,
92 `GOV` int(11) NOT NULL,
93 `SCOTUS` int(11) NOT NULL,
94 `NEWS` int(11) NOT NULL,
95 `TAXI` int(11) NOT NULL
96) ENGINE=MyISAM DEFAULT CHARSET=latin1;
97
98-- --------------------------------------------------------
99
100--
101-- Table structure for table `gamefeed`
102--
103
104CREATE TABLE IF NOT EXISTS `gamefeed` (
105 `ID` int(11) NOT NULL,
106 `Date` datetime NOT NULL,
107 `Message` varchar(255) NOT NULL,
108 `Color` varchar(24) NOT NULL
109) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
110
111-- --------------------------------------------------------
112
113--
114-- Table structure for table `houses`
115--
116
117CREATE TABLE IF NOT EXISTS `houses` (
118 `HouseID` int(11) NOT NULL,
119 `OwnerID` int(11) unsigned NOT NULL,
120 `Created` tinyint(1) NOT NULL,
121 `Owned` tinyint(1) NOT NULL,
122 `Value` int(11) NOT NULL,
123 `OutsideX` float NOT NULL,
124 `OutsideY` float NOT NULL,
125 `OutsideZ` float NOT NULL,
126 `OutsideA` float NOT NULL,
127 `InsideX` float NOT NULL,
128 `InsideY` float NOT NULL,
129 `InsideZ` float NOT NULL,
130 `InsideA` float NOT NULL,
131 `Interior` int(11) NOT NULL,
132 `Locked` tinyint(1) NOT NULL,
133 `Alarm` tinyint(1) NOT NULL,
134 `AlarmStatus` tinyint(1) NOT NULL,
135 `Cash` int(11) NOT NULL,
136 `Materials` int(11) NOT NULL,
137 `Pot` int(11) NOT NULL,
138 `Crack` int(11) NOT NULL,
139 `Gun1` tinyint(2) NOT NULL,
140 `Gun2` tinyint(2) NOT NULL,
141 `Gun3` tinyint(2) NOT NULL,
142 `Gun4` tinyint(2) NOT NULL,
143 `Tag` varchar(32) NOT NULL,
144 `Level` tinyint(2) NOT NULL
145) ENGINE=MyISAM AUTO_INCREMENT=182 DEFAULT CHARSET=latin1;
146
147--
148-- Dumping data for table `houses`
149--
150
151INSERT INTO `houses` (`HouseID`, `OwnerID`, `Created`, `Owned`, `Value`, `OutsideX`, `OutsideY`, `OutsideZ`, `OutsideA`, `InsideX`, `InsideY`, `InsideZ`, `InsideA`, `Interior`, `Locked`, `Alarm`, `AlarmStatus`, `Cash`, `Materials`, `Pot`, `Crack`, `Gun1`, `Gun2`, `Gun3`, `Gun4`, `Tag`, `Level`) VALUES
152(2, 0, 1, 0, 1, 2497.14, -1672.15, 13.3359, 31.8884, 234.189, 1064.23, 1084.21, 357.893, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'House', 2),
153(3, 0, 1, 0, 1, 2227.76, -1331.43, 23.9844, 54.0867, 244.5, 305, 999.148, 270, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'House', 2);
154
155-- --------------------------------------------------------
156
157--
158-- Table structure for table `paylog`
159--
160
161CREATE TABLE IF NOT EXISTS `paylog` (
162 `ID` int(11) NOT NULL,
163 `Date` date NOT NULL,
164 `Info` varchar(256) NOT NULL
165) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
166
167-- --------------------------------------------------------
168
169--
170-- Table structure for table `players`
171--
172
173CREATE TABLE IF NOT EXISTS `players` (
174 `ID` int(11) unsigned NOT NULL,
175 `Name` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
176 `Key_` varchar(64) NOT NULL,
177 `Level` int(11) unsigned NOT NULL,
178 `AdminLvl` int(11) unsigned NOT NULL,
179 `AdminLevel` int(11) unsigned NOT NULL,
180 `SecurityKey` int(11) unsigned NOT NULL,
181 `Stealthed` tinyint(1) unsigned NOT NULL,
182 `Band` tinyint(1) unsigned NOT NULL,
183 `PermBand` tinyint(1) unsigned NOT NULL,
184 `BanReason` varchar(255) NOT NULL,
185 `PrisonReason` varchar(255) NOT NULL,
186 `AdminJailed` tinyint(1) unsigned NOT NULL,
187 `PrisonedBy` varchar(32) NOT NULL,
188 `Warnings` tinyint(1) unsigned NOT NULL,
189 `Disabled` tinyint(1) unsigned NOT NULL,
190 `Bleeding` tinyint(4) NOT NULL DEFAULT '0',
191 `DonateRank` tinyint(1) unsigned NOT NULL,
192 `Tag` tinyint(1) unsigned NOT NULL,
193 `VIPJoinDate` varchar(32) NOT NULL,
194 `VIPExpDate` varchar(32) NOT NULL,
195 `BanAppealer` tinyint(1) unsigned NOT NULL,
196 `GangModd` tinyint(1) unsigned NOT NULL,
197 `EventModd` tinyint(1) unsigned NOT NULL,
198 `ComplaintModd` tinyint(1) unsigned NOT NULL,
199 `ShopMod` tinyint(1) unsigned NOT NULL,
200 `BizMod` tinyint(1) unsigned NOT NULL,
201 `FactionMod` tinyint(1) unsigned NOT NULL,
202 `GangDirector` tinyint(1) unsigned NOT NULL,
203 `UpgradePoints` int(11) unsigned NOT NULL,
204 `ConnectedTime` int(11) NOT NULL,
205 `Registered` tinyint(1) unsigned NOT NULL,
206 `Sex` tinyint(1) unsigned NOT NULL,
207 `Age` tinyint(1) unsigned NOT NULL,
208 `Origin` tinyint(1) unsigned NOT NULL,
209 `Appearance` varchar(255) NOT NULL,
210 `Muted` tinyint(1) unsigned NOT NULL,
211 `Respect` int(11) unsigned NOT NULL,
212 `Money` int(11) NOT NULL,
213 `Bank` int(11) NOT NULL,
214 `Crimes` int(11) unsigned NOT NULL,
215 `Accent` varchar(64) NOT NULL,
216 `Kills` int(11) unsigned NOT NULL,
217 `Deaths` int(11) unsigned NOT NULL,
218 `CHits` int(11) unsigned NOT NULL,
219 `FHits` int(11) unsigned NOT NULL,
220 `Arrested` int(11) unsigned NOT NULL,
221 `LottoNr` smallint(4) unsigned NOT NULL,
222 `BiggestFish` int(11) unsigned NOT NULL,
223 `Job` int(11) unsigned NOT NULL,
224 `Paycheck` smallint(4) unsigned NOT NULL,
225 `HeadValue` int(11) unsigned NOT NULL,
226 `Jailed` tinyint(1) unsigned NOT NULL,
227 `JailCell` tinyint(1) unsigned NOT NULL,
228 `JailTime` int(11) unsigned NOT NULL,
229 `Leader` tinyint(3) unsigned NOT NULL,
230 `Member` tinyint(3) unsigned NOT NULL,
231 `FMember` tinyint(3) unsigned NOT NULL,
232 `Rank` tinyint(3) unsigned NOT NULL,
233 `RadioStation` tinyint(3) unsigned NOT NULL,
234 `Instructor` tinyint(1) unsigned NOT NULL,
235 `Passes` tinyint(3) unsigned NOT NULL,
236 `Fails` tinyint(1) unsigned NOT NULL,
237 `DetSkill` int(11) unsigned NOT NULL,
238 `SexSkill` int(11) unsigned NOT NULL,
239 `BoxSkill` int(11) unsigned NOT NULL,
240 `LawSkill` int(11) unsigned NOT NULL,
241 `MechSkill` int(11) unsigned NOT NULL,
242 `JackSkill` int(11) unsigned NOT NULL,
243 `CarSkill` int(11) unsigned NOT NULL,
244 `DrugsSkill` int(11) unsigned NOT NULL,
245 `ArmsSkill` int(11) unsigned NOT NULL,
246 `SmugglerSkill` int(11) unsigned NOT NULL,
247 `ThieveSkill` int(11) unsigned NOT NULL,
248 `FishSkill` int(11) unsigned NOT NULL,
249 `FightingStyle` int(11) unsigned NOT NULL,
250 `pHealth` tinyint(3) unsigned NOT NULL,
251 `pArmor` tinyint(3) unsigned NOT NULL,
252 `pSHP` tinyint(3) unsigned NOT NULL,
253 `pStrength` tinyint(3) unsigned NOT NULL,
254 `pSHealth` tinyint(3) unsigned NOT NULL,
255 `InteriorID` tinyint(3) unsigned NOT NULL,
256 `Local` int(11) unsigned NOT NULL,
257 `VirtualWorld` int(11) unsigned NOT NULL,
258 `Model` int(11) unsigned NOT NULL,
259 `Clothes` int(11) unsigned NOT NULL,
260 `PhoneNr` int(11) NOT NULL,
261 `PhoneType` int(11) unsigned NOT NULL,
262 `BizKey` smallint(11) NOT NULL,
263 `BizFixed` int(11) unsigned NOT NULL,
264 `SetVehSpawn` int(11) NOT NULL,
265 `CarLic` tinyint(1) unsigned NOT NULL,
266 `FlyLic` tinyint(1) unsigned NOT NULL,
267 `BoatLic` tinyint(1) unsigned NOT NULL,
268 `FishLic` tinyint(1) unsigned NOT NULL,
269 `GunLic` tinyint(1) unsigned NOT NULL,
270 `Gun0` tinyint(3) unsigned NOT NULL,
271 `Gun1` tinyint(3) unsigned NOT NULL,
272 `Gun2` tinyint(3) unsigned NOT NULL,
273 `Gun3` tinyint(3) unsigned NOT NULL,
274 `Gun4` tinyint(3) unsigned NOT NULL,
275 `Gun5` tinyint(3) unsigned NOT NULL,
276 `Gun6` tinyint(3) unsigned NOT NULL,
277 `Gun7` tinyint(3) unsigned NOT NULL,
278 `Gun8` tinyint(3) unsigned NOT NULL,
279 `Gun9` tinyint(3) unsigned NOT NULL,
280 `Gun10` tinyint(3) unsigned NOT NULL,
281 `Gun11` tinyint(3) unsigned NOT NULL,
282 `Gun12` tinyint(3) unsigned NOT NULL,
283 `CarTime` int(11) unsigned NOT NULL,
284 `DrugsTime` int(11) unsigned NOT NULL,
285 `LawyerTime` int(11) unsigned NOT NULL,
286 `LawyerFreeTime` int(11) unsigned NOT NULL,
287 `MechTime` int(11) unsigned NOT NULL,
288 `SexTime` int(11) unsigned NOT NULL,
289 `PlantTime` int(11) unsigned NOT NULL,
290 `RepairTime` int(11) unsigned NOT NULL,
291 `RobTime` int(11) unsigned NOT NULL,
292 `PayDay` int(11) NOT NULL,
293 `PayDayHad` int(11) NOT NULL,
294 `Wins` int(11) unsigned NOT NULL,
295 `Loses` int(11) unsigned NOT NULL,
296 `Tutorial` tinyint(1) unsigned NOT NULL,
297 `OnDuty` tinyint(1) unsigned NOT NULL,
298 `Hospital` tinyint(1) unsigned NOT NULL,
299 `Adjustable` tinyint(1) unsigned NOT NULL,
300 `Married` tinyint(1) unsigned NOT NULL,
301 `MarriedTo` varchar(32) NOT NULL,
302 `ContractBy` varchar(32) NOT NULL,
303 `IP` varchar(32) NOT NULL,
304 `Country` varchar(64) NOT NULL,
305 `WantedLevel` tinyint(3) unsigned NOT NULL,
306 `NewbieMuted` tinyint(1) unsigned NOT NULL,
307 `NewbieMutedTime` int(11) unsigned NOT NULL,
308 `NewbieWarns` tinyint(3) unsigned NOT NULL,
309 `AdMuted` tinyint(1) unsigned NOT NULL,
310 `BugMuted` tinyint(1) unsigned NOT NULL,
311 `SPos_x` float NOT NULL,
312 `SPos_y` float NOT NULL,
313 `SPos_z` float NOT NULL,
314 `SPos_r` float NOT NULL,
315 `HelperLevel` tinyint(3) unsigned NOT NULL,
316 `DevLevel` tinyint(3) unsigned NOT NULL,
317 `TesterLevel` tinyint(3) unsigned NOT NULL,
318 `Famed` tinyint(1) unsigned NOT NULL,
319 `Enlightened` tinyint(1) unsigned NOT NULL,
320 `BanDay` tinyint(2) unsigned NOT NULL,
321 `BanMonth` tinyint(2) unsigned NOT NULL,
322 `BanYear` smallint(4) unsigned NOT NULL,
323 `BanTime` int(11) unsigned NOT NULL,
324 `GottenGift` tinyint(1) unsigned NOT NULL,
325 `GottenTimeLeft` int(11) unsigned NOT NULL,
326 `pHouseID` smallint(11) NOT NULL,
327 `hTicket` tinyint(1) unsigned NOT NULL,
328 `gTicket` tinyint(3) unsigned NOT NULL,
329 `gRefund` tinyint(1) unsigned NOT NULL,
330 `Economist` tinyint(1) unsigned NOT NULL,
331 `Mission_spawn` tinyint(3) unsigned NOT NULL,
332 `Mission_mafia` tinyint(3) unsigned NOT NULL,
333 `Mission_triad` tinyint(3) unsigned NOT NULL,
334 `Mission_smoke` tinyint(3) unsigned NOT NULL,
335 `Mission_ryder` tinyint(3) unsigned NOT NULL,
336 `Mission_taxi` tinyint(3) unsigned NOT NULL,
337 `Mission_redneck3` tinyint(3) unsigned NOT NULL,
338 `Mission_cargo` tinyint(3) unsigned NOT NULL,
339 `HAFakeBadge` tinyint(1) unsigned NOT NULL,
340 `Badge` tinyint(1) unsigned NOT NULL,
341 `Accessory1` mediumint(8) unsigned NOT NULL,
342 `Accessory2` mediumint(8) unsigned NOT NULL,
343 `Accessory3` mediumint(8) unsigned NOT NULL,
344 `Accessory4` mediumint(8) unsigned NOT NULL,
345 `Accessory5` mediumint(8) unsigned NOT NULL,
346 `Accessory6` mediumint(8) unsigned NOT NULL,
347 `Accessory7` mediumint(8) unsigned NOT NULL,
348 `AccessoryB1` tinyint(2) unsigned NOT NULL,
349 `AccessoryB2` tinyint(2) unsigned NOT NULL,
350 `AccessoryB3` tinyint(2) unsigned NOT NULL,
351 `AccessoryB4` tinyint(2) unsigned NOT NULL,
352 `AccessoryB5` tinyint(2) unsigned NOT NULL,
353 `AccessoryB6` tinyint(2) unsigned NOT NULL,
354 `AccessoryB7` tinyint(2) unsigned NOT NULL,
355 `AccessoryX1` float NOT NULL,
356 `AccessoryX2` float NOT NULL,
357 `AccessoryX3` float NOT NULL,
358 `AccessoryX4` float NOT NULL,
359 `AccessoryX5` float NOT NULL,
360 `AccessoryX6` float NOT NULL,
361 `AccessoryX7` float NOT NULL,
362 `AccessoryY1` float NOT NULL,
363 `AccessoryY2` float NOT NULL,
364 `AccessoryY3` float NOT NULL,
365 `AccessoryY4` float NOT NULL,
366 `AccessoryY5` float NOT NULL,
367 `AccessoryY6` float NOT NULL,
368 `AccessoryY7` float NOT NULL,
369 `AccessoryZ1` float NOT NULL,
370 `AccessoryZ2` float NOT NULL,
371 `AccessoryZ3` float NOT NULL,
372 `AccessoryZ4` float NOT NULL,
373 `AccessoryZ5` float NOT NULL,
374 `AccessoryZ6` float NOT NULL,
375 `AccessoryZ7` float NOT NULL,
376 `AccessoryrX1` float NOT NULL,
377 `AccessoryrX2` float NOT NULL,
378 `AccessoryrX3` float NOT NULL,
379 `AccessoryrX4` float NOT NULL,
380 `AccessoryrX5` float NOT NULL,
381 `AccessoryrX6` float NOT NULL,
382 `AccessoryrX7` float NOT NULL,
383 `AccessoryrY1` float NOT NULL,
384 `AccessoryrY2` float NOT NULL,
385 `AccessoryrY3` float NOT NULL,
386 `AccessoryrY4` float NOT NULL,
387 `AccessoryrY5` float NOT NULL,
388 `AccessoryrY6` float NOT NULL,
389 `AccessoryrY7` float NOT NULL,
390 `AccessoryrZ1` float NOT NULL,
391 `AccessoryrZ2` float NOT NULL,
392 `AccessoryrZ3` float NOT NULL,
393 `AccessoryrZ4` float NOT NULL,
394 `AccessoryrZ5` float NOT NULL,
395 `AccessoryrZ6` float NOT NULL,
396 `AccessoryrZ7` float NOT NULL,
397 `AccessorysX1` float NOT NULL,
398 `AccessorysX2` float NOT NULL,
399 `AccessorysX3` float NOT NULL,
400 `AccessorysX4` float NOT NULL,
401 `AccessorysX5` float NOT NULL,
402 `AccessorysX6` float NOT NULL,
403 `AccessorysX7` float NOT NULL,
404 `AccessorysY1` float NOT NULL,
405 `AccessorysY2` float NOT NULL,
406 `AccessorysY3` float NOT NULL,
407 `AccessorysY4` float NOT NULL,
408 `AccessorysY5` float NOT NULL,
409 `AccessorysY6` float NOT NULL,
410 `AccessorysY7` float NOT NULL,
411 `AccessorysZ1` float NOT NULL,
412 `AccessorysZ2` float NOT NULL,
413 `AccessorysZ3` float NOT NULL,
414 `AccessorysZ4` float NOT NULL,
415 `AccessorysZ5` float NOT NULL,
416 `AccessorysZ6` float NOT NULL,
417 `AccessorysZ7` float NOT NULL,
418 `AccessorysC1` mediumint(8) unsigned NOT NULL,
419 `AccessorysC2` mediumint(8) unsigned NOT NULL,
420 `AccessorysC3` mediumint(8) unsigned NOT NULL,
421 `AccessorysC4` mediumint(8) unsigned NOT NULL,
422 `AccessorysC5` mediumint(8) unsigned NOT NULL,
423 `AccessorysC6` mediumint(8) unsigned NOT NULL,
424 `AccessorysC7` mediumint(8) unsigned NOT NULL,
425 `CKey1` smallint(5) unsigned NOT NULL,
426 `CKey2` smallint(5) unsigned NOT NULL,
427 `Mapper` tinyint(1) unsigned NOT NULL,
428 `customTag` varchar(32) NOT NULL,
429 `customRank` varchar(32) NOT NULL,
430 `Graphic` tinyint(1) unsigned NOT NULL,
431 `LastLogin` varchar(64) NOT NULL,
432 `isinHosp` tinyint(1) unsigned NOT NULL,
433 `HasMap` tinyint(1) unsigned NOT NULL,
434 `JailNumber` int(11) NOT NULL,
435 `NewCarLic` tinyint(1) unsigned NOT NULL,
436 `NewFlyLic` tinyint(1) unsigned NOT NULL,
437 `NewBoatLic` tinyint(1) unsigned NOT NULL,
438 `NewGunLic` tinyint(1) unsigned NOT NULL,
439 `SueUnix` int(11) NOT NULL,
440 `SueNotice` int(11) NOT NULL,
441 `AllowedArmory` tinyint(1) unsigned NOT NULL,
442 `WalkStyle` tinyint(3) unsigned NOT NULL,
443 `Fishes` int(11) NOT NULL,
444 `Products` int(11) NOT NULL,
445 `Materials` int(11) unsigned NOT NULL,
446 `Pot` int(11) unsigned NOT NULL,
447 `Crack` int(11) unsigned NOT NULL,
448 `Seeds` int(11) unsigned NOT NULL,
449 `Calculator` int(11) unsigned NOT NULL,
450 `Suitcase` int(11) unsigned NOT NULL,
451 `SuitCrack` int(11) unsigned NOT NULL,
452 `SuitMats` int(11) unsigned NOT NULL,
453 `SuitWeapon` int(11) unsigned NOT NULL,
454 `SuitPot` int(11) unsigned NOT NULL,
455 `SuitMoney` int(11) unsigned NOT NULL,
456 `Phonebook` int(11) unsigned NOT NULL,
457 `FishRod` int(11) unsigned NOT NULL,
458 `Bait` int(11) unsigned NOT NULL,
459 `BaitAmount` int(11) unsigned NOT NULL,
460 `Line` int(11) unsigned NOT NULL,
461 `iPod` int(11) unsigned NOT NULL,
462 `Dice` int(11) unsigned NOT NULL,
463 `Spraycan` int(11) unsigned NOT NULL,
464 `Screw` int(11) unsigned NOT NULL,
465 `Rope` int(11) unsigned NOT NULL,
466 `Cigars` int(11) unsigned NOT NULL,
467 `Sprunk` int(11) unsigned NOT NULL,
468 `Tikis` int(11) unsigned NOT NULL,
469 `WT` tinyint(1) unsigned NOT NULL,
470 `WTc` int(11) unsigned NOT NULL,
471 `Radio` int(11) unsigned NOT NULL,
472 `Handtazer` tinyint(3) unsigned NOT NULL,
473 `tazerGun` tinyint(3) unsigned NOT NULL,
474 `Bombs` tinyint(1) unsigned NOT NULL,
475 `Poison` tinyint(1) unsigned NOT NULL,
476 `Glasses` tinyint(1) unsigned NOT NULL,
477 `Bandana` tinyint(1) unsigned NOT NULL,
478 `Helmet` tinyint(1) unsigned NOT NULL,
479 `Mask` tinyint(3) unsigned NOT NULL,
480 `Blindfolds` int(11) unsigned NOT NULL,
481 `Deck` tinyint(1) unsigned NOT NULL,
482 `Stereo` tinyint(3) unsigned NOT NULL,
483 `Matches` tinyint(3) unsigned NOT NULL,
484 `Jerrycan` tinyint(1) unsigned NOT NULL,
485 `MP5Laser` tinyint(1) unsigned NOT NULL,
486 `M4Laser` tinyint(1) unsigned NOT NULL,
487 `AKLaser` tinyint(1) unsigned NOT NULL,
488 `SpasLaser` tinyint(1) unsigned NOT NULL,
489 `DeagleLaser` tinyint(1) unsigned NOT NULL,
490 `AddressBook` tinyint(1) unsigned NOT NULL,
491 `DeathState` tinyint(3) unsigned NOT NULL,
492 `SpawnPos` int(11) NOT NULL DEFAULT '0',
493 `LogUnix` int(11) NOT NULL DEFAULT '0',
494 `HelperReports` int(11) NOT NULL DEFAULT '0'
495) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
496
497--
498-- Dumping data for table `players`
499--
500
501INSERT INTO `players` (`ID`, `Name`, `Key_`, `Level`, `AdminLvl`, `AdminLevel`, `SecurityKey`, `Stealthed`, `Band`, `PermBand`, `BanReason`, `PrisonReason`, `AdminJailed`, `PrisonedBy`, `Warnings`, `Disabled`, `Bleeding`, `DonateRank`, `Tag`, `VIPJoinDate`, `VIPExpDate`, `BanAppealer`, `GangModd`, `EventModd`, `ComplaintModd`, `ShopMod`, `BizMod`, `FactionMod`, `GangDirector`, `UpgradePoints`, `ConnectedTime`, `Registered`, `Sex`, `Age`, `Origin`, `Appearance`, `Muted`, `Respect`, `Money`, `Bank`, `Crimes`, `Accent`, `Kills`, `Deaths`, `CHits`, `FHits`, `Arrested`, `LottoNr`, `BiggestFish`, `Job`, `Paycheck`, `HeadValue`, `Jailed`, `JailCell`, `JailTime`, `Leader`, `Member`, `FMember`, `Rank`, `RadioStation`, `Instructor`, `Passes`, `Fails`, `DetSkill`, `SexSkill`, `BoxSkill`, `LawSkill`, `MechSkill`, `JackSkill`, `CarSkill`, `DrugsSkill`, `ArmsSkill`, `SmugglerSkill`, `ThieveSkill`, `FishSkill`, `FightingStyle`, `pHealth`, `pArmor`, `pSHP`, `pStrength`, `pSHealth`, `InteriorID`, `Local`, `VirtualWorld`, `Model`, `Clothes`, `PhoneNr`, `PhoneType`, `BizKey`, `BizFixed`, `SetVehSpawn`, `CarLic`, `FlyLic`, `BoatLic`, `FishLic`, `GunLic`, `Gun0`, `Gun1`, `Gun2`, `Gun3`, `Gun4`, `Gun5`, `Gun6`, `Gun7`, `Gun8`, `Gun9`, `Gun10`, `Gun11`, `Gun12`, `CarTime`, `DrugsTime`, `LawyerTime`, `LawyerFreeTime`, `MechTime`, `SexTime`, `PlantTime`, `RepairTime`, `RobTime`, `PayDay`, `PayDayHad`, `Wins`, `Loses`, `Tutorial`, `OnDuty`, `Hospital`, `Adjustable`, `Married`, `MarriedTo`, `ContractBy`, `IP`, `Country`, `WantedLevel`, `NewbieMuted`, `NewbieMutedTime`, `NewbieWarns`, `AdMuted`, `BugMuted`, `SPos_x`, `SPos_y`, `SPos_z`, `SPos_r`, `HelperLevel`, `DevLevel`, `TesterLevel`, `Famed`, `Enlightened`, `BanDay`, `BanMonth`, `BanYear`, `BanTime`, `GottenGift`, `GottenTimeLeft`, `pHouseID`, `hTicket`, `gTicket`, `gRefund`, `Economist`, `Mission_spawn`, `Mission_mafia`, `Mission_triad`, `Mission_smoke`, `Mission_ryder`, `Mission_taxi`, `Mission_redneck3`, `Mission_cargo`, `HAFakeBadge`, `Badge`, `Accessory1`, `Accessory2`, `Accessory3`, `Accessory4`, `Accessory5`, `Accessory6`, `Accessory7`, `AccessoryB1`, `AccessoryB2`, `AccessoryB3`, `AccessoryB4`, `AccessoryB5`, `AccessoryB6`, `AccessoryB7`, `AccessoryX1`, `AccessoryX2`, `AccessoryX3`, `AccessoryX4`, `AccessoryX5`, `AccessoryX6`, `AccessoryX7`, `AccessoryY1`, `AccessoryY2`, `AccessoryY3`, `AccessoryY4`, `AccessoryY5`, `AccessoryY6`, `AccessoryY7`, `AccessoryZ1`, `AccessoryZ2`, `AccessoryZ3`, `AccessoryZ4`, `AccessoryZ5`, `AccessoryZ6`, `AccessoryZ7`, `AccessoryrX1`, `AccessoryrX2`, `AccessoryrX3`, `AccessoryrX4`, `AccessoryrX5`, `AccessoryrX6`, `AccessoryrX7`, `AccessoryrY1`, `AccessoryrY2`, `AccessoryrY3`, `AccessoryrY4`, `AccessoryrY5`, `AccessoryrY6`, `AccessoryrY7`, `AccessoryrZ1`, `AccessoryrZ2`, `AccessoryrZ3`, `AccessoryrZ4`, `AccessoryrZ5`, `AccessoryrZ6`, `AccessoryrZ7`, `AccessorysX1`, `AccessorysX2`, `AccessorysX3`, `AccessorysX4`, `AccessorysX5`, `AccessorysX6`, `AccessorysX7`, `AccessorysY1`, `AccessorysY2`, `AccessorysY3`, `AccessorysY4`, `AccessorysY5`, `AccessorysY6`, `AccessorysY7`, `AccessorysZ1`, `AccessorysZ2`, `AccessorysZ3`, `AccessorysZ4`, `AccessorysZ5`, `AccessorysZ6`, `AccessorysZ7`, `AccessorysC1`, `AccessorysC2`, `AccessorysC3`, `AccessorysC4`, `AccessorysC5`, `AccessorysC6`, `AccessorysC7`, `CKey1`, `CKey2`, `Mapper`, `customTag`, `customRank`, `Graphic`, `LastLogin`, `isinHosp`, `HasMap`, `JailNumber`, `NewCarLic`, `NewFlyLic`, `NewBoatLic`, `NewGunLic`, `SueUnix`, `SueNotice`, `AllowedArmory`, `WalkStyle`, `Fishes`, `Products`, `Materials`, `Pot`, `Crack`, `Seeds`, `Calculator`, `Suitcase`, `SuitCrack`, `SuitMats`, `SuitWeapon`, `SuitPot`, `SuitMoney`, `Phonebook`, `FishRod`, `Bait`, `BaitAmount`, `Line`, `iPod`, `Dice`, `Spraycan`, `Screw`, `Rope`, `Cigars`, `Sprunk`, `Tikis`, `WT`, `WTc`, `Radio`, `Handtazer`, `tazerGun`, `Bombs`, `Poison`, `Glasses`, `Bandana`, `Helmet`, `Mask`, `Blindfolds`, `Deck`, `Stereo`, `Matches`, `Jerrycan`, `MP5Laser`, `M4Laser`, `AKLaser`, `SpasLaser`, `DeagleLaser`, `AddressBook`, `DeathState`, `SpawnPos`, `LogUnix`, `HelperReports`) VALUES
502(1, 'Callum_Getty', 'lqn', 1, 0, 0, 1234, 0, 0, 0, '', 'None', 0, 'Nobody', 0, 0, 0, 0, 1, '0/0/0', '0/0/0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 'None', 0, 0, 10000, 20000, 0, 'None', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 255, 7, 255, 255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 100, 0, 0, 0, 0, 0, 999, 0, 265, 0, 0, 0, -1, 0, 0, 0, 0, 0, 1, 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, 1, 0, 0, 1, 0, 'Nobody', 'Nobody', '80.42.184.127', '', 0, 0, 0, 0, 0, 0, 1836.99, -1558.05, 13.37, 166.973, 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, 1, 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, 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, 0, 0, 0, 'None', 'None', 0, 'Friday the 1st of April 2016 @ 17:25:53', 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1459547658, 0),
503(2, 'Stan_Wells', 'lqnoˆÂ', 22, 0, 99999, 8045, 0, 0, 0, 'None', 'None', 0, 'Nobody', 0, 0, 0, 0, 8, '0/0/0', '0/0/0', 0, 1, 0, 0, 0, 0, 0, 0, 100, 1, 1, 0, 0, 0, 'None', 0, 46, 1113520, 20000, 0, 'ROBOTIC-IDIOTIC-MUSLIMA', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 11, 255, 6, 255, 255, 0, 0, 0, 400, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 88, 0, 0, 0, 100, 0, 999, 0, 36, 0, 0, 0, -1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 1, 'Julie Wells', 'Nobody', '86.61.50.34', '', 0, 0, 0, 0, 0, 0, 1174.93, -759.604, 104.766, 359.817, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 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, 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, 0, 0, 0, 'None', 'None', 0, 'Saturday the 2nd of April 2016 @ 16:12:31', 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 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, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1459615750, 0);
504
505-- --------------------------------------------------------
506
507--
508-- Table structure for table `prisons`
509--
510
511CREATE TABLE IF NOT EXISTS `prisons` (
512 `ID` int(11) NOT NULL,
513 `User` varchar(24) NOT NULL,
514 `Admin` varchar(24) NOT NULL,
515 `Reason` varchar(128) NOT NULL,
516 `Time` int(11) NOT NULL,
517 `Date` varchar(40) NOT NULL
518) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
519
520-- --------------------------------------------------------
521
522--
523-- Table structure for table `stuff`
524--
525
526CREATE TABLE IF NOT EXISTS `stuff` (
527 `ID` int(11) NOT NULL,
528 `versionstr` varchar(3000) NOT NULL,
529 `Jackpot` int(11) NOT NULL,
530 `Tax` int(11) NOT NULL,
531 `TaxValue` int(11) NOT NULL,
532 `Security` int(11) NOT NULL,
533 `TimeAfterBankJob` int(11) NOT NULL,
534 `dhstock` int(11) NOT NULL,
535 `chstock` int(11) NOT NULL,
536 `anticheatbans` int(11) NOT NULL,
537 `anticheatwarns` int(11) NOT NULL,
538 `matprice` int(11) NOT NULL,
539 `seedprice` int(11) NOT NULL,
540 `crackgprice` int(11) NOT NULL,
541 `prodprice` int(11) NOT NULL,
542 `potcprice` int(11) NOT NULL,
543 `crackcprice` int(11) NOT NULL,
544 `HitmanBadgeLSPD` int(11) NOT NULL,
545 `HitmanBadgeFBI` int(11) NOT NULL,
546 `HitmanBadgeRCSD` int(11) NOT NULL,
547 `HitmanBadgeLSFMD` int(11) NOT NULL,
548 `HitmanBadgeNG` int(11) NOT NULL,
549 `HitmanBadgeGOV` int(11) NOT NULL,
550 `HitmanBadgeSCOTUS` int(11) NOT NULL,
551 `HitmanBadgeDEA` int(11) NOT NULL,
552 `HitmanBadgeATF` int(11) NOT NULL
553) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
554
555--
556-- Dumping data for table `stuff`
557--
558
559INSERT INTO `stuff` (`ID`, `versionstr`, `Jackpot`, `Tax`, `TaxValue`, `Security`, `TimeAfterBankJob`, `dhstock`, `chstock`, `anticheatbans`, `anticheatwarns`, `matprice`, `seedprice`, `crackgprice`, `prodprice`, `potcprice`, `crackcprice`, `HitmanBadgeLSPD`, `HitmanBadgeFBI`, `HitmanBadgeRCSD`, `HitmanBadgeLSFMD`, `HitmanBadgeNG`, `HitmanBadgeGOV`, `HitmanBadgeSCOTUS`, `HitmanBadgeDEA`, `HitmanBadgeATF`) VALUES
560(1, 'This is currently being adjusted to allow real time editing for developers.\nPlease be patient, as we have nearly completed it.', 75569, 15, 17989285, 0, 9, 122, 221, 13219, 43775, 500, 1000, 500, 500, 1000, 1000, 0, 0, 0, 0, 1, 0, 0, 1, 0);
561
562-- --------------------------------------------------------
563
564--
565-- Table structure for table `vehicles`
566--
567
568CREATE TABLE IF NOT EXISTS `vehicles` (
569 `ID` int(11) NOT NULL,
570 `model` int(11) NOT NULL,
571 `x` float NOT NULL,
572 `y` float NOT NULL,
573 `z` float NOT NULL,
574 `rz` float NOT NULL,
575 `color1` int(11) NOT NULL,
576 `color2` int(11) NOT NULL,
577 `faction` int(11) NOT NULL,
578 `family` int(2) NOT NULL DEFAULT '0',
579 `lockfeature` int(2) NOT NULL DEFAULT '0'
580) ENGINE=MyISAM DEFAULT CHARSET=latin1;
581
582--
583-- Indexes for dumped tables
584--
585
586--
587-- Indexes for table `activitylog`
588--
589ALTER TABLE `activitylog`
590 ADD PRIMARY KEY (`ID`);
591
592--
593-- Indexes for table `banlist`
594--
595ALTER TABLE `banlist`
596 ADD PRIMARY KEY (`ID`),
597 ADD KEY `banlist_ibfk_1` (`userID`);
598
599--
600-- Indexes for table `crimes`
601--
602ALTER TABLE `crimes`
603 ADD PRIMARY KEY (`ID`);
604
605--
606-- Indexes for table `divisions`
607--
608ALTER TABLE `divisions`
609 ADD PRIMARY KEY (`ID`);
610
611--
612-- Indexes for table `factionbanks`
613--
614ALTER TABLE `factionbanks`
615 ADD PRIMARY KEY (`ID`);
616
617--
618-- Indexes for table `gamefeed`
619--
620ALTER TABLE `gamefeed`
621 ADD PRIMARY KEY (`ID`);
622
623--
624-- Indexes for table `houses`
625--
626ALTER TABLE `houses`
627 ADD PRIMARY KEY (`HouseID`),
628 ADD KEY `OwnerID` (`OwnerID`);
629
630--
631-- Indexes for table `paylog`
632--
633ALTER TABLE `paylog`
634 ADD PRIMARY KEY (`ID`);
635
636--
637-- Indexes for table `players`
638--
639ALTER TABLE `players`
640 ADD PRIMARY KEY (`ID`),
641 ADD UNIQUE KEY `Name` (`Name`);
642
643--
644-- Indexes for table `prisons`
645--
646ALTER TABLE `prisons`
647 ADD PRIMARY KEY (`ID`);
648
649--
650-- Indexes for table `stuff`
651--
652ALTER TABLE `stuff`
653 ADD PRIMARY KEY (`ID`);
654
655--
656-- Indexes for table `vehicles`
657--
658ALTER TABLE `vehicles`
659 ADD PRIMARY KEY (`ID`);
660
661--
662-- AUTO_INCREMENT for dumped tables
663--
664
665--
666-- AUTO_INCREMENT for table `activitylog`
667--
668ALTER TABLE `activitylog`
669 MODIFY `ID` int(11) unsigned NOT NULL AUTO_INCREMENT;
670--
671-- AUTO_INCREMENT for table `banlist`
672--
673ALTER TABLE `banlist`
674 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6514;
675--
676-- AUTO_INCREMENT for table `crimes`
677--
678ALTER TABLE `crimes`
679 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
680--
681-- AUTO_INCREMENT for table `divisions`
682--
683ALTER TABLE `divisions`
684 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
685--
686-- AUTO_INCREMENT for table `factionbanks`
687--
688ALTER TABLE `factionbanks`
689 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
690--
691-- AUTO_INCREMENT for table `gamefeed`
692--
693ALTER TABLE `gamefeed`
694 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
695--
696-- AUTO_INCREMENT for table `houses`
697--
698ALTER TABLE `houses`
699 MODIFY `HouseID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=182;
700--
701-- AUTO_INCREMENT for table `paylog`
702--
703ALTER TABLE `paylog`
704 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
705--
706-- AUTO_INCREMENT for table `players`
707--
708ALTER TABLE `players`
709 MODIFY `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
710--
711-- AUTO_INCREMENT for table `prisons`
712--
713ALTER TABLE `prisons`
714 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
715--
716-- AUTO_INCREMENT for table `stuff`
717--
718ALTER TABLE `stuff`
719 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
720--
721-- AUTO_INCREMENT for table `vehicles`
722--
723ALTER TABLE `vehicles`
724 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
725/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
726/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
727/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;