· 8 years ago · Jun 10, 2018, 08:30 AM
1-- phpMyAdmin SQL Dump
2-- version 3.2.0.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jun 10, 2018 at 05:35 AM
7-- Server version: 5.1.36
8-- PHP Version: 5.3.0
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12--
13-- Database: `viper`
14--
15
16-- --------------------------------------------------------
17
18--
19-- Table structure for table `account`
20--
21CREATE TABLE IF NOT EXISTS `account` (
22 `id` int(32) NOT NULL AUTO_INCREMENT,
23 `email` varchar(100) NOT NULL,
24 `username` varchar(64) NOT NULL,
25 `password` varchar(128) NOT NULL,
26 `role` varchar(50) NOT NULL DEFAULT 'member',
27 `created` varchar(200) CHARACTER SET utf32 DEFAULT NULL,
28 `aktif` varchar(200) CHARACTER SET utf32 NOT NULL DEFAULT 'n',
29 `kode` varchar(200) CHARACTER SET utf32 NOT NULL,
30 `balance` varchar(200) CHARACTER SET utf32 DEFAULT '0',
31 `banned` smallint(3) NOT NULL,
32 `bandate` varchar(16) NOT NULL,
33 `bantime` varchar(16) NOT NULL,
34 `adminban` varchar(32) NOT NULL,
35 `banreason` varchar(64) NOT NULL,
36 `banfor` varchar(16) NOT NULL,
37 PRIMARY KEY (`id`)
38) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
39
40-- --------------------------------------------------------
41
42--
43-- Table structure for table `atm`
44--
45
46CREATE TABLE IF NOT EXISTS `atm` (
47 `id` int(10) NOT NULL AUTO_INCREMENT,
48 `atmid` int(10) NOT NULL,
49 `X` float(10,5) NOT NULL,
50 `Y` float(10,5) NOT NULL,
51 `Z` float(10,5) NOT NULL,
52 `Angle` float(10,5) NOT NULL,
53 PRIMARY KEY (`id`)
54) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
55
56-- --------------------------------------------------------
57
58--
59-- Table structure for table `blackmarket`
60--
61
62CREATE TABLE IF NOT EXISTS `blackmarket` (
63 `id` int(10) NOT NULL AUTO_INCREMENT,
64 `bmid` int(10) NOT NULL,
65 `Price` varchar(430) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0',
66 `Date` varchar(130) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0',
67 `Year` varchar(80) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0',
68 `GunAmmo` varchar(90) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0',
69 `GunID` varchar(40) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0',
70 `Owner` varchar(350) NOT NULL DEFAULT 'None|None|None|None|None|None|None|None|None|None|None|None|None',
71 `Spawn` varchar(30) NOT NULL DEFAULT '0|0|0',
72 PRIMARY KEY (`id`)
73) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
74
75-- --------------------------------------------------------
76
77--
78-- Table structure for table `business`
79--
80
81CREATE TABLE IF NOT EXISTS `business` (
82 `id` int(10) NOT NULL AUTO_INCREMENT,
83 `bizID` int(10) NOT NULL,
84 `Segel` int(5) NOT NULL DEFAULT '0',
85 `SegelReason` varchar(64) NOT NULL DEFAULT 'None',
86 `Owned` int(5) NOT NULL DEFAULT '0',
87 `Owner` varchar(64) NOT NULL DEFAULT 'None',
88 `Message` varchar(128) NOT NULL DEFAULT 'None',
89 `VirWorld` int(10) NOT NULL DEFAULT '0',
90 `BuyVir` int(10) NOT NULL DEFAULT '0',
91 `BuyPointX` float(10,5) NOT NULL DEFAULT '0.00000',
92 `BuyPointY` float(10,5) NOT NULL DEFAULT '0.00000',
93 `BuyPointZ` float(10,5) NOT NULL DEFAULT '0.00000',
94 `EntranceX` float(10,5) NOT NULL DEFAULT '0.00000',
95 `EntranceY` float(10,5) NOT NULL DEFAULT '0.00000',
96 `EntranceZ` float(10,5) NOT NULL DEFAULT '0.00000',
97 `ExitX` float(10,5) NOT NULL DEFAULT '0.00000',
98 `ExitY` float(10,5) NOT NULL DEFAULT '0.00000',
99 `ExitZ` float(10,5) NOT NULL DEFAULT '0.00000',
100 `bAngle` float(10,5) NOT NULL DEFAULT '0.00000',
101 `LevelNeeded` int(10) NOT NULL DEFAULT '0',
102 `BuyPrice` int(18) NOT NULL DEFAULT '0',
103 `Till` int(18) NOT NULL DEFAULT '0',
104 `Locked` int(5) NOT NULL DEFAULT '0',
105 `InteriorID` int(10) NOT NULL DEFAULT '0',
106 `ExteriorID` int(10) NOT NULL DEFAULT '0',
107 `bInterior` int(10) NOT NULL DEFAULT '0',
108 `Type` int(5) NOT NULL DEFAULT '0',
109 `bStock0` int(10) NOT NULL DEFAULT '0',
110 `bPrice0` int(18) NOT NULL DEFAULT '0',
111 `bStock1` int(10) NOT NULL DEFAULT '0',
112 `bPrice1` int(18) NOT NULL DEFAULT '0',
113 `bStock2` int(10) NOT NULL DEFAULT '0',
114 `bPrice2` int(18) NOT NULL DEFAULT '0',
115 `bStock3` int(10) NOT NULL DEFAULT '0',
116 `bPrice3` int(18) NOT NULL DEFAULT '0',
117 `bStock4` int(10) NOT NULL DEFAULT '0',
118 `bPrice4` int(18) NOT NULL DEFAULT '0',
119 `bStock5` int(10) NOT NULL DEFAULT '0',
120 `bPrice5` int(18) NOT NULL DEFAULT '0',
121 `bStock6` int(10) NOT NULL DEFAULT '0',
122 `bPrice6` int(18) NOT NULL DEFAULT '0',
123 `bStock7` int(10) NOT NULL DEFAULT '0',
124 `bPrice7` int(18) NOT NULL DEFAULT '0',
125 `bStock8` int(10) NOT NULL DEFAULT '0',
126 `bPrice8` int(18) NOT NULL DEFAULT '0',
127 `bStock9` int(10) NOT NULL DEFAULT '0',
128 `bPrice9` int(18) NOT NULL DEFAULT '0',
129 `bStock10` int(10) NOT NULL DEFAULT '0',
130 `bPrice10` int(18) NOT NULL DEFAULT '0',
131 PRIMARY KEY (`id`)
132) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
133
134-- --------------------------------------------------------
135
136--
137-- Table structure for table `contact`
138--
139
140CREATE TABLE IF NOT EXISTS `contact` (
141 `id` int(16) NOT NULL AUTO_INCREMENT,
142 `pid` int(16) NOT NULL,
143 `slot` int(5) NOT NULL,
144 `number` int(11) NOT NULL,
145 `name` varchar(64) NOT NULL,
146 `message` varchar(128) NOT NULL,
147 PRIMARY KEY (`id`)
148) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=109 ;
149
150-- --------------------------------------------------------
151
152--
153-- Table structure for table `customtext`
154--
155
156CREATE TABLE IF NOT EXISTS `customtext` (
157 `id` int(32) NOT NULL AUTO_INCREMENT,
158 `textid` int(10) NOT NULL,
159 `model` int(8) NOT NULL,
160 `cindex` int(5) NOT NULL,
161 `x` float(10,5) NOT NULL,
162 `y` float(10,5) NOT NULL,
163 `z` float(10,5) NOT NULL,
164 `rx` float(10,5) NOT NULL,
165 `ry` float(10,5) NOT NULL,
166 `rz` float(10,5) NOT NULL,
167 `text1` varchar(128) NOT NULL,
168 `text2` varchar(128) NOT NULL,
169 `text3` varchar(128) NOT NULL,
170 `tsize` int(5) NOT NULL,
171 `bsize` int(5) NOT NULL,
172 `vw` int(32) NOT NULL,
173 `cint` int(10) NOT NULL,
174 `transparent` int(3) NOT NULL,
175 PRIMARY KEY (`id`)
176) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
177
178-- --------------------------------------------------------
179
180--
181-- Table structure for table `families`
182--
183
184CREATE TABLE IF NOT EXISTS `families` (
185 `id` int(10) NOT NULL AUTO_INCREMENT,
186 `famid` int(10) NOT NULL,
187 `FamilyTaken` int(5) NOT NULL,
188 `FamilyName` varchar(42) NOT NULL,
189 `FamilyMotd` varchar(65) NOT NULL DEFAULT 'ViperGamers Family',
190 `FamilyLeader` varchar(24) NOT NULL,
191 `FamilyBank` int(16) NOT NULL,
192 `FamilyCash` int(16) NOT NULL,
193 `FamilyUSafe` int(5) NOT NULL,
194 `FSafeX` float(10,5) NOT NULL,
195 `FSafeY` float(10,5) NOT NULL,
196 `FSafeZ` float(10,5) NOT NULL,
197 `FamilyPot` int(10) NOT NULL,
198 `FamilyCrack` int(10) NOT NULL,
199 `FamilyMats` int(10) NOT NULL,
200 `FamRank1` varchar(20) NOT NULL DEFAULT 'Outsider',
201 `FamRank2` varchar(20) NOT NULL DEFAULT 'Associate',
202 `FamRank3` varchar(20) NOT NULL DEFAULT 'Soldier',
203 `FamRank4` varchar(20) NOT NULL DEFAULT 'Capo',
204 `FamRank5` varchar(20) NOT NULL DEFAULT 'Underboss',
205 `FamRank6` varchar(20) NOT NULL DEFAULT 'GodFather',
206 `FamMember` int(10) NOT NULL,
207 `FamMaxSkin` int(5) NOT NULL,
208 `FamSkin1` varchar(35) NOT NULL DEFAULT '120',
209 `FamSkin2` varchar(35) NOT NULL DEFAULT '121',
210 `FamSkin3` varchar(35) NOT NULL DEFAULT '123',
211 `FamSkin4` varchar(35) NOT NULL DEFAULT '124',
212 `FamSkin5` varchar(35) NOT NULL DEFAULT '125',
213 `FamSkin6` varchar(35) NOT NULL DEFAULT '126',
214 `FamSkin7` varchar(35) NOT NULL DEFAULT '127',
215 `FamSkin8` varchar(35) NOT NULL DEFAULT '128',
216 `FamColor` int(5) NOT NULL DEFAULT '1',
217 `FamToken` int(10) NOT NULL DEFAULT '0',
218 `FamGun1` varchar(35) NOT NULL,
219 `FamGun2` varchar(35) NOT NULL,
220 `FamGun3` varchar(35) NOT NULL,
221 `FamGun4` varchar(35) NOT NULL,
222 `FamGun5` varchar(35) NOT NULL,
223 `FamGun6` varchar(35) NOT NULL,
224 `FamGun7` varchar(35) NOT NULL,
225 `FamGun8` varchar(35) NOT NULL,
226 `FamGun9` varchar(35) NOT NULL,
227 `FamGun10` varchar(35) NOT NULL,
228 `fEntrance` varchar(64) NOT NULL DEFAULT '0|0|0',
229 `fExit` varchar(64) NOT NULL DEFAULT '0|0|0',
230 `fInterior` int(10) NOT NULL,
231 `fVW` int(24) NOT NULL,
232 `fCustom` int(3) NOT NULL,
233 PRIMARY KEY (`id`)
234) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
235
236-- --------------------------------------------------------
237
238--
239-- Table structure for table `familieshq`
240--
241
242CREATE TABLE IF NOT EXISTS `familieshq` (
243 `id` int(10) NOT NULL AUTO_INCREMENT,
244 `famid` int(10) NOT NULL,
245 `fEntrance` varchar(40) NOT NULL DEFAULT '0|0|0|0',
246 `fExit` varchar(40) NOT NULL DEFAULT '0|0|0|0',
247 `fInterior` int(5) NOT NULL,
248 `fCustom` int(3) NOT NULL,
249 `fVW` int(5) NOT NULL,
250 `FamVehModel` varchar(70) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0',
251 `FamVehX` varchar(90) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0',
252 `FamVehY` varchar(90) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0',
253 `FamVehZ` varchar(90) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0',
254 `FamVehA` varchar(90) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0',
255 `FamVehLock` varchar(30) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0',
256 `FamVehLocked` varchar(30) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0',
257 `FamVehPJ` varchar(30) NOT NULL DEFAULT '-1|-1|-1|-1|-1|-1|-1|-1|-1|-1',
258 `FamVehCol1` varchar(45) NOT NULL DEFAULT '1|1|1|1|1|1|1|1|1|1',
259 `FamVehCol2` varchar(45) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0',
260 `FamVehFuel` varchar(60) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0',
261 PRIMARY KEY (`id`)
262) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
263
264-- --------------------------------------------------------
265
266--
267-- Table structure for table `famvehicles`
268--
269
270CREATE TABLE IF NOT EXISTS `famvehicles` (
271 `id` int(10) NOT NULL AUTO_INCREMENT,
272 `famid` int(10) NOT NULL,
273 `model` int(4) NOT NULL,
274 `x` float(10,5) NOT NULL,
275 `y` float(10,5) NOT NULL,
276 `z` float(10,5) NOT NULL,
277 `a` float(10,5) NOT NULL,
278 `lock` int(3) NOT NULL,
279 `locked` int(3) NOT NULL,
280 `pj` int(3) NOT NULL,
281 `c1` int(4) NOT NULL,
282 `c2` int(4) NOT NULL,
283 `fuel` int(10) NOT NULL,
284 `mod0` int(5) NOT NULL,
285 `mod1` int(5) NOT NULL,
286 `mod2` int(5) NOT NULL,
287 `mod3` int(5) NOT NULL,
288 `mod4` int(5) NOT NULL,
289 `mod5` int(5) NOT NULL,
290 `mod6` int(5) NOT NULL,
291 `mod7` int(5) NOT NULL,
292 `mod8` int(5) NOT NULL,
293 `mod9` int(5) NOT NULL,
294 `mod10` int(5) NOT NULL,
295 `mod11` int(5) NOT NULL,
296 `mod12` int(5) NOT NULL,
297 `mod13` int(5) NOT NULL,
298 PRIMARY KEY (`id`)
299) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
300
301-- --------------------------------------------------------
302
303--
304-- Table structure for table `garage`
305--
306
307CREATE TABLE IF NOT EXISTS `garage` (
308 `id` int(10) NOT NULL AUTO_INCREMENT,
309 `garageID` int(10) NOT NULL,
310 `Owner` varchar(64) NOT NULL DEFAULT 'None',
311 `Price` int(18) NOT NULL DEFAULT '0',
312 `Level` int(7) NOT NULL DEFAULT '1',
313 `X` float(10,5) NOT NULL DEFAULT '0.00000',
314 `Y` float(10,5) NOT NULL DEFAULT '0.00000',
315 `Z` float(10,5) NOT NULL DEFAULT '0.00000',
316 `A` float(10,5) NOT NULL DEFAULT '0.00000',
317 `CModel0` int(10) NOT NULL DEFAULT '0',
318 `CModel1` int(10) NOT NULL DEFAULT '0',
319 `Owned` int(3) NOT NULL,
320 PRIMARY KEY (`id`)
321) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
322
323-- --------------------------------------------------------
324
325--
326-- Table structure for table `gates`
327--
328
329CREATE TABLE IF NOT EXISTS `gates` (
330 `id` int(10) NOT NULL AUTO_INCREMENT,
331 `gateid` int(10) NOT NULL,
332 `HID` int(5) NOT NULL,
333 `Speed` int(5) NOT NULL,
334 `Range` int(5) NOT NULL,
335 `Model` int(5) NOT NULL,
336 `VW` int(6) NOT NULL,
337 `Int` int(6) NOT NULL,
338 `Pass` varchar(24) NOT NULL,
339 `PosX` float NOT NULL,
340 `PosY` float NOT NULL,
341 `PosZ` float NOT NULL,
342 `RotX` float NOT NULL,
343 `RotY` float NOT NULL,
344 `RotZ` float NOT NULL,
345 `PosXM` float NOT NULL,
346 `PosYM` float NOT NULL,
347 `PosZM` float NOT NULL,
348 `RotXM` float NOT NULL,
349 `RotYM` float NOT NULL,
350 `RotZM` float NOT NULL,
351 `RenderHQ` int(5) NOT NULL,
352 PRIMARY KEY (`id`)
353) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
354
355-- --------------------------------------------------------
356
357--
358-- Table structure for table `house`
359--
360
361CREATE TABLE IF NOT EXISTS `house` (
362 `id` int(10) NOT NULL AUTO_INCREMENT,
363 `houseID` int(10) NOT NULL,
364 `Owned` int(5) NOT NULL DEFAULT '0',
365 `hInt` int(10) NOT NULL DEFAULT '0',
366 `Level` int(5) NOT NULL DEFAULT '1',
367 `hDesc` varchar(64) NOT NULL DEFAULT 'Low',
368 `hOwner` varchar(64) NOT NULL DEFAULT 'None',
369 `ExX` float(10,5) NOT NULL DEFAULT '0.00000',
370 `ExY` float(10,5) NOT NULL DEFAULT '0.00000',
371 `ExZ` float(10,5) NOT NULL DEFAULT '0.00000',
372 `IntX` float(10,5) NOT NULL DEFAULT '0.00000',
373 `IntY` float(10,5) NOT NULL DEFAULT '0.00000',
374 `IntZ` float(10,5) NOT NULL DEFAULT '0.00000',
375 `hLock` int(5) NOT NULL DEFAULT '0',
376 `Value` int(16) NOT NULL DEFAULT '0',
377 `SafeMoney` int(16) NOT NULL DEFAULT '0',
378 `Pot` int(10) NOT NULL DEFAULT '0',
379 `Crack` int(10) NOT NULL DEFAULT '0',
380 `Mats` int(10) NOT NULL DEFAULT '0',
381 `Wep1` int(5) NOT NULL DEFAULT '0',
382 `Wep2` int(5) NOT NULL DEFAULT '0',
383 `Wep3` int(5) NOT NULL DEFAULT '0',
384 `Wep4` int(5) NOT NULL DEFAULT '0',
385 `Wep5` int(5) NOT NULL DEFAULT '0',
386 `CustInt` int(5) NOT NULL DEFAULT '0',
387 `CustEx` int(5) NOT NULL DEFAULT '0',
388 `ExA` float(10,5) NOT NULL DEFAULT '0.00000',
389 `IntA` float(10,5) NOT NULL DEFAULT '0.00000',
390 PRIMARY KEY (`id`)
391) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
392
393-- --------------------------------------------------------
394
395--
396-- Table structure for table `map`
397--
398
399CREATE TABLE IF NOT EXISTS `map` (
400 `id` int(10) NOT NULL AUTO_INCREMENT,
401 `mapid` int(10) NOT NULL,
402 `X` float(10,5) NOT NULL,
403 `Y` float(10,5) NOT NULL,
404 `Z` float(10,5) NOT NULL,
405 `Angle` float(10,5) NOT NULL,
406 PRIMARY KEY (`id`)
407) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
408
409-- --------------------------------------------------------
410
411--
412-- Table structure for table `pfarm`
413--
414
415CREATE TABLE IF NOT EXISTS `pfarm` (
416 `id` int(10) NOT NULL AUTO_INCREMENT,
417 `farmid` int(10) NOT NULL,
418 `name` varchar(64) NOT NULL,
419 `owner` varchar(64) NOT NULL,
420 `x` float(10,5) NOT NULL,
421 `y` float(10,5) NOT NULL,
422 `z` float(10,5) NOT NULL,
423 `fx` float(10,5) NOT NULL,
424 `fy` float(10,5) NOT NULL,
425 `fz` float(10,5) NOT NULL,
426 `cost` int(32) NOT NULL,
427 `owned` tinyint(2) NOT NULL,
428 `radius` float(10,5) NOT NULL,
429 `segel` tinyint(2) NOT NULL,
430 `sreason` varchar(128) NOT NULL,
431 `plant` varchar(128) NOT NULL DEFAULT '0|0|0',
432 PRIMARY KEY (`id`)
433) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
434
435-- --------------------------------------------------------
436
437--
438-- Table structure for table `playerdata`
439--
440
441CREATE TABLE IF NOT EXISTS `playerdata` (
442 `playerID` int(10) NOT NULL AUTO_INCREMENT,
443 `pKey` varchar(128) NOT NULL DEFAULT '0',
444 `AdminBan` varchar(64) NOT NULL DEFAULT 'None',
445 `pLastConnect` int(10) NOT NULL DEFAULT '0',
446 `BanReason` varchar(128) NOT NULL DEFAULT 'None',
447 `Hint` varchar(128) NOT NULL DEFAULT 'None',
448 `BanExpired` varchar(128) NOT NULL DEFAULT 'None',
449 `BanExpired2` varchar(128) NOT NULL DEFAULT 'None',
450 `Level` int(6) NOT NULL DEFAULT '1',
451 `AdminLevel` int(6) NOT NULL DEFAULT '0',
452 `Band` int(5) NOT NULL DEFAULT '0',
453 `PermBand` int(5) NOT NULL DEFAULT '0',
454 `Warnings` int(5) NOT NULL DEFAULT '0',
455 `BanAppealer` int(5) NOT NULL DEFAULT '0',
456 `ShopTech` int(5) NOT NULL DEFAULT '0',
457 `Undercover` int(5) NOT NULL DEFAULT '0',
458 `TogReports` int(5) NOT NULL DEFAULT '0',
459 `Radio` int(5) NOT NULL DEFAULT '0',
460 `RadioFreq` int(10) NOT NULL DEFAULT '0',
461 `GTrain` int(6) NOT NULL DEFAULT '0',
462 `ConnectTime` varchar(30) NOT NULL DEFAULT '0|0|0',
463 `Registered` int(5) NOT NULL DEFAULT '0',
464 `Sex` int(5) NOT NULL DEFAULT '0',
465 `Cacing` int(10) NOT NULL DEFAULT '0',
466 `ATM` int(7) NOT NULL DEFAULT '0',
467 `KTP` int(5) NOT NULL DEFAULT '0',
468 `Sakit` varchar(50) NOT NULL DEFAULT '0|0|0|0',
469 `Sakot` varchar(50) NOT NULL DEFAULT '0|0|0',
470 `Obat` varchar(50) NOT NULL DEFAULT '0|0|0|0',
471 `Izin` int(5) NOT NULL DEFAULT '0',
472 `KTPID` int(5) NOT NULL DEFAULT '0',
473 `PBiskey2` int(6) NOT NULL DEFAULT '9999',
474 `PDTime` int(6) NOT NULL DEFAULT '0',
475 `Makan` float(10,5) NOT NULL DEFAULT '0.00000',
476 `Pee` int(5) NOT NULL DEFAULT '0',
477 `Energy` float(10,5) NOT NULL DEFAULT '0.00000',
478 `PBiskey` int(6) NOT NULL DEFAULT '9999',
479 `InBizz` int(6) NOT NULL DEFAULT '0',
480 `Mask` int(6) NOT NULL DEFAULT '0',
481 `Pancingan` int(6) NOT NULL DEFAULT '0',
482 `Terms` int(6) NOT NULL DEFAULT '0',
483 `Age` int(6) NOT NULL DEFAULT '0',
484 `Muted` int(6) NOT NULL DEFAULT '0',
485 `Respect` int(10) NOT NULL DEFAULT '0',
486 `Money` int(16) NOT NULL DEFAULT '0',
487 `Bank` int(16) NOT NULL DEFAULT '0',
488 `Crimes` int(10) NOT NULL DEFAULT '0',
489 `Donate` int(5) NOT NULL DEFAULT '0',
490 `Arrested` int(10) NOT NULL DEFAULT '0',
491 `Job` int(5) NOT NULL DEFAULT '0',
492 `Job2` int(5) NOT NULL DEFAULT '0',
493 `Paycheck` int(5) NOT NULL DEFAULT '0',
494 `Jailed` int(5) NOT NULL DEFAULT '0',
495 `JailTime` int(10) NOT NULL DEFAULT '0',
496 `WRestricted` int(5) NOT NULL DEFAULT '0',
497 `Materials` int(10) NOT NULL DEFAULT '0',
498 `Pot` int(10) NOT NULL DEFAULT '0',
499 `Crack` int(10) NOT NULL DEFAULT '0',
500 `Leader` int(5) NOT NULL DEFAULT '0',
501 `Member` int(5) NOT NULL DEFAULT '0',
502 `Division` int(5) NOT NULL DEFAULT '0',
503 `FMember` int(6) NOT NULL DEFAULT '255',
504 `Rank` int(5) NOT NULL DEFAULT '0',
505 `Helper` int(5) NOT NULL DEFAULT '0',
506 `Uniform` int(5) NOT NULL DEFAULT '0',
507 `BoxSkill` int(10) NOT NULL DEFAULT '0',
508 `MechSkill` int(10) NOT NULL DEFAULT '0',
509 `Roti` int(10) NOT NULL DEFAULT '0',
510 `DrugsSkill` int(10) NOT NULL DEFAULT '0',
511 `FightingStyle` int(5) NOT NULL DEFAULT '0',
512 `pHealth` float(10,5) NOT NULL DEFAULT '100.00000',
513 `pArmor` float(10,5) NOT NULL DEFAULT '0.00000',
514 `pInt` int(10) NOT NULL DEFAULT '0',
515 `pLocal` int(10) NOT NULL DEFAULT '0',
516 `VirtualWorld` int(10) NOT NULL DEFAULT '0',
517 `HouseInvite` int(10) NOT NULL DEFAULT '0',
518 `Model` int(6) NOT NULL DEFAULT '0',
519 `Clothes` int(6) NOT NULL DEFAULT '0',
520 `PhoneNr` int(10) NOT NULL DEFAULT '0',
521 `Pulsa` int(16) NOT NULL DEFAULT '0',
522 `FMax` int(10) NOT NULL DEFAULT '0',
523 `FTime` int(10) NOT NULL DEFAULT '0',
524 `JTime` int(10) NOT NULL DEFAULT '0',
525 `TTime` int(10) NOT NULL DEFAULT '0',
526 `KTPTime` int(10) NOT NULL DEFAULT '0',
527 `KTime` int(10) NOT NULL DEFAULT '0',
528 `BeratIkan` int(10) NOT NULL DEFAULT '0',
529 `Apartment` int(7) NOT NULL DEFAULT '9999',
530 `Apartment2` int(7) NOT NULL DEFAULT '9999',
531 `CarLic` int(5) NOT NULL DEFAULT '0',
532 `FlyLic` int(5) NOT NULL DEFAULT '0',
533 `BoatLic` int(5) NOT NULL DEFAULT '0',
534 `GunLic` int(5) NOT NULL DEFAULT '0',
535 `DrugsTime` int(10) NOT NULL DEFAULT '0',
536 `MechTime` int(10) NOT NULL DEFAULT '0',
537 `PayDay` int(10) NOT NULL DEFAULT '0',
538 `PayDayHad` int(10) NOT NULL DEFAULT '0',
539 `Dice` int(10) DEFAULT NULL,
540 `Spraycan` int(10) NOT NULL DEFAULT '0',
541 `Cigars` int(10) NOT NULL DEFAULT '0',
542 `Cigarss` int(10) NOT NULL DEFAULT '0',
543 `Sprunk` int(10) NOT NULL DEFAULT '0',
544 `Wins` int(7) NOT NULL DEFAULT '0',
545 `Loses` int(7) NOT NULL DEFAULT '0',
546 `Tutorial` int(5) NOT NULL DEFAULT '0',
547 `OnDuty` int(5) NOT NULL DEFAULT '0',
548 `Hospital` int(5) NOT NULL DEFAULT '0',
549 `Adjustable` int(7) NOT NULL DEFAULT '0',
550 `Married` int(5) NOT NULL DEFAULT '0',
551 `MarriedTo` varchar(64) NOT NULL DEFAULT 'None',
552 `IP` varchar(64) NOT NULL DEFAULT 'None',
553 `WantedLevel` int(10) NOT NULL DEFAULT '0',
554 `NewMuted` int(7) NOT NULL DEFAULT '0',
555 `NewMutedTotal` int(7) NOT NULL DEFAULT '0',
556 `AdMuted` int(7) NOT NULL DEFAULT '0',
557 `AdMutedTotal` int(7) NOT NULL DEFAULT '0',
558 `SPos_x` float(10,5) NOT NULL DEFAULT '1641.86267',
559 `SPos_y` float(10,5) NOT NULL DEFAULT '-2332.94043',
560 `SPos_z` float(10,5) NOT NULL DEFAULT '13.37340',
561 `Spos_r` float(10,5) NOT NULL DEFAULT '90.00000',
562 `ReportMuted` int(5) NOT NULL DEFAULT '0',
563 `PaperT` int(5) NOT NULL DEFAULT '0',
564 `ReportMutedTime` int(7) NOT NULL DEFAULT '0',
565 `FactionModerator` int(5) NOT NULL DEFAULT '0',
566 `GangModerator` int(5) NOT NULL DEFAULT '0',
567 `FactionBanned` int(5) NOT NULL DEFAULT '0',
568 `CSFBanned` int(5) NOT NULL DEFAULT '0',
569 `TriageTime` int(10) NOT NULL DEFAULT '0',
570 `Injure` int(7) NOT NULL DEFAULT '0',
571 `Screwdriver` int(10) NOT NULL DEFAULT '0',
572 `Tire` int(10) NOT NULL DEFAULT '0',
573 `GPS` int(5) NOT NULL DEFAULT '0',
574 `CallsAccepted` int(10) NOT NULL DEFAULT '0',
575 `LiveBanned` int(5) NOT NULL DEFAULT '0',
576 `Component` int(10) NOT NULL DEFAULT '0',
577 `BoomBox` int(5) NOT NULL DEFAULT '0',
578 `Jerigen` int(5) NOT NULL DEFAULT '0',
579 `JType` int(5) NOT NULL DEFAULT '0',
580 `Bensin` float(10,5) NOT NULL DEFAULT '0.00000',
581 `KuliT` int(10) NOT NULL DEFAULT '0',
582 `Kuli` int(5) NOT NULL DEFAULT '0',
583 `RadioPick` int(10) NOT NULL DEFAULT '0',
584 `BoomboxPick` int(10) NOT NULL DEFAULT '0',
585 `HPPick` int(10) NOT NULL DEFAULT '0',
586 `Handphone` int(10) NOT NULL DEFAULT '0',
587 `LKJ` int(10) NOT NULL DEFAULT '0',
588 `CS` int(10) NOT NULL DEFAULT '0',
589 `Asuransi` int(10) NOT NULL DEFAULT '0',
590 `SPosR_x` float(10,5) NOT NULL DEFAULT '0.00000',
591 `SPosR_y` float(10,5) NOT NULL DEFAULT '0.00000',
592 `SPosR_z` float(10,5) NOT NULL DEFAULT '0.00000',
593 `SPosR_r` float(10,5) NOT NULL DEFAULT '0.00000',
594 `RModel` int(10) NOT NULL DEFAULT '0',
595 `RTime` int(10) NOT NULL DEFAULT '0',
596 `RTax` int(18) NOT NULL DEFAULT '0',
597 `RDenda` int(18) NOT NULL DEFAULT '0',
598 `RLock` int(5) NOT NULL DEFAULT '0',
599 `AID` int(10) NOT NULL DEFAULT '9999',
600 `ZAID` int(10) NOT NULL DEFAULT '9999',
601 `GID` int(10) NOT NULL DEFAULT '9999',
602 `RAID` int(10) NOT NULL DEFAULT '9999',
603 `VAID` int(10) NOT NULL DEFAULT '9999',
604 `REnter` int(10) NOT NULL DEFAULT '9999',
605 `GTut` int(5) NOT NULL DEFAULT '0',
606 `InvGun` int(10) NOT NULL DEFAULT '0',
607 `InvGun2` int(10) NOT NULL DEFAULT '0',
608 `InvAmmo` int(10) NOT NULL DEFAULT '0',
609 `InvAmmo2` int(10) NOT NULL DEFAULT '0',
610 `SweeperT` int(10) NOT NULL DEFAULT '0',
611 `StockHot` int(10) NOT NULL DEFAULT '0',
612 `StockPiz` int(10) NOT NULL DEFAULT '0',
613 `Pacul` int(10) NOT NULL DEFAULT '0',
614 `AdminName` varchar(64) NOT NULL DEFAULT 'None',
615 `NormalName` varchar(64) NOT NULL DEFAULT 'None',
616 `FSKey` int(10) NOT NULL DEFAULT '9999',
617 `APKey` int(10) NOT NULL DEFAULT '0',
618 `CP` int(10) NOT NULL DEFAULT '0',
619 `CompMember` int(10) NOT NULL DEFAULT '0',
620 `CompLeader` int(10) NOT NULL DEFAULT '0',
621 `Rock` int(10) NOT NULL DEFAULT '0',
622 `Hammer` int(10) NOT NULL DEFAULT '0',
623 `CIModel` varchar(30) NOT NULL DEFAULT '0|0|0|0|0',
624 `CITime` varchar(50) NOT NULL DEFAULT '',
625 `CInsure` varchar(30) NOT NULL DEFAULT '0|0|0|0|0',
626 `LastActive` varchar(30) NOT NULL DEFAULT '1|1|2000|0|0|0',
627 `Seeds` varchar(30) NOT NULL DEFAULT '0|0|0',
628 `Wheat` varchar(30) NOT NULL DEFAULT '0|0|0',
629 `GunSkill` varchar(90) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0',
630 `Farm` int(11) NOT NULL DEFAULT '-1',
631 `FarmW` int(11) NOT NULL DEFAULT '-1',
632 `owner` varchar(32) NOT NULL,
633 `ws` int(10) NOT NULL DEFAULT '-1',
634 `workws` int(10) NOT NULL DEFAULT '-1',
635 PRIMARY KEY (`playerID`)
636) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
637
638-- --------------------------------------------------------
639
640--
641-- Table structure for table `playergun`
642--
643
644CREATE TABLE IF NOT EXISTS `playergun` (
645 `id` int(25) NOT NULL AUTO_INCREMENT,
646 `pid` int(16) NOT NULL,
647 `slot` int(5) NOT NULL,
648 `gun` int(6) NOT NULL,
649 `ammo` int(10) NOT NULL,
650 PRIMARY KEY (`id`)
651) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;
652
653-- --------------------------------------------------------
654
655--
656-- Table structure for table `playertoys`
657--
658
659CREATE TABLE IF NOT EXISTS `playertoys` (
660 `id` int(16) NOT NULL AUTO_INCREMENT,
661 `slot` int(5) NOT NULL,
662 `owner` varchar(45) NOT NULL,
663 `pid` int(16) NOT NULL,
664 `model` int(6) NOT NULL,
665 `bone` int(3) NOT NULL,
666 `x` float(10,5) NOT NULL,
667 `y` float(10,5) NOT NULL,
668 `z` float(10,5) NOT NULL,
669 `rx` float(10,5) NOT NULL,
670 `ry` float(10,5) NOT NULL,
671 `rz` float(10,5) NOT NULL,
672 `sx` float(10,5) NOT NULL,
673 `sy` float(10,5) NOT NULL,
674 `sz` float(10,5) NOT NULL,
675 `c1` int(4) NOT NULL DEFAULT '1',
676 `c2` int(4) NOT NULL DEFAULT '1',
677 PRIMARY KEY (`id`)
678) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
679
680-- --------------------------------------------------------
681
682--
683-- Table structure for table `playerucp`
684--
685
686CREATE TABLE IF NOT EXISTS `playerucp` (
687 `id` int(32) NOT NULL AUTO_INCREMENT,
688 `owner` varchar(32) NOT NULL,
689 `char` varchar(32) NOT NULL,
690 PRIMARY KEY (`id`)
691) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
692
693-- --------------------------------------------------------
694
695--
696-- Table structure for table `playervehiclemods`
697--
698
699CREATE TABLE IF NOT EXISTS `playervehiclemods` (
700 `modid` int(20) NOT NULL AUTO_INCREMENT,
701 `owner` varchar(64) NOT NULL,
702 `id` int(10) NOT NULL,
703 `mod0` int(11) NOT NULL,
704 `mod1` int(11) NOT NULL,
705 `mod2` int(11) NOT NULL,
706 `mod3` int(11) NOT NULL,
707 `mod4` int(11) NOT NULL,
708 `mod5` int(11) NOT NULL,
709 `mod6` int(11) NOT NULL,
710 `mod7` int(11) NOT NULL,
711 `mod8` int(11) NOT NULL,
712 `mod9` int(11) NOT NULL,
713 `mod10` int(11) NOT NULL,
714 `mod11` int(11) NOT NULL,
715 `mod12` int(11) NOT NULL,
716 `mod13` int(11) NOT NULL,
717 PRIMARY KEY (`modid`)
718) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
719
720-- --------------------------------------------------------
721
722--
723-- Table structure for table `playervehicles`
724--
725
726CREATE TABLE IF NOT EXISTS `playervehicles` (
727 `vid` int(10) NOT NULL AUTO_INCREMENT,
728 `owner` varchar(64) NOT NULL,
729 `id` int(10) NOT NULL,
730 `X` float(10,5) NOT NULL,
731 `Y` float(10,5) NOT NULL,
732 `Z` float(10,5) NOT NULL,
733 `Angle` float(10,5) NOT NULL,
734 `Model` int(4) NOT NULL,
735 `vLock` int(3) NOT NULL,
736 `Locked` int(3) NOT NULL,
737 `Paintjob` int(3) NOT NULL DEFAULT '-1',
738 `c1` int(4) NOT NULL,
739 `c2` int(4) NOT NULL,
740 `price` int(32) NOT NULL,
741 `wep0` int(3) NOT NULL,
742 `wep1` int(3) NOT NULL,
743 `wep2` int(3) NOT NULL,
744 `awep0` int(3) NOT NULL,
745 `awep1` int(3) NOT NULL,
746 `awep2` int(3) NOT NULL,
747 `fuel` float(10,5) NOT NULL,
748 `wheat` int(4) NOT NULL,
749 `inven` int(10) NOT NULL,
750 `inventype` int(10) NOT NULL,
751 `ptype` int(10) NOT NULL,
752 `invenpublic` int(10) NOT NULL,
753 `neon` int(4) NOT NULL,
754 `garage` int(4) NOT NULL,
755 `impound` int(4) NOT NULL,
756 `plate` varchar(64) NOT NULL,
757 `health` float(10,5) NOT NULL DEFAULT '1000.00000',
758 `dam0` int(5) NOT NULL,
759 `dam1` int(5) NOT NULL,
760 `dam2` int(5) NOT NULL,
761 `dam3` int(5) NOT NULL,
762 PRIMARY KEY (`vid`)
763) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
764
765-- --------------------------------------------------------
766
767--
768-- Table structure for table `playervehicletoys`
769--
770
771CREATE TABLE IF NOT EXISTS `playervehicletoys` (
772 `toyid` int(32) NOT NULL AUTO_INCREMENT,
773 `owner` varchar(64) NOT NULL,
774 `id` int(32) NOT NULL,
775 `slot` int(5) NOT NULL,
776 `model` int(10) NOT NULL,
777 `x` float(10,5) NOT NULL,
778 `y` float(10,5) NOT NULL,
779 `z` float(10,5) NOT NULL,
780 `rx` float(10,5) NOT NULL,
781 `ry` float(10,5) NOT NULL,
782 `rz` float(10,5) NOT NULL,
783 `col` int(5) NOT NULL DEFAULT '1',
784 `index` int(5) NOT NULL,
785 `text1` varchar(128) NOT NULL,
786 `text2` varchar(128) NOT NULL,
787 `text3` varchar(128) NOT NULL,
788 `text4` varchar(128) NOT NULL,
789 `text5` varchar(128) NOT NULL,
790 `text6` varchar(128) NOT NULL,
791 `text7` varchar(128) NOT NULL,
792 `text8` varchar(128) NOT NULL,
793 `text9` varchar(128) NOT NULL,
794 `text10` varchar(128) NOT NULL,
795 `textcol` int(5) NOT NULL DEFAULT '1',
796 `textsize` int(5) NOT NULL,
797 PRIMARY KEY (`toyid`)
798) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
799
800-- --------------------------------------------------------
801
802--
803-- Table structure for table `renting`
804--
805
806CREATE TABLE IF NOT EXISTS `renting` (
807 `id` int(10) NOT NULL AUTO_INCREMENT,
808 `rentID` int(10) NOT NULL,
809 `rentX` float(10,5) NOT NULL DEFAULT '0.00000',
810 `rentY` float(10,5) NOT NULL DEFAULT '0.00000',
811 `rentZ` float(10,5) NOT NULL DEFAULT '0.00000',
812 PRIMARY KEY (`id`)
813) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
814
815-- --------------------------------------------------------
816
817--
818-- Table structure for table `salary`
819--
820
821CREATE TABLE IF NOT EXISTS `salary` (
822 `id` int(16) NOT NULL AUTO_INCREMENT,
823 `ownerid` int(16) NOT NULL,
824 `issuer` text NOT NULL,
825 `cash` int(32) NOT NULL,
826 `from` text NOT NULL,
827 `date` int(32) NOT NULL,
828 PRIMARY KEY (`id`)
829) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
830
831-- --------------------------------------------------------
832
833--
834-- Table structure for table `workshop`
835--
836
837CREATE TABLE IF NOT EXISTS `workshop` (
838 `id` int(32) NOT NULL AUTO_INCREMENT,
839 `wsid` int(10) NOT NULL,
840 `owner` varchar(64) NOT NULL,
841 `x` float(10,5) NOT NULL,
842 `y` float(10,5) NOT NULL,
843 `z` float(10,5) NOT NULL,
844 `cost` int(32) NOT NULL,
845 `lock` tinyint(2) NOT NULL,
846 `px` float(10,5) NOT NULL,
847 `py` float(10,5) NOT NULL,
848 `pz` float(10,5) NOT NULL,
849 `prx` float(10,5) NOT NULL,
850 `pry` float(10,5) NOT NULL,
851 `prz` float(10,5) NOT NULL,
852 `moto` varchar(128) NOT NULL,
853 `owned` tinyint(2) NOT NULL,
854 `name` varchar(45) NOT NULL,
855 `repx` float(10,5) NOT NULL,
856 `repy` float(10,5) NOT NULL,
857 `repz` float(10,5) NOT NULL,
858 `radius` float(10,5) NOT NULL,
859 `cash` int(32) NOT NULL,
860 `compo` int(10) NOT NULL,
861 PRIMARY KEY (`id`)
862) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;