· 8 years ago · Mar 17, 2018, 05:02 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.4
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Feb 01, 2015 at 08:06 PM
7-- Server version: 5.5.32
8-- PHP Version: 5.4.16
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-- Table structure for table `911calls`
21--
22
23CREATE TABLE IF NOT EXISTS `911calls` (
24 `id` int(11) NOT NULL AUTO_INCREMENT,
25 `Caller` varchar(24) COLLATE utf8_bin NOT NULL DEFAULT 'N/A',
26 `Phone` int(11) NOT NULL DEFAULT '0',
27 `Area` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'None',
28 `MainZone` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'None',
29 `Description` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'None',
30 `Type` int(11) NOT NULL DEFAULT '0',
31 `Time` int(11) NOT NULL DEFAULT '0',
32 PRIMARY KEY (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
34
35-- --------------------------------------------------------
36
37--
38-- Table structure for table `accounts`
39--
40
41CREATE TABLE IF NOT EXISTS `accounts` (
42 `id` int(11) NOT NULL AUTO_INCREMENT,
43 `Online` int(11) NOT NULL DEFAULT '0',
44 `UpdateDate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
45 `RegiDate` datetime DEFAULT NULL,
46 `LastLogin` datetime DEFAULT NULL,
47 `Username` varchar(32) NOT NULL DEFAULT '',
48 `Key` varchar(256) NOT NULL DEFAULT '',
49 `Salt` varchar(255) NOT NULL,
50 `LastPassChange` datetime NOT NULL,
51 `Email` varchar(256) NOT NULL DEFAULT '',
52 `IP` varchar(32) NOT NULL DEFAULT '0.0.0.0',
53 `SecureIP` varchar(32) NOT NULL DEFAULT '0.0.0.0',
54 `Registered` int(11) NOT NULL DEFAULT '0',
55 `ConnectedTime` int(11) NOT NULL DEFAULT '0',
56 `Sex` int(11) NOT NULL DEFAULT '1',
57 `Age` int(11) NOT NULL DEFAULT '18',
58 `BirthDate` date NOT NULL DEFAULT '0000-00-00',
59 `Band` int(11) NOT NULL DEFAULT '0',
60 `PermBand` int(11) NOT NULL DEFAULT '0',
61 `Warnings` int(11) NOT NULL DEFAULT '0',
62 `referral_id` int(11) NOT NULL DEFAULT '0',
63 `Disabled` int(11) NOT NULL DEFAULT '0',
64 `Level` int(11) NOT NULL DEFAULT '1',
65 `AdminLevel` int(11) NOT NULL DEFAULT '0',
66 `AdminType` int(11) NOT NULL DEFAULT '0',
67 `DonateRank` int(11) NOT NULL DEFAULT '0',
68 `Respect` int(11) NOT NULL DEFAULT '0',
69 `Money` bigint(11) NOT NULL DEFAULT '5000',
70 `Bank` bigint(11) NOT NULL DEFAULT '20000',
71 `pHealth` float(10,5) NOT NULL DEFAULT '50.00000',
72 `pArmor` float(10,5) NOT NULL DEFAULT '0.00000',
73 `pSHealth` float(10,5) NOT NULL DEFAULT '0.00000',
74 `Int` int(11) NOT NULL DEFAULT '0',
75 `VirtualWorld` int(11) NOT NULL DEFAULT '0',
76 `Model` int(11) NOT NULL DEFAULT '299',
77 `SPos_x` float(20,5) NOT NULL DEFAULT '0.00000',
78 `SPos_y` float(20,5) NOT NULL DEFAULT '0.00000',
79 `SPos_z` float(20,5) NOT NULL DEFAULT '0.00000',
80 `SPos_r` float(20,5) NOT NULL DEFAULT '0.00000',
81 `BanAppealer` int(11) NOT NULL DEFAULT '0',
82 `ShopTech` int(11) NOT NULL DEFAULT '0',
83 `HR` int(11) NOT NULL,
84 `Undercover` int(11) NOT NULL DEFAULT '0',
85 `TogReports` int(11) NOT NULL DEFAULT '0',
86 `Radio` int(11) NOT NULL DEFAULT '0',
87 `RadioFreq` int(11) NOT NULL DEFAULT '0',
88 `UpgradePoints` int(11) NOT NULL DEFAULT '0',
89 `Origin` int(11) NOT NULL DEFAULT '0',
90 `Muted` int(11) NOT NULL DEFAULT '0',
91 `Crimes` int(11) NOT NULL DEFAULT '0',
92 `Accent` int(11) NOT NULL DEFAULT '0',
93 `CHits` int(11) NOT NULL DEFAULT '0',
94 `FHits` int(11) NOT NULL DEFAULT '0',
95 `Arrested` int(11) NOT NULL DEFAULT '0',
96 `Phonebook` int(11) NOT NULL DEFAULT '0',
97 `LottoNr` int(11) NOT NULL DEFAULT '0',
98 `Fishes` int(11) NOT NULL DEFAULT '0',
99 `BiggestFish` int(11) NOT NULL DEFAULT '0',
100 `Job` int(11) NOT NULL DEFAULT '0',
101 `Job2` int(11) NOT NULL DEFAULT '0',
102 `Paycheck` int(11) NOT NULL DEFAULT '0',
103 `HeadValue` int(11) NOT NULL DEFAULT '0',
104 `Jailed` int(11) NOT NULL DEFAULT '0',
105 `JailTime` int(11) NOT NULL DEFAULT '0',
106 `WRestricted` int(11) NOT NULL DEFAULT '0',
107 `Materials` int(11) NOT NULL DEFAULT '0',
108 `Crates` int(11) NOT NULL DEFAULT '0',
109 `Pot` int(11) NOT NULL DEFAULT '0',
110 `Crack` int(11) NOT NULL DEFAULT '0',
111 `Nation` int(1) NOT NULL DEFAULT '0',
112 `Leader` int(11) NOT NULL DEFAULT '-1',
113 `Member` int(11) NOT NULL DEFAULT '-1',
114 `Division` int(11) NOT NULL DEFAULT '-1',
115 `FMember` int(11) NOT NULL DEFAULT '255',
116 `Rank` int(11) NOT NULL DEFAULT '-1',
117 `DetSkill` int(11) NOT NULL DEFAULT '0',
118 `SexSkill` int(11) NOT NULL DEFAULT '0',
119 `BoxSkill` int(11) NOT NULL DEFAULT '0',
120 `LawSkill` int(11) NOT NULL DEFAULT '0',
121 `MechSkill` int(11) NOT NULL DEFAULT '0',
122 `TruckSkill` int(11) NOT NULL DEFAULT '0',
123 `DrugsSkill` int(11) NOT NULL DEFAULT '0',
124 `ArmsSkill` int(11) NOT NULL DEFAULT '0',
125 `SmugglerSkill` int(11) NOT NULL DEFAULT '0',
126 `FishSkill` int(11) NOT NULL DEFAULT '0',
127 `FightingStyle` int(11) NOT NULL DEFAULT '0',
128 `PhoneNr` int(11) NOT NULL DEFAULT '0',
129 `Apartment` int(11) NOT NULL DEFAULT '-1',
130 `Apartment2` int(11) NOT NULL DEFAULT '-1',
131 `Renting` int(11) NOT NULL DEFAULT '-1',
132 `CarLic` int(11) NOT NULL DEFAULT '1',
133 `FlyLic` int(11) NOT NULL DEFAULT '0',
134 `BoatLic` int(11) NOT NULL DEFAULT '1',
135 `FishLic` int(11) NOT NULL DEFAULT '1',
136 `CheckCash` int(11) NOT NULL DEFAULT '0',
137 `Checks` int(11) NOT NULL DEFAULT '0',
138 `GunLic` int(11) NOT NULL DEFAULT '1',
139 `Gun0` int(11) NOT NULL DEFAULT '0',
140 `Gun1` int(11) NOT NULL DEFAULT '0',
141 `Gun2` int(11) NOT NULL DEFAULT '0',
142 `Gun3` int(11) NOT NULL DEFAULT '0',
143 `Gun4` int(11) NOT NULL DEFAULT '0',
144 `Gun5` int(11) NOT NULL DEFAULT '0',
145 `Gun6` int(11) NOT NULL DEFAULT '0',
146 `Gun7` int(11) NOT NULL DEFAULT '0',
147 `Gun8` int(11) NOT NULL DEFAULT '0',
148 `Gun9` int(11) NOT NULL DEFAULT '0',
149 `Gun10` int(11) NOT NULL DEFAULT '0',
150 `Gun11` int(11) NOT NULL DEFAULT '0',
151 `DrugsTime` int(11) NOT NULL DEFAULT '0',
152 `LawyerTime` int(11) NOT NULL DEFAULT '0',
153 `LawyerFreeTime` int(11) NOT NULL DEFAULT '0',
154 `MechTime` int(11) NOT NULL DEFAULT '0',
155 `SexTime` int(11) NOT NULL DEFAULT '0',
156 `PayDay` int(11) NOT NULL DEFAULT '0',
157 `PayDayHad` int(11) NOT NULL DEFAULT '0',
158 `CDPlayer` int(11) NOT NULL DEFAULT '0',
159 `Dice` int(11) NOT NULL DEFAULT '0',
160 `Spraycan` int(11) NOT NULL DEFAULT '0',
161 `Rope` int(11) NOT NULL DEFAULT '0',
162 `Cigars` int(11) NOT NULL DEFAULT '0',
163 `Sprunk` int(11) NOT NULL DEFAULT '0',
164 `Bombs` int(11) NOT NULL DEFAULT '0',
165 `Wins` int(11) NOT NULL DEFAULT '0',
166 `Loses` int(11) NOT NULL DEFAULT '0',
167 `Tutorial` int(11) NOT NULL DEFAULT '0',
168 `OnDuty` int(11) NOT NULL DEFAULT '0',
169 `Hospital` int(11) NOT NULL DEFAULT '0',
170 `MarriedID` int(11) NOT NULL DEFAULT '-1',
171 `MarriedTo` varchar(32) NOT NULL DEFAULT 'Nobody',
172 `ContractBy` varchar(32) NOT NULL DEFAULT 'Nobody',
173 `ContractDetail` varchar(64) NOT NULL DEFAULT 'None',
174 `WantedLevel` int(11) NOT NULL DEFAULT '0',
175 `Insurance` int(11) NOT NULL DEFAULT '0',
176 `NewMuted` int(11) NOT NULL DEFAULT '0',
177 `NewMutedTotal` int(11) NOT NULL DEFAULT '0',
178 `AdMuted` int(11) NOT NULL DEFAULT '0',
179 `AdMutedTotal` int(11) NOT NULL DEFAULT '0',
180 `HelpMute` int(11) NOT NULL DEFAULT '0',
181 `Helper` int(11) NOT NULL DEFAULT '0',
182 `ReportMuted` int(11) NOT NULL DEFAULT '0',
183 `ReportMutedTotal` int(11) NOT NULL DEFAULT '0',
184 `ReportMutedTime` int(11) NOT NULL DEFAULT '0',
185 `VIPMuted` int(11) NOT NULL DEFAULT '0',
186 `VIPMutedTime` int(11) NOT NULL DEFAULT '0',
187 `GiftTime` int(11) NOT NULL DEFAULT '0',
188 `AdvisorDutyHours` int(11) NOT NULL DEFAULT '0',
189 `AcceptedHelp` int(11) NOT NULL DEFAULT '0',
190 `AcceptReport` int(11) NOT NULL DEFAULT '0',
191 `ShopTechOrders` int(11) NOT NULL DEFAULT '0',
192 `TrashReport` int(11) NOT NULL DEFAULT '0',
193 `FactionModerator` int(11) NOT NULL DEFAULT '0',
194 `GangModerator` int(11) NOT NULL DEFAULT '0',
195 `SeniorModerator` int(11) NOT NULL DEFAULT '0',
196 `GangWarn` int(11) NOT NULL DEFAULT '0',
197 `FactionBanned` int(11) NOT NULL DEFAULT '0',
198 `CSFBanned` int(11) NOT NULL DEFAULT '0',
199 `VIPInviteDay` int(11) NOT NULL DEFAULT '0',
200 `TempVIP` int(11) NOT NULL DEFAULT '0',
201 `BuddyInvite` int(11) NOT NULL DEFAULT '0',
202 `Tokens` int(11) NOT NULL DEFAULT '0',
203 `PTokens` int(11) NOT NULL DEFAULT '0',
204 `TriageTime` int(11) NOT NULL DEFAULT '0',
205 `PrisonedBy` varchar(32) NOT NULL DEFAULT 'Nobody',
206 `PrisonReason` varchar(128) NOT NULL DEFAULT 'None',
207 `Flag` varchar(128) NOT NULL DEFAULT '',
208 `TaxiLicense` int(11) NOT NULL DEFAULT '0',
209 `TicketTime` int(11) NOT NULL DEFAULT '0',
210 `Screwdriver` int(11) NOT NULL DEFAULT '0',
211 `Smslog` int(11) NOT NULL DEFAULT '0',
212 `Wristwatch` int(11) NOT NULL DEFAULT '0',
213 `Surveillance` int(11) NOT NULL DEFAULT '0',
214 `Tire` int(11) NOT NULL DEFAULT '0',
215 `Firstaid` int(11) NOT NULL DEFAULT '0',
216 `Rccam` int(11) NOT NULL DEFAULT '0',
217 `Receiver` int(11) NOT NULL DEFAULT '0',
218 `GPS` int(11) NOT NULL DEFAULT '0',
219 `Sweep` int(11) NOT NULL DEFAULT '0',
220 `SweepLeft` int(11) NOT NULL DEFAULT '0',
221 `Bugged` int(11) NOT NULL DEFAULT '0',
222 `Smslog0` varchar(256) NOT NULL DEFAULT '',
223 `Smslog1` varchar(256) NOT NULL DEFAULT '',
224 `Smslog2` varchar(256) NOT NULL DEFAULT '',
225 `Smslog3` varchar(256) NOT NULL DEFAULT '',
226 `Smslog4` varchar(256) NOT NULL DEFAULT '',
227 `Smslog5` varchar(256) NOT NULL DEFAULT '',
228 `Smslog6` varchar(256) NOT NULL DEFAULT '',
229 `Smslog7` varchar(256) NOT NULL DEFAULT '',
230 `Smslog8` varchar(256) NOT NULL DEFAULT '',
231 `Smslog9` varchar(256) NOT NULL DEFAULT '',
232 `KillLog0` varchar(256) NOT NULL DEFAULT '',
233 `KillLog1` varchar(256) NOT NULL DEFAULT '',
234 `KillLog2` varchar(256) NOT NULL DEFAULT '',
235 `KillLog3` varchar(256) NOT NULL DEFAULT '',
236 `KillLog4` varchar(256) NOT NULL DEFAULT '',
237 `KillLog5` varchar(256) NOT NULL DEFAULT '',
238 `KillLog6` varchar(256) NOT NULL DEFAULT '',
239 `KillLog7` varchar(256) NOT NULL DEFAULT '',
240 `KillLog8` varchar(256) NOT NULL DEFAULT '',
241 `KillLog9` varchar(256) NOT NULL DEFAULT '',
242 `pWExists` int(11) NOT NULL DEFAULT '0',
243 `pWX` float(10,5) NOT NULL DEFAULT '0.00000',
244 `pWY` float(10,5) NOT NULL DEFAULT '0.00000',
245 `pWZ` float(10,5) NOT NULL DEFAULT '0.00000',
246 `pWVW` int(11) NOT NULL DEFAULT '0',
247 `pWInt` int(11) NOT NULL DEFAULT '0',
248 `pWValue` int(11) NOT NULL DEFAULT '-1',
249 `pWSeeds` int(11) NOT NULL DEFAULT '0',
250 `Warrants` varchar(128) NOT NULL DEFAULT '',
251 `JudgeJailTime` int(11) NOT NULL DEFAULT '0',
252 `JudgeJailType` int(11) NOT NULL DEFAULT '0',
253 `BeingSentenced` int(11) NOT NULL DEFAULT '0',
254 `ProbationTime` int(11) NOT NULL DEFAULT '0',
255 `DMKills` int(11) NOT NULL DEFAULT '0',
256 `Order` varchar(63) NOT NULL DEFAULT '',
257 `OrderConfirmed` int(11) NOT NULL DEFAULT '0',
258 `CallsAccepted` int(11) NOT NULL DEFAULT '0',
259 `PatientsDelivered` int(11) NOT NULL DEFAULT '0',
260 `LiveBanned` int(11) NOT NULL DEFAULT '0',
261 `FreezeBank` int(11) NOT NULL DEFAULT '0',
262 `FreezeHouse` int(11) NOT NULL DEFAULT '0',
263 `FreezeCar` int(11) NOT NULL DEFAULT '0',
264 `Hydration` int(11) NOT NULL DEFAULT '0',
265 `DoubleEXP` int(11) NOT NULL DEFAULT '0',
266 `EXPToken` int(11) NOT NULL DEFAULT '0',
267 `RacePlayerLaps` int(11) NOT NULL DEFAULT '0',
268 `Ringtone` int(11) NOT NULL DEFAULT '0',
269 `VIPM` int(11) NOT NULL DEFAULT '0',
270 `VIPMO` int(11) NOT NULL DEFAULT '0',
271 `VIPExpire` int(11) NOT NULL DEFAULT '0',
272 `VIPSold` int(11) NOT NULL DEFAULT '0',
273 `GVip` int(11) NOT NULL DEFAULT '0',
274 `Speedo` int(11) NOT NULL DEFAULT '0',
275 `Firework` int(11) NOT NULL DEFAULT '0',
276 `Boombox` int(11) NOT NULL DEFAULT '0',
277 `pv0PosX` float(10,5) NOT NULL DEFAULT '0.00000',
278 `pv0PosY` float(10,5) NOT NULL DEFAULT '0.00000',
279 `pv0PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
280 `pv0PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
281 `pv0ModelId` int(11) NOT NULL DEFAULT '0',
282 `pv0Lock` int(11) NOT NULL DEFAULT '0',
283 `pv0dLocked` int(11) NOT NULL DEFAULT '0',
284 `pv0PaintJob` int(11) NOT NULL DEFAULT '-1',
285 `pv0Color1` int(11) NOT NULL DEFAULT '0',
286 `pv0Color2` int(11) NOT NULL DEFAULT '0',
287 `pv0Price` int(11) NOT NULL DEFAULT '0',
288 `pv0Ticket` int(11) NOT NULL DEFAULT '0',
289 `pv0Weapon0` int(11) NOT NULL DEFAULT '0',
290 `pv0Weapon1` int(11) NOT NULL DEFAULT '0',
291 `pv0Weapon2` int(11) NOT NULL DEFAULT '0',
292 `pv0WepUpgrade` int(11) NOT NULL DEFAULT '0',
293 `pv0Fuel` float(10,5) NOT NULL DEFAULT '100.00000',
294 `pv0Impound` int(11) NOT NULL DEFAULT '0',
295 `pv0Spawned` int(11) NOT NULL DEFAULT '0',
296 `pv0Disabled` int(11) NOT NULL DEFAULT '0',
297 `pv0Plate` varchar(32) NOT NULL DEFAULT '',
298 `pv0Mod0` int(11) NOT NULL DEFAULT '0',
299 `pv0Mod1` int(11) NOT NULL DEFAULT '0',
300 `pv0Mod2` int(11) NOT NULL DEFAULT '0',
301 `pv0Mod3` int(11) NOT NULL DEFAULT '0',
302 `pv0Mod4` int(11) NOT NULL DEFAULT '0',
303 `pv0Mod5` int(11) NOT NULL DEFAULT '0',
304 `pv0Mod6` int(11) NOT NULL DEFAULT '0',
305 `pv0Mod7` int(11) NOT NULL DEFAULT '0',
306 `pv0Mod8` int(11) NOT NULL DEFAULT '0',
307 `pv0Mod9` int(11) NOT NULL DEFAULT '0',
308 `pv0Mod10` int(11) NOT NULL DEFAULT '0',
309 `pv0Mod11` int(11) NOT NULL DEFAULT '0',
310 `pv0Mod12` int(11) NOT NULL DEFAULT '0',
311 `pv0Mod13` int(11) NOT NULL DEFAULT '0',
312 `pv0Mod14` int(11) NOT NULL DEFAULT '0',
313 `pv1PosX` float(10,5) NOT NULL DEFAULT '0.00000',
314 `pv1PosY` float(10,5) NOT NULL DEFAULT '0.00000',
315 `pv1PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
316 `pv1PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
317 `pv1ModelId` int(11) NOT NULL DEFAULT '0',
318 `pv1Lock` int(11) NOT NULL DEFAULT '0',
319 `pv1dLocked` int(11) NOT NULL DEFAULT '0',
320 `pv1PaintJob` int(11) NOT NULL DEFAULT '-1',
321 `pv1Color1` int(11) NOT NULL DEFAULT '0',
322 `pv1Color2` int(11) NOT NULL DEFAULT '0',
323 `pv1Price` int(11) NOT NULL DEFAULT '0',
324 `pv1Ticket` int(11) NOT NULL DEFAULT '0',
325 `pv1Weapon0` int(11) NOT NULL DEFAULT '0',
326 `pv1Weapon1` int(11) NOT NULL DEFAULT '0',
327 `pv1Weapon2` int(11) NOT NULL DEFAULT '0',
328 `pv1WepUpgrade` int(11) NOT NULL DEFAULT '0',
329 `pv1Fuel` float(10,5) NOT NULL DEFAULT '100.00000',
330 `pv1Impound` int(11) NOT NULL DEFAULT '0',
331 `pv1Spawned` int(11) NOT NULL DEFAULT '0',
332 `pv1Disabled` int(11) NOT NULL DEFAULT '0',
333 `pv1Plate` varchar(32) NOT NULL DEFAULT '',
334 `pv1Mod0` int(11) NOT NULL DEFAULT '0',
335 `pv1Mod1` int(11) NOT NULL DEFAULT '0',
336 `pv1Mod2` int(11) NOT NULL DEFAULT '0',
337 `pv1Mod3` int(11) NOT NULL DEFAULT '0',
338 `pv1Mod4` int(11) NOT NULL DEFAULT '0',
339 `pv1Mod5` int(11) NOT NULL DEFAULT '0',
340 `pv1Mod6` int(11) NOT NULL DEFAULT '0',
341 `pv1Mod7` int(11) NOT NULL DEFAULT '0',
342 `pv1Mod8` int(11) NOT NULL DEFAULT '0',
343 `pv1Mod9` int(11) NOT NULL DEFAULT '0',
344 `pv1Mod10` int(11) NOT NULL DEFAULT '0',
345 `pv1Mod11` int(11) NOT NULL DEFAULT '0',
346 `pv1Mod12` int(11) NOT NULL DEFAULT '0',
347 `pv1Mod13` int(11) NOT NULL DEFAULT '0',
348 `pv1Mod14` int(11) NOT NULL DEFAULT '0',
349 `pv2PosX` float(10,5) NOT NULL DEFAULT '0.00000',
350 `pv2PosY` float(10,5) NOT NULL DEFAULT '0.00000',
351 `pv2PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
352 `pv2PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
353 `pv2ModelId` int(11) NOT NULL DEFAULT '0',
354 `pv2Lock` int(11) NOT NULL DEFAULT '0',
355 `pv2dLocked` int(11) NOT NULL DEFAULT '0',
356 `pv2PaintJob` int(11) NOT NULL DEFAULT '-1',
357 `pv2Color1` int(11) NOT NULL DEFAULT '0',
358 `pv2Color2` int(11) NOT NULL DEFAULT '0',
359 `pv2Price` int(11) NOT NULL DEFAULT '0',
360 `pv2Ticket` int(11) NOT NULL DEFAULT '0',
361 `pv2Weapon0` int(11) NOT NULL DEFAULT '0',
362 `pv2Weapon1` int(11) NOT NULL DEFAULT '0',
363 `pv2Weapon2` int(11) NOT NULL DEFAULT '0',
364 `pv2WepUpgrade` int(11) NOT NULL DEFAULT '0',
365 `pv2Fuel` float(10,5) NOT NULL DEFAULT '100.00000',
366 `pv2Impound` int(11) NOT NULL DEFAULT '0',
367 `pv2Spawned` int(11) NOT NULL DEFAULT '0',
368 `pv2Disabled` int(11) NOT NULL DEFAULT '0',
369 `pv2Plate` varchar(32) NOT NULL DEFAULT '',
370 `pv2Mod0` int(11) NOT NULL DEFAULT '0',
371 `pv2Mod1` int(11) NOT NULL DEFAULT '0',
372 `pv2Mod2` int(11) NOT NULL DEFAULT '0',
373 `pv2Mod3` int(11) NOT NULL DEFAULT '0',
374 `pv2Mod4` int(11) NOT NULL DEFAULT '0',
375 `pv2Mod5` int(11) NOT NULL DEFAULT '0',
376 `pv2Mod6` int(11) NOT NULL DEFAULT '0',
377 `pv2Mod7` int(11) NOT NULL DEFAULT '0',
378 `pv2Mod8` int(11) NOT NULL DEFAULT '0',
379 `pv2Mod9` int(11) NOT NULL DEFAULT '0',
380 `pv2Mod10` int(11) NOT NULL DEFAULT '0',
381 `pv2Mod11` int(11) NOT NULL DEFAULT '0',
382 `pv2Mod12` int(11) NOT NULL DEFAULT '0',
383 `pv2Mod13` int(11) NOT NULL DEFAULT '0',
384 `pv2Mod14` int(11) NOT NULL DEFAULT '0',
385 `pv3PosX` float(10,5) NOT NULL DEFAULT '0.00000',
386 `pv3PosY` float(10,5) NOT NULL DEFAULT '0.00000',
387 `pv3PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
388 `pv3PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
389 `pv3ModelId` int(11) NOT NULL DEFAULT '0',
390 `pv3Lock` int(11) NOT NULL DEFAULT '0',
391 `pv3dLocked` int(11) NOT NULL DEFAULT '0',
392 `pv3PaintJob` int(11) NOT NULL DEFAULT '-1',
393 `pv3Color1` int(11) NOT NULL DEFAULT '0',
394 `pv3Color2` int(11) NOT NULL DEFAULT '0',
395 `pv3Price` int(11) NOT NULL DEFAULT '0',
396 `pv3Ticket` int(11) NOT NULL DEFAULT '0',
397 `pv3Weapon0` int(11) NOT NULL DEFAULT '0',
398 `pv3Weapon1` int(11) NOT NULL DEFAULT '0',
399 `pv3Weapon2` int(11) NOT NULL DEFAULT '0',
400 `pv3WepUpgrade` int(11) NOT NULL DEFAULT '0',
401 `pv3Fuel` float(10,5) NOT NULL DEFAULT '100.00000',
402 `pv3Impound` int(11) NOT NULL DEFAULT '0',
403 `pv3Spawned` int(11) NOT NULL DEFAULT '0',
404 `pv3Disabled` int(11) NOT NULL DEFAULT '0',
405 `pv3Plate` varchar(32) NOT NULL DEFAULT '',
406 `pv3Mod0` int(11) NOT NULL DEFAULT '0',
407 `pv3Mod1` int(11) NOT NULL DEFAULT '0',
408 `pv3Mod2` int(11) NOT NULL DEFAULT '0',
409 `pv3Mod3` int(11) NOT NULL DEFAULT '0',
410 `pv3Mod4` int(11) NOT NULL DEFAULT '0',
411 `pv3Mod5` int(11) NOT NULL DEFAULT '0',
412 `pv3Mod6` int(11) NOT NULL DEFAULT '0',
413 `pv3Mod7` int(11) NOT NULL DEFAULT '0',
414 `pv3Mod8` int(11) NOT NULL DEFAULT '0',
415 `pv3Mod9` int(11) NOT NULL DEFAULT '0',
416 `pv3Mod10` int(11) NOT NULL DEFAULT '0',
417 `pv3Mod11` int(11) NOT NULL DEFAULT '0',
418 `pv3Mod12` int(11) NOT NULL DEFAULT '0',
419 `pv3Mod13` int(11) NOT NULL DEFAULT '0',
420 `pv3Mod14` int(11) NOT NULL DEFAULT '0',
421 `pv4PosX` float(10,5) NOT NULL DEFAULT '0.00000',
422 `pv4PosY` float(10,5) NOT NULL DEFAULT '0.00000',
423 `pv4PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
424 `pv4PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
425 `pv4ModelId` int(11) NOT NULL DEFAULT '0',
426 `pv4Lock` int(11) NOT NULL DEFAULT '0',
427 `pv4dLocked` int(11) NOT NULL DEFAULT '0',
428 `pv4PaintJob` int(11) NOT NULL DEFAULT '-1',
429 `pv4Color1` int(11) NOT NULL DEFAULT '0',
430 `pv4Color2` int(11) NOT NULL DEFAULT '0',
431 `pv4Price` int(11) NOT NULL DEFAULT '0',
432 `pv4Ticket` int(11) NOT NULL DEFAULT '0',
433 `pv4Weapon0` int(11) NOT NULL DEFAULT '0',
434 `pv4Weapon1` int(11) NOT NULL DEFAULT '0',
435 `pv4Weapon2` int(11) NOT NULL DEFAULT '0',
436 `pv4WepUpgrade` int(11) NOT NULL DEFAULT '0',
437 `pv4Fuel` float(10,5) NOT NULL DEFAULT '100.00000',
438 `pv4Impound` int(11) NOT NULL DEFAULT '0',
439 `pv4Spawned` int(11) NOT NULL DEFAULT '0',
440 `pv4Disabled` int(11) NOT NULL DEFAULT '0',
441 `pv4Plate` varchar(32) NOT NULL DEFAULT '',
442 `pv4Mod0` int(11) NOT NULL DEFAULT '0',
443 `pv4Mod1` int(11) NOT NULL DEFAULT '0',
444 `pv4Mod2` int(11) NOT NULL DEFAULT '0',
445 `pv4Mod3` int(11) NOT NULL DEFAULT '0',
446 `pv4Mod4` int(11) NOT NULL DEFAULT '0',
447 `pv4Mod5` int(11) NOT NULL DEFAULT '0',
448 `pv4Mod6` int(11) NOT NULL DEFAULT '0',
449 `pv4Mod7` int(11) NOT NULL DEFAULT '0',
450 `pv4Mod8` int(11) NOT NULL DEFAULT '0',
451 `pv4Mod9` int(11) NOT NULL DEFAULT '0',
452 `pv4Mod10` int(11) NOT NULL DEFAULT '0',
453 `pv4Mod11` int(11) NOT NULL DEFAULT '0',
454 `pv4Mod12` int(11) NOT NULL DEFAULT '0',
455 `pv4Mod13` int(11) NOT NULL DEFAULT '0',
456 `pv4Mod14` int(11) NOT NULL DEFAULT '0',
457 `pv5PosX` float(10,5) NOT NULL DEFAULT '0.00000',
458 `pv5PosY` float(10,5) NOT NULL DEFAULT '0.00000',
459 `pv5PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
460 `pv5PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
461 `pv5ModelId` int(11) NOT NULL DEFAULT '0',
462 `pv5Lock` int(11) NOT NULL DEFAULT '0',
463 `pv5dLocked` int(11) NOT NULL DEFAULT '0',
464 `pv5PaintJob` int(11) NOT NULL DEFAULT '-1',
465 `pv5Color1` int(11) NOT NULL DEFAULT '0',
466 `pv5Color2` int(11) NOT NULL DEFAULT '0',
467 `pv5Price` int(11) NOT NULL DEFAULT '0',
468 `pv5Ticket` int(11) NOT NULL DEFAULT '0',
469 `pv5Weapon0` int(11) NOT NULL DEFAULT '0',
470 `pv5Weapon1` int(11) NOT NULL DEFAULT '0',
471 `pv5Weapon2` int(11) NOT NULL DEFAULT '0',
472 `pv5WepUpgrade` int(11) NOT NULL DEFAULT '0',
473 `pv5Fuel` float(10,5) NOT NULL DEFAULT '100.00000',
474 `pv5Impound` int(11) NOT NULL DEFAULT '0',
475 `pv5Spawned` int(11) NOT NULL DEFAULT '0',
476 `pv5Disabled` int(11) NOT NULL DEFAULT '0',
477 `pv5Plate` varchar(32) NOT NULL DEFAULT '',
478 `pv5Mod0` int(11) NOT NULL DEFAULT '0',
479 `pv5Mod1` int(11) NOT NULL DEFAULT '0',
480 `pv5Mod2` int(11) NOT NULL DEFAULT '0',
481 `pv5Mod3` int(11) NOT NULL DEFAULT '0',
482 `pv5Mod4` int(11) NOT NULL DEFAULT '0',
483 `pv5Mod5` int(11) NOT NULL DEFAULT '0',
484 `pv5Mod6` int(11) NOT NULL DEFAULT '0',
485 `pv5Mod7` int(11) NOT NULL DEFAULT '0',
486 `pv5Mod8` int(11) NOT NULL DEFAULT '0',
487 `pv5Mod9` int(11) NOT NULL DEFAULT '0',
488 `pv5Mod10` int(11) NOT NULL DEFAULT '0',
489 `pv5Mod11` int(11) NOT NULL DEFAULT '0',
490 `pv5Mod12` int(11) NOT NULL DEFAULT '0',
491 `pv5Mod13` int(11) NOT NULL DEFAULT '0',
492 `pv5Mod14` int(11) NOT NULL DEFAULT '0',
493 `pv6PosX` float(10,5) NOT NULL DEFAULT '0.00000',
494 `pv6PosY` float(10,5) NOT NULL DEFAULT '0.00000',
495 `pv6PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
496 `pv6PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
497 `pv6ModelId` int(11) NOT NULL DEFAULT '0',
498 `pv6Lock` int(11) NOT NULL DEFAULT '0',
499 `pv6dLocked` int(11) NOT NULL DEFAULT '0',
500 `pv6PaintJob` int(11) NOT NULL DEFAULT '-1',
501 `pv6Color1` int(11) NOT NULL DEFAULT '0',
502 `pv6Color2` int(11) NOT NULL DEFAULT '0',
503 `pv6Price` int(11) NOT NULL DEFAULT '0',
504 `pv6Ticket` int(11) NOT NULL DEFAULT '0',
505 `pv6Weapon0` int(11) NOT NULL DEFAULT '0',
506 `pv6Weapon1` int(11) NOT NULL DEFAULT '0',
507 `pv6Weapon2` int(11) NOT NULL DEFAULT '0',
508 `pv6WepUpgrade` int(11) NOT NULL DEFAULT '0',
509 `pv6Fuel` float(10,5) NOT NULL DEFAULT '100.00000',
510 `pv6Impound` int(11) NOT NULL DEFAULT '0',
511 `pv6Spawned` int(11) NOT NULL DEFAULT '0',
512 `pv6Disabled` int(11) NOT NULL DEFAULT '0',
513 `pv6Plate` varchar(32) NOT NULL DEFAULT '',
514 `pv6Mod0` int(11) NOT NULL DEFAULT '0',
515 `pv6Mod1` int(11) NOT NULL DEFAULT '0',
516 `pv6Mod2` int(11) NOT NULL DEFAULT '0',
517 `pv6Mod3` int(11) NOT NULL DEFAULT '0',
518 `pv6Mod4` int(11) NOT NULL DEFAULT '0',
519 `pv6Mod5` int(11) NOT NULL DEFAULT '0',
520 `pv6Mod6` int(11) NOT NULL DEFAULT '0',
521 `pv6Mod7` int(11) NOT NULL DEFAULT '0',
522 `pv6Mod8` int(11) NOT NULL DEFAULT '0',
523 `pv6Mod9` int(11) NOT NULL DEFAULT '0',
524 `pv6Mod10` int(11) NOT NULL DEFAULT '0',
525 `pv6Mod11` int(11) NOT NULL DEFAULT '0',
526 `pv6Mod12` int(11) NOT NULL DEFAULT '0',
527 `pv6Mod13` int(11) NOT NULL DEFAULT '0',
528 `pv6Mod14` int(11) NOT NULL DEFAULT '0',
529 `pv7PosX` float(10,5) NOT NULL DEFAULT '0.00000',
530 `pv7PosY` float(10,5) NOT NULL DEFAULT '0.00000',
531 `pv7PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
532 `pv7PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
533 `pv7ModelId` int(11) NOT NULL DEFAULT '0',
534 `pv7Lock` int(11) NOT NULL DEFAULT '0',
535 `pv7dLocked` int(11) NOT NULL DEFAULT '0',
536 `pv7PaintJob` int(11) NOT NULL DEFAULT '-1',
537 `pv7Color1` int(11) NOT NULL DEFAULT '0',
538 `pv7Color2` int(11) NOT NULL DEFAULT '0',
539 `pv7Price` int(11) NOT NULL DEFAULT '0',
540 `pv7Ticket` int(11) NOT NULL DEFAULT '0',
541 `pv7Weapon0` int(11) NOT NULL DEFAULT '0',
542 `pv7Weapon1` int(11) NOT NULL DEFAULT '0',
543 `pv7Weapon2` int(11) NOT NULL DEFAULT '0',
544 `pv7WepUpgrade` int(11) NOT NULL DEFAULT '0',
545 `pv7Fuel` float(10,5) NOT NULL DEFAULT '100.00000',
546 `pv7Impound` int(11) NOT NULL DEFAULT '0',
547 `pv7Spawned` int(11) NOT NULL DEFAULT '0',
548 `pv7Disabled` int(11) NOT NULL DEFAULT '0',
549 `pv7Plate` varchar(32) NOT NULL DEFAULT '',
550 `pv7Mod0` int(11) NOT NULL DEFAULT '0',
551 `pv7Mod1` int(11) NOT NULL DEFAULT '0',
552 `pv7Mod2` int(11) NOT NULL DEFAULT '0',
553 `pv7Mod3` int(11) NOT NULL DEFAULT '0',
554 `pv7Mod4` int(11) NOT NULL DEFAULT '0',
555 `pv7Mod5` int(11) NOT NULL DEFAULT '0',
556 `pv7Mod6` int(11) NOT NULL DEFAULT '0',
557 `pv7Mod7` int(11) NOT NULL DEFAULT '0',
558 `pv7Mod8` int(11) NOT NULL DEFAULT '0',
559 `pv7Mod9` int(11) NOT NULL DEFAULT '0',
560 `pv7Mod10` int(11) NOT NULL DEFAULT '0',
561 `pv7Mod11` int(11) NOT NULL DEFAULT '0',
562 `pv7Mod12` int(11) NOT NULL DEFAULT '0',
563 `pv7Mod13` int(11) NOT NULL DEFAULT '0',
564 `pv7Mod14` int(11) NOT NULL DEFAULT '0',
565 `pv8PosX` float(10,5) NOT NULL DEFAULT '0.00000',
566 `pv8PosY` float(10,5) NOT NULL DEFAULT '0.00000',
567 `pv8PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
568 `pv8PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
569 `pv8ModelId` int(11) NOT NULL DEFAULT '0',
570 `pv8Lock` int(11) NOT NULL DEFAULT '0',
571 `pv8dLocked` int(11) NOT NULL DEFAULT '0',
572 `pv8PaintJob` int(11) NOT NULL DEFAULT '-1',
573 `pv8Color1` int(11) NOT NULL DEFAULT '0',
574 `pv8Color2` int(11) NOT NULL DEFAULT '0',
575 `pv8Price` int(11) NOT NULL DEFAULT '0',
576 `pv8Ticket` int(11) NOT NULL DEFAULT '0',
577 `pv8Weapon0` int(11) NOT NULL DEFAULT '0',
578 `pv8Weapon1` int(11) NOT NULL DEFAULT '0',
579 `pv8Weapon2` int(11) NOT NULL DEFAULT '0',
580 `pv8WepUpgrade` int(11) NOT NULL DEFAULT '0',
581 `pv8Fuel` float(10,5) NOT NULL DEFAULT '100.00000',
582 `pv8Impound` int(11) NOT NULL DEFAULT '0',
583 `pv8Spawned` int(11) NOT NULL DEFAULT '0',
584 `pv8Disabled` int(11) NOT NULL DEFAULT '0',
585 `pv8Plate` varchar(32) NOT NULL DEFAULT '',
586 `pv8Mod0` int(11) NOT NULL DEFAULT '0',
587 `pv8Mod1` int(11) NOT NULL DEFAULT '0',
588 `pv8Mod2` int(11) NOT NULL DEFAULT '0',
589 `pv8Mod3` int(11) NOT NULL DEFAULT '0',
590 `pv8Mod4` int(11) NOT NULL DEFAULT '0',
591 `pv8Mod5` int(11) NOT NULL DEFAULT '0',
592 `pv8Mod6` int(11) NOT NULL DEFAULT '0',
593 `pv8Mod7` int(11) NOT NULL DEFAULT '0',
594 `pv8Mod8` int(11) NOT NULL DEFAULT '0',
595 `pv8Mod9` int(11) NOT NULL DEFAULT '0',
596 `pv8Mod10` int(11) NOT NULL DEFAULT '0',
597 `pv8Mod11` int(11) NOT NULL DEFAULT '0',
598 `pv8Mod12` int(11) NOT NULL DEFAULT '0',
599 `pv8Mod13` int(11) NOT NULL DEFAULT '0',
600 `pv8Mod14` int(11) NOT NULL DEFAULT '0',
601 `pv9PosX` float(10,5) NOT NULL DEFAULT '0.00000',
602 `pv9PosY` float(10,5) NOT NULL DEFAULT '0.00000',
603 `pv9PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
604 `pv9PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
605 `pv9ModelId` int(11) NOT NULL DEFAULT '0',
606 `pv9Lock` int(11) NOT NULL DEFAULT '0',
607 `pv9dLocked` int(11) NOT NULL DEFAULT '0',
608 `pv9PaintJob` int(11) NOT NULL DEFAULT '-1',
609 `pv9Color1` int(11) NOT NULL DEFAULT '0',
610 `pv9Color2` int(11) NOT NULL DEFAULT '0',
611 `pv9Price` int(11) NOT NULL DEFAULT '0',
612 `pv9Ticket` int(11) NOT NULL DEFAULT '0',
613 `pv9Weapon0` int(11) NOT NULL DEFAULT '0',
614 `pv9Weapon1` int(11) NOT NULL DEFAULT '0',
615 `pv9Weapon2` int(11) NOT NULL DEFAULT '0',
616 `pv9WepUpgrade` int(11) NOT NULL DEFAULT '0',
617 `pv9Fuel` float(10,5) NOT NULL DEFAULT '100.00000',
618 `pv9Impound` int(11) NOT NULL DEFAULT '0',
619 `pv9Spawned` int(11) NOT NULL DEFAULT '0',
620 `pv9Disabled` int(11) NOT NULL DEFAULT '0',
621 `pv9Plate` varchar(32) NOT NULL DEFAULT '',
622 `pv9Mod0` int(11) NOT NULL DEFAULT '0',
623 `pv9Mod1` int(11) NOT NULL DEFAULT '0',
624 `pv9Mod2` int(11) NOT NULL DEFAULT '0',
625 `pv9Mod3` int(11) NOT NULL DEFAULT '0',
626 `pv9Mod4` int(11) NOT NULL DEFAULT '0',
627 `pv9Mod5` int(11) NOT NULL DEFAULT '0',
628 `pv9Mod6` int(11) NOT NULL DEFAULT '0',
629 `pv9Mod7` int(11) NOT NULL DEFAULT '0',
630 `pv9Mod8` int(11) NOT NULL DEFAULT '0',
631 `pv9Mod9` int(11) NOT NULL DEFAULT '0',
632 `pv9Mod10` int(11) NOT NULL DEFAULT '0',
633 `pv9Mod11` int(11) NOT NULL DEFAULT '0',
634 `pv9Mod12` int(11) NOT NULL DEFAULT '0',
635 `pv9Mod13` int(11) NOT NULL DEFAULT '0',
636 `pv9Mod14` int(11) NOT NULL DEFAULT '0',
637 `pt0ModelID` int(5) NOT NULL DEFAULT '0',
638 `pt0Bone` int(11) NOT NULL DEFAULT '0',
639 `pt0PosX` float(10,5) NOT NULL DEFAULT '0.00000',
640 `pt0PosY` float(10,5) NOT NULL DEFAULT '0.00000',
641 `pt0PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
642 `pt0RotX` float(10,5) NOT NULL DEFAULT '0.00000',
643 `pt0RotY` float(10,5) NOT NULL DEFAULT '0.00000',
644 `pt0RotZ` float(10,5) NOT NULL DEFAULT '0.00000',
645 `pt0ScaX` float(10,5) NOT NULL DEFAULT '0.00000',
646 `pt0ScaY` float(10,5) NOT NULL DEFAULT '0.00000',
647 `pt0ScaZ` float(10,5) NOT NULL DEFAULT '0.00000',
648 `pt1ModelID` int(5) NOT NULL DEFAULT '0',
649 `pt1Bone` int(11) NOT NULL DEFAULT '0',
650 `pt1PosX` float(10,5) NOT NULL DEFAULT '0.00000',
651 `pt1PosY` float(10,5) NOT NULL DEFAULT '0.00000',
652 `pt1PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
653 `pt1RotX` float(10,5) NOT NULL DEFAULT '0.00000',
654 `pt1RotY` float(10,5) NOT NULL DEFAULT '0.00000',
655 `pt1RotZ` float(10,5) NOT NULL DEFAULT '0.00000',
656 `pt1ScaX` float(10,5) NOT NULL DEFAULT '0.00000',
657 `pt1ScaY` float(10,5) NOT NULL DEFAULT '0.00000',
658 `pt1ScaZ` float(10,5) NOT NULL DEFAULT '0.00000',
659 `pt2ModelID` int(5) NOT NULL DEFAULT '0',
660 `pt2Bone` int(11) NOT NULL DEFAULT '0',
661 `pt2PosX` float(10,5) NOT NULL DEFAULT '0.00000',
662 `pt2PosY` float(10,5) NOT NULL DEFAULT '0.00000',
663 `pt2PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
664 `pt2RotX` float(10,5) NOT NULL DEFAULT '0.00000',
665 `pt2RotY` float(10,5) NOT NULL DEFAULT '0.00000',
666 `pt2RotZ` float(10,5) NOT NULL DEFAULT '0.00000',
667 `pt2ScaX` float(10,5) NOT NULL DEFAULT '0.00000',
668 `pt2ScaY` float(10,5) NOT NULL DEFAULT '0.00000',
669 `pt2ScaZ` float(10,5) NOT NULL DEFAULT '0.00000',
670 `pt3ModelID` int(5) NOT NULL DEFAULT '0',
671 `pt3Bone` int(11) NOT NULL DEFAULT '0',
672 `pt3PosX` float(10,5) NOT NULL DEFAULT '0.00000',
673 `pt3PosY` float(10,5) NOT NULL DEFAULT '0.00000',
674 `pt3PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
675 `pt3RotX` float(10,5) NOT NULL DEFAULT '0.00000',
676 `pt3RotY` float(10,5) NOT NULL DEFAULT '0.00000',
677 `pt3RotZ` float(10,5) NOT NULL DEFAULT '0.00000',
678 `pt3ScaX` float(10,5) NOT NULL DEFAULT '0.00000',
679 `pt3ScaY` float(10,5) NOT NULL DEFAULT '0.00000',
680 `pt3ScaZ` float(10,5) NOT NULL DEFAULT '0.00000',
681 `pt4ModelID` int(5) NOT NULL DEFAULT '0',
682 `pt4Bone` int(11) NOT NULL DEFAULT '0',
683 `pt4PosX` float(10,5) NOT NULL DEFAULT '0.00000',
684 `pt4PosY` float(10,5) NOT NULL DEFAULT '0.00000',
685 `pt4PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
686 `pt4RotX` float(10,5) NOT NULL DEFAULT '0.00000',
687 `pt4RotY` float(10,5) NOT NULL DEFAULT '0.00000',
688 `pt4RotZ` float(10,5) NOT NULL DEFAULT '0.00000',
689 `pt4ScaX` float(10,5) NOT NULL DEFAULT '0.00000',
690 `pt4ScaY` float(10,5) NOT NULL DEFAULT '0.00000',
691 `pt4ScaZ` float(10,5) NOT NULL DEFAULT '0.00000',
692 `pt5ModelID` int(5) NOT NULL DEFAULT '0',
693 `pt5Bone` int(11) NOT NULL DEFAULT '0',
694 `pt5PosX` float(10,5) NOT NULL DEFAULT '0.00000',
695 `pt5PosY` float(10,5) NOT NULL DEFAULT '0.00000',
696 `pt5PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
697 `pt5RotX` float(10,5) NOT NULL DEFAULT '0.00000',
698 `pt5RotY` float(10,5) NOT NULL DEFAULT '0.00000',
699 `pt5RotZ` float(10,5) NOT NULL DEFAULT '0.00000',
700 `pt5ScaX` float(10,5) NOT NULL DEFAULT '0.00000',
701 `pt5ScaY` float(10,5) NOT NULL DEFAULT '0.00000',
702 `pt5ScaZ` float(10,5) NOT NULL DEFAULT '0.00000',
703 `pt6ModelID` int(5) NOT NULL DEFAULT '0',
704 `pt6Bone` int(11) NOT NULL DEFAULT '0',
705 `pt6PosX` float(10,5) NOT NULL DEFAULT '0.00000',
706 `pt6PosY` float(10,5) NOT NULL DEFAULT '0.00000',
707 `pt6PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
708 `pt6RotX` float(10,5) NOT NULL DEFAULT '0.00000',
709 `pt6RotY` float(10,5) NOT NULL DEFAULT '0.00000',
710 `pt6RotZ` float(10,5) NOT NULL DEFAULT '0.00000',
711 `pt6ScaX` float(10,5) NOT NULL DEFAULT '0.00000',
712 `pt6ScaY` float(10,5) NOT NULL DEFAULT '0.00000',
713 `pt6ScaZ` float(10,5) NOT NULL DEFAULT '0.00000',
714 `pt7ModelID` int(5) NOT NULL DEFAULT '0',
715 `pt7Bone` int(11) NOT NULL DEFAULT '0',
716 `pt7PosX` float(10,5) NOT NULL DEFAULT '0.00000',
717 `pt7PosY` float(10,5) NOT NULL DEFAULT '0.00000',
718 `pt7PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
719 `pt7RotX` float(10,5) NOT NULL DEFAULT '0.00000',
720 `pt7RotY` float(10,5) NOT NULL DEFAULT '0.00000',
721 `pt7RotZ` float(10,5) NOT NULL DEFAULT '0.00000',
722 `pt7ScaX` float(10,5) NOT NULL DEFAULT '0.00000',
723 `pt7ScaY` float(10,5) NOT NULL DEFAULT '0.00000',
724 `pt7ScaZ` float(10,5) NOT NULL DEFAULT '0.00000',
725 `pt8ModelID` int(5) NOT NULL DEFAULT '0',
726 `pt8Bone` int(11) NOT NULL DEFAULT '0',
727 `pt8PosX` float(10,5) NOT NULL DEFAULT '0.00000',
728 `pt8PosY` float(10,5) NOT NULL DEFAULT '0.00000',
729 `pt8PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
730 `pt8RotX` float(10,5) NOT NULL DEFAULT '0.00000',
731 `pt8RotY` float(10,5) NOT NULL DEFAULT '0.00000',
732 `pt8RotZ` float(10,5) NOT NULL DEFAULT '0.00000',
733 `pt8ScaX` float(10,5) NOT NULL DEFAULT '0.00000',
734 `pt8ScaY` float(10,5) NOT NULL DEFAULT '0.00000',
735 `pt8ScaZ` float(10,5) NOT NULL DEFAULT '0.00000',
736 `pt9ModelID` int(5) NOT NULL DEFAULT '0',
737 `pt9Bone` int(11) NOT NULL DEFAULT '0',
738 `pt9PosX` float(10,5) NOT NULL DEFAULT '0.00000',
739 `pt9PosY` float(10,5) NOT NULL DEFAULT '0.00000',
740 `pt9PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
741 `pt9RotX` float(10,5) NOT NULL DEFAULT '0.00000',
742 `pt9RotY` float(10,5) NOT NULL DEFAULT '0.00000',
743 `pt9RotZ` float(10,5) NOT NULL DEFAULT '0.00000',
744 `pt9ScaX` float(10,5) NOT NULL DEFAULT '0.00000',
745 `pt9ScaY` float(10,5) NOT NULL DEFAULT '0.00000',
746 `pt9ScaZ` float(10,5) unsigned zerofill NOT NULL DEFAULT '0000.00000',
747 `DrawChance` int(11) NOT NULL DEFAULT '0',
748 `GoldBoxTokens` int(11) NOT NULL DEFAULT '0',
749 `RewardHours` float(10,5) NOT NULL DEFAULT '0.00000',
750 `DMRMuted` int(11) unsigned NOT NULL DEFAULT '0',
751 `Watchdog` int(11) unsigned NOT NULL DEFAULT '0',
752 `CarsRestricted` tinyint(2) NOT NULL DEFAULT '0',
753 `Flagged` tinyint(2) NOT NULL DEFAULT '0',
754 `LepPoints` int(11) unsigned NOT NULL DEFAULT '0',
755 `LepSafePoints` int(11) NOT NULL DEFAULT '0',
756 `LastCarWarning` int(11) NOT NULL DEFAULT '0',
757 `CarWarns` int(11) NOT NULL DEFAULT '0',
758 `pv0Restricted` int(11) NOT NULL DEFAULT '0',
759 `pv1Restricted` int(11) NOT NULL DEFAULT '0',
760 `pv2Restricted` int(11) NOT NULL DEFAULT '0',
761 `pv3Restricted` int(11) NOT NULL DEFAULT '0',
762 `pv4Restricted` int(11) NOT NULL DEFAULT '0',
763 `pv5Restricted` int(11) NOT NULL DEFAULT '0',
764 `pv6Restricted` int(11) NOT NULL DEFAULT '0',
765 `pv7Restricted` int(11) NOT NULL DEFAULT '0',
766 `pv8Restricted` int(11) NOT NULL DEFAULT '0',
767 `pv9restricted` int(11) NOT NULL DEFAULT '0',
768 `Scripter` int(11) NOT NULL DEFAULT '0',
769 `PR` int(11) NOT NULL DEFAULT '0',
770 `Hours` int(11) NOT NULL DEFAULT '0',
771 `Paper` int(11) NOT NULL DEFAULT '0',
772 `MailEnabled` int(11) NOT NULL DEFAULT '1',
773 `Mailbox` int(11) NOT NULL DEFAULT '0',
774 `UnreadMails` int(11) NOT NULL DEFAULT '0',
775 `TreasureSkill` int(5) NOT NULL DEFAULT '0',
776 `MetalDetector` int(5) NOT NULL DEFAULT '0',
777 `HelpedBefore` int(11) NOT NULL DEFAULT '0',
778 `Business` int(11) NOT NULL DEFAULT '-1',
779 `BusinessRank` int(11) NOT NULL DEFAULT '-1',
780 `Trickortreat` int(11) NOT NULL DEFAULT '0',
781 `RHMutes` int(1) NOT NULL DEFAULT '0',
782 `RHMuteTime` int(11) NOT NULL DEFAULT '0',
783 `GiftCode` int(11) NOT NULL DEFAULT '0',
784 `Table` int(11) NOT NULL DEFAULT '0',
785 `OpiumSeeds` int(11) NOT NULL DEFAULT '0',
786 `RawOpium` int(11) NOT NULL DEFAULT '0',
787 `Heroin` int(11) NOT NULL DEFAULT '0',
788 `Syringe` int(11) NOT NULL DEFAULT '0',
789 `Skins` int(2) NOT NULL DEFAULT '0',
790 `Hunger` int(11) NOT NULL DEFAULT '50',
791 `HungerTimer` int(11) NOT NULL DEFAULT '0',
792 `HungerDeathTimer` int(11) NOT NULL DEFAULT '0',
793 `Fitness` int(11) NOT NULL DEFAULT '0',
794 `Credits` int(11) NOT NULL DEFAULT '0',
795 `LastCharmReceived` int(11) NOT NULL DEFAULT '0',
796 `HealthCare` int(11) NOT NULL DEFAULT '0',
797 `TotalCredits` int(11) NOT NULL DEFAULT '0',
798 `911Muted` int(11) NOT NULL DEFAULT '0',
799 `ForcePasswordChange` int(11) NOT NULL DEFAULT '0',
800 `ReceivedCredits` int(11) NOT NULL DEFAULT '0',
801 `Pin` varchar(256) NOT NULL DEFAULT '',
802 `RimMod` int(11) NOT NULL DEFAULT '0',
803 `Tazer` int(11) NOT NULL DEFAULT '0',
804 `Cuff` int(11) NOT NULL DEFAULT '0',
805 `CarVoucher` int(11) NOT NULL DEFAULT '0',
806 `ReferredBy` varchar(32) NOT NULL DEFAULT 'Nobody',
807 `PendingRefReward` int(11) NOT NULL DEFAULT '0',
808 `Refers` int(11) NOT NULL DEFAULT '0',
809 `Developer` int(11) NOT NULL DEFAULT '0',
810 `Famed` int(11) NOT NULL DEFAULT '0',
811 `FamedMuted` int(11) NOT NULL DEFAULT '0',
812 `DefendTime` int(11) NOT NULL DEFAULT '0',
813 `VehicleSlot` int(11) NOT NULL DEFAULT '0',
814 `PVIPVoucher` int(11) NOT NULL DEFAULT '0',
815 `ToySlot` int(11) NOT NULL,
816 `RFLTeam` int(11) NOT NULL,
817 `RFLTeamL` int(11) NOT NULL,
818 `VehVoucher` int(11) NOT NULL,
819 `SVIPVoucher` int(11) NOT NULL,
820 `GVIPVoucher` int(11) NOT NULL,
821 `GiftVoucher` int(11) NOT NULL,
822 `ContactSlot` int(11) NOT NULL DEFAULT '0',
823 `FallIntoFun` int(11) NOT NULL,
824 `AP` int(11) NOT NULL,
825 `Security` int(11) NOT NULL,
826 `HungerVoucher` int(11) NOT NULL,
827 `BoughtCure` int(11) NOT NULL,
828 `Vials` int(11) NOT NULL,
829 `ShopTut` int(11) NOT NULL,
830 `ShopCounter` int(11) NOT NULL,
831 `ShopNotice` int(11) NOT NULL,
832 `AdvertVoucher` int(11) NOT NULL DEFAULT '0',
833 `SVIPExVoucher` int(11) NOT NULL DEFAULT '0',
834 `GVIPExVoucher` int(11) NOT NULL DEFAULT '0',
835 `VIPSellable` int(11) NOT NULL DEFAULT '0',
836 `ReceivedPrize` int(11) NOT NULL DEFAULT '0',
837 `Job3` int(11) NOT NULL DEFAULT '0',
838 `Apartment3` int(11) NOT NULL DEFAULT '0',
839 `VIPSpawn` int(11) NOT NULL DEFAULT '0',
840 `FreeAdsDay` int(11) NOT NULL DEFAULT '0',
841 `FreeAdsLeft` int(11) NOT NULL DEFAULT '0',
842 `BuddyInvites` int(11) NOT NULL DEFAULT '0',
843 `ReceivedBGift` int(11) NOT NULL DEFAULT '0',
844 `pVIPJob` int(11) NOT NULL DEFAULT '0',
845 `LastBirthday` int(11) NOT NULL DEFAULT '0',
846 `AvatarLink` varchar(255) NOT NULL DEFAULT './img/avatar-mini.png',
847 `AccountRestricted` int(11) NOT NULL DEFAULT '0',
848 `Watchlist` int(11) NOT NULL DEFAULT '0',
849 `WatchlistTime` int(11) NOT NULL DEFAULT '0',
850 `Backpack` int(11) NOT NULL DEFAULT '0',
851 `BEquipped` int(11) NOT NULL DEFAULT '0',
852 `BStoredH` int(11) NOT NULL DEFAULT '-1',
853 `BStoredV` int(11) NOT NULL DEFAULT '0',
854 `BItem0` int(11) NOT NULL DEFAULT '0',
855 `BItem1` int(11) NOT NULL DEFAULT '0',
856 `BItem2` int(11) NOT NULL DEFAULT '0',
857 `BItem3` int(11) NOT NULL DEFAULT '0',
858 `BItem4` int(11) NOT NULL DEFAULT '0',
859 `BItem5` int(11) NOT NULL DEFAULT '0',
860 `BItem6` int(11) NOT NULL DEFAULT '0',
861 `BItem7` int(11) NOT NULL DEFAULT '0',
862 `BItem8` int(11) NOT NULL DEFAULT '0',
863 `BItem9` int(11) NOT NULL DEFAULT '0',
864 `BItem10` int(11) NOT NULL DEFAULT '0',
865 `BetaTester` int(11) NOT NULL,
866 `BRTimeout` int(11) NOT NULL,
867 `NewbieTogged` int(11) NOT NULL,
868 `VIPTogged` int(11) NOT NULL,
869 `FamedTogged` int(11) NOT NULL,
870 `pDigCooldown` int(11) NOT NULL DEFAULT '0',
871 `ToolBox` int(11) NOT NULL DEFAULT '0',
872 `CrowBar` int(11) NOT NULL DEFAULT '0',
873 `CarLockPickSkill` int(11) NOT NULL DEFAULT '0',
874 `LockPickVehCount` int(11) NOT NULL DEFAULT '0',
875 `LockPickTime` int(11) NOT NULL DEFAULT '0',
876 `SEC` int(11) NOT NULL DEFAULT '0',
877 `BM` int(11) NOT NULL DEFAULT '0',
878 `Isolated` int(11) NOT NULL DEFAULT '0',
879 `WantedJailTime` int(11) NOT NULL DEFAULT '0',
880 `WantedJailFine` int(11) NOT NULL DEFAULT '0',
881 `NextNameChange` int(11) NOT NULL DEFAULT '0',
882 `mInventory` varchar(255) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0',
883 `mPurchaseCounts` varchar(255) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0',
884 `mCooldowns` varchar(255) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0',
885 `mBoost` varchar(255) NOT NULL DEFAULT '0|0',
886 `mShopNotice` varchar(255) NOT NULL DEFAULT '0|0',
887 `BItem11` int(11) NOT NULL DEFAULT '0',
888 `pExamineDesc` varchar(255) NOT NULL,
889 `Badge` varchar(8) NOT NULL DEFAULT 'None',
890 `FavStation` varchar(255) NOT NULL,
891 `pDedicatedPlayer` int(11) NOT NULL DEFAULT '0',
892 `pDedicatedEnabled` int(11) NOT NULL DEFAULT '0',
893 `pDedicatedMuted` int(11) NOT NULL DEFAULT '0',
894 `pDedicatedWarn` int(11) NOT NULL DEFAULT '0',
895 `pOED` int(11) NOT NULL DEFAULT '0',
896 `zFuelCan` int(11) NOT NULL DEFAULT '0',
897 `BackPackItems` varchar(255) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0',
898 `bTicket` int(11) NOT NULL DEFAULT '0',
899 `JailedInfo` varchar(255) NOT NULL DEFAULT '0|0|0|0|0',
900 `JailedWeapons` varchar(255) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0',
901 `pVIPMod` int(11) NOT NULL DEFAULT '0',
902 PRIMARY KEY (`id`,`Username`),
903 KEY `Username` (`Username`(5))
904) ENGINE=InnoDB DEFAULT CHARSET=utf8;
905
906-- --------------------------------------------------------
907
908--
909-- Table structure for table `anticheat`
910--
911
912CREATE TABLE IF NOT EXISTS `anticheat` (
913 `id` int(11) NOT NULL AUTO_INCREMENT,
914 `date` int(11) NOT NULL,
915 `microtime` int(11) NOT NULL,
916 `damagedid` int(11) NOT NULL,
917 `damagedlastupdate` int(11) NOT NULL,
918 `damagedping` int(11) NOT NULL,
919 `giverid` int(11) NOT NULL,
920 `giverping` int(11) NOT NULL,
921 `amount` float(10,5) NOT NULL,
922 `weaponid` tinyint(3) NOT NULL,
923 `damagedX` float(10,5) NOT NULL,
924 `damagedY` float(10,5) NOT NULL,
925 `damagedZ` float(10,5) NOT NULL,
926 `giverX` float(10,5) NOT NULL,
927 `giverY` float(10,5) NOT NULL,
928 `giverZ` float(10,5) NOT NULL,
929 `giverCX` float(10,5) NOT NULL,
930 `giverCY` float(10,5) NOT NULL,
931 `giverCZ` float(10,5) NOT NULL,
932 PRIMARY KEY (`id`)
933) ENGINE=InnoDB DEFAULT CHARSET=utf8;
934
935-- --------------------------------------------------------
936
937--
938-- Table structure for table `app_admins`
939--
940
941CREATE TABLE IF NOT EXISTS `app_admins` (
942 `id` int(254) NOT NULL AUTO_INCREMENT,
943 `adminName` varchar(254) DEFAULT NULL,
944 `status` int(10) DEFAULT '1',
945 `lastMsg` varchar(254) DEFAULT NULL,
946 PRIMARY KEY (`id`)
947) ENGINE=InnoDB DEFAULT CHARSET=utf8;
948
949-- --------------------------------------------------------
950
951--
952-- Table structure for table `app_todo`
953--
954
955CREATE TABLE IF NOT EXISTS `app_todo` (
956 `id` int(254) NOT NULL AUTO_INCREMENT,
957 `adminName` varchar(254) DEFAULT NULL,
958 `todo` varchar(999) DEFAULT NULL,
959 PRIMARY KEY (`id`)
960) ENGINE=InnoDB DEFAULT CHARSET=utf8;
961
962-- --------------------------------------------------------
963
964--
965-- Table structure for table `arenas`
966--
967
968CREATE TABLE IF NOT EXISTS `arenas` (
969 `id` int(11) NOT NULL AUTO_INCREMENT,
970 `name` varchar(64) NOT NULL DEFAULT 'Name',
971 `vw` int(11) NOT NULL DEFAULT '0',
972 `interior` int(11) NOT NULL DEFAULT '0',
973 `dm1` varchar(128) NOT NULL DEFAULT '0.0|0.0|0.0|0.0',
974 `dm2` varchar(128) NOT NULL DEFAULT '0.0|0.0|0.0|0.0',
975 `dm3` varchar(128) NOT NULL DEFAULT '0.0|0.0|0.0|0.0',
976 `dm4` varchar(128) NOT NULL DEFAULT '0.0|0.0|0.0|0.0',
977 `red1` varchar(128) NOT NULL DEFAULT '0.0|0.0|0.0|0.0',
978 `red2` varchar(128) NOT NULL DEFAULT '0.0|0.0|0.0|0.0',
979 `red3` varchar(128) NOT NULL DEFAULT '0.0|0.0|0.0|0.0',
980 `blue1` varchar(128) NOT NULL DEFAULT '0.0|0.0|0.0|0.0',
981 `blue2` varchar(128) NOT NULL DEFAULT '0.0|0.0|0.0|0.0',
982 `blue3` varchar(128) NOT NULL DEFAULT '0.0|0.0|0.0|0.0',
983 `flagred` varchar(128) NOT NULL DEFAULT '0.0|0.0|0.0',
984 `flagblue` varchar(128) NOT NULL DEFAULT '0.0|0.0|0.0',
985 `hill` varchar(128) NOT NULL DEFAULT '0.0|0.0|0.0',
986 `hillr` float(11,4) NOT NULL DEFAULT '0.0000',
987 `veh1` varchar(128) NOT NULL DEFAULT '0|0.0|0.0|0.0|0.0',
988 `veh2` varchar(128) NOT NULL DEFAULT '0|0.0|0.0|0.0|0.0',
989 `veh3` varchar(128) NOT NULL DEFAULT '0|0.0|0.0|0.0|0.0',
990 `veh4` varchar(128) NOT NULL DEFAULT '0|0.0|0.0|0.0|0.0',
991 `veh5` varchar(128) NOT NULL DEFAULT '0|0.0|0.0|0.0|0.0',
992 `veh6` varchar(128) NOT NULL DEFAULT '0|0.0|0.0|0.0|0.0',
993 PRIMARY KEY (`id`)
994) ENGINE=InnoDB DEFAULT CHARSET=latin1;
995
996-- --------------------------------------------------------
997
998--
999-- Table structure for table `arrestpoints`
1000--
1001
1002CREATE TABLE IF NOT EXISTS `arrestpoints` (
1003 `id` int(2) NOT NULL AUTO_INCREMENT,
1004 `PosX` float(10,5) NOT NULL DEFAULT '0.00000',
1005 `PosY` float(10,5) NOT NULL DEFAULT '0.00000',
1006 `PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
1007 `VW` int(5) NOT NULL DEFAULT '0',
1008 `Int` int(5) NOT NULL DEFAULT '0',
1009 `Type` int(1) NOT NULL DEFAULT '0',
1010 `jailVW` int(5) NOT NULL DEFAULT '0',
1011 `jailInt` int(5) NOT NULL DEFAULT '0',
1012 `jailpos1x` float(10,5) NOT NULL DEFAULT '0.00000',
1013 `jailpos1y` float(10,5) NOT NULL DEFAULT '0.00000',
1014 `jailpos1z` float(10,5) NOT NULL DEFAULT '0.00000',
1015 `jailpos2x` float(10,5) NOT NULL DEFAULT '0.00000',
1016 `jailpos2y` float(10,5) NOT NULL DEFAULT '0.00000',
1017 `jailpos2z` float(10,5) NOT NULL DEFAULT '0.00000',
1018 PRIMARY KEY (`id`)
1019) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1020
1021-- --------------------------------------------------------
1022
1023--
1024-- Table structure for table `arrestreports`
1025--
1026
1027CREATE TABLE IF NOT EXISTS `arrestreports` (
1028 `id` int(12) NOT NULL AUTO_INCREMENT,
1029 `copid` int(12) NOT NULL DEFAULT '0',
1030 `suspectid` int(12) NOT NULL DEFAULT '0',
1031 `shortreport` varchar(512) NOT NULL DEFAULT '',
1032 `longreport` varchar(2024) NOT NULL DEFAULT '',
1033 `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1034 PRIMARY KEY (`id`)
1035) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1036
1037-- --------------------------------------------------------
1038
1039--
1040-- Table structure for table `auctions`
1041--
1042
1043CREATE TABLE IF NOT EXISTS `auctions` (
1044 `id` int(11) NOT NULL,
1045 `BiddingFor` varchar(64) NOT NULL DEFAULT '(none)',
1046 `InProgress` int(11) NOT NULL DEFAULT '0',
1047 `Bid` int(11) NOT NULL DEFAULT '0',
1048 `Bidder` int(11) NOT NULL DEFAULT '0',
1049 `Expires` int(11) NOT NULL DEFAULT '0',
1050 `Wining` varchar(24) NOT NULL DEFAULT '(none)',
1051 `Increment` int(11) NOT NULL DEFAULT '0',
1052 PRIMARY KEY (`id`)
1053) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1054
1055-- --------------------------------------------------------
1056
1057--
1058-- Table structure for table `bans`
1059--
1060
1061CREATE TABLE IF NOT EXISTS `bans` (
1062 `id` int(11) NOT NULL AUTO_INCREMENT,
1063 `user_id` int(11) NOT NULL,
1064 `ip_address` varchar(32) DEFAULT NULL,
1065 `reason` varchar(156) DEFAULT NULL,
1066 `date_added` datetime DEFAULT NULL,
1067 `date_unban` datetime DEFAULT NULL,
1068 `status` int(1) DEFAULT NULL,
1069 `link` varchar(156) DEFAULT NULL,
1070 `admin` varchar(156) DEFAULT NULL,
1071 PRIMARY KEY (`id`)
1072) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1073
1074-- --------------------------------------------------------
1075
1076--
1077-- Table structure for table `bugcomments`
1078--
1079
1080CREATE TABLE IF NOT EXISTS `bugcomments` (
1081 `id` int(11) NOT NULL AUTO_INCREMENT,
1082 `bugid` int(11) NOT NULL,
1083 `user` varchar(255) NOT NULL,
1084 `comment` text NOT NULL,
1085 `ip` varchar(255) NOT NULL,
1086 `time` int(255) NOT NULL,
1087 PRIMARY KEY (`id`)
1088) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1089
1090-- --------------------------------------------------------
1091
1092--
1093-- Table structure for table `bugcommentss`
1094--
1095
1096CREATE TABLE IF NOT EXISTS `bugcommentss` (
1097 `id` int(11) DEFAULT '0',
1098 `CommentBy` varchar(32) DEFAULT NULL,
1099 `CommentTime` datetime DEFAULT NULL,
1100 `Comment` varchar(128) DEFAULT NULL
1101) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1102
1103-- --------------------------------------------------------
1104
1105--
1106-- Table structure for table `bugs`
1107--
1108
1109CREATE TABLE IF NOT EXISTS `bugs` (
1110 `id` int(11) NOT NULL AUTO_INCREMENT,
1111 `ReportedBy` varchar(255) DEFAULT NULL,
1112 `Time` int(255) DEFAULT NULL,
1113 `Bug` varchar(46) DEFAULT NULL,
1114 `AssignedTo` varchar(255) NOT NULL DEFAULT 'Nobody',
1115 `Status` int(11) DEFAULT '0',
1116 `Description` text,
1117 `Deleted` int(1) NOT NULL DEFAULT '0',
1118 `Anonymous` int(1) NOT NULL DEFAULT '0',
1119 `Tech` int(11) NOT NULL,
1120 PRIMARY KEY (`id`)
1121) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1122
1123-- --------------------------------------------------------
1124
1125--
1126-- Table structure for table `bugss`
1127--
1128
1129CREATE TABLE IF NOT EXISTS `bugss` (
1130 `id` int(11) NOT NULL AUTO_INCREMENT,
1131 `ReportedBy` varchar(32) DEFAULT '',
1132 `Date` date DEFAULT NULL,
1133 `Time` time DEFAULT NULL,
1134 `Bug` varchar(20) DEFAULT NULL,
1135 `AssignedTo` varchar(32) NOT NULL DEFAULT 'Nobody',
1136 `Status` int(11) DEFAULT '0',
1137 `Description` varchar(128) DEFAULT NULL,
1138 PRIMARY KEY (`id`)
1139) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1140
1141-- --------------------------------------------------------
1142
1143--
1144-- Table structure for table `bug_misc`
1145--
1146
1147CREATE TABLE IF NOT EXISTS `bug_misc` (
1148 `news` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'None'
1149) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1150
1151-- --------------------------------------------------------
1152
1153--
1154-- Table structure for table `businesses`
1155--
1156
1157CREATE TABLE IF NOT EXISTS `businesses` (
1158 `Id` int(11) NOT NULL AUTO_INCREMENT,
1159 `Name` varchar(40) NOT NULL DEFAULT 'Unnamed Business',
1160 `Type` int(11) NOT NULL DEFAULT '0',
1161 `Value` int(11) NOT NULL DEFAULT '0',
1162 `OwnerID` int(11) NOT NULL DEFAULT '0',
1163 `OwnerName` varchar(40) NOT NULL DEFAULT 'None',
1164 `Months` int(11) NOT NULL DEFAULT '0',
1165 `SafeBalance` int(11) NOT NULL DEFAULT '0',
1166 `Inventory` int(11) NOT NULL DEFAULT '0',
1167 `InventoryCapacity` int(11) NOT NULL DEFAULT '1000',
1168 `Status` int(11) NOT NULL DEFAULT '1',
1169 `Level` tinyint(4) NOT NULL DEFAULT '1',
1170 `LevelProgress` int(11) NOT NULL DEFAULT '0',
1171 `AutoSale` tinyint(4) NOT NULL DEFAULT '1',
1172 `OrderDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1173 `OrderAmount` int(11) NOT NULL DEFAULT '0',
1174 `OrderBy` varchar(24) NOT NULL DEFAULT '',
1175 `OrderState` int(11) NOT NULL DEFAULT '0',
1176 `TotalSales` int(11) NOT NULL DEFAULT '0',
1177 `Bargain` tinyint(4) NOT NULL DEFAULT '0',
1178 `ExteriorX` float NOT NULL DEFAULT '0',
1179 `ExteriorY` float NOT NULL DEFAULT '0',
1180 `ExteriorZ` float NOT NULL DEFAULT '0',
1181 `ExteriorA` float NOT NULL DEFAULT '0',
1182 `InteriorX` float NOT NULL DEFAULT '0',
1183 `InteriorY` float NOT NULL DEFAULT '0',
1184 `InteriorZ` float NOT NULL DEFAULT '0',
1185 `InteriorA` float NOT NULL DEFAULT '0',
1186 `Interior` tinyint(4) NOT NULL DEFAULT '0',
1187 `CustomExterior` int(11) NOT NULL DEFAULT '0',
1188 `CustomInterior` int(11) NOT NULL DEFAULT '0',
1189 `SupplyPointX` float NOT NULL DEFAULT '0',
1190 `SupplyPointY` float NOT NULL DEFAULT '0',
1191 `SupplyPointZ` float NOT NULL DEFAULT '0',
1192 `Item1Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1193 `Item2Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1194 `Item3Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1195 `Item4Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1196 `Item5Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1197 `Item6Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1198 `Item7Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1199 `Item8Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1200 `Item9Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1201 `Item10Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1202 `Item11Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1203 `Item12Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1204 `Item13Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1205 `Item14Price` mediumint(8) unsigned NOT NULL DEFAULT '0',
1206 `Item15Price` mediumint(8) NOT NULL DEFAULT '0',
1207 `Item16Price` mediumint(8) NOT NULL DEFAULT '0',
1208 `Item17Price` mediumint(8) NOT NULL DEFAULT '0',
1209 `Item18Price` mediumint(8) NOT NULL DEFAULT '0',
1210 `Item19Price` mediumint(8) NOT NULL DEFAULT '0',
1211 `Rank0Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
1212 `Rank1Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
1213 `Rank2Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
1214 `Rank3Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
1215 `Rank4Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
1216 `Rank5Pay` mediumint(8) NOT NULL,
1217 `Pay` tinyint(4) NOT NULL DEFAULT '0',
1218 `GasPrice` float unsigned NOT NULL DEFAULT '0',
1219 `MinInviteRank` tinyint(4) NOT NULL DEFAULT '4',
1220 `MinSupplyRank` tinyint(4) NOT NULL DEFAULT '5',
1221 `MinGiveRankRank` tinyint(4) NOT NULL DEFAULT '5',
1222 `MinSafeRank` tinyint(4) NOT NULL DEFAULT '5',
1223 `GasPump1PosX` float NOT NULL DEFAULT '0',
1224 `GasPump1PosY` float NOT NULL DEFAULT '0',
1225 `GasPump1PosZ` float NOT NULL DEFAULT '0',
1226 `GasPump1Angle` float NOT NULL DEFAULT '0',
1227 `GasPump1Model` float NOT NULL DEFAULT '0',
1228 `GasPump1Capacity` float NOT NULL DEFAULT '0',
1229 `GasPump1Gas` float NOT NULL DEFAULT '0',
1230 `GasPump2PosX` float NOT NULL DEFAULT '0',
1231 `GasPump2PosY` float NOT NULL DEFAULT '0',
1232 `GasPump2PosZ` float NOT NULL DEFAULT '0',
1233 `GasPump2Angle` float NOT NULL DEFAULT '0',
1234 `GasPump2Model` float NOT NULL DEFAULT '0',
1235 `GasPump2Capacity` float NOT NULL DEFAULT '0',
1236 `GasPump2Gas` float NOT NULL DEFAULT '0',
1237 `Car1PosX` float NOT NULL DEFAULT '0',
1238 `Car1PosY` float NOT NULL DEFAULT '0',
1239 `Car1PosZ` float NOT NULL DEFAULT '0',
1240 `Car1PosAngle` float NOT NULL DEFAULT '0',
1241 `Car1ModelId` int(11) NOT NULL DEFAULT '0',
1242 `Car1Lock` int(11) NOT NULL DEFAULT '0',
1243 `Car1Locked` int(11) NOT NULL DEFAULT '0',
1244 `Car1PaintJob` int(11) NOT NULL DEFAULT '-1',
1245 `Car1Color1` int(11) NOT NULL DEFAULT '0',
1246 `Car1Color2` int(11) NOT NULL DEFAULT '0',
1247 `Car1Price` int(11) NOT NULL DEFAULT '0',
1248 `Car1Ticket` int(11) NOT NULL DEFAULT '0',
1249 `Car1Weapon0` int(11) NOT NULL DEFAULT '0',
1250 `Car1Weapon1` int(11) NOT NULL DEFAULT '0',
1251 `Car1Weapon2` int(11) NOT NULL DEFAULT '0',
1252 `Car1WepUpgrade` int(11) NOT NULL DEFAULT '0',
1253 `Car1Fuel` float NOT NULL DEFAULT '100',
1254 `Car1Mod0` int(11) NOT NULL DEFAULT '0',
1255 `Car1Mod1` int(11) NOT NULL DEFAULT '0',
1256 `Car1Mod2` int(11) NOT NULL DEFAULT '0',
1257 `Car1Mod3` int(11) NOT NULL DEFAULT '0',
1258 `Car1Mod4` int(11) NOT NULL DEFAULT '0',
1259 `Car1Mod5` int(11) NOT NULL DEFAULT '0',
1260 `Car1Mod6` int(11) NOT NULL DEFAULT '0',
1261 `Car1Mod7` int(11) NOT NULL DEFAULT '0',
1262 `Car1Mod8` int(11) NOT NULL DEFAULT '0',
1263 `Car1Mod9` int(11) NOT NULL DEFAULT '0',
1264 `Car1Mod10` int(11) NOT NULL DEFAULT '0',
1265 `Car1Mod11` int(11) NOT NULL DEFAULT '0',
1266 `Car1Mod12` int(11) NOT NULL DEFAULT '0',
1267 `Car1Mod13` int(11) NOT NULL DEFAULT '0',
1268 `Car1Mod14` int(11) NOT NULL DEFAULT '0',
1269 `Car2PosX` float NOT NULL DEFAULT '0',
1270 `Car2PosY` float NOT NULL DEFAULT '0',
1271 `Car2PosZ` float NOT NULL DEFAULT '0',
1272 `Car2PosAngle` float NOT NULL DEFAULT '0',
1273 `Car2ModelId` int(11) NOT NULL DEFAULT '0',
1274 `Car2Lock` int(11) NOT NULL DEFAULT '0',
1275 `Car2Locked` int(11) NOT NULL DEFAULT '0',
1276 `Car2PaintJob` int(11) NOT NULL DEFAULT '-1',
1277 `Car2Color1` int(11) NOT NULL DEFAULT '0',
1278 `Car2Color2` int(11) NOT NULL DEFAULT '0',
1279 `Car2Price` int(11) NOT NULL DEFAULT '0',
1280 `Car2Ticket` int(11) NOT NULL DEFAULT '0',
1281 `Car2Weapon0` int(11) NOT NULL DEFAULT '0',
1282 `Car2Weapon1` int(11) NOT NULL DEFAULT '0',
1283 `Car2Weapon2` int(11) NOT NULL DEFAULT '0',
1284 `Car2WepUpgrade` int(11) NOT NULL DEFAULT '0',
1285 `Car2Fuel` float NOT NULL DEFAULT '100',
1286 `Car2Mod0` int(11) NOT NULL DEFAULT '0',
1287 `Car2Mod1` int(11) NOT NULL DEFAULT '0',
1288 `Car2Mod2` int(11) NOT NULL DEFAULT '0',
1289 `Car2Mod3` int(11) NOT NULL DEFAULT '0',
1290 `Car2Mod4` int(11) NOT NULL DEFAULT '0',
1291 `Car2Mod5` int(11) NOT NULL DEFAULT '0',
1292 `Car2Mod6` int(11) NOT NULL DEFAULT '0',
1293 `Car2Mod7` int(11) NOT NULL DEFAULT '0',
1294 `Car2Mod8` int(11) NOT NULL DEFAULT '0',
1295 `Car2Mod9` int(11) NOT NULL DEFAULT '0',
1296 `Car2Mod10` int(11) NOT NULL DEFAULT '0',
1297 `Car2Mod11` int(11) NOT NULL DEFAULT '0',
1298 `Car2Mod12` int(11) NOT NULL DEFAULT '0',
1299 `Car2Mod13` int(11) NOT NULL DEFAULT '0',
1300 `Car2Mod14` int(11) NOT NULL DEFAULT '0',
1301 `Car3PosX` float NOT NULL DEFAULT '0',
1302 `Car3PosY` float NOT NULL DEFAULT '0',
1303 `Car3PosZ` float NOT NULL DEFAULT '0',
1304 `Car3PosAngle` float NOT NULL DEFAULT '0',
1305 `Car3ModelId` int(11) NOT NULL DEFAULT '0',
1306 `Car3Lock` int(11) NOT NULL DEFAULT '0',
1307 `Car3Locked` int(11) NOT NULL DEFAULT '0',
1308 `Car3PaintJob` int(11) NOT NULL DEFAULT '-1',
1309 `Car3Color1` int(11) NOT NULL DEFAULT '0',
1310 `Car3Color2` int(11) NOT NULL DEFAULT '0',
1311 `Car3Price` int(11) NOT NULL DEFAULT '0',
1312 `Car3Ticket` int(11) NOT NULL DEFAULT '0',
1313 `Car3Weapon0` int(11) NOT NULL DEFAULT '0',
1314 `Car3Weapon1` int(11) NOT NULL DEFAULT '0',
1315 `Car3Weapon2` int(11) NOT NULL DEFAULT '0',
1316 `Car3WepUpgrade` int(11) NOT NULL DEFAULT '0',
1317 `Car3Fuel` float NOT NULL DEFAULT '100',
1318 `Car3Mod0` int(11) NOT NULL DEFAULT '0',
1319 `Car3Mod1` int(11) NOT NULL DEFAULT '0',
1320 `Car3Mod2` int(11) NOT NULL DEFAULT '0',
1321 `Car3Mod3` int(11) NOT NULL DEFAULT '0',
1322 `Car3Mod4` int(11) NOT NULL DEFAULT '0',
1323 `Car3Mod5` int(11) NOT NULL DEFAULT '0',
1324 `Car3Mod6` int(11) NOT NULL DEFAULT '0',
1325 `Car3Mod7` int(11) NOT NULL DEFAULT '0',
1326 `Car3Mod8` int(11) NOT NULL DEFAULT '0',
1327 `Car3Mod9` int(11) NOT NULL DEFAULT '0',
1328 `Car3Mod10` int(11) NOT NULL DEFAULT '0',
1329 `Car3Mod11` int(11) NOT NULL DEFAULT '0',
1330 `Car3Mod12` int(11) NOT NULL DEFAULT '0',
1331 `Car3Mod13` int(11) NOT NULL DEFAULT '0',
1332 `Car3Mod14` int(11) NOT NULL DEFAULT '0',
1333 `Car1Stock` int(11) NOT NULL DEFAULT '0',
1334 `Car2Stock` int(11) NOT NULL DEFAULT '0',
1335 `Car3Stock` int(11) NOT NULL DEFAULT '0',
1336 `Car1Order` int(11) NOT NULL DEFAULT '0',
1337 `Car2Order` int(11) NOT NULL DEFAULT '0',
1338 `Car3Order` int(11) NOT NULL DEFAULT '0',
1339 `Car0PosX` float NOT NULL DEFAULT '0',
1340 `Car0PosY` float NOT NULL DEFAULT '0',
1341 `Car0PosZ` float NOT NULL DEFAULT '0',
1342 `Car0PosAngle` float NOT NULL DEFAULT '0',
1343 `Car0ModelId` int(11) NOT NULL DEFAULT '0',
1344 `Car0Price` int(11) NOT NULL DEFAULT '0',
1345 `Car4PosX` float NOT NULL DEFAULT '0',
1346 `Car4PosY` float NOT NULL DEFAULT '0',
1347 `Car4PosZ` float NOT NULL DEFAULT '0',
1348 `Car4PosAngle` float NOT NULL DEFAULT '0',
1349 `Car4ModelId` int(11) NOT NULL DEFAULT '0',
1350 `Car4Price` int(11) NOT NULL DEFAULT '0',
1351 `Car5PosX` int(11) NOT NULL DEFAULT '0',
1352 `Car5PosY` float NOT NULL DEFAULT '0',
1353 `Car5PosZ` float NOT NULL DEFAULT '0',
1354 `Car5PosAngle` float NOT NULL DEFAULT '0',
1355 `Car5ModelId` int(11) NOT NULL DEFAULT '0',
1356 `Car5Price` int(11) NOT NULL DEFAULT '0',
1357 `Car6PosX` float NOT NULL DEFAULT '0',
1358 `Car6PosY` float NOT NULL DEFAULT '0',
1359 `Car6PosZ` float NOT NULL DEFAULT '0',
1360 `Car6PosAngle` float NOT NULL DEFAULT '0',
1361 `Car6ModelId` int(11) NOT NULL DEFAULT '0',
1362 `Car6Price` int(11) NOT NULL DEFAULT '0',
1363 `Car7PosX` float NOT NULL DEFAULT '0',
1364 `Car7PosY` float NOT NULL DEFAULT '0',
1365 `Car7PosZ` float NOT NULL DEFAULT '0',
1366 `Car7PosAngle` float NOT NULL DEFAULT '0',
1367 `Car7ModelId` int(11) NOT NULL DEFAULT '0',
1368 `Car7Price` int(11) NOT NULL DEFAULT '0',
1369 `Car8PosX` float NOT NULL DEFAULT '0',
1370 `Car8PosY` float NOT NULL DEFAULT '0',
1371 `Car8PosZ` float NOT NULL DEFAULT '0',
1372 `Car8PosAngle` float NOT NULL DEFAULT '0',
1373 `Car8ModelId` int(11) NOT NULL DEFAULT '0',
1374 `Car8Price` int(11) NOT NULL DEFAULT '0',
1375 `Car9PosX` float NOT NULL DEFAULT '0',
1376 `Car9PosY` float NOT NULL DEFAULT '0',
1377 `Car9PosZ` float NOT NULL DEFAULT '0',
1378 `Car9PosAngle` float NOT NULL DEFAULT '0',
1379 `Car9ModelId` int(11) NOT NULL DEFAULT '0',
1380 `Car9Price` int(11) NOT NULL DEFAULT '0',
1381 `PurchaseX` float NOT NULL DEFAULT '0',
1382 `PurchaseY` float NOT NULL DEFAULT '0',
1383 `PurchaseZ` float NOT NULL DEFAULT '0',
1384 `PurchaseAngle` float NOT NULL DEFAULT '0',
1385 `TotalProfits` int(11) NOT NULL DEFAULT '0',
1386 `GymEntryFee` int(11) NOT NULL DEFAULT '0',
1387 `GymType` int(11) NOT NULL DEFAULT '0',
1388 `CustomVW` int(11) NOT NULL DEFAULT '0',
1389 `Grade` int(11) NOT NULL DEFAULT '0',
1390 PRIMARY KEY (`Id`)
1391) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1392
1393-- --------------------------------------------------------
1394
1395--
1396-- Table structure for table `businesssales`
1397--
1398
1399CREATE TABLE IF NOT EXISTS `businesssales` (
1400 `bID` int(10) unsigned NOT NULL AUTO_INCREMENT,
1401 `BusinessID` int(11) unsigned NOT NULL DEFAULT '0',
1402 `Text` varchar(128) DEFAULT '0',
1403 `Price` int(11) DEFAULT '0',
1404 `Available` int(11) NOT NULL DEFAULT '0',
1405 `Purchased` int(11) DEFAULT '0',
1406 `Type` int(11) DEFAULT '0',
1407 PRIMARY KEY (`bID`)
1408) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1409
1410-- --------------------------------------------------------
1411
1412--
1413-- Table structure for table `columns_priv`
1414--
1415
1416CREATE TABLE IF NOT EXISTS `columns_priv` (
1417 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
1418 `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1419 `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
1420 `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1421 `Column_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
1422 `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1423 `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
1424 PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
1425) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges';
1426
1427-- --------------------------------------------------------
1428
1429--
1430-- Table structure for table `contacts`
1431--
1432
1433CREATE TABLE IF NOT EXISTS `contacts` (
1434 `id` int(11) NOT NULL AUTO_INCREMENT,
1435 `sqlID` int(11) NOT NULL,
1436 `name` varchar(24) CHARACTER SET utf8 NOT NULL,
1437 `number` int(20) NOT NULL,
1438 PRIMARY KEY (`id`)
1439) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1440
1441-- --------------------------------------------------------
1442
1443--
1444-- Table structure for table `cp_access`
1445--
1446
1447CREATE TABLE IF NOT EXISTS `cp_access` (
1448 `user_id` int(11) NOT NULL DEFAULT '0',
1449 `punish` tinyint(1) DEFAULT '0',
1450 `refund` tinyint(1) DEFAULT '0',
1451 `ban` tinyint(1) DEFAULT '0',
1452 `cplgeneral` tinyint(1) DEFAULT '0',
1453 `cplstaff` tinyint(1) DEFAULT NULL,
1454 `cplfaction` tinyint(1) DEFAULT NULL,
1455 `cplfamily` tinyint(1) DEFAULT NULL,
1456 `gladmin` tinyint(1) DEFAULT '0',
1457 `gladmingive` tinyint(1) DEFAULT NULL,
1458 `gladminpay` tinyint(1) DEFAULT NULL,
1459 `glban` tinyint(1) DEFAULT NULL,
1460 `glcontracts` tinyint(1) DEFAULT NULL,
1461 `glddedit` tinyint(1) DEFAULT NULL,
1462 `gldmpedit` tinyint(1) DEFAULT NULL,
1463 `glfaction` tinyint(1) DEFAULT NULL,
1464 `glfamily` tinyint(1) DEFAULT NULL,
1465 `glfmembercount` tinyint(1) DEFAULT NULL,
1466 `glgedit` tinyint(1) DEFAULT NULL,
1467 `glgifts` tinyint(1) DEFAULT NULL,
1468 `glhack` tinyint(1) DEFAULT NULL,
1469 `glhedit` tinyint(1) DEFAULT NULL,
1470 `glhouse` tinyint(1) DEFAULT NULL,
1471 `glkick` tinyint(1) DEFAULT NULL,
1472 `gllicenses` tinyint(1) DEFAULT NULL,
1473 `glmoderator` tinyint(1) DEFAULT NULL,
1474 `glmute` tinyint(1) DEFAULT NULL,
1475 `glpads` tinyint(1) DEFAULT NULL,
1476 `glpassword` tinyint(1) DEFAULT NULL,
1477 `glpay` tinyint(1) DEFAULT NULL,
1478 `glplayervehicle` tinyint(1) DEFAULT NULL,
1479 `glrpspecial` tinyint(1) DEFAULT NULL,
1480 `glsecurity` tinyint(1) DEFAULT NULL,
1481 `glsetvip` tinyint(1) DEFAULT NULL,
1482 `glshopconfirmedorders` tinyint(1) DEFAULT NULL,
1483 `glshoplog` tinyint(1) DEFAULT NULL,
1484 `glshoporders` tinyint(1) DEFAULT NULL,
1485 `glstats` tinyint(1) DEFAULT NULL,
1486 `glundercover` tinyint(1) DEFAULT NULL,
1487 `glvipnamechanges` tinyint(1) DEFAULT NULL,
1488 `glvipremove` tinyint(1) DEFAULT NULL,
1489 `cplaccess` tinyint(1) DEFAULT '0',
1490 `glrapid` tinyint(1) DEFAULT '0',
1491 PRIMARY KEY (`user_id`)
1492) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1493
1494-- --------------------------------------------------------
1495
1496--
1497-- Table structure for table `cp_admin_notes`
1498--
1499
1500CREATE TABLE IF NOT EXISTS `cp_admin_notes` (
1501 `id` int(11) NOT NULL AUTO_INCREMENT,
1502 `user_id` int(11) DEFAULT NULL,
1503 `type` int(1) DEFAULT NULL,
1504 `details` varchar(1024) DEFAULT NULL,
1505 `invoke_id` int(11) DEFAULT NULL,
1506 `date` date DEFAULT NULL,
1507 `status` int(1) DEFAULT NULL,
1508 `points` int(11) DEFAULT NULL,
1509 PRIMARY KEY (`id`)
1510) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1511
1512-- --------------------------------------------------------
1513
1514--
1515-- Table structure for table `cp_cache_email`
1516--
1517
1518CREATE TABLE IF NOT EXISTS `cp_cache_email` (
1519 `id` int(11) NOT NULL AUTO_INCREMENT,
1520 `user_id` int(11) DEFAULT NULL,
1521 `email_address` varchar(255) DEFAULT NULL,
1522 `token` varchar(24) DEFAULT NULL,
1523 PRIMARY KEY (`id`)
1524) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1525
1526-- --------------------------------------------------------
1527
1528--
1529-- Table structure for table `cp_cache_passreset`
1530--
1531
1532CREATE TABLE IF NOT EXISTS `cp_cache_passreset` (
1533 `id` int(11) NOT NULL AUTO_INCREMENT,
1534 `user_id` int(11) NOT NULL,
1535 `token` varchar(128) NOT NULL,
1536 `date` datetime NOT NULL,
1537 PRIMARY KEY (`id`)
1538) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1539
1540-- --------------------------------------------------------
1541
1542--
1543-- Table structure for table `cp_cache_sec_questions`
1544--
1545
1546CREATE TABLE IF NOT EXISTS `cp_cache_sec_questions` (
1547 `id` int(11) NOT NULL AUTO_INCREMENT,
1548 `user_id` int(11) NOT NULL,
1549 `question` varchar(255) NOT NULL,
1550 `answer` varchar(128) NOT NULL,
1551 `token` varchar(128) NOT NULL,
1552 `date` datetime NOT NULL,
1553 PRIMARY KEY (`id`)
1554) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1555
1556-- --------------------------------------------------------
1557
1558--
1559-- Table structure for table `cp_faction`
1560--
1561
1562CREATE TABLE IF NOT EXISTS `cp_faction` (
1563 `id` int(11) NOT NULL DEFAULT '0',
1564 `name` varchar(64) DEFAULT NULL,
1565 `rank_0` varchar(64) DEFAULT NULL,
1566 `rank_1` varchar(64) DEFAULT NULL,
1567 `rank_2` varchar(64) DEFAULT NULL,
1568 `rank_3` varchar(64) DEFAULT NULL,
1569 `rank_4` varchar(64) DEFAULT NULL,
1570 `rank_5` varchar(64) DEFAULT NULL,
1571 `rank_6` varchar(64) DEFAULT NULL,
1572 `div_0` varchar(64) DEFAULT NULL,
1573 `div_1` varchar(64) DEFAULT NULL,
1574 `div_2` varchar(64) DEFAULT NULL,
1575 `div_3` varchar(64) DEFAULT NULL,
1576 `div_4` varchar(64) DEFAULT NULL,
1577 `div_5` varchar(64) DEFAULT NULL,
1578 `div_6` varchar(64) DEFAULT NULL,
1579 `div_7` varchar(64) DEFAULT '',
1580 PRIMARY KEY (`id`)
1581) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1582
1583-- --------------------------------------------------------
1584
1585--
1586-- Table structure for table `cp_family`
1587--
1588
1589CREATE TABLE IF NOT EXISTS `cp_family` (
1590 `id` int(11) NOT NULL DEFAULT '0',
1591 `name` varchar(64) DEFAULT NULL,
1592 `leader` int(11) DEFAULT NULL,
1593 `rank_1` varchar(64) DEFAULT NULL,
1594 `rank_2` varchar(64) DEFAULT NULL,
1595 `rank_3` varchar(64) DEFAULT NULL,
1596 `rank_4` varchar(64) DEFAULT NULL,
1597 `rank_5` varchar(64) DEFAULT NULL,
1598 `rank_6` varchar(64) DEFAULT NULL,
1599 PRIMARY KEY (`id`)
1600) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1601
1602-- --------------------------------------------------------
1603
1604--
1605-- Table structure for table `cp_info_states`
1606--
1607
1608CREATE TABLE IF NOT EXISTS `cp_info_states` (
1609 `state_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'PK: Unique state ID',
1610 `state_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT 'State name with first letter capital',
1611 `state_abbr` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Optional state abbreviation (US is 2 capital letters)',
1612 PRIMARY KEY (`state_id`)
1613) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1614
1615-- --------------------------------------------------------
1616
1617--
1618-- Table structure for table `cp_info_temp`
1619--
1620
1621CREATE TABLE IF NOT EXISTS `cp_info_temp` (
1622 `order_id` varchar(12) NOT NULL,
1623 `player_id` varchar(200) DEFAULT NULL,
1624 `first_name` varchar(120) DEFAULT NULL,
1625 `last_name` varchar(120) DEFAULT NULL,
1626 `billing_address` varchar(120) DEFAULT NULL,
1627 `country` varchar(120) DEFAULT NULL,
1628 `state` varchar(120) DEFAULT NULL,
1629 `city` varchar(120) DEFAULT NULL,
1630 `zip_code` varchar(120) DEFAULT NULL,
1631 `gift_player` varchar(200) DEFAULT NULL,
1632 `purchasetype` varchar(120) DEFAULT NULL,
1633 `method` varchar(120) DEFAULT NULL,
1634 `date_added` varchar(120) DEFAULT NULL,
1635 PRIMARY KEY (`order_id`)
1636) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1637
1638-- --------------------------------------------------------
1639
1640--
1641-- Table structure for table `cp_leave`
1642--
1643
1644CREATE TABLE IF NOT EXISTS `cp_leave` (
1645 `id` int(11) NOT NULL AUTO_INCREMENT,
1646 `user_id` int(11) DEFAULT NULL,
1647 `date_leave` date DEFAULT NULL,
1648 `date_return` date DEFAULT NULL,
1649 `reason` varchar(1024) DEFAULT NULL,
1650 `status` int(1) DEFAULT NULL,
1651 `acceptedby_id` int(11) DEFAULT NULL,
1652 PRIMARY KEY (`id`)
1653) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1654
1655-- --------------------------------------------------------
1656
1657--
1658-- Table structure for table `cp_log`
1659--
1660
1661CREATE TABLE IF NOT EXISTS `cp_log` (
1662 `id` int(11) NOT NULL AUTO_INCREMENT,
1663 `date` datetime DEFAULT NULL,
1664 `user_id` int(11) DEFAULT NULL,
1665 `section` varchar(255) DEFAULT NULL,
1666 `area` varchar(255) DEFAULT NULL,
1667 `details` varchar(1024) DEFAULT NULL,
1668 `ip_address` varchar(15) DEFAULT NULL,
1669 PRIMARY KEY (`id`)
1670) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1671
1672-- --------------------------------------------------------
1673
1674--
1675-- Table structure for table `cp_log_access`
1676--
1677
1678CREATE TABLE IF NOT EXISTS `cp_log_access` (
1679 `id` int(11) NOT NULL AUTO_INCREMENT,
1680 `date` datetime DEFAULT NULL,
1681 `user_id` int(11) DEFAULT NULL,
1682 `area` varchar(255) DEFAULT NULL,
1683 `details` varchar(1024) DEFAULT NULL,
1684 `ip_address` varchar(15) DEFAULT NULL,
1685 PRIMARY KEY (`id`)
1686) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1687
1688-- --------------------------------------------------------
1689
1690--
1691-- Table structure for table `cp_log_cr`
1692--
1693
1694CREATE TABLE IF NOT EXISTS `cp_log_cr` (
1695 `id` int(11) NOT NULL AUTO_INCREMENT,
1696 `date` datetime DEFAULT NULL,
1697 `user_id` int(11) DEFAULT NULL,
1698 `area` varchar(255) DEFAULT NULL,
1699 `details` varchar(1024) DEFAULT NULL,
1700 `ip_address` varchar(15) DEFAULT NULL,
1701 PRIMARY KEY (`id`)
1702) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1703
1704-- --------------------------------------------------------
1705
1706--
1707-- Table structure for table `cp_log_faction`
1708--
1709
1710CREATE TABLE IF NOT EXISTS `cp_log_faction` (
1711 `id` int(11) NOT NULL AUTO_INCREMENT,
1712 `date` datetime DEFAULT NULL,
1713 `user_id` int(11) DEFAULT NULL,
1714 `area` varchar(255) DEFAULT NULL,
1715 `details` varchar(1024) DEFAULT NULL,
1716 `ip_address` varchar(15) DEFAULT NULL,
1717 PRIMARY KEY (`id`)
1718) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1719
1720-- --------------------------------------------------------
1721
1722--
1723-- Table structure for table `cp_log_family`
1724--
1725
1726CREATE TABLE IF NOT EXISTS `cp_log_family` (
1727 `id` int(11) NOT NULL AUTO_INCREMENT,
1728 `date` datetime DEFAULT NULL,
1729 `user_id` int(11) DEFAULT NULL,
1730 `area` varchar(255) DEFAULT NULL,
1731 `details` varchar(1024) DEFAULT NULL,
1732 `ip_address` varchar(15) DEFAULT NULL,
1733 PRIMARY KEY (`id`)
1734) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1735
1736-- --------------------------------------------------------
1737
1738--
1739-- Table structure for table `cp_log_general`
1740--
1741
1742CREATE TABLE IF NOT EXISTS `cp_log_general` (
1743 `id` int(11) NOT NULL AUTO_INCREMENT,
1744 `date` datetime DEFAULT NULL,
1745 `user_id` int(11) DEFAULT NULL,
1746 `area` varchar(255) DEFAULT NULL,
1747 `details` varchar(1024) DEFAULT NULL,
1748 `ip_address` varchar(15) DEFAULT NULL,
1749 PRIMARY KEY (`id`)
1750) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1751
1752-- --------------------------------------------------------
1753
1754--
1755-- Table structure for table `cp_log_security`
1756--
1757
1758CREATE TABLE IF NOT EXISTS `cp_log_security` (
1759 `id` int(11) NOT NULL AUTO_INCREMENT,
1760 `date` datetime DEFAULT NULL,
1761 `user_id` int(11) DEFAULT NULL,
1762 `area` varchar(255) DEFAULT NULL,
1763 `details` varchar(1024) DEFAULT NULL,
1764 `ip_address` varchar(15) DEFAULT NULL,
1765 PRIMARY KEY (`id`)
1766) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1767
1768-- --------------------------------------------------------
1769
1770--
1771-- Table structure for table `cp_log_staff`
1772--
1773
1774CREATE TABLE IF NOT EXISTS `cp_log_staff` (
1775 `id` int(11) NOT NULL AUTO_INCREMENT,
1776 `date` datetime DEFAULT NULL,
1777 `user_id` int(11) DEFAULT NULL,
1778 `area` varchar(255) DEFAULT NULL,
1779 `details` varchar(1024) DEFAULT NULL,
1780 `ip_address` varchar(15) DEFAULT NULL,
1781 PRIMARY KEY (`id`)
1782) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1783
1784-- --------------------------------------------------------
1785
1786--
1787-- Table structure for table `cp_mass_email`
1788--
1789
1790CREATE TABLE IF NOT EXISTS `cp_mass_email` (
1791 `id` int(11) DEFAULT '0',
1792 `subject` varchar(255) COLLATE utf8_bin NOT NULL,
1793 `message` varchar(255) COLLATE utf8_bin NOT NULL,
1794 `creator` varchar(255) COLLATE utf8_bin NOT NULL,
1795 `create_date` datetime NOT NULL,
1796 `update_date` datetime NOT NULL,
1797 `last_sent` datetime NOT NULL,
1798 `banned` int(11) NOT NULL,
1799 `disabled` int(11) NOT NULL,
1800 `admins` int(11) NOT NULL,
1801 `helpers` int(11) NOT NULL,
1802 `vip` int(11) NOT NULL,
1803 `famed` int(11) NOT NULL,
1804 `faction` int(11) NOT NULL,
1805 `faction_rank` int(11) NOT NULL,
1806 `gang` int(11) NOT NULL,
1807 `gang_rank` int(11) NOT NULL,
1808 `biz` int(11) NOT NULL,
1809 `biz_rank` int(11) NOT NULL,
1810 `bypass` int(11) NOT NULL
1811) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1812
1813-- --------------------------------------------------------
1814
1815--
1816-- Table structure for table `cp_misc`
1817--
1818
1819CREATE TABLE IF NOT EXISTS `cp_misc` (
1820 `id` int(11) NOT NULL,
1821 `status` int(11) NOT NULL DEFAULT '1',
1822 `from` varchar(24) COLLATE utf8_bin NOT NULL,
1823 `message` varchar(128) COLLATE utf8_bin NOT NULL,
1824 PRIMARY KEY (`id`)
1825) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1826
1827-- --------------------------------------------------------
1828
1829--
1830-- Table structure for table `cp_punishment`
1831--
1832
1833CREATE TABLE IF NOT EXISTS `cp_punishment` (
1834 `id` int(11) NOT NULL AUTO_INCREMENT,
1835 `player_id` int(11) DEFAULT NULL,
1836 `date_added` date DEFAULT NULL,
1837 `addedby_id` int(11) DEFAULT NULL,
1838 `reason` varchar(1024) DEFAULT NULL,
1839 `status` int(1) DEFAULT NULL,
1840 `prison` int(11) DEFAULT NULL,
1841 `jail` int(11) DEFAULT NULL,
1842 `warn` int(1) DEFAULT NULL,
1843 `fine` int(11) DEFAULT NULL,
1844 `ban` int(1) DEFAULT NULL,
1845 `wep_restrict` int(11) DEFAULT NULL,
1846 `other_punish` varchar(1024) DEFAULT NULL,
1847 `link` varchar(1024) DEFAULT NULL,
1848 `date_issued` date DEFAULT NULL,
1849 `issuedby_id` int(11) DEFAULT NULL,
1850 PRIMARY KEY (`id`)
1851) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1852
1853-- --------------------------------------------------------
1854
1855--
1856-- Table structure for table `cp_refund`
1857--
1858
1859CREATE TABLE IF NOT EXISTS `cp_refund` (
1860 `id` int(11) NOT NULL AUTO_INCREMENT,
1861 `user_id` int(11) DEFAULT NULL,
1862 `refund` varchar(512) DEFAULT NULL,
1863 `link` varchar(256) DEFAULT NULL,
1864 `status` int(1) DEFAULT NULL,
1865 `auth` int(11) DEFAULT NULL,
1866 `addedby_id` int(11) DEFAULT NULL,
1867 `date_added` date DEFAULT NULL,
1868 `issuedby_id` int(1) DEFAULT NULL,
1869 `date_issued` date DEFAULT NULL,
1870 PRIMARY KEY (`id`)
1871) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1872
1873-- --------------------------------------------------------
1874
1875--
1876-- Table structure for table `cp_restricted_archive`
1877--
1878
1879CREATE TABLE IF NOT EXISTS `cp_restricted_archive` (
1880 `id` int(12) NOT NULL AUTO_INCREMENT,
1881 `user_id` int(12) DEFAULT NULL,
1882 `removed_by` int(12) DEFAULT NULL,
1883 `removed_date` datetime DEFAULT NULL,
1884 `reason` varchar(524) DEFAULT NULL,
1885 PRIMARY KEY (`id`)
1886) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1887
1888-- --------------------------------------------------------
1889
1890--
1891-- Table structure for table `cp_security_files`
1892--
1893
1894CREATE TABLE IF NOT EXISTS `cp_security_files` (
1895 `id` int(12) NOT NULL AUTO_INCREMENT,
1896 `user_id` int(12) NOT NULL,
1897 `uploader_id` int(12) NOT NULL,
1898 `file_name` varchar(524) NOT NULL,
1899 `file_type` varchar(524) NOT NULL,
1900 `file_size` varchar(524) NOT NULL,
1901 `file_location` varchar(524) NOT NULL,
1902 `file_description` varchar(524) NOT NULL,
1903 PRIMARY KEY (`id`)
1904) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1905
1906-- --------------------------------------------------------
1907
1908--
1909-- Table structure for table `cp_security_notes`
1910--
1911
1912CREATE TABLE IF NOT EXISTS `cp_security_notes` (
1913 `id` int(12) NOT NULL AUTO_INCREMENT,
1914 `user_id` int(12) NOT NULL,
1915 `note_by` int(12) NOT NULL,
1916 `note` varchar(524) NOT NULL,
1917 `date_added` datetime NOT NULL,
1918 PRIMARY KEY (`id`)
1919) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1920
1921-- --------------------------------------------------------
1922
1923--
1924-- Table structure for table `cp_security_profiles`
1925--
1926
1927CREATE TABLE IF NOT EXISTS `cp_security_profiles` (
1928 `id` int(12) NOT NULL AUTO_INCREMENT,
1929 `user_id` int(12) NOT NULL,
1930 `forum_name` varchar(524) NOT NULL,
1931 `teamspeak_name` varchar(524) NOT NULL,
1932 `recommending_admin` varchar(524) NOT NULL,
1933 `rp_names` varchar(524) NOT NULL,
1934 `email_addresses` varchar(524) NOT NULL,
1935 `messenger_handles` varchar(524) NOT NULL,
1936 `security_orientation` date NOT NULL,
1937 `security_profile` date NOT NULL,
1938 PRIMARY KEY (`id`)
1939) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1940
1941-- --------------------------------------------------------
1942
1943--
1944-- Table structure for table `cp_shifts`
1945--
1946
1947CREATE TABLE IF NOT EXISTS `cp_shifts` (
1948 `id` int(11) NOT NULL AUTO_INCREMENT,
1949 `user_id` int(11) DEFAULT NULL,
1950 `type` int(1) DEFAULT NULL,
1951 `shift_id` int(11) DEFAULT NULL,
1952 `date` date DEFAULT NULL,
1953 `sign_up` datetime DEFAULT NULL,
1954 `status` int(1) DEFAULT NULL,
1955 `bonus` int(11) DEFAULT '0',
1956 PRIMARY KEY (`id`)
1957) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1958
1959-- --------------------------------------------------------
1960
1961--
1962-- Table structure for table `cp_shift_blocks`
1963--
1964
1965CREATE TABLE IF NOT EXISTS `cp_shift_blocks` (
1966 `id` int(11) NOT NULL AUTO_INCREMENT,
1967 `shift_id` int(11) NOT NULL,
1968 `shift` varchar(1) DEFAULT NULL,
1969 `time_start` time DEFAULT NULL,
1970 `time_end` time DEFAULT NULL,
1971 `needs_sunday` int(11) DEFAULT NULL,
1972 `needs_monday` int(11) DEFAULT NULL,
1973 `needs_tuesday` int(11) DEFAULT NULL,
1974 `needs_wednesday` int(11) DEFAULT NULL,
1975 `needs_thursday` int(11) DEFAULT NULL,
1976 `needs_friday` int(11) DEFAULT NULL,
1977 `needs_saturday` int(11) DEFAULT NULL,
1978 `type` int(11) NOT NULL,
1979 PRIMARY KEY (`id`)
1980) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1981
1982-- --------------------------------------------------------
1983
1984--
1985-- Table structure for table `cp_shift_leader`
1986--
1987
1988CREATE TABLE IF NOT EXISTS `cp_shift_leader` (
1989 `id` int(11) NOT NULL AUTO_INCREMENT,
1990 `user_id` int(11) NOT NULL,
1991 `shift_id` int(11) NOT NULL,
1992 `type` int(11) NOT NULL,
1993 PRIMARY KEY (`id`)
1994) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1995
1996-- --------------------------------------------------------
1997
1998--
1999-- Table structure for table `cp_stat`
2000--
2001
2002CREATE TABLE IF NOT EXISTS `cp_stat` (
2003 `user_id` int(11) NOT NULL DEFAULT '0',
2004 `type` int(11) NOT NULL,
2005 `timezone` varchar(128) NOT NULL DEFAULT 'NULL',
2006 `gtalk` varchar(124) DEFAULT 'N/A',
2007 `paypal` varchar(128) DEFAULT NULL,
2008 `points` int(11) DEFAULT '0',
2009 `shift` int(11) DEFAULT '0',
2010 `shift_restrict` varchar(255) DEFAULT NULL,
2011 `shift_complete` int(11) DEFAULT '0',
2012 `shift_partcomplete` int(11) DEFAULT '0',
2013 `shift_missed` int(11) DEFAULT '0',
2014 PRIMARY KEY (`user_id`)
2015) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2016
2017-- --------------------------------------------------------
2018
2019--
2020-- Table structure for table `cp_store_cart`
2021--
2022
2023CREATE TABLE IF NOT EXISTS `cp_store_cart` (
2024 `id` int(12) NOT NULL AUTO_INCREMENT,
2025 `cart_id` int(12) NOT NULL,
2026 `customer_id` int(12) NOT NULL,
2027 `customer_ip_address` varchar(32) NOT NULL,
2028 `cart_pack_id` varchar(32) NOT NULL,
2029 `date_item_added` varchar(32) NOT NULL,
2030 PRIMARY KEY (`id`)
2031) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2032
2033-- --------------------------------------------------------
2034
2035--
2036-- Table structure for table `cp_store_manage`
2037--
2038
2039CREATE TABLE IF NOT EXISTS `cp_store_manage` (
2040 `id` int(12) NOT NULL,
2041 `pack_id` int(12) NOT NULL,
2042 `pack_picture` varchar(120) NOT NULL DEFAULT '',
2043 `total_tokens` varchar(12) NOT NULL,
2044 `old_price` varchar(12) DEFAULT NULL,
2045 `total_price` varchar(12) NOT NULL,
2046 `additional_tokens` varchar(12) DEFAULT NULL,
2047 `store_online` varchar(12) NOT NULL DEFAULT 'OFF',
2048 PRIMARY KEY (`id`)
2049) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2050
2051-- --------------------------------------------------------
2052
2053--
2054-- Table structure for table `cp_store_orders`
2055--
2056
2057CREATE TABLE IF NOT EXISTS `cp_store_orders` (
2058 `id` int(24) NOT NULL AUTO_INCREMENT,
2059 `order_id` int(12) DEFAULT NULL,
2060 `order_status` varchar(60) DEFAULT NULL,
2061 `customer_id` int(12) DEFAULT NULL,
2062 `customer_ip_address` varchar(60) DEFAULT NULL,
2063 `pack_id` int(12) DEFAULT NULL,
2064 `pack_total_tokens` varchar(12) DEFAULT NULL,
2065 `pack_total_price` varchar(12) DEFAULT NULL,
2066 `gift_player_id` varchar(24) DEFAULT NULL,
2067 `payment_method` varchar(12) DEFAULT NULL,
2068 `payment_address` varchar(150) DEFAULT NULL,
2069 `date_purchased` varchar(150) DEFAULT NULL,
2070 PRIMARY KEY (`id`)
2071) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2072
2073-- --------------------------------------------------------
2074
2075--
2076-- Table structure for table `cp_support_faq`
2077--
2078
2079CREATE TABLE IF NOT EXISTS `cp_support_faq` (
2080 `faq_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2081 `category` int(12) NOT NULL DEFAULT '0',
2082 `isenabled` int(1) unsigned NOT NULL DEFAULT '1',
2083 `question` varchar(125) NOT NULL DEFAULT '',
2084 `answer` varchar(500) NOT NULL,
2085 `created` varchar(150) NOT NULL DEFAULT '0000-00-00 00:00:00',
2086 `updated` varchar(150) NOT NULL DEFAULT '0000-00-00 00:00:00',
2087 PRIMARY KEY (`faq_id`),
2088 UNIQUE KEY `title_2` (`question`) USING BTREE,
2089 KEY `dept_id` (`category`) USING BTREE,
2090 KEY `active` (`isenabled`) USING BTREE,
2091 FULLTEXT KEY `title` (`question`,`answer`)
2092) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2093
2094-- --------------------------------------------------------
2095
2096--
2097-- Table structure for table `cp_support_faq_category`
2098--
2099
2100CREATE TABLE IF NOT EXISTS `cp_support_faq_category` (
2101 `id` int(12) NOT NULL AUTO_INCREMENT,
2102 `category` varchar(250) DEFAULT NULL,
2103 `sub_category` varchar(250) DEFAULT NULL,
2104 PRIMARY KEY (`id`)
2105) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2106
2107-- --------------------------------------------------------
2108
2109--
2110-- Table structure for table `cp_support_items`
2111--
2112
2113CREATE TABLE IF NOT EXISTS `cp_support_items` (
2114 `id` int(12) NOT NULL AUTO_INCREMENT,
2115 `sort_id` int(6) NOT NULL,
2116 `item_category` varchar(32) NOT NULL,
2117 `item_name` varchar(32) NOT NULL,
2118 `item_picture` varchar(150) NOT NULL DEFAULT '',
2119 `item_credit_price` varchar(12) NOT NULL,
2120 `item_description` varchar(5000) NOT NULL,
2121 PRIMARY KEY (`id`)
2122) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2123
2124-- --------------------------------------------------------
2125
2126--
2127-- Table structure for table `cp_support_tickets`
2128--
2129
2130CREATE TABLE IF NOT EXISTS `cp_support_tickets` (
2131 `ticket_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
2132 `ticketID` varchar(12) DEFAULT NULL,
2133 `area` varchar(150) NOT NULL DEFAULT '2',
2134 `priority` varchar(12) NOT NULL DEFAULT 'Normal',
2135 `p_id` int(20) unsigned NOT NULL DEFAULT '0',
2136 `email` varchar(150) NOT NULL DEFAULT '',
2137 `subject` varchar(150) NOT NULL DEFAULT '[no subject]',
2138 `ip_address` varchar(40) NOT NULL DEFAULT '',
2139 `status` varchar(24) NOT NULL DEFAULT 'open',
2140 `isoverdue` int(1) unsigned NOT NULL DEFAULT '0',
2141 `isanswered` int(1) unsigned NOT NULL DEFAULT '0',
2142 `duedate` varchar(150) DEFAULT NULL,
2143 `reopened` varchar(150) DEFAULT NULL,
2144 `closed` varchar(150) DEFAULT NULL,
2145 `lastmessage` varchar(150) DEFAULT NULL,
2146 `lastresponse` varchar(150) DEFAULT NULL,
2147 `created` varchar(150) NOT NULL DEFAULT '0000-00-00 00:00:00',
2148 `updated` varchar(150) NOT NULL DEFAULT '0000-00-00 00:00:00',
2149 PRIMARY KEY (`ticket_id`),
2150 UNIQUE KEY `email_extid` (`ticketID`,`email`) USING BTREE,
2151 KEY `staff_id` (`p_id`) USING BTREE,
2152 KEY `status` (`status`) USING BTREE,
2153 KEY `priority_id` (`area`) USING BTREE,
2154 KEY `created` (`created`) USING BTREE,
2155 KEY `closed` (`closed`) USING BTREE,
2156 KEY `duedate` (`duedate`) USING BTREE
2157) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2158
2159-- --------------------------------------------------------
2160
2161--
2162-- Table structure for table `cp_support_tickets_response`
2163--
2164
2165CREATE TABLE IF NOT EXISTS `cp_support_tickets_response` (
2166 `response_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
2167 `ticket_id` int(11) unsigned NOT NULL DEFAULT '0',
2168 `p_id` int(20) unsigned NOT NULL DEFAULT '0',
2169 `form` int(11) unsigned NOT NULL DEFAULT '0',
2170 `staff` int(11) unsigned NOT NULL DEFAULT '0',
2171 `response` varchar(1000) NOT NULL,
2172 `ip_address` varchar(40) NOT NULL DEFAULT '',
2173 `created` varchar(150) NOT NULL DEFAULT '0000-00-00 00:00:00',
2174 `updated` varchar(150) NOT NULL DEFAULT '0000-00-00 00:00:00',
2175 PRIMARY KEY (`response_id`),
2176 KEY `ticket_id` (`ticket_id`) USING BTREE,
2177 KEY `staff_id` (`p_id`) USING BTREE,
2178 FULLTEXT KEY `response` (`response`)
2179) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2180
2181-- --------------------------------------------------------
2182
2183--
2184-- Table structure for table `cp_weekly_reports`
2185--
2186
2187CREATE TABLE IF NOT EXISTS `cp_weekly_reports` (
2188 `id` int(11) NOT NULL AUTO_INCREMENT,
2189 `admin_id` int(11) NOT NULL,
2190 `date` datetime NOT NULL,
2191 `q1` varchar(512) DEFAULT NULL,
2192 `q2` varchar(512) DEFAULT NULL,
2193 `q3` varchar(512) DEFAULT NULL,
2194 `q4` varchar(512) DEFAULT NULL,
2195 `q5` varchar(512) DEFAULT NULL,
2196 `status` int(1) NOT NULL,
2197 PRIMARY KEY (`id`)
2198) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2199
2200-- --------------------------------------------------------
2201
2202--
2203-- Table structure for table `cp_whitelist`
2204--
2205
2206CREATE TABLE IF NOT EXISTS `cp_whitelist` (
2207 `id` int(11) NOT NULL,
2208 `username` varchar(25) NOT NULL,
2209 `key` varchar(128) NOT NULL,
2210 `ip` varchar(15) NOT NULL,
2211 `date` datetime NOT NULL,
2212 PRIMARY KEY (`id`)
2213) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2214
2215-- --------------------------------------------------------
2216
2217--
2218-- Table structure for table `crates`
2219--
2220
2221CREATE TABLE IF NOT EXISTS `crates` (
2222 `id` int(11) NOT NULL AUTO_INCREMENT,
2223 `Active` int(11) NOT NULL DEFAULT '0',
2224 `CrateX` float NOT NULL DEFAULT '0',
2225 `CrateY` float NOT NULL DEFAULT '0',
2226 `CrateZ` float NOT NULL DEFAULT '0',
2227 `GunQuantity` int(11) NOT NULL DEFAULT '50',
2228 `InVehicle` int(11) NOT NULL DEFAULT '0',
2229 `Int` int(11) NOT NULL DEFAULT '0',
2230 `VW` int(11) NOT NULL DEFAULT '0',
2231 `PlacedBy` varchar(24) NOT NULL DEFAULT 'Unknown',
2232 PRIMARY KEY (`id`)
2233) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2234
2235-- --------------------------------------------------------
2236
2237--
2238-- Table structure for table `db`
2239--
2240
2241CREATE TABLE IF NOT EXISTS `db` (
2242 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
2243 `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
2244 `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
2245 `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2246 `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2247 `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2248 `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2249 `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2250 `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2251 `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2252 `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2253 `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2254 `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2255 `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2256 `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2257 `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2258 `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2259 `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2260 `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2261 `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2262 `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2263 `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
2264 PRIMARY KEY (`Host`,`Db`,`User`),
2265 KEY `User` (`User`)
2266) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges';
2267
2268-- --------------------------------------------------------
2269
2270--
2271-- Table structure for table `ddoors`
2272--
2273
2274CREATE TABLE IF NOT EXISTS `ddoors` (
2275 `id` int(11) NOT NULL AUTO_INCREMENT,
2276 `Description` varchar(128) NOT NULL DEFAULT 'None',
2277 `Owner` int(11) NOT NULL DEFAULT '-1',
2278 `OwnerName` varchar(24) NOT NULL DEFAULT 'Nobody',
2279 `CustomInterior` int(11) NOT NULL DEFAULT '0',
2280 `ExteriorVW` int(11) NOT NULL DEFAULT '0',
2281 `ExteriorInt` int(11) NOT NULL DEFAULT '0',
2282 `InteriorVW` int(11) NOT NULL DEFAULT '0',
2283 `InteriorInt` int(11) NOT NULL DEFAULT '0',
2284 `ExteriorX` float(10,5) NOT NULL DEFAULT '0.00000',
2285 `ExteriorY` float(10,5) NOT NULL DEFAULT '0.00000',
2286 `ExteriorZ` float(10,5) NOT NULL DEFAULT '0.00000',
2287 `ExteriorA` float(10,5) NOT NULL DEFAULT '0.00000',
2288 `InteriorX` float(10,5) NOT NULL DEFAULT '0.00000',
2289 `InteriorY` float(10,5) NOT NULL DEFAULT '0.00000',
2290 `InteriorZ` float(10,5) NOT NULL DEFAULT '0.00000',
2291 `InteriorA` float(10,5) NOT NULL DEFAULT '0.00000',
2292 `CustomExterior` int(11) NOT NULL DEFAULT '0',
2293 `Type` int(1) NOT NULL DEFAULT '0',
2294 `Rank` int(1) NOT NULL DEFAULT '-1',
2295 `VIP` int(11) NOT NULL DEFAULT '0',
2296 `DPC` int(11) NOT NULL DEFAULT '0',
2297 `Allegiance` int(11) NOT NULL DEFAULT '0',
2298 `GroupType` int(11) NOT NULL DEFAULT '0',
2299 `Family` int(11) NOT NULL DEFAULT '0',
2300 `Faction` int(11) NOT NULL DEFAULT '-1',
2301 `Admin` int(11) NOT NULL DEFAULT '0',
2302 `Wanted` int(11) NOT NULL DEFAULT '0',
2303 `VehicleAble` int(11) NOT NULL DEFAULT '0',
2304 `Color` int(11) NOT NULL DEFAULT '0',
2305 `PickupModel` int(11) NOT NULL DEFAULT '0',
2306 `Pass` varchar(24) NOT NULL DEFAULT 'pass',
2307 `Locked` int(11) NOT NULL DEFAULT '0',
2308 `Famed` int(11) NOT NULL DEFAULT '0',
2309 `LastLogin` int(11) NOT NULL DEFAULT '0',
2310 PRIMARY KEY (`id`)
2311) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2312
2313-- --------------------------------------------------------
2314
2315--
2316-- Table structure for table `dedi_april`
2317--
2318
2319CREATE TABLE IF NOT EXISTS `dedi_april` (
2320 `id` int(11) NOT NULL DEFAULT '0',
2321 `Username` varchar(255) DEFAULT NULL,
2322 `RewardHours` int(11) DEFAULT NULL,
2323 PRIMARY KEY (`id`)
2324) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2325
2326-- --------------------------------------------------------
2327
2328--
2329-- Table structure for table `devcpbans`
2330--
2331
2332CREATE TABLE IF NOT EXISTS `devcpbans` (
2333 `id` int(11) NOT NULL AUTO_INCREMENT,
2334 `user` varchar(255) NOT NULL,
2335 `anon` int(1) NOT NULL DEFAULT '0',
2336 `bugs` int(1) NOT NULL DEFAULT '0',
2337 `updated` int(34) NOT NULL,
2338 PRIMARY KEY (`id`)
2339) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2340
2341-- --------------------------------------------------------
2342
2343--
2344-- Table structure for table `devcplogs`
2345--
2346
2347CREATE TABLE IF NOT EXISTS `devcplogs` (
2348 `id` int(11) NOT NULL AUTO_INCREMENT,
2349 `user` varchar(255) NOT NULL,
2350 `log` text NOT NULL,
2351 `type` varchar(255) NOT NULL,
2352 `time` int(255) NOT NULL,
2353 `ip` varchar(255) NOT NULL,
2354 `bugid` int(11) NOT NULL,
2355 PRIMARY KEY (`id`)
2356) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2357
2358-- --------------------------------------------------------
2359
2360--
2361-- Table structure for table `dmapicons`
2362--
2363
2364CREATE TABLE IF NOT EXISTS `dmapicons` (
2365 `id` int(11) NOT NULL AUTO_INCREMENT,
2366 `MarkerType` int(11) NOT NULL DEFAULT '0',
2367 `Color` int(11) NOT NULL DEFAULT '0',
2368 `VW` int(11) NOT NULL DEFAULT '0',
2369 `Int` int(11) NOT NULL DEFAULT '0',
2370 `PosX` float(10,5) NOT NULL DEFAULT '0.00000',
2371 `PosY` float(10,5) NOT NULL DEFAULT '0.00000',
2372 `PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
2373 PRIMARY KEY (`id`)
2374) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2375
2376-- --------------------------------------------------------
2377
2378--
2379-- Table structure for table `dm_watchdog`
2380--
2381
2382CREATE TABLE IF NOT EXISTS `dm_watchdog` (
2383 `id` int(11) NOT NULL DEFAULT '0',
2384 `reporter` int(11) NOT NULL DEFAULT '0',
2385 `timestamp` int(11) NOT NULL DEFAULT '0',
2386 `superwatch` tinyint(11) NOT NULL DEFAULT '0'
2387) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2388
2389-- --------------------------------------------------------
2390
2391--
2392-- Table structure for table `event`
2393--
2394
2395CREATE TABLE IF NOT EXISTS `event` (
2396 `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
2397 `name` char(64) NOT NULL DEFAULT '',
2398 `body` longblob NOT NULL,
2399 `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
2400 `execute_at` datetime DEFAULT NULL,
2401 `interval_value` int(11) DEFAULT NULL,
2402 `interval_field` enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICROSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','MINUTE_MICROSECOND','SECOND_MICROSECOND') DEFAULT NULL,
2403 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2404 `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
2405 `last_executed` datetime DEFAULT NULL,
2406 `starts` datetime DEFAULT NULL,
2407 `ends` datetime DEFAULT NULL,
2408 `status` enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NOT NULL DEFAULT 'ENABLED',
2409 `on_completion` enum('DROP','PRESERVE') NOT NULL DEFAULT 'DROP',
2410 `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
2411 `comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
2412 `originator` int(10) unsigned NOT NULL,
2413 `time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT 'SYSTEM',
2414 `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
2415 `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
2416 `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
2417 `body_utf8` longblob,
2418 PRIMARY KEY (`db`,`name`)
2419) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Events';
2420
2421-- --------------------------------------------------------
2422
2423--
2424-- Table structure for table `events`
2425--
2426
2427CREATE TABLE IF NOT EXISTS `events` (
2428 `id` int(11) NOT NULL AUTO_INCREMENT,
2429 `creator` int(11) NOT NULL DEFAULT '-1',
2430 `approvedby` int(11) NOT NULL DEFAULT '-1',
2431 `pos` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0.0, 0.0, 0.0',
2432 `weapons` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0,0,0,0,0',
2433 `skins` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0,0',
2434 `time` int(11) NOT NULL DEFAULT '0',
2435 PRIMARY KEY (`id`)
2436) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
2437
2438-- --------------------------------------------------------
2439
2440--
2441-- Table structure for table `event_hungergames-2013-10`
2442--
2443
2444CREATE TABLE IF NOT EXISTS `event_hungergames-2013-10` (
2445 `id` int(11) NOT NULL AUTO_INCREMENT,
2446 `user_id` int(11) NOT NULL DEFAULT '-1',
2447 PRIMARY KEY (`id`)
2448) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2449
2450-- --------------------------------------------------------
2451
2452--
2453-- Table structure for table `fallintofun`
2454--
2455
2456CREATE TABLE IF NOT EXISTS `fallintofun` (
2457 `player` int(50) NOT NULL DEFAULT '0',
2458 `FIFHours` int(30) DEFAULT '0',
2459 `FIFChances` int(30) DEFAULT '0',
2460 PRIMARY KEY (`player`)
2461) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2462
2463-- --------------------------------------------------------
2464
2465--
2466-- Table structure for table `families`
2467--
2468
2469CREATE TABLE IF NOT EXISTS `families` (
2470 `ID` tinyint(1) NOT NULL AUTO_INCREMENT,
2471 `Taken` tinyint(1) NOT NULL DEFAULT '0',
2472 `Name` varchar(40) NOT NULL DEFAULT 'None',
2473 `MOTD` varchar(64) NOT NULL DEFAULT 'None',
2474 `MOTD1` varchar(128) NOT NULL,
2475 `MOTD2` varchar(128) NOT NULL,
2476 `MOTD3` varchar(128) NOT NULL,
2477 `Leader` varchar(24) NOT NULL DEFAULT 'None',
2478 `Bank` int(11) NOT NULL DEFAULT '0',
2479 `Cash` int(11) NOT NULL DEFAULT '0',
2480 `FamilyUSafe` int(11) NOT NULL DEFAULT '0',
2481 `FamilySafeX` float(11,5) NOT NULL DEFAULT '0.00000',
2482 `FamilySafeY` float(11,5) NOT NULL DEFAULT '0.00000',
2483 `FamilySafeZ` float(11,5) NOT NULL DEFAULT '0.00000',
2484 `FamilySafeVW` int(11) NOT NULL DEFAULT '-1',
2485 `FamilySafeInt` int(11) NOT NULL DEFAULT '-1',
2486 `Pot` int(11) NOT NULL DEFAULT '0',
2487 `Crack` int(11) NOT NULL DEFAULT '0',
2488 `Mats` int(11) NOT NULL DEFAULT '0',
2489 `Rank0` varchar(30) NOT NULL DEFAULT 'Newb',
2490 `Rank1` varchar(30) NOT NULL DEFAULT 'Outsider',
2491 `Rank2` varchar(30) NOT NULL DEFAULT 'Associate',
2492 `Rank3` varchar(30) NOT NULL DEFAULT 'Soldier',
2493 `Rank4` varchar(30) NOT NULL DEFAULT 'Capo',
2494 `Rank5` varchar(30) NOT NULL DEFAULT 'Underboss',
2495 `Rank6` varchar(30) NOT NULL DEFAULT 'Godfather',
2496 `Members` smallint(6) NOT NULL DEFAULT '0',
2497 `MaxSkins` tinyint(4) NOT NULL DEFAULT '0',
2498 `Skin1` int(11) NOT NULL DEFAULT '0',
2499 `Skin2` int(11) NOT NULL DEFAULT '0',
2500 `Skin3` int(11) NOT NULL DEFAULT '0',
2501 `Skin4` int(11) NOT NULL DEFAULT '0',
2502 `Skin5` int(11) NOT NULL DEFAULT '0',
2503 `Skin6` int(11) NOT NULL DEFAULT '0',
2504 `Skin7` int(11) NOT NULL DEFAULT '0',
2505 `Skin8` int(11) NOT NULL DEFAULT '0',
2506 `Color` int(11) NOT NULL DEFAULT '0',
2507 `TurfTokens` int(11) NOT NULL DEFAULT '0',
2508 `Gun1` tinyint(4) NOT NULL DEFAULT '0',
2509 `Gun2` tinyint(4) NOT NULL DEFAULT '0',
2510 `Gun3` tinyint(4) NOT NULL DEFAULT '0',
2511 `Gun4` tinyint(4) NOT NULL DEFAULT '0',
2512 `Gun5` tinyint(4) NOT NULL DEFAULT '0',
2513 `Gun6` tinyint(4) NOT NULL DEFAULT '0',
2514 `Gun7` tinyint(4) NOT NULL DEFAULT '0',
2515 `Gun8` tinyint(4) NOT NULL DEFAULT '0',
2516 `Gun9` tinyint(4) NOT NULL DEFAULT '0',
2517 `Gun10` tinyint(4) NOT NULL DEFAULT '0',
2518 `ExteriorX` float(11,5) NOT NULL DEFAULT '0.00000',
2519 `ExteriorY` float(11,5) NOT NULL DEFAULT '0.00000',
2520 `ExteriorZ` float(11,5) NOT NULL DEFAULT '0.00000',
2521 `ExteriorA` float(11,5) NOT NULL DEFAULT '0.00000',
2522 `InteriorX` float(11,5) NOT NULL DEFAULT '0.00000',
2523 `InteriorY` float(11,5) NOT NULL DEFAULT '0.00000',
2524 `InteriorZ` float(11,5) NOT NULL DEFAULT '0.00000',
2525 `InteriorA` float(11,5) NOT NULL DEFAULT '0.00000',
2526 `VW` int(11) NOT NULL DEFAULT '0',
2527 `INT` int(11) NOT NULL DEFAULT '0',
2528 `CustomInterior` int(11) NOT NULL DEFAULT '0',
2529 `Division0` varchar(16) NOT NULL DEFAULT 'none',
2530 `Division1` varchar(16) NOT NULL DEFAULT 'none',
2531 `Division2` varchar(16) NOT NULL DEFAULT 'none',
2532 `Division3` varchar(16) NOT NULL DEFAULT 'none',
2533 `Division4` varchar(16) NOT NULL DEFAULT 'none',
2534 `Heroin` int(16) NOT NULL DEFAULT '0',
2535 `GtObject` int(11) NOT NULL DEFAULT '1490',
2536 `fontface` varchar(32) NOT NULL,
2537 `fontsize` int(11) NOT NULL,
2538 `bold` int(11) NOT NULL,
2539 `fontcolor` int(11) NOT NULL,
2540 `backcolor` int(11) NOT NULL,
2541 `text` varchar(32) NOT NULL,
2542 `gtUsed` int(11) NOT NULL,
2543 `FamColor` mediumint(8) unsigned NOT NULL DEFAULT '130303',
2544 PRIMARY KEY (`ID`)
2545) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2546
2547-- --------------------------------------------------------
2548
2549--
2550-- Table structure for table `flags`
2551--
2552
2553CREATE TABLE IF NOT EXISTS `flags` (
2554 `fid` int(11) NOT NULL AUTO_INCREMENT,
2555 `id` int(11) NOT NULL,
2556 `time` datetime NOT NULL,
2557 `issuer` varchar(24) NOT NULL,
2558 `flag` varchar(128) NOT NULL,
2559 `type` int(11) NOT NULL DEFAULT '1' COMMENT '1 = Regular | 2 = Admin',
2560 PRIMARY KEY (`fid`)
2561) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2562
2563-- --------------------------------------------------------
2564
2565--
2566-- Table structure for table `func`
2567--
2568
2569CREATE TABLE IF NOT EXISTS `func` (
2570 `name` binary(64) NOT NULL DEFAULT ' ',
2571 `ret` tinyint(1) NOT NULL DEFAULT '0',
2572 `dl` char(128) COLLATE utf8_bin NOT NULL DEFAULT '',
2573 `type` enum('function','aggregate') CHARACTER SET utf8 NOT NULL,
2574 PRIMARY KEY (`name`)
2575) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions';
2576
2577-- --------------------------------------------------------
2578
2579--
2580-- Table structure for table `gangtags`
2581--
2582
2583CREATE TABLE IF NOT EXISTS `gangtags` (
2584 `id` int(11) NOT NULL AUTO_INCREMENT,
2585 `posx` float(11,4) NOT NULL DEFAULT '0.0000',
2586 `posy` float(11,4) NOT NULL DEFAULT '0.0000',
2587 `posz` float(11,4) NOT NULL DEFAULT '0.0000',
2588 `posrx` float(11,4) NOT NULL DEFAULT '0.0000',
2589 `posry` float(11,4) NOT NULL DEFAULT '0.0000',
2590 `posrz` float(11,4) NOT NULL DEFAULT '0.0000',
2591 `objectid` int(11) NOT NULL DEFAULT '1490',
2592 `vw` int(11) NOT NULL DEFAULT '0',
2593 `interior` int(11) NOT NULL DEFAULT '0',
2594 `family` int(11) NOT NULL DEFAULT '255',
2595 `used` int(11) NOT NULL DEFAULT '0',
2596 `time` int(11) NOT NULL DEFAULT '0',
2597 PRIMARY KEY (`id`)
2598) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2599
2600-- --------------------------------------------------------
2601
2602--
2603-- Table structure for table `garages`
2604--
2605
2606CREATE TABLE IF NOT EXISTS `garages` (
2607 `id` int(11) NOT NULL AUTO_INCREMENT,
2608 `Owner` int(11) NOT NULL DEFAULT '-1',
2609 `OwnerName` varchar(24) NOT NULL DEFAULT 'Nobody',
2610 `ExteriorX` float(10,5) NOT NULL DEFAULT '0.00000',
2611 `ExteriorY` float(10,5) NOT NULL DEFAULT '0.00000',
2612 `ExteriorZ` float(10,5) NOT NULL DEFAULT '0.00000',
2613 `ExteriorA` float(10,5) NOT NULL DEFAULT '0.00000',
2614 `ExteriorVW` int(11) NOT NULL DEFAULT '0',
2615 `ExteriorInt` int(11) NOT NULL DEFAULT '0',
2616 `CustomExterior` int(11) NOT NULL DEFAULT '0',
2617 `InteriorX` float(10,5) NOT NULL DEFAULT '0.00000',
2618 `InteriorY` float(10,5) NOT NULL DEFAULT '0.00000',
2619 `InteriorZ` float(10,5) NOT NULL DEFAULT '0.00000',
2620 `InteriorA` float(10,5) NOT NULL DEFAULT '0.00000',
2621 `InteriorVW` int(11) NOT NULL DEFAULT '0',
2622 `Pass` varchar(24) NOT NULL DEFAULT 'pass',
2623 `Locked` int(11) NOT NULL DEFAULT '0',
2624 PRIMARY KEY (`id`)
2625) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2626
2627-- --------------------------------------------------------
2628
2629--
2630-- Table structure for table `gates`
2631--
2632
2633CREATE TABLE IF NOT EXISTS `gates` (
2634 `ID` int(11) NOT NULL AUTO_INCREMENT,
2635 `HID` int(11) NOT NULL DEFAULT '-1',
2636 `Speed` float NOT NULL DEFAULT '10',
2637 `Range` float NOT NULL DEFAULT '10',
2638 `Model` int(11) NOT NULL DEFAULT '18631',
2639 `VW` int(11) NOT NULL DEFAULT '0',
2640 `Int` int(11) NOT NULL DEFAULT '0',
2641 `Pass` varchar(24) NOT NULL DEFAULT '',
2642 `PosX` float NOT NULL DEFAULT '0',
2643 `PosY` float NOT NULL DEFAULT '0',
2644 `PosZ` float NOT NULL DEFAULT '0',
2645 `RotX` float NOT NULL DEFAULT '0',
2646 `RotY` float NOT NULL DEFAULT '0',
2647 `RotZ` float NOT NULL DEFAULT '0',
2648 `PosXM` float NOT NULL DEFAULT '0',
2649 `PosYM` float NOT NULL DEFAULT '0',
2650 `PosZM` float NOT NULL DEFAULT '0',
2651 `RotXM` float NOT NULL DEFAULT '0',
2652 `RotYM` float NOT NULL DEFAULT '0',
2653 `RotZM` float NOT NULL DEFAULT '0',
2654 `Allegiance` int(11) NOT NULL DEFAULT '0',
2655 `GroupType` int(11) NOT NULL DEFAULT '0',
2656 `GroupID` int(2) NOT NULL DEFAULT '-1',
2657 `FamilyID` int(2) NOT NULL DEFAULT '-1',
2658 `RenderHQ` int(11) NOT NULL DEFAULT '1',
2659 `Timer` int(1) NOT NULL DEFAULT '0',
2660 `Automate` int(11) NOT NULL,
2661 `Locked` int(11) NOT NULL,
2662 PRIMARY KEY (`ID`)
2663) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2664
2665-- --------------------------------------------------------
2666
2667--
2668-- Table structure for table `general_log`
2669--
2670
2671CREATE TABLE IF NOT EXISTS `general_log` (
2672 `event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
2673 `user_host` mediumtext NOT NULL,
2674 `thread_id` int(11) NOT NULL,
2675 `server_id` int(10) unsigned NOT NULL,
2676 `command_type` varchar(64) NOT NULL,
2677 `argument` mediumtext NOT NULL
2678) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='General log';
2679
2680-- --------------------------------------------------------
2681
2682--
2683-- Table structure for table `giftbox`
2684--
2685
2686CREATE TABLE IF NOT EXISTS `giftbox` (
2687 `dgMoney0` int(11) DEFAULT '0',
2688 `dgRimKit0` int(11) DEFAULT '0',
2689 `dgFirework0` int(11) DEFAULT '0',
2690 `dgGVIP0` int(11) DEFAULT '0',
2691 `dgGVIPEx0` int(11) DEFAULT '0',
2692 `dgSVIP0` int(11) DEFAULT '0',
2693 `dgSVIPEx0` int(11) DEFAULT '0',
2694 `dgCarSlot0` int(11) DEFAULT '0',
2695 `dgToySlot0` int(11) DEFAULT '0',
2696 `dgArmor0` int(11) DEFAULT '0',
2697 `dgFirstaid0` int(11) DEFAULT '0',
2698 `dgDDFlag0` int(11) DEFAULT '0',
2699 `dgGateFlag0` int(11) DEFAULT '0',
2700 `dgCredits0` int(11) DEFAULT '0',
2701 `dgPriorityAd0` int(11) DEFAULT '0',
2702 `dgHealthNArmor0` int(11) DEFAULT '0',
2703 `dgRespectPoint0` int(11) DEFAULT '0',
2704 `dgCarVoucher0` int(11) DEFAULT '0',
2705 `dgBuddyInvite0` int(11) DEFAULT '0',
2706 `dgLaser0` int(11) DEFAULT '0',
2707 `dgCustomToy0` int(11) DEFAULT '0',
2708 `dgAdmuteReset0` int(11) DEFAULT '0',
2709 `dgNewbieMuteReset0` int(11) DEFAULT '0',
2710 `dgRestrictedCarVoucher0` int(11) DEFAULT '0',
2711 `dgPlatinumVIPVoucher0` int(11) DEFAULT '0',
2712 `dgGiftReset0` int(11) DEFAULT '0',
2713 `dgMaterial0` int(11) DEFAULT '0',
2714 `dgWarning0` int(11) DEFAULT '0',
2715 `dgPot0` int(11) DEFAULT '0',
2716 `dgCrack0` int(11) DEFAULT '0',
2717 `dgPaintballToken0` int(11) DEFAULT '0',
2718 `dgVIPToken0` int(11) DEFAULT '0',
2719 `dgMoney1` int(11) DEFAULT '0',
2720 `dgRimKit1` int(11) DEFAULT '0',
2721 `dgFirework1` int(11) DEFAULT '0',
2722 `dgGVIP1` int(11) DEFAULT '0',
2723 `dgGVIPEx1` int(11) DEFAULT '0',
2724 `dgSVIP1` int(11) DEFAULT '0',
2725 `dgSVIPEx1` int(11) DEFAULT '0',
2726 `dgCarSlot1` int(11) DEFAULT '0',
2727 `dgToySlot1` int(11) DEFAULT '0',
2728 `dgArmor1` int(11) DEFAULT '0',
2729 `dgFirstaid1` int(11) DEFAULT '0',
2730 `dgDDFlag1` int(11) DEFAULT '0',
2731 `dgGateFlag1` int(11) DEFAULT '0',
2732 `dgCredits1` int(11) DEFAULT '0',
2733 `dgPriorityAd1` int(11) DEFAULT '0',
2734 `dgHealthNArmor1` int(11) DEFAULT '0',
2735 `dgRespectPoint1` int(11) DEFAULT '0',
2736 `dgCarVoucher1` int(11) DEFAULT '0',
2737 `dgBuddyInvite1` int(11) DEFAULT '0',
2738 `dgLaser1` int(11) DEFAULT '0',
2739 `dgCustomToy1` int(11) DEFAULT '0',
2740 `dgAdmuteReset1` int(11) DEFAULT '0',
2741 `dgNewbieMuteReset1` int(11) DEFAULT '0',
2742 `dgRestrictedCarVoucher1` int(11) DEFAULT '0',
2743 `dgPlatinumVIPVoucher1` int(11) DEFAULT '0',
2744 `dgGiftReset1` int(11) DEFAULT '0',
2745 `dgMaterial1` int(11) DEFAULT '0',
2746 `dgWarning1` int(11) DEFAULT '0',
2747 `dgPot1` int(11) DEFAULT '0',
2748 `dgCrack1` int(11) DEFAULT '0',
2749 `dgPaintballToken1` int(11) DEFAULT '0',
2750 `dgVIPToken1` int(11) DEFAULT '0',
2751 `dgMoney2` int(11) DEFAULT '0',
2752 `dgRimKit2` int(11) DEFAULT '0',
2753 `dgFirework2` int(11) DEFAULT '0',
2754 `dgGVIP2` int(11) DEFAULT '0',
2755 `dgGVIPEx2` int(11) DEFAULT '0',
2756 `dgSVIP2` int(11) DEFAULT '0',
2757 `dgSVIPEx2` int(11) DEFAULT '0',
2758 `dgCarSlot2` int(11) DEFAULT '0',
2759 `dgToySlot2` int(11) DEFAULT '0',
2760 `dgArmor2` int(11) DEFAULT '0',
2761 `dgFirstaid2` int(11) DEFAULT '0',
2762 `dgDDFlag2` int(11) DEFAULT '0',
2763 `dgGateFlag2` int(11) DEFAULT '0',
2764 `dgCredits2` int(11) DEFAULT '0',
2765 `dgPriorityAd2` int(11) DEFAULT '0',
2766 `dgHealthNArmor2` int(11) DEFAULT '0',
2767 `dgRespectPoint2` int(11) DEFAULT '0',
2768 `dgCarVoucher2` int(11) DEFAULT '0',
2769 `dgBuddyInvite2` int(11) DEFAULT '0',
2770 `dgLaser2` int(11) DEFAULT '0',
2771 `dgCustomToy2` int(11) DEFAULT '0',
2772 `dgAdmuteReset2` int(11) DEFAULT '0',
2773 `dgNewbieMuteReset2` int(11) DEFAULT '0',
2774 `dgRestrictedCarVoucher2` int(11) DEFAULT '0',
2775 `dgPlatinumVIPVoucher2` int(11) DEFAULT '0',
2776 `dgGiftReset2` int(11) DEFAULT '0',
2777 `dgMaterial2` int(11) DEFAULT '0',
2778 `dgWarning2` int(11) DEFAULT '0',
2779 `dgPot2` int(11) DEFAULT '0',
2780 `dgCrack2` int(11) DEFAULT '0',
2781 `dgPaintballToken2` int(11) DEFAULT '0',
2782 `dgVIPToken2` int(11) DEFAULT '0',
2783 `dgMoney3` int(11) DEFAULT '0',
2784 `dgRimKit3` int(11) DEFAULT '0',
2785 `dgFirework3` int(11) DEFAULT '0',
2786 `dgGVIP3` int(11) DEFAULT '0',
2787 `dgGVIPEx3` int(11) DEFAULT '0',
2788 `dgSVIP3` int(11) DEFAULT '0',
2789 `dgSVIPEx3` int(11) DEFAULT '0',
2790 `dgCarSlot3` int(11) DEFAULT '0',
2791 `dgToySlot3` int(11) DEFAULT '0',
2792 `dgArmor3` int(11) DEFAULT '0',
2793 `dgFirstaid3` int(11) DEFAULT '0',
2794 `dgDDFlag3` int(11) DEFAULT '0',
2795 `dgGateFlag3` int(11) DEFAULT '0',
2796 `dgCredits3` int(11) DEFAULT '0',
2797 `dgPriorityAd3` int(11) DEFAULT '0',
2798 `dgHealthNArmor3` int(11) DEFAULT '0',
2799 `dgRespectPoint3` int(11) DEFAULT '0',
2800 `dgCarVoucher3` int(11) DEFAULT '0',
2801 `dgBuddyInvite3` int(11) DEFAULT '0',
2802 `dgLaser3` int(11) DEFAULT '0',
2803 `dgCustomToy3` int(11) DEFAULT '0',
2804 `dgAdmuteReset3` int(11) DEFAULT '0',
2805 `dgNewbieMuteReset3` int(11) DEFAULT '0',
2806 `dgRestrictedCarVoucher3` int(11) DEFAULT '0',
2807 `dgPlatinumVIPVoucher3` int(11) DEFAULT '0',
2808 `dgGiftReset3` int(11) DEFAULT '0',
2809 `dgMaterial3` int(11) DEFAULT '0',
2810 `dgWarning3` int(11) DEFAULT '0',
2811 `dgPot3` int(11) DEFAULT '0',
2812 `dgCrack3` int(11) DEFAULT '0',
2813 `dgPaintballToken3` int(11) DEFAULT '0',
2814 `dgVIPToken3` int(11) DEFAULT '0'
2815) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2816
2817-- --------------------------------------------------------
2818
2819--
2820-- Table structure for table `giftpage_dec`
2821--
2822
2823CREATE TABLE IF NOT EXISTS `giftpage_dec` (
2824 `id` int(11) NOT NULL AUTO_INCREMENT,
2825 `dID` varchar(32) NOT NULL,
2826 `Username` varchar(32) NOT NULL,
2827 `ip` varchar(32) NOT NULL DEFAULT '0',
2828 `rToken` int(11) NOT NULL DEFAULT '0',
2829 `usedReset` int(11) NOT NULL DEFAULT '0',
2830 `plyHour` int(11) DEFAULT '0',
2831 `sgToken` int(11) DEFAULT '0',
2832 `sBeer` int(11) DEFAULT '0',
2833 `rBeer` int(11) DEFAULT '0',
2834 `rVIP` int(11) DEFAULT '0',
2835 PRIMARY KEY (`id`)
2836) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2837
2838-- --------------------------------------------------------
2839
2840--
2841-- Table structure for table `groupbans`
2842--
2843
2844CREATE TABLE IF NOT EXISTS `groupbans` (
2845 `id` int(11) NOT NULL AUTO_INCREMENT,
2846 `TypeBan` int(11) NOT NULL DEFAULT '-1',
2847 `PlayerID` int(11) NOT NULL DEFAULT '-1',
2848 `BanDate` datetime NOT NULL DEFAULT '2001-01-12 00:00:00',
2849 `GroupBan` int(11) NOT NULL DEFAULT '-1',
2850 `BannedBy` varchar(24) NOT NULL DEFAULT '',
2851 `BanReason` varchar(64) NOT NULL DEFAULT '',
2852 PRIMARY KEY (`id`)
2853) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2854
2855-- --------------------------------------------------------
2856
2857--
2858-- Table structure for table `groups`
2859--
2860
2861CREATE TABLE IF NOT EXISTS `groups` (
2862 `id` int(11) NOT NULL AUTO_INCREMENT,
2863 `Type` tinyint(4) NOT NULL DEFAULT '0',
2864 `Name` varchar(64) NOT NULL DEFAULT '',
2865 `MOTD` varchar(128) NOT NULL DEFAULT '',
2866 `MOTD2` varchar(128) NOT NULL DEFAULT '',
2867 `MOTD3` varchar(128) NOT NULL DEFAULT '',
2868 `Allegiance` tinyint(4) NOT NULL DEFAULT '0',
2869 `Bug` tinyint(4) unsigned NOT NULL DEFAULT '255',
2870 `Radio` tinyint(4) unsigned NOT NULL DEFAULT '255',
2871 `DeptRadio` tinyint(4) unsigned NOT NULL DEFAULT '255',
2872 `GovAnnouncement` tinyint(4) unsigned NOT NULL DEFAULT '255',
2873 `SpikeStrips` tinyint(4) unsigned NOT NULL DEFAULT '255',
2874 `Barricades` tinyint(4) unsigned NOT NULL DEFAULT '255',
2875 `Cones` tinyint(4) unsigned NOT NULL DEFAULT '255',
2876 `Flares` tinyint(4) unsigned NOT NULL DEFAULT '255',
2877 `Barrels` tinyint(4) unsigned NOT NULL DEFAULT '255',
2878 `Ladders` tinyint(4) unsigned NOT NULL DEFAULT '255',
2879 `FreeNameChange` tinyint(3) unsigned NOT NULL DEFAULT '255',
2880 `CrateIslandAccess` tinyint(4) unsigned NOT NULL DEFAULT '255',
2881 `DutyColour` mediumint(8) unsigned NOT NULL DEFAULT '16777215',
2882 `RadioColour` mediumint(8) unsigned NOT NULL DEFAULT '16777215',
2883 `Budget` int(11) NOT NULL DEFAULT '0',
2884 `BudgetPayment` int(11) NOT NULL DEFAULT '0',
2885 `Stock` int(11) NOT NULL DEFAULT '0',
2886 `LockerCostType` int(11) NOT NULL,
2887 `CrateX` float NOT NULL DEFAULT '0',
2888 `CrateY` float NOT NULL DEFAULT '0',
2889 `CrateZ` float NOT NULL DEFAULT '0',
2890 `Rank0` varchar(30) NOT NULL DEFAULT '',
2891 `Rank1` varchar(30) NOT NULL DEFAULT '',
2892 `Rank2` varchar(30) NOT NULL DEFAULT '',
2893 `Rank3` varchar(30) NOT NULL DEFAULT '',
2894 `Rank4` varchar(30) NOT NULL DEFAULT '',
2895 `Rank5` varchar(30) NOT NULL DEFAULT '',
2896 `Rank6` varchar(30) NOT NULL DEFAULT '',
2897 `Rank7` varchar(30) NOT NULL DEFAULT '',
2898 `Rank8` varchar(30) NOT NULL DEFAULT '',
2899 `Rank9` varchar(30) NOT NULL DEFAULT '',
2900 `Rank0Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
2901 `Rank1Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
2902 `Rank2Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
2903 `Rank3Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
2904 `Rank4Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
2905 `Rank5Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
2906 `Rank6Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
2907 `Rank7Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
2908 `Rank8Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
2909 `Rank9Pay` mediumint(8) unsigned NOT NULL DEFAULT '0',
2910 `Div0` varchar(30) NOT NULL,
2911 `Div1` varchar(16) NOT NULL DEFAULT '',
2912 `Div2` varchar(16) NOT NULL DEFAULT '',
2913 `Div3` varchar(16) NOT NULL DEFAULT '',
2914 `Div4` varchar(16) NOT NULL DEFAULT '',
2915 `Div5` varchar(16) NOT NULL DEFAULT '',
2916 `Div6` varchar(16) NOT NULL DEFAULT '',
2917 `Div7` varchar(16) NOT NULL DEFAULT '',
2918 `Div8` varchar(16) NOT NULL DEFAULT '',
2919 `Div9` varchar(16) NOT NULL DEFAULT '',
2920 `Div10` varchar(16) NOT NULL DEFAULT '',
2921 `Gun0` tinyint(4) NOT NULL,
2922 `Cost0` int(11) NOT NULL,
2923 `Gun1` tinyint(4) NOT NULL DEFAULT '0',
2924 `Cost1` int(11) NOT NULL DEFAULT '0',
2925 `Gun2` tinyint(4) NOT NULL DEFAULT '0',
2926 `Cost2` int(11) NOT NULL DEFAULT '0',
2927 `Gun3` tinyint(4) NOT NULL DEFAULT '0',
2928 `Cost3` int(11) NOT NULL DEFAULT '0',
2929 `Gun4` tinyint(4) NOT NULL DEFAULT '0',
2930 `Cost4` int(11) NOT NULL DEFAULT '0',
2931 `Gun5` tinyint(4) NOT NULL DEFAULT '0',
2932 `Cost5` int(11) NOT NULL DEFAULT '0',
2933 `Gun6` tinyint(4) NOT NULL DEFAULT '0',
2934 `Cost6` int(11) NOT NULL DEFAULT '0',
2935 `Gun7` tinyint(4) NOT NULL DEFAULT '0',
2936 `Cost7` int(11) NOT NULL DEFAULT '0',
2937 `Gun8` tinyint(4) NOT NULL DEFAULT '0',
2938 `Cost8` int(11) NOT NULL DEFAULT '0',
2939 `Gun9` tinyint(4) NOT NULL DEFAULT '0',
2940 `Cost9` int(11) NOT NULL DEFAULT '0',
2941 `Gun10` tinyint(4) NOT NULL DEFAULT '0',
2942 `Cost10` int(11) NOT NULL DEFAULT '0',
2943 `Gun11` tinyint(4) NOT NULL DEFAULT '0',
2944 `Cost11` int(11) NOT NULL DEFAULT '0',
2945 `Gun12` tinyint(4) NOT NULL DEFAULT '0',
2946 `Cost12` int(11) NOT NULL DEFAULT '0',
2947 `Gun13` tinyint(4) NOT NULL DEFAULT '0',
2948 `Cost13` int(11) NOT NULL DEFAULT '0',
2949 `Gun14` tinyint(4) NOT NULL DEFAULT '0',
2950 `Cost14` int(11) NOT NULL DEFAULT '0',
2951 `Gun15` tinyint(4) NOT NULL DEFAULT '0',
2952 `Cost15` int(11) NOT NULL DEFAULT '0',
2953 `Gun16` int(11) NOT NULL DEFAULT '0',
2954 `Cost16` int(11) NOT NULL DEFAULT '0',
2955 `CratesOrder` int(11) NOT NULL DEFAULT '0',
2956 `CrateIsland` int(4) NOT NULL DEFAULT '255',
2957 `IntRadio` int(11) NOT NULL DEFAULT '255',
2958 `GarageX` float NOT NULL,
2959 `GarageY` float NOT NULL,
2960 `GarageZ` float NOT NULL,
2961 `TackleAccess` int(11) NOT NULL DEFAULT '255',
2962 `WheelClamps` int(11) NOT NULL DEFAULT '255',
2963 `DoCAccess` int(11) NOT NULL DEFAULT '255',
2964 `MedicAccess` int(11) NOT NULL DEFAULT '255',
2965 `DMVAccess` int(11) NOT NULL DEFAULT '255',
2966 `OOCChat` int(11) NOT NULL DEFAULT '0',
2967 `OOCColor` mediumint(8) unsigned NOT NULL DEFAULT '130303',
2968 `Pot` int(11) NOT NULL,
2969 `Crack` int(11) NOT NULL DEFAULT '0',
2970 `Heroin` int(11) NOT NULL DEFAULT '0',
2971 `Syringes` int(11) NOT NULL DEFAULT '0',
2972 `Opium` int(11) NOT NULL DEFAULT '0',
2973 `TurfCapRank` int(11) NOT NULL DEFAULT '255',
2974 `PointCapRank` int(11) NOT NULL DEFAULT '255',
2975 `WithdrawRank` int(11) NOT NULL DEFAULT '255',
2976 `GClothes0` int(11) NOT NULL DEFAULT '0',
2977 `GClothes1` int(11) NOT NULL DEFAULT '0',
2978 `GClothes2` int(11) NOT NULL DEFAULT '0',
2979 `GClothes3` int(11) NOT NULL DEFAULT '0',
2980 `GClothes4` int(11) NOT NULL DEFAULT '0',
2981 `GClothes5` int(11) NOT NULL DEFAULT '0',
2982 `GClothes6` int(11) NOT NULL DEFAULT '0',
2983 `GClothes7` int(11) NOT NULL DEFAULT '0',
2984 `GClothes8` int(11) NOT NULL DEFAULT '0',
2985 `GClothes9` int(11) NOT NULL DEFAULT '0',
2986 `Mats` int(11) NOT NULL DEFAULT '0',
2987 `Tokens` int(11) NOT NULL DEFAULT '0',
2988 PRIMARY KEY (`id`)
2989) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2990
2991-- --------------------------------------------------------
2992
2993--
2994-- Table structure for table `groupvehs`
2995--
2996
2997CREATE TABLE IF NOT EXISTS `groupvehs` (
2998 `id` int(11) NOT NULL AUTO_INCREMENT,
2999 `SpawnedID` int(11) NOT NULL DEFAULT '65535',
3000 `vDisabled` tinyint(4) NOT NULL DEFAULT '0',
3001 `gID` int(11) NOT NULL DEFAULT '-1',
3002 `gDivID` int(11) NOT NULL DEFAULT '0',
3003 `vModel` int(11) NOT NULL DEFAULT '0',
3004 `vPlate` varchar(32) NOT NULL,
3005 `vMaxHealth` float NOT NULL DEFAULT '1000',
3006 `vFuel` int(11) NOT NULL DEFAULT '100',
3007 `vType` int(11) NOT NULL DEFAULT '0',
3008 `vLoadMax` int(11) NOT NULL DEFAULT '2',
3009 `vCol1` int(11) NOT NULL DEFAULT '0',
3010 `vCol2` int(11) NOT NULL DEFAULT '0',
3011 `vX` float NOT NULL DEFAULT '0',
3012 `vY` float NOT NULL DEFAULT '0',
3013 `vZ` float NOT NULL DEFAULT '0',
3014 `vRotZ` float NOT NULL DEFAULT '0',
3015 `vUpkeep` int(11) NOT NULL DEFAULT '0',
3016 `vMod0` int(11) NOT NULL DEFAULT '0',
3017 `vMod1` int(11) NOT NULL DEFAULT '0',
3018 `vMod2` int(11) NOT NULL DEFAULT '0',
3019 `vMod3` int(11) NOT NULL DEFAULT '0',
3020 `vMod4` int(11) NOT NULL DEFAULT '0',
3021 `vMod5` int(11) NOT NULL DEFAULT '0',
3022 `vMod6` int(11) NOT NULL DEFAULT '0',
3023 `vMod7` int(11) NOT NULL DEFAULT '0',
3024 `vMod8` int(11) NOT NULL DEFAULT '0',
3025 `vMod9` int(11) NOT NULL DEFAULT '0',
3026 `vMod10` int(11) NOT NULL DEFAULT '0',
3027 `vMod11` int(11) NOT NULL DEFAULT '0',
3028 `vMod12` int(11) NOT NULL DEFAULT '0',
3029 `vMod13` int(11) NOT NULL DEFAULT '0',
3030 `vMod14` int(11) NOT NULL DEFAULT '0',
3031 `vAttachedObjectModel1` int(11) NOT NULL DEFAULT '65535',
3032 `vObjectX1` float(11,2) NOT NULL DEFAULT '0.00',
3033 `vObjectY1` float(11,2) NOT NULL DEFAULT '0.00',
3034 `vObjectZ1` float(11,2) NOT NULL DEFAULT '0.00',
3035 `vObjectRX1` float(11,2) NOT NULL DEFAULT '0.00',
3036 `vObjectRY1` float(11,2) NOT NULL DEFAULT '0.00',
3037 `vObjectRZ1` float(11,2) NOT NULL DEFAULT '0.00',
3038 `vAttachedObjectModel2` int(11) NOT NULL DEFAULT '65535',
3039 `vObjectX2` float(11,2) NOT NULL DEFAULT '0.00',
3040 `vObjectY2` float(11,2) NOT NULL DEFAULT '0.00',
3041 `vObjectZ2` float(11,2) NOT NULL DEFAULT '0.00',
3042 `vObjectRX2` float(11,2) NOT NULL DEFAULT '0.00',
3043 `vObjectRY2` float(11,2) NOT NULL DEFAULT '0.00',
3044 `vObjectRZ2` float(11,2) NOT NULL DEFAULT '0.00',
3045 `vVW` int(11) NOT NULL DEFAULT '0',
3046 `vInt` int(11) NOT NULL DEFAULT '0',
3047 `fID` int(11) NOT NULL DEFAULT '0',
3048 `rID` int(11) NOT NULL DEFAULT '0',
3049 PRIMARY KEY (`id`)
3050) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3051
3052-- --------------------------------------------------------
3053
3054--
3055-- Table structure for table `groupvehss`
3056--
3057
3058CREATE TABLE IF NOT EXISTS `groupvehss` (
3059 `id` int(11) NOT NULL AUTO_INCREMENT,
3060 `SpawnedID` int(11) NOT NULL DEFAULT '65535',
3061 `vDisabled` tinyint(4) NOT NULL DEFAULT '0',
3062 `gID` int(11) NOT NULL DEFAULT '-1',
3063 `gDivID` int(11) NOT NULL DEFAULT '0',
3064 `vModel` int(11) NOT NULL DEFAULT '0',
3065 `vPlate` varchar(32) NOT NULL,
3066 `vMaxHealth` float NOT NULL DEFAULT '1000',
3067 `vFuel` int(11) NOT NULL DEFAULT '100',
3068 `vType` int(11) NOT NULL DEFAULT '0',
3069 `vLoadMax` int(11) NOT NULL DEFAULT '2',
3070 `vCol1` int(11) NOT NULL DEFAULT '0',
3071 `vCol2` int(11) NOT NULL DEFAULT '0',
3072 `vX` float NOT NULL DEFAULT '0',
3073 `vY` float NOT NULL DEFAULT '0',
3074 `vZ` float NOT NULL DEFAULT '0',
3075 `vRotZ` float NOT NULL DEFAULT '0',
3076 `vUpkeep` int(11) NOT NULL DEFAULT '0',
3077 `vMod0` int(11) NOT NULL DEFAULT '0',
3078 `vMod1` int(11) NOT NULL DEFAULT '0',
3079 `vMod2` int(11) NOT NULL DEFAULT '0',
3080 `vMod3` int(11) NOT NULL DEFAULT '0',
3081 `vMod4` int(11) NOT NULL DEFAULT '0',
3082 `vMod5` int(11) NOT NULL DEFAULT '0',
3083 `vMod6` int(11) NOT NULL DEFAULT '0',
3084 `vMod7` int(11) NOT NULL DEFAULT '0',
3085 `vMod8` int(11) NOT NULL DEFAULT '0',
3086 `vMod9` int(11) NOT NULL DEFAULT '0',
3087 `vMod10` int(11) NOT NULL DEFAULT '0',
3088 `vMod11` int(11) NOT NULL DEFAULT '0',
3089 `vMod12` int(11) NOT NULL DEFAULT '0',
3090 `vMod13` int(11) NOT NULL DEFAULT '0',
3091 `vMod14` int(11) NOT NULL DEFAULT '0',
3092 `vAttachedObjectModel1` int(11) NOT NULL DEFAULT '65535',
3093 `vObjectX1` float(11,2) NOT NULL DEFAULT '0.00',
3094 `vObjectY1` float(11,2) NOT NULL DEFAULT '0.00',
3095 `vObjectZ1` float(11,2) NOT NULL DEFAULT '0.00',
3096 `vObjectRX1` float(11,2) NOT NULL DEFAULT '0.00',
3097 `vObjectRY1` float(11,2) NOT NULL DEFAULT '0.00',
3098 `vObjectRZ1` float(11,2) NOT NULL DEFAULT '0.00',
3099 `vAttachedObjectModel2` int(11) NOT NULL DEFAULT '65535',
3100 `vObjectX2` float(11,2) NOT NULL DEFAULT '0.00',
3101 `vObjectY2` float(11,2) NOT NULL DEFAULT '0.00',
3102 `vObjectZ2` float(11,2) NOT NULL DEFAULT '0.00',
3103 `vObjectRX2` float(11,2) NOT NULL DEFAULT '0.00',
3104 `vObjectRY2` float(11,2) NOT NULL DEFAULT '0.00',
3105 `vObjectRZ2` float(11,2) NOT NULL DEFAULT '0.00',
3106 `vVW` int(11) NOT NULL DEFAULT '0',
3107 `vInt` int(11) NOT NULL DEFAULT '0',
3108 `fID` int(11) NOT NULL DEFAULT '0',
3109 `rID` int(11) NOT NULL,
3110 PRIMARY KEY (`id`)
3111) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3112
3113-- --------------------------------------------------------
3114
3115--
3116-- Table structure for table `gweapons`
3117--
3118
3119CREATE TABLE IF NOT EXISTS `gweapons` (
3120 `id` int(11) NOT NULL AUTO_INCREMENT,
3121 `Weapon_ID` int(11) NOT NULL DEFAULT '0',
3122 `Group_ID` int(11) NOT NULL DEFAULT '0',
3123 PRIMARY KEY (`id`)
3124) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
3125
3126-- --------------------------------------------------------
3127
3128--
3129-- Table structure for table `help_category`
3130--
3131
3132CREATE TABLE IF NOT EXISTS `help_category` (
3133 `help_category_id` smallint(5) unsigned NOT NULL DEFAULT '0',
3134 `name` varchar(64) NOT NULL DEFAULT '',
3135 `parent_category_id` smallint(5) unsigned DEFAULT NULL,
3136 `url` varchar(128) NOT NULL DEFAULT '',
3137 PRIMARY KEY (`help_category_id`),
3138 UNIQUE KEY `name` (`name`)
3139) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help categories';
3140
3141-- --------------------------------------------------------
3142
3143--
3144-- Table structure for table `help_keyword`
3145--
3146
3147CREATE TABLE IF NOT EXISTS `help_keyword` (
3148 `help_keyword_id` int(10) unsigned NOT NULL DEFAULT '0',
3149 `name` varchar(64) NOT NULL DEFAULT '',
3150 PRIMARY KEY (`help_keyword_id`),
3151 UNIQUE KEY `name` (`name`)
3152) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help keywords';
3153
3154-- --------------------------------------------------------
3155
3156--
3157-- Table structure for table `help_relation`
3158--
3159
3160CREATE TABLE IF NOT EXISTS `help_relation` (
3161 `help_topic_id` int(10) unsigned NOT NULL DEFAULT '0',
3162 `help_keyword_id` int(10) unsigned NOT NULL DEFAULT '0',
3163 PRIMARY KEY (`help_keyword_id`,`help_topic_id`)
3164) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='keyword-topic relation';
3165
3166-- --------------------------------------------------------
3167
3168--
3169-- Table structure for table `help_topic`
3170--
3171
3172CREATE TABLE IF NOT EXISTS `help_topic` (
3173 `help_topic_id` int(10) unsigned NOT NULL DEFAULT '0',
3174 `name` varchar(64) NOT NULL DEFAULT '',
3175 `help_category_id` smallint(5) unsigned NOT NULL DEFAULT '0',
3176 `description` text NOT NULL,
3177 `example` text NOT NULL,
3178 `url` varchar(128) NOT NULL DEFAULT '',
3179 PRIMARY KEY (`help_topic_id`),
3180 UNIQUE KEY `name` (`name`)
3181) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help topics';
3182
3183-- --------------------------------------------------------
3184
3185--
3186-- Table structure for table `hgbackpacks`
3187--
3188
3189CREATE TABLE IF NOT EXISTS `hgbackpacks` (
3190 `id` int(11) NOT NULL AUTO_INCREMENT,
3191 `type` int(11) NOT NULL,
3192 `posx` float(20,0) NOT NULL,
3193 `posy` float(20,0) NOT NULL,
3194 `posz` float(20,0) NOT NULL,
3195 PRIMARY KEY (`id`)
3196) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3197
3198-- --------------------------------------------------------
3199
3200--
3201-- Table structure for table `host`
3202--
3203
3204CREATE TABLE IF NOT EXISTS `host` (
3205 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
3206 `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
3207 `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3208 `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3209 `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3210 `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3211 `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3212 `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3213 `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3214 `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3215 `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3216 `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3217 `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3218 `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3219 `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3220 `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3221 `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3222 `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3223 `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3224 `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
3225 PRIMARY KEY (`Host`,`Db`)
3226) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Host privileges; Merged with database privileges';
3227
3228-- --------------------------------------------------------
3229
3230--
3231-- Table structure for table `houses`
3232--
3233
3234CREATE TABLE IF NOT EXISTS `houses` (
3235 `id` int(11) NOT NULL AUTO_INCREMENT,
3236 `Owned` int(11) NOT NULL DEFAULT '0',
3237 `Level` int(11) NOT NULL DEFAULT '999',
3238 `Description` varchar(16) NOT NULL DEFAULT 'High',
3239 `OwnerID` int(11) NOT NULL DEFAULT '-1',
3240 `OwnerName` varchar(24) NOT NULL DEFAULT 'Nobody',
3241 `Owner` varchar(24) NOT NULL DEFAULT 'No-Owner',
3242 `ExteriorX` float(10,5) NOT NULL DEFAULT '0.00000',
3243 `ExteriorY` float(10,5) NOT NULL DEFAULT '0.00000',
3244 `ExteriorZ` float(10,5) NOT NULL DEFAULT '0.00000',
3245 `ExteriorR` float(10,5) NOT NULL DEFAULT '0.00000',
3246 `InteriorX` float(10,5) NOT NULL DEFAULT '0.00000',
3247 `InteriorY` float(10,5) NOT NULL DEFAULT '0.00000',
3248 `InteriorZ` float(10,5) NOT NULL DEFAULT '0.00000',
3249 `InteriorR` float(10,5) NOT NULL DEFAULT '0.00000',
3250 `ExtIW` int(11) NOT NULL DEFAULT '0',
3251 `ExtVW` int(11) NOT NULL DEFAULT '0',
3252 `IntIW` int(11) NOT NULL DEFAULT '9',
3253 `IntVW` int(11) NOT NULL DEFAULT '0',
3254 `Lock` int(11) NOT NULL DEFAULT '0',
3255 `Rentable` int(11) NOT NULL DEFAULT '0',
3256 `RentFee` int(11) NOT NULL DEFAULT '0',
3257 `Value` int(11) NOT NULL DEFAULT '0',
3258 `SafeMoney` int(11) NOT NULL DEFAULT '0',
3259 `Pot` int(11) NOT NULL DEFAULT '0',
3260 `Crack` int(11) NOT NULL DEFAULT '0',
3261 `Materials` int(11) NOT NULL DEFAULT '0',
3262 `Weapons0` int(11) NOT NULL DEFAULT '0',
3263 `Weapons1` int(11) NOT NULL DEFAULT '0',
3264 `Weapons2` int(11) NOT NULL DEFAULT '0',
3265 `Weapons3` int(11) NOT NULL DEFAULT '0',
3266 `Weapons4` int(11) NOT NULL DEFAULT '0',
3267 `GLUpgrade` int(11) NOT NULL DEFAULT '0',
3268 `PickupID` int(11) NOT NULL DEFAULT '0',
3269 `CustomInterior` int(11) NOT NULL DEFAULT '0',
3270 `CustomExterior` int(11) NOT NULL DEFAULT '0',
3271 `ExteriorA` float(10,5) NOT NULL DEFAULT '0.00000',
3272 `InteriorA` float(10,5) NOT NULL DEFAULT '0.00000',
3273 `MailX` float(10,5) NOT NULL DEFAULT '0.00000',
3274 `MailY` float(10,5) NOT NULL DEFAULT '0.00000',
3275 `MailZ` float(10,5) NOT NULL DEFAULT '0.00000',
3276 `MailA` float(10,5) NOT NULL DEFAULT '0.00000',
3277 `MailType` tinyint(4) NOT NULL DEFAULT '0',
3278 `Heroin` int(11) NOT NULL DEFAULT '0',
3279 `ClosetX` float(10,5) NOT NULL DEFAULT '0.00000',
3280 `ClosetY` float(10,5) NOT NULL DEFAULT '0.00000',
3281 `ClosetZ` float(10,5) NOT NULL DEFAULT '0.00000',
3282 `SignDesc` varchar(255) NOT NULL DEFAULT 'None',
3283 `SignX` float(10,5) NOT NULL DEFAULT '0.00000',
3284 `SignY` float(10,5) NOT NULL DEFAULT '0.00000',
3285 `SignZ` float(10,5) NOT NULL DEFAULT '0.00000',
3286 `SignA` float(10,5) NOT NULL DEFAULT '0.00000',
3287 `SignExpire` int(11) NOT NULL DEFAULT '0',
3288 `LastLogin` int(11) NOT NULL DEFAULT '0',
3289 PRIMARY KEY (`id`)
3290) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3291
3292-- --------------------------------------------------------
3293
3294--
3295-- Table structure for table `house_closet`
3296--
3297
3298CREATE TABLE IF NOT EXISTS `house_closet` (
3299 `id` int(11) NOT NULL AUTO_INCREMENT,
3300 `playerid` int(11) NOT NULL,
3301 `skinid` int(3) NOT NULL,
3302 PRIMARY KEY (`id`)
3303) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3304
3305-- --------------------------------------------------------
3306
3307--
3308-- Table structure for table `humankills`
3309--
3310
3311CREATE TABLE IF NOT EXISTS `humankills` (
3312 `id` int(11) NOT NULL DEFAULT '0',
3313 `num` int(11) NOT NULL DEFAULT '0',
3314 PRIMARY KEY (`id`)
3315) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3316
3317-- --------------------------------------------------------
3318
3319--
3320-- Table structure for table `impoundpoints`
3321--
3322
3323CREATE TABLE IF NOT EXISTS `impoundpoints` (
3324 `id` int(2) NOT NULL AUTO_INCREMENT,
3325 `PosX` float(10,5) NOT NULL DEFAULT '0.00000',
3326 `PosY` float(10,5) NOT NULL DEFAULT '0.00000',
3327 `PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
3328 `VW` int(5) NOT NULL DEFAULT '0',
3329 `Int` int(5) NOT NULL DEFAULT '0',
3330 PRIMARY KEY (`id`)
3331) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3332
3333-- --------------------------------------------------------
3334
3335--
3336-- Table structure for table `ip_bans`
3337--
3338
3339CREATE TABLE IF NOT EXISTS `ip_bans` (
3340 `bid` int(10) unsigned NOT NULL AUTO_INCREMENT,
3341 `ip` varchar(32) NOT NULL,
3342 `date` datetime NOT NULL,
3343 `reason` varchar(128) NOT NULL,
3344 `admin` varchar(32) NOT NULL,
3345 PRIMARY KEY (`bid`)
3346) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3347
3348-- --------------------------------------------------------
3349
3350--
3351-- Table structure for table `jobstuff`
3352--
3353
3354CREATE TABLE IF NOT EXISTS `jobstuff` (
3355 `id` int(11) NOT NULL AUTO_INCREMENT,
3356 `pId` int(11) NOT NULL,
3357 `junkmetal` int(11) NOT NULL DEFAULT '0',
3358 `newcoin` int(11) NOT NULL DEFAULT '0',
3359 `oldcoin` int(11) NOT NULL DEFAULT '0',
3360 `brokenwatch` int(11) NOT NULL DEFAULT '0',
3361 `oldkey` int(11) NOT NULL DEFAULT '0',
3362 `treasure` int(11) NOT NULL DEFAULT '0',
3363 `goldwatch` int(11) NOT NULL DEFAULT '0',
3364 `silvernugget` int(11) NOT NULL DEFAULT '0',
3365 `goldnugget` int(11) NOT NULL DEFAULT '0',
3366 PRIMARY KEY (`id`)
3367) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3368
3369-- --------------------------------------------------------
3370
3371--
3372-- Table structure for table `jurisdictions`
3373--
3374
3375CREATE TABLE IF NOT EXISTS `jurisdictions` (
3376 `id` int(11) NOT NULL AUTO_INCREMENT,
3377 `GroupID` int(11) NOT NULL DEFAULT '-1',
3378 `JurisdictionID` int(2) NOT NULL DEFAULT '0',
3379 `AreaName` varchar(64) DEFAULT NULL,
3380 PRIMARY KEY (`id`)
3381) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3382
3383-- --------------------------------------------------------
3384
3385--
3386-- Table structure for table `kills`
3387--
3388
3389CREATE TABLE IF NOT EXISTS `kills` (
3390 `id` int(11) NOT NULL AUTO_INCREMENT,
3391 `killerid` int(11) NOT NULL DEFAULT '-1',
3392 `killedid` int(11) NOT NULL DEFAULT '-1',
3393 `date` datetime DEFAULT NULL,
3394 `weapon` varchar(56) DEFAULT '',
3395 PRIMARY KEY (`id`)
3396) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3397
3398-- --------------------------------------------------------
3399
3400--
3401-- Table structure for table `leaderboards`
3402--
3403
3404CREATE TABLE IF NOT EXISTS `leaderboards` (
3405 `Username` varchar(36) NOT NULL DEFAULT 'None',
3406 `seconds` int(11) NOT NULL DEFAULT '0',
3407 PRIMARY KEY (`Username`)
3408) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3409
3410-- --------------------------------------------------------
3411
3412--
3413-- Table structure for table `letters`
3414--
3415
3416CREATE TABLE IF NOT EXISTS `letters` (
3417 `Id` int(11) NOT NULL AUTO_INCREMENT,
3418 `Sender_Id` int(11) DEFAULT NULL,
3419 `Receiver_Id` int(11) DEFAULT NULL,
3420 `Date` datetime DEFAULT NULL,
3421 `Message` varchar(255) DEFAULT NULL,
3422 `Notify` varchar(1) DEFAULT NULL,
3423 `Delivery_Min` int(11) DEFAULT NULL,
3424 `Read` int(11) DEFAULT '0',
3425 PRIMARY KEY (`Id`)
3426) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3427
3428-- --------------------------------------------------------
3429
3430--
3431-- Table structure for table `lockers`
3432--
3433
3434CREATE TABLE IF NOT EXISTS `lockers` (
3435 `Id` int(11) NOT NULL AUTO_INCREMENT,
3436 `Group_ID` int(11) NOT NULL DEFAULT '-1',
3437 `Locker_ID` int(11) NOT NULL,
3438 `LockerX` float NOT NULL DEFAULT '0',
3439 `LockerY` float NOT NULL DEFAULT '0',
3440 `LockerZ` float NOT NULL DEFAULT '0',
3441 `LockerVW` int(11) NOT NULL DEFAULT '0',
3442 `LockerShare` tinyint(4) NOT NULL DEFAULT '0',
3443 PRIMARY KEY (`Id`)
3444) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3445
3446-- --------------------------------------------------------
3447
3448--
3449-- Table structure for table `login_strikes`
3450--
3451
3452CREATE TABLE IF NOT EXISTS `login_strikes` (
3453 `id` int(11) NOT NULL AUTO_INCREMENT,
3454 `ip_address` varchar(15) NOT NULL,
3455 `username` varchar(128) DEFAULT NULL,
3456 `date` datetime NOT NULL,
3457 PRIMARY KEY (`id`)
3458) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3459
3460-- --------------------------------------------------------
3461
3462--
3463-- Table structure for table `lotto`
3464--
3465
3466CREATE TABLE IF NOT EXISTS `lotto` (
3467 `tid` int(11) NOT NULL AUTO_INCREMENT,
3468 `id` int(11) NOT NULL,
3469 `number` int(11) NOT NULL,
3470 PRIMARY KEY (`tid`) USING BTREE
3471) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3472
3473-- --------------------------------------------------------
3474
3475--
3476-- Table structure for table `mail2`
3477--
3478
3479CREATE TABLE IF NOT EXISTS `mail2` (
3480 `id` int(11) NOT NULL AUTO_INCREMENT,
3481 `Owned` int(11) NOT NULL DEFAULT '0',
3482 `Level` int(11) NOT NULL DEFAULT '999',
3483 `Description` varchar(16) NOT NULL DEFAULT 'High',
3484 `OwnerID` int(11) NOT NULL DEFAULT '-1',
3485 `OwnerName` varchar(24) NOT NULL DEFAULT 'Nobody',
3486 `Owner` varchar(24) NOT NULL DEFAULT 'No-Owner',
3487 `ExteriorX` float(10,5) NOT NULL DEFAULT '0.00000',
3488 `ExteriorY` float(10,5) NOT NULL DEFAULT '0.00000',
3489 `ExteriorZ` float(10,5) NOT NULL DEFAULT '0.00000',
3490 `ExteriorR` float(10,5) NOT NULL DEFAULT '0.00000',
3491 `InteriorX` float(10,5) NOT NULL DEFAULT '0.00000',
3492 `InteriorY` float(10,5) NOT NULL DEFAULT '0.00000',
3493 `InteriorZ` float(10,5) NOT NULL DEFAULT '0.00000',
3494 `InteriorR` float(10,5) NOT NULL DEFAULT '0.00000',
3495 `ExtIW` int(11) NOT NULL DEFAULT '0',
3496 `ExtVW` int(11) NOT NULL DEFAULT '0',
3497 `IntIW` int(11) NOT NULL DEFAULT '9',
3498 `IntVW` int(11) NOT NULL DEFAULT '0',
3499 `Lock` int(11) NOT NULL DEFAULT '0',
3500 `Rentable` int(11) NOT NULL DEFAULT '0',
3501 `RentFee` int(11) NOT NULL DEFAULT '0',
3502 `Value` int(11) NOT NULL DEFAULT '0',
3503 `SafeMoney` int(11) NOT NULL DEFAULT '0',
3504 `Pot` int(11) NOT NULL DEFAULT '0',
3505 `Crack` int(11) NOT NULL DEFAULT '0',
3506 `Materials` int(11) NOT NULL DEFAULT '0',
3507 `Weapons0` int(11) NOT NULL DEFAULT '0',
3508 `Weapons1` int(11) NOT NULL DEFAULT '0',
3509 `Weapons2` int(11) NOT NULL DEFAULT '0',
3510 `Weapons3` int(11) NOT NULL DEFAULT '0',
3511 `Weapons4` int(11) NOT NULL DEFAULT '0',
3512 `GLUpgrade` int(11) NOT NULL DEFAULT '0',
3513 `PickupID` int(11) NOT NULL DEFAULT '0',
3514 `CustomInterior` int(11) NOT NULL DEFAULT '0',
3515 `CustomExterior` int(11) NOT NULL DEFAULT '0',
3516 `ExteriorA` float(10,5) NOT NULL DEFAULT '0.00000',
3517 `InteriorA` float(10,5) NOT NULL DEFAULT '0.00000',
3518 `MailX` float(10,5) NOT NULL DEFAULT '0.00000',
3519 `MailY` float(10,5) NOT NULL DEFAULT '0.00000',
3520 `MailZ` float(10,5) NOT NULL DEFAULT '0.00000',
3521 `MailA` float(10,5) NOT NULL DEFAULT '0.00000',
3522 `MailType` tinyint(4) NOT NULL DEFAULT '0',
3523 `Heroin` int(11) NOT NULL DEFAULT '0',
3524 `ClosetX` float(10,5) NOT NULL DEFAULT '0.00000',
3525 `ClosetY` float(10,5) NOT NULL DEFAULT '0.00000',
3526 `ClosetZ` float(10,5) NOT NULL DEFAULT '0.00000',
3527 PRIMARY KEY (`id`)
3528) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3529
3530-- --------------------------------------------------------
3531
3532--
3533-- Table structure for table `mailboxes`
3534--
3535
3536CREATE TABLE IF NOT EXISTS `mailboxes` (
3537 `ID` int(11) NOT NULL AUTO_INCREMENT,
3538 `VW` int(11) NOT NULL DEFAULT '0',
3539 `Int` int(11) NOT NULL DEFAULT '0',
3540 `Model` int(11) NOT NULL DEFAULT '3407',
3541 `PosX` float(10,5) NOT NULL DEFAULT '0.00000',
3542 `PosY` float(10,5) NOT NULL DEFAULT '0.00000',
3543 `PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
3544 `Angle` float NOT NULL DEFAULT '0',
3545 PRIMARY KEY (`ID`)
3546) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3547
3548-- --------------------------------------------------------
3549
3550--
3551-- Table structure for table `mdc`
3552--
3553
3554CREATE TABLE IF NOT EXISTS `mdc` (
3555 `cid` int(11) NOT NULL AUTO_INCREMENT,
3556 `id` int(11) NOT NULL,
3557 `time` datetime NOT NULL,
3558 `issuer` varchar(24) NOT NULL,
3559 `crime` varchar(128) NOT NULL,
3560 `active` tinyint(2) DEFAULT '1',
3561 PRIMARY KEY (`cid`)
3562) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3563
3564-- --------------------------------------------------------
3565
3566--
3567-- Table structure for table `misc`
3568--
3569
3570CREATE TABLE IF NOT EXISTS `misc` (
3571 `gMOTD` varchar(256) NOT NULL,
3572 `aMOTD` varchar(256) NOT NULL,
3573 `vMOTD` varchar(256) NOT NULL,
3574 `cMOTD` varchar(256) NOT NULL,
3575 `pMOTD` varchar(256) NOT NULL,
3576 `ShopTechPay` float(11,1) NOT NULL DEFAULT '0.5',
3577 `Safe` int(11) NOT NULL DEFAULT '0',
3578 `TicketsSold` int(11) NOT NULL DEFAULT '0',
3579 `GiftCode` varchar(32) NOT NULL DEFAULT 'off',
3580 `GiftCodeBypass` int(11) NOT NULL DEFAULT '0',
3581 `TotalCitizens` int(11) NOT NULL DEFAULT '0',
3582 `TRCitizens` int(11) NOT NULL DEFAULT '0',
3583 `SecurityCode` varchar(128) NOT NULL,
3584 `ShopClosed` int(11) NOT NULL DEFAULT '0',
3585 `RimMod` int(11) NOT NULL DEFAULT '0',
3586 `CarVoucher` int(11) NOT NULL DEFAULT '0',
3587 `PVIPVoucher` int(11) NOT NULL DEFAULT '0',
3588 `PVIPAmount` int(11) NOT NULL DEFAULT '0',
3589 `GarageVW` int(11) NOT NULL DEFAULT '0',
3590 `PumpkinStock` int(11) NOT NULL,
3591 `HalloweenShop` int(11) NOT NULL,
3592 `PassComplexCheck` int(11) NOT NULL DEFAULT '0'
3593) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3594
3595-- --------------------------------------------------------
3596
3597--
3598-- Table structure for table `nation_queue`
3599--
3600
3601CREATE TABLE IF NOT EXISTS `nation_queue` (
3602 `id` int(11) NOT NULL AUTO_INCREMENT,
3603 `playerid` int(11) NOT NULL,
3604 `name` varchar(24) DEFAULT NULL,
3605 `date` datetime NOT NULL,
3606 `nation` int(1) NOT NULL,
3607 `status` int(1) NOT NULL DEFAULT '1',
3608 PRIMARY KEY (`id`)
3609) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3610
3611-- --------------------------------------------------------
3612
3613--
3614-- Table structure for table `ndb_binlog_index`
3615--
3616
3617CREATE TABLE IF NOT EXISTS `ndb_binlog_index` (
3618 `Position` bigint(20) unsigned NOT NULL,
3619 `File` varchar(255) NOT NULL,
3620 `epoch` bigint(20) unsigned NOT NULL,
3621 `inserts` bigint(20) unsigned NOT NULL,
3622 `updates` bigint(20) unsigned NOT NULL,
3623 `deletes` bigint(20) unsigned NOT NULL,
3624 `schemaops` bigint(20) unsigned NOT NULL,
3625 PRIMARY KEY (`epoch`)
3626) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3627
3628-- --------------------------------------------------------
3629
3630--
3631-- Table structure for table `nonrppoints`
3632--
3633
3634CREATE TABLE IF NOT EXISTS `nonrppoints` (
3635 `sqlid` int(11) NOT NULL DEFAULT '0',
3636 `point` int(11) NOT NULL DEFAULT '0',
3637 `expiration` int(11) NOT NULL DEFAULT '0',
3638 `reason` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT 'N/A',
3639 `issuer` int(11) NOT NULL DEFAULT '0',
3640 `active` int(11) NOT NULL DEFAULT '0',
3641 `manual` int(11) NOT NULL DEFAULT '0'
3642) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
3643
3644-- --------------------------------------------------------
3645
3646--
3647-- Table structure for table `orders`
3648--
3649
3650CREATE TABLE IF NOT EXISTS `orders` (
3651 `id` int(11) NOT NULL DEFAULT '0',
3652 PRIMARY KEY (`id`)
3653) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3654
3655-- --------------------------------------------------------
3656
3657--
3658-- Table structure for table `paynsprays`
3659--
3660
3661CREATE TABLE IF NOT EXISTS `paynsprays` (
3662 `id` int(11) NOT NULL AUTO_INCREMENT,
3663 `Status` int(1) NOT NULL DEFAULT '0',
3664 `PosX` float(10,5) NOT NULL DEFAULT '0.00000',
3665 `PosY` float(10,5) NOT NULL DEFAULT '0.00000',
3666 `PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
3667 `VW` int(11) NOT NULL DEFAULT '0',
3668 `Int` int(11) NOT NULL DEFAULT '0',
3669 `GroupCost` int(11) NOT NULL DEFAULT '0',
3670 `RegCost` int(11) NOT NULL DEFAULT '0',
3671 PRIMARY KEY (`id`)
3672) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3673
3674-- --------------------------------------------------------
3675
3676--
3677-- Table structure for table `plants`
3678--
3679
3680CREATE TABLE IF NOT EXISTS `plants` (
3681 `plantID` int(11) NOT NULL AUTO_INCREMENT,
3682 `Owner` int(11) NOT NULL DEFAULT '0',
3683 `Object` int(11) NOT NULL DEFAULT '0',
3684 `PlantType` int(11) NOT NULL DEFAULT '0',
3685 `PositionX` float NOT NULL DEFAULT '0',
3686 `PositionY` float NOT NULL DEFAULT '0',
3687 `PositionZ` float NOT NULL DEFAULT '0',
3688 `Virtual` int(11) NOT NULL DEFAULT '0',
3689 `Interior` int(11) NOT NULL DEFAULT '0',
3690 `Growth` int(11) NOT NULL DEFAULT '0',
3691 `Expires` int(11) NOT NULL DEFAULT '0',
3692 `DrugsSkill` int(11) NOT NULL DEFAULT '0',
3693 PRIMARY KEY (`plantID`)
3694) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3695
3696-- --------------------------------------------------------
3697
3698--
3699-- Table structure for table `plugin`
3700--
3701
3702CREATE TABLE IF NOT EXISTS `plugin` (
3703 `name` varchar(64) NOT NULL DEFAULT '',
3704 `dl` varchar(128) NOT NULL DEFAULT '',
3705 PRIMARY KEY (`name`)
3706) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL plugins';
3707
3708-- --------------------------------------------------------
3709
3710--
3711-- Table structure for table `points`
3712--
3713
3714CREATE TABLE IF NOT EXISTS `points` (
3715 `id` int(11) NOT NULL AUTO_INCREMENT,
3716 `posx` float(20,5) NOT NULL DEFAULT '0.00000',
3717 `posy` float(20,5) NOT NULL DEFAULT '0.00000',
3718 `posz` float(20,5) NOT NULL DEFAULT '0.00000',
3719 `vw` int(11) NOT NULL,
3720 `type` int(11) NOT NULL DEFAULT '0',
3721 `vulnerable` int(11) NOT NULL DEFAULT '0',
3722 `matpoint` int(11) NOT NULL DEFAULT '0',
3723 `owner` varchar(128) DEFAULT NULL,
3724 `cappername` varchar(24) DEFAULT NULL,
3725 `name` varchar(128) DEFAULT NULL,
3726 `captime` int(11) NOT NULL DEFAULT '0',
3727 `capfam` int(11) NOT NULL DEFAULT '255',
3728 `capname` varchar(24) NOT NULL DEFAULT 'NULL',
3729 PRIMARY KEY (`id`)
3730) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3731
3732-- --------------------------------------------------------
3733
3734--
3735-- Table structure for table `proc`
3736--
3737
3738CREATE TABLE IF NOT EXISTS `proc` (
3739 `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
3740 `name` char(64) NOT NULL DEFAULT '',
3741 `type` enum('FUNCTION','PROCEDURE') NOT NULL,
3742 `specific_name` char(64) NOT NULL DEFAULT '',
3743 `language` enum('SQL') NOT NULL DEFAULT 'SQL',
3744 `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
3745 `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',
3746 `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
3747 `param_list` blob NOT NULL,
3748 `returns` longblob NOT NULL,
3749 `body` longblob NOT NULL,
3750 `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
3751 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3752 `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
3753 `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
3754 `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
3755 `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
3756 `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
3757 `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
3758 `body_utf8` longblob,
3759 PRIMARY KEY (`db`,`name`,`type`)
3760) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures';
3761
3762-- --------------------------------------------------------
3763
3764--
3765-- Table structure for table `procs_priv`
3766--
3767
3768CREATE TABLE IF NOT EXISTS `procs_priv` (
3769 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
3770 `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
3771 `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
3772 `Routine_name` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
3773 `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,
3774 `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
3775 `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',
3776 `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3777 PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
3778 KEY `Grantor` (`Grantor`)
3779) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges';
3780
3781-- --------------------------------------------------------
3782
3783--
3784-- Table structure for table `proxies_priv`
3785--
3786
3787CREATE TABLE IF NOT EXISTS `proxies_priv` (
3788 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
3789 `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
3790 `Proxied_host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
3791 `Proxied_user` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
3792 `With_grant` tinyint(1) NOT NULL DEFAULT '0',
3793 `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
3794 `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3795 PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
3796 KEY `Grantor` (`Grantor`)
3797) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User proxy privileges';
3798
3799-- --------------------------------------------------------
3800
3801--
3802-- Table structure for table `pvehpositions`
3803--
3804
3805CREATE TABLE IF NOT EXISTS `pvehpositions` (
3806 `id` int(11) NOT NULL DEFAULT '-1',
3807 `pv0ModelId` int(11) NOT NULL DEFAULT '0',
3808 `pv0PosX` float(10,5) NOT NULL DEFAULT '0.00000',
3809 `pv0PosY` float(10,5) NOT NULL DEFAULT '0.00000',
3810 `pv0PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
3811 `pv0PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
3812 `pv1ModelId` int(11) NOT NULL DEFAULT '0',
3813 `pv1PosX` float(10,5) NOT NULL DEFAULT '0.00000',
3814 `pv1PosY` float(10,5) NOT NULL DEFAULT '0.00000',
3815 `pv1PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
3816 `pv1PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
3817 `pv2ModelId` int(11) NOT NULL DEFAULT '0',
3818 `pv2PosX` float(10,5) NOT NULL DEFAULT '0.00000',
3819 `pv2PosY` float(10,5) NOT NULL DEFAULT '0.00000',
3820 `pv2PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
3821 `pv2PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
3822 `pv3ModelId` int(11) NOT NULL DEFAULT '0',
3823 `pv3PosX` float(10,5) NOT NULL DEFAULT '0.00000',
3824 `pv3PosY` float(10,5) NOT NULL DEFAULT '0.00000',
3825 `pv3PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
3826 `pv3PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
3827 `pv4ModelId` int(11) NOT NULL DEFAULT '0',
3828 `pv4PosX` float(10,5) NOT NULL DEFAULT '0.00000',
3829 `pv4PosY` float(10,5) NOT NULL DEFAULT '0.00000',
3830 `pv4PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
3831 `pv4PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
3832 `pv5ModelId` int(11) NOT NULL DEFAULT '0',
3833 `pv5PosX` float(10,5) NOT NULL DEFAULT '0.00000',
3834 `pv5PosY` float(10,5) NOT NULL DEFAULT '0.00000',
3835 `pv5PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
3836 `pv5PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
3837 `pv6ModelId` int(11) NOT NULL DEFAULT '0',
3838 `pv6PosX` float(10,5) NOT NULL DEFAULT '0.00000',
3839 `pv6PosY` float(10,5) NOT NULL DEFAULT '0.00000',
3840 `pv6PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
3841 `pv6PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
3842 `pv7ModelId` int(11) NOT NULL DEFAULT '0',
3843 `pv7PosX` float(10,5) NOT NULL DEFAULT '0.00000',
3844 `pv7PosY` float(10,5) NOT NULL DEFAULT '0.00000',
3845 `pv7PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
3846 `pv7PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
3847 `pv8ModelId` int(11) NOT NULL DEFAULT '0',
3848 `pv8PosX` float(10,5) NOT NULL DEFAULT '0.00000',
3849 `pv8PosY` float(10,5) NOT NULL DEFAULT '0.00000',
3850 `pv8PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
3851 `pv8PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
3852 `pv9ModelId` int(11) NOT NULL DEFAULT '0',
3853 `pv9PosX` float(10,5) NOT NULL DEFAULT '0.00000',
3854 `pv9PosY` float(10,5) NOT NULL DEFAULT '0.00000',
3855 `pv9PosZ` float(10,5) NOT NULL DEFAULT '0.00000',
3856 `pv9PosAngle` float(10,5) NOT NULL DEFAULT '0.00000',
3857 PRIMARY KEY (`id`)
3858) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3859
3860-- --------------------------------------------------------
3861
3862--
3863-- Table structure for table `rentedcars`
3864--
3865
3866CREATE TABLE IF NOT EXISTS `rentedcars` (
3867 `id` int(11) NOT NULL AUTO_INCREMENT,
3868 `sqlid` int(11) DEFAULT '0',
3869 `modelid` int(11) DEFAULT '0',
3870 `posx` float DEFAULT '0',
3871 `posy` float DEFAULT '0',
3872 `posz` float DEFAULT '0',
3873 `posa` float DEFAULT '0',
3874 `spawned` int(11) DEFAULT '0',
3875 `hours` int(11) DEFAULT '0',
3876 PRIMARY KEY (`id`)
3877) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3878
3879-- --------------------------------------------------------
3880
3881--
3882-- Table structure for table `requestcomments`
3883--
3884
3885CREATE TABLE IF NOT EXISTS `requestcomments` (
3886 `id` int(11) NOT NULL AUTO_INCREMENT,
3887 `rid` int(11) NOT NULL,
3888 `user` varchar(255) NOT NULL,
3889 `comment` text NOT NULL,
3890 `ip` varchar(255) NOT NULL,
3891 `time` int(255) NOT NULL,
3892 PRIMARY KEY (`id`)
3893) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3894
3895-- --------------------------------------------------------
3896
3897--
3898-- Table structure for table `requests`
3899--
3900
3901CREATE TABLE IF NOT EXISTS `requests` (
3902 `id` int(11) NOT NULL AUTO_INCREMENT,
3903 `requestedBy` varchar(255) NOT NULL,
3904 `time` int(255) NOT NULL,
3905 `details` text NOT NULL,
3906 `gdoc` text NOT NULL,
3907 `assignedTo` varchar(255) NOT NULL,
3908 `priority` int(2) NOT NULL,
3909 `value` int(50) NOT NULL,
3910 `status` int(2) NOT NULL,
3911 `progress` int(255) NOT NULL,
3912 `title` varchar(255) NOT NULL,
3913 `deleted` tinyint(4) NOT NULL DEFAULT '0',
3914 PRIMARY KEY (`id`)
3915) ENGINE=MyISAM DEFAULT CHARSET=latin1;
3916
3917-- --------------------------------------------------------
3918
3919--
3920-- Table structure for table `rewardcalc`
3921--
3922
3923CREATE TABLE IF NOT EXISTS `rewardcalc` (
3924 `pID` int(11) NOT NULL
3925) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3926
3927-- --------------------------------------------------------
3928
3929--
3930-- Table structure for table `rflteams`
3931--
3932
3933CREATE TABLE IF NOT EXISTS `rflteams` (
3934 `id` int(11) NOT NULL AUTO_INCREMENT,
3935 `name` varchar(24) CHARACTER SET utf8 NOT NULL,
3936 `leader` varchar(24) CHARACTER SET utf8 NOT NULL,
3937 `used` int(11) NOT NULL,
3938 `members` int(11) NOT NULL,
3939 `laps` int(11) NOT NULL,
3940 PRIMARY KEY (`id`)
3941) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
3942
3943-- --------------------------------------------------------
3944
3945--
3946-- Table structure for table `sales`
3947--
3948
3949CREATE TABLE IF NOT EXISTS `sales` (
3950 `id` int(11) NOT NULL AUTO_INCREMENT,
3951 `Month` datetime NOT NULL,
3952 `TotalSold0` int(11) NOT NULL DEFAULT '0',
3953 `AmountMade0` int(11) NOT NULL DEFAULT '0',
3954 `TotalSold1` int(11) NOT NULL DEFAULT '0',
3955 `AmountMade1` int(11) NOT NULL DEFAULT '0',
3956 `TotalSold2` int(11) NOT NULL DEFAULT '0',
3957 `AmountMade2` int(11) NOT NULL DEFAULT '0',
3958 `TotalSold3` int(11) NOT NULL DEFAULT '0',
3959 `AmountMade3` int(11) NOT NULL DEFAULT '0',
3960 `TotalSold4` int(11) NOT NULL DEFAULT '0',
3961 `AmountMade4` int(11) NOT NULL DEFAULT '0',
3962 `TotalSold5` int(11) NOT NULL DEFAULT '0',
3963 `AmountMade5` int(11) NOT NULL DEFAULT '0',
3964 `TotalSold6` int(11) NOT NULL DEFAULT '0',
3965 `AmountMade6` int(11) NOT NULL DEFAULT '0',
3966 `TotalSold7` int(11) NOT NULL DEFAULT '0',
3967 `AmountMade7` int(11) NOT NULL DEFAULT '0',
3968 `TotalSold8` int(11) NOT NULL DEFAULT '0',
3969 `AmountMade8` int(11) NOT NULL DEFAULT '0',
3970 `TotalSold9` int(11) NOT NULL DEFAULT '0',
3971 `AmountMade9` int(11) NOT NULL DEFAULT '0',
3972 `TotalSold10` int(11) NOT NULL DEFAULT '0',
3973 `AmountMade10` int(11) NOT NULL DEFAULT '0',
3974 `TotalSold11` int(11) NOT NULL DEFAULT '0',
3975 `AmountMade11` int(11) NOT NULL DEFAULT '0',
3976 `TotalSold12` int(11) NOT NULL DEFAULT '0',
3977 `AmountMade12` int(11) NOT NULL DEFAULT '0',
3978 `TotalSold13` int(11) NOT NULL DEFAULT '0',
3979 `AmountMade13` int(11) NOT NULL DEFAULT '0',
3980 `TotalSold14` int(11) NOT NULL DEFAULT '0',
3981 `AmountMade14` int(11) NOT NULL DEFAULT '0',
3982 `TotalSold15` int(11) NOT NULL DEFAULT '0',
3983 `AmountMade15` int(11) NOT NULL DEFAULT '0',
3984 `TotalSold16` int(11) NOT NULL DEFAULT '0',
3985 `AmountMade16` int(11) NOT NULL DEFAULT '0',
3986 `TotalSold17` int(11) NOT NULL DEFAULT '0',
3987 `AmountMade17` int(11) NOT NULL DEFAULT '0',
3988 `TotalSold18` int(11) NOT NULL DEFAULT '0',
3989 `AmountMade18` int(11) NOT NULL DEFAULT '0',
3990 `TotalSold19` int(11) NOT NULL DEFAULT '0',
3991 `AmountMade19` int(11) NOT NULL DEFAULT '0',
3992 `TotalSold20` int(11) NOT NULL DEFAULT '0',
3993 `AmountMade20` int(11) NOT NULL DEFAULT '0',
3994 `TotalSold21` int(11) NOT NULL DEFAULT '0',
3995 `AmountMade21` int(11) NOT NULL DEFAULT '0',
3996 `TotalSold22` int(11) NOT NULL DEFAULT '0',
3997 `AmountMade22` int(11) NOT NULL DEFAULT '0',
3998 `TotalSold23` int(11) NOT NULL DEFAULT '0',
3999 `AmountMade23` int(11) NOT NULL DEFAULT '0',
4000 `TotalSold24` int(11) NOT NULL DEFAULT '0',
4001 `AmountMade24` int(11) NOT NULL DEFAULT '0',
4002 `TotalSold25` int(11) NOT NULL DEFAULT '0',
4003 `AmountMade25` int(11) NOT NULL DEFAULT '0',
4004 `TotalSold26` int(11) NOT NULL DEFAULT '0',
4005 `AmountMade26` int(11) NOT NULL DEFAULT '0',
4006 `TotalSold27` int(11) NOT NULL DEFAULT '0',
4007 `AmountMade27` int(11) NOT NULL DEFAULT '0',
4008 `TotalSold28` int(11) NOT NULL DEFAULT '0',
4009 `AmountMade28` int(11) NOT NULL DEFAULT '0',
4010 `TotalSold29` int(11) NOT NULL DEFAULT '0',
4011 `AmountMade29` int(11) NOT NULL DEFAULT '0',
4012 `TotalSold30` int(11) NOT NULL,
4013 `AmountMade30` int(11) NOT NULL,
4014 `TotalSold31` int(11) NOT NULL,
4015 `AmountMade31` int(11) NOT NULL,
4016 `TotalSold32` int(11) NOT NULL,
4017 `AmountMade32` int(11) NOT NULL,
4018 `TotalSold33` int(11) NOT NULL,
4019 `AmountMade33` int(11) NOT NULL,
4020 `TotalSold34` int(11) NOT NULL,
4021 `AmountMade34` int(11) NOT NULL,
4022 `TotalSold35` int(11) NOT NULL DEFAULT '0',
4023 `AmountMade35` int(11) NOT NULL,
4024 `TotalSold36` int(11) NOT NULL DEFAULT '0',
4025 `AmountMade36` int(11) NOT NULL DEFAULT '0',
4026 `TotalSold37` int(11) NOT NULL DEFAULT '0',
4027 `AmountMade37` int(11) NOT NULL DEFAULT '0',
4028 `TotalSold38` int(11) NOT NULL DEFAULT '0',
4029 `AmountMade38` int(11) NOT NULL DEFAULT '0',
4030 `TotalSold39` int(11) NOT NULL DEFAULT '0',
4031 `AmountMade39` int(11) NOT NULL,
4032 `TotalSoldMicro` varchar(512) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0|0',
4033 `AmountMadeMicro` varchar(512) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0|0',
4034 `TotalSold40` int(11) NOT NULL DEFAULT '0',
4035 `AmountMade40` int(11) NOT NULL DEFAULT '0',
4036 PRIMARY KEY (`id`) USING BTREE
4037) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4038
4039-- --------------------------------------------------------
4040
4041--
4042-- Table structure for table `sec_questions`
4043--
4044
4045CREATE TABLE IF NOT EXISTS `sec_questions` (
4046 `userid` int(11) NOT NULL,
4047 `question` varchar(256) NOT NULL,
4048 `answer` varchar(256) NOT NULL,
4049 PRIMARY KEY (`userid`)
4050) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4051
4052-- --------------------------------------------------------
4053
4054--
4055-- Table structure for table `servers`
4056--
4057
4058CREATE TABLE IF NOT EXISTS `servers` (
4059 `Server_name` char(64) NOT NULL DEFAULT '',
4060 `Host` char(64) NOT NULL DEFAULT '',
4061 `Db` char(64) NOT NULL DEFAULT '',
4062 `Username` char(64) NOT NULL DEFAULT '',
4063 `Password` char(64) NOT NULL DEFAULT '',
4064 `Port` int(4) NOT NULL DEFAULT '0',
4065 `Socket` char(64) NOT NULL DEFAULT '',
4066 `Wrapper` char(64) NOT NULL DEFAULT '',
4067 `Owner` char(64) NOT NULL DEFAULT '',
4068 PRIMARY KEY (`Server_name`)
4069) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';
4070
4071-- --------------------------------------------------------
4072
4073--
4074-- Table structure for table `shop`
4075--
4076
4077CREATE TABLE IF NOT EXISTS `shop` (
4078 `order_product_id` int(11) NOT NULL,
4079 `order_id` int(11) NOT NULL DEFAULT '0',
4080 `product_id` int(11) NOT NULL DEFAULT '0',
4081 `status` tinyint(2) NOT NULL DEFAULT '0',
4082 `name` varchar(64) NOT NULL DEFAULT '',
4083 `price` decimal(15,4) NOT NULL DEFAULT '0.0000',
4084 `quantity` int(4) NOT NULL DEFAULT '0',
4085 `delivered` tinyint(1) NOT NULL DEFAULT '0',
4086 `updatedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
4087 `deliveruser` varchar(32) NOT NULL DEFAULT '',
4088 `ip` varchar(32) NOT NULL DEFAULT '',
4089 `email` varchar(256) NOT NULL DEFAULT '',
4090 PRIMARY KEY (`order_product_id`)
4091) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4092
4093-- --------------------------------------------------------
4094
4095--
4096-- Table structure for table `shopprices`
4097--
4098
4099CREATE TABLE IF NOT EXISTS `shopprices` (
4100 `Price0` int(11) NOT NULL DEFAULT '0',
4101 `Price1` int(11) NOT NULL DEFAULT '0',
4102 `Price2` int(11) NOT NULL DEFAULT '0',
4103 `Price3` int(11) NOT NULL DEFAULT '0',
4104 `Price4` int(11) NOT NULL DEFAULT '0',
4105 `Price5` int(11) NOT NULL DEFAULT '0',
4106 `Price6` int(11) NOT NULL DEFAULT '0',
4107 `Price7` int(11) NOT NULL DEFAULT '0',
4108 `Price8` int(11) NOT NULL DEFAULT '0',
4109 `Price9` int(11) NOT NULL DEFAULT '0',
4110 `Price10` int(11) NOT NULL DEFAULT '0',
4111 `Price11` int(11) NOT NULL DEFAULT '0',
4112 `Price12` int(11) NOT NULL DEFAULT '0',
4113 `Price13` int(11) NOT NULL DEFAULT '0',
4114 `Price14` int(11) NOT NULL DEFAULT '0',
4115 `Price15` int(11) NOT NULL DEFAULT '0',
4116 `Price16` int(11) NOT NULL DEFAULT '0',
4117 `Price17` int(11) NOT NULL DEFAULT '0',
4118 `Price18` int(11) NOT NULL DEFAULT '0',
4119 `Price19` int(11) NOT NULL,
4120 `Price20` int(11) NOT NULL DEFAULT '0',
4121 `Price21` int(11) NOT NULL DEFAULT '0',
4122 `Price22` int(11) NOT NULL DEFAULT '0',
4123 `Price23` int(11) NOT NULL DEFAULT '0',
4124 `Price24` int(11) NOT NULL DEFAULT '0',
4125 `Price25` int(11) NOT NULL DEFAULT '0',
4126 `Price26` int(11) NOT NULL DEFAULT '0',
4127 `Price27` int(11) NOT NULL DEFAULT '0',
4128 `Price28` int(11) NOT NULL DEFAULT '0',
4129 `Price29` int(11) NOT NULL DEFAULT '0',
4130 `Price30` int(11) NOT NULL DEFAULT '0',
4131 `Price31` int(11) NOT NULL DEFAULT '0',
4132 `Price32` int(11) NOT NULL DEFAULT '0',
4133 `Price33` int(11) NOT NULL DEFAULT '0',
4134 `Price34` int(11) NOT NULL DEFAULT '0',
4135 `Price35` int(11) NOT NULL DEFAULT '0',
4136 `Price36` int(11) NOT NULL DEFAULT '0',
4137 `Price37` int(11) NOT NULL DEFAULT '0',
4138 `Price38` int(11) NOT NULL DEFAULT '0',
4139 `Price39` int(11) NOT NULL DEFAULT '0',
4140 `MicroPrices` varchar(255) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0|0',
4141 `Price40` int(11) NOT NULL DEFAULT '0',
4142 PRIMARY KEY (`Price0`),
4143 KEY `Price31` (`Price31`,`Price32`,`Price33`,`Price34`)
4144) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4145
4146-- --------------------------------------------------------
4147
4148--
4149-- Table structure for table `shoptech`
4150--
4151
4152CREATE TABLE IF NOT EXISTS `shoptech` (
4153 `id` int(11) NOT NULL DEFAULT '0',
4154 `total` int(11) NOT NULL DEFAULT '0',
4155 `dtotal` float(11,1) NOT NULL DEFAULT '0.0',
4156 PRIMARY KEY (`id`)
4157) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4158
4159-- --------------------------------------------------------
4160
4161--
4162-- Table structure for table `shop_orders`
4163--
4164
4165CREATE TABLE IF NOT EXISTS `shop_orders` (
4166 `id` int(12) NOT NULL AUTO_INCREMENT,
4167 `user_id` int(12) DEFAULT NULL,
4168 `GiftVoucher` int(12) DEFAULT NULL,
4169 `CarVoucher` int(12) DEFAULT NULL,
4170 `VehVoucher` int(12) DEFAULT NULL,
4171 `SVIPVoucher` int(12) DEFAULT NULL,
4172 `GVIPVoucher` int(12) DEFAULT NULL,
4173 `credits_spent` int(12) DEFAULT NULL,
4174 `PVIPVoucher` int(12) DEFAULT NULL,
4175 `status` int(12) DEFAULT NULL,
4176 `date_added` datetime DEFAULT NULL,
4177 PRIMARY KEY (`id`)
4178) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4179
4180-- --------------------------------------------------------
4181
4182--
4183-- Table structure for table `sig_stats`
4184--
4185
4186CREATE TABLE IF NOT EXISTS `sig_stats` (
4187 `user_id` int(11) NOT NULL DEFAULT '-1',
4188 `enabled` int(1) NOT NULL DEFAULT '0',
4189 `field1` int(1) NOT NULL DEFAULT '1',
4190 `field2` int(1) NOT NULL DEFAULT '1',
4191 `field3` int(1) NOT NULL DEFAULT '1',
4192 `field4` int(1) NOT NULL DEFAULT '1',
4193 `field5` int(1) NOT NULL DEFAULT '1',
4194 `field6` int(1) NOT NULL DEFAULT '1',
4195 `field7` int(1) NOT NULL DEFAULT '1',
4196 `field8` int(1) NOT NULL DEFAULT '1',
4197 `field9` int(1) NOT NULL DEFAULT '1',
4198 `field10` int(1) NOT NULL DEFAULT '1',
4199 `field11` int(1) NOT NULL DEFAULT '1',
4200 `field12` int(1) NOT NULL DEFAULT '1',
4201 `field13` int(1) NOT NULL DEFAULT '1',
4202 `field14` int(1) NOT NULL DEFAULT '1',
4203 `field15` int(1) NOT NULL DEFAULT '1',
4204 `field16` int(1) NOT NULL DEFAULT '1',
4205 `field17` int(1) NOT NULL DEFAULT '1',
4206 `field18` int(1) NOT NULL DEFAULT '1',
4207 `field19` int(1) NOT NULL DEFAULT '1',
4208 `field20` int(1) NOT NULL DEFAULT '1',
4209 `field21` int(1) NOT NULL DEFAULT '1',
4210 `field22` int(1) NOT NULL DEFAULT '1',
4211 `field23` int(1) NOT NULL DEFAULT '1',
4212 `field24` int(1) NOT NULL DEFAULT '1',
4213 `field25` int(1) NOT NULL DEFAULT '1',
4214 `field26` int(1) NOT NULL DEFAULT '1',
4215 `field27` int(1) NOT NULL DEFAULT '1',
4216 `field28` int(1) NOT NULL DEFAULT '1',
4217 `field29` int(1) NOT NULL DEFAULT '1',
4218 `field30` int(1) NOT NULL DEFAULT '1',
4219 `field31` int(1) NOT NULL DEFAULT '1',
4220 `field32` int(1) NOT NULL DEFAULT '1',
4221 `field33` int(1) NOT NULL DEFAULT '1',
4222 `field34` int(1) NOT NULL DEFAULT '1',
4223 `field35` int(1) NOT NULL DEFAULT '1',
4224 `field36` int(1) NOT NULL DEFAULT '1',
4225 `field37` int(1) NOT NULL DEFAULT '1',
4226 `field38` int(1) NOT NULL DEFAULT '1',
4227 `field39` int(1) NOT NULL DEFAULT '1',
4228 `field40` int(1) NOT NULL DEFAULT '1',
4229 `field41` int(1) NOT NULL DEFAULT '1',
4230 `field42` int(1) NOT NULL DEFAULT '1',
4231 `field43` int(1) NOT NULL DEFAULT '1',
4232 `field44` int(1) NOT NULL DEFAULT '1',
4233 `field45` int(1) NOT NULL DEFAULT '1',
4234 `field46` int(1) NOT NULL DEFAULT '1',
4235 `field47` int(1) NOT NULL DEFAULT '1',
4236 `field48` int(1) NOT NULL DEFAULT '1',
4237 `field49` int(1) NOT NULL DEFAULT '1',
4238 `field50` int(1) NOT NULL DEFAULT '1',
4239 `field51` int(1) NOT NULL DEFAULT '1',
4240 `field52` int(1) NOT NULL DEFAULT '1',
4241 `field53` int(1) NOT NULL DEFAULT '1',
4242 `field54` int(1) NOT NULL DEFAULT '1',
4243 `field55` int(1) NOT NULL DEFAULT '1',
4244 `field56` int(1) NOT NULL DEFAULT '1',
4245 `field57` int(1) NOT NULL DEFAULT '1',
4246 `field58` int(1) NOT NULL DEFAULT '1',
4247 `field59` int(1) NOT NULL DEFAULT '1',
4248 PRIMARY KEY (`user_id`)
4249) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4250
4251-- --------------------------------------------------------
4252
4253--
4254-- Table structure for table `slow_log`
4255--
4256
4257CREATE TABLE IF NOT EXISTS `slow_log` (
4258 `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4259 `user_host` mediumtext NOT NULL,
4260 `query_time` time NOT NULL,
4261 `lock_time` time NOT NULL,
4262 `rows_sent` int(11) NOT NULL,
4263 `rows_examined` int(11) NOT NULL,
4264 `db` varchar(512) NOT NULL,
4265 `last_insert_id` int(11) NOT NULL,
4266 `insert_id` int(11) NOT NULL,
4267 `server_id` int(10) unsigned NOT NULL,
4268 `sql_text` mediumtext NOT NULL
4269) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log';
4270
4271-- --------------------------------------------------------
4272
4273--
4274-- Table structure for table `sms`
4275--
4276
4277CREATE TABLE IF NOT EXISTS `sms` (
4278 `id` int(11) NOT NULL AUTO_INCREMENT,
4279 `sender` varchar(24) DEFAULT NULL,
4280 `senderid` int(11) NOT NULL DEFAULT '-1',
4281 `sendernumber` int(11) NOT NULL DEFAULT '0',
4282 `receiver` varchar(24) DEFAULT NULL,
4283 `receiverid` int(11) NOT NULL DEFAULT '-1',
4284 `receivernumber` int(11) NOT NULL DEFAULT '0',
4285 `message` varchar(128) DEFAULT NULL,
4286 `date` datetime DEFAULT NULL,
4287 PRIMARY KEY (`id`)
4288) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4289
4290-- --------------------------------------------------------
4291
4292--
4293-- Table structure for table `sobeitkicks`
4294--
4295
4296CREATE TABLE IF NOT EXISTS `sobeitkicks` (
4297 `sqlID` int(11) NOT NULL DEFAULT '0',
4298 `Kicks` int(11) NOT NULL DEFAULT '0',
4299 PRIMARY KEY (`sqlID`)
4300) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4301
4302-- --------------------------------------------------------
4303
4304--
4305-- Table structure for table `speed_cameras`
4306--
4307
4308CREATE TABLE IF NOT EXISTS `speed_cameras` (
4309 `id` int(10) NOT NULL AUTO_INCREMENT,
4310 `pos_x` float(10,5) NOT NULL,
4311 `pos_y` float(10,5) NOT NULL,
4312 `pos_z` float(10,5) NOT NULL,
4313 `rotation` float(10,5) NOT NULL,
4314 `range` float(10,5) NOT NULL,
4315 `speed_limit` float(10,5) NOT NULL,
4316 PRIMARY KEY (`id`)
4317) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contains data regarding speed cameras.';
4318
4319-- --------------------------------------------------------
4320
4321--
4322-- Table structure for table `tables_priv`
4323--
4324
4325CREATE TABLE IF NOT EXISTS `tables_priv` (
4326 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
4327 `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4328 `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
4329 `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
4330 `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
4331 `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4332 `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',
4333 `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
4334 PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
4335 KEY `Grantor` (`Grantor`)
4336) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges';
4337
4338-- --------------------------------------------------------
4339
4340--
4341-- Table structure for table `text_labels`
4342--
4343
4344CREATE TABLE IF NOT EXISTS `text_labels` (
4345 `id` int(11) NOT NULL AUTO_INCREMENT,
4346 `Text` varchar(128) NOT NULL DEFAULT '0',
4347 `PosX` float NOT NULL DEFAULT '0',
4348 `PosY` float NOT NULL DEFAULT '0',
4349 `PosZ` float NOT NULL DEFAULT '0',
4350 `VW` int(11) NOT NULL DEFAULT '0',
4351 `Int` int(11) NOT NULL DEFAULT '0',
4352 `Color` int(11) NOT NULL DEFAULT '0',
4353 `PickupModel` int(11) NOT NULL DEFAULT '0',
4354 PRIMARY KEY (`id`)
4355) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4356
4357-- --------------------------------------------------------
4358
4359--
4360-- Table structure for table `time_zone`
4361--
4362
4363CREATE TABLE IF NOT EXISTS `time_zone` (
4364 `Time_zone_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4365 `Use_leap_seconds` enum('Y','N') NOT NULL DEFAULT 'N',
4366 PRIMARY KEY (`Time_zone_id`)
4367) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zones';
4368
4369-- --------------------------------------------------------
4370
4371--
4372-- Table structure for table `time_zone_leap_second`
4373--
4374
4375CREATE TABLE IF NOT EXISTS `time_zone_leap_second` (
4376 `Transition_time` bigint(20) NOT NULL DEFAULT '0',
4377 `Correction` int(11) NOT NULL DEFAULT '0',
4378 PRIMARY KEY (`Transition_time`)
4379) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Leap seconds information for time zones';
4380
4381-- --------------------------------------------------------
4382
4383--
4384-- Table structure for table `time_zone_name`
4385--
4386
4387CREATE TABLE IF NOT EXISTS `time_zone_name` (
4388 `Name` char(64) NOT NULL DEFAULT '',
4389 `Time_zone_id` int(10) unsigned NOT NULL DEFAULT '0',
4390 PRIMARY KEY (`Name`)
4391) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone names';
4392
4393-- --------------------------------------------------------
4394
4395--
4396-- Table structure for table `time_zone_transition`
4397--
4398
4399CREATE TABLE IF NOT EXISTS `time_zone_transition` (
4400 `Time_zone_id` int(10) unsigned NOT NULL DEFAULT '0',
4401 `Transition_time` bigint(20) NOT NULL DEFAULT '0',
4402 `Transition_type_id` int(10) unsigned NOT NULL DEFAULT '0',
4403 PRIMARY KEY (`Time_zone_id`,`Transition_time`)
4404) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transitions';
4405
4406-- --------------------------------------------------------
4407
4408--
4409-- Table structure for table `time_zone_transition_type`
4410--
4411
4412CREATE TABLE IF NOT EXISTS `time_zone_transition_type` (
4413 `Time_zone_id` int(10) unsigned NOT NULL DEFAULT '0',
4414 `Transition_type_id` int(10) unsigned NOT NULL DEFAULT '0',
4415 `Offset` int(11) NOT NULL DEFAULT '0',
4416 `Is_DST` tinyint(3) unsigned NOT NULL DEFAULT '0',
4417 `Abbreviation` char(8) NOT NULL DEFAULT '',
4418 PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
4419) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transition types';
4420
4421-- --------------------------------------------------------
4422
4423--
4424-- Table structure for table `tokens_call`
4425--
4426
4427CREATE TABLE IF NOT EXISTS `tokens_call` (
4428 `id` int(11) NOT NULL AUTO_INCREMENT,
4429 `playerid` int(11) NOT NULL,
4430 `date` date DEFAULT NULL,
4431 `hour` int(2) DEFAULT NULL,
4432 `count` int(11) NOT NULL DEFAULT '0',
4433 PRIMARY KEY (`id`)
4434) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4435
4436-- --------------------------------------------------------
4437
4438--
4439-- Table structure for table `tokens_report`
4440--
4441
4442CREATE TABLE IF NOT EXISTS `tokens_report` (
4443 `id` int(11) NOT NULL AUTO_INCREMENT,
4444 `playerid` int(11) NOT NULL,
4445 `date` date DEFAULT NULL,
4446 `hour` time DEFAULT NULL,
4447 `count` int(11) NOT NULL DEFAULT '0',
4448 PRIMARY KEY (`id`)
4449) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4450
4451-- --------------------------------------------------------
4452
4453--
4454-- Table structure for table `tokens_request`
4455--
4456
4457CREATE TABLE IF NOT EXISTS `tokens_request` (
4458 `id` int(11) NOT NULL AUTO_INCREMENT,
4459 `playerid` int(11) NOT NULL,
4460 `date` date DEFAULT NULL,
4461 `hour` time DEFAULT NULL,
4462 `count` int(11) NOT NULL DEFAULT '0',
4463 PRIMARY KEY (`id`)
4464) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4465
4466-- --------------------------------------------------------
4467
4468--
4469-- Table structure for table `tokens_wd`
4470--
4471
4472CREATE TABLE IF NOT EXISTS `tokens_wd` (
4473 `id` int(11) NOT NULL AUTO_INCREMENT,
4474 `playerid` int(11) NOT NULL,
4475 `date` date DEFAULT NULL,
4476 `hour` time DEFAULT NULL,
4477 `count` int(11) NOT NULL DEFAULT '0',
4478 PRIMARY KEY (`id`)
4479) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4480
4481-- --------------------------------------------------------
4482
4483--
4484-- Table structure for table `tournaments`
4485--
4486
4487CREATE TABLE IF NOT EXISTS `tournaments` (
4488 `id` int(11) NOT NULL AUTO_INCREMENT,
4489 `Contestants` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '-1|-1|-1|-1|-1|-1|-1|-1|-1|-1|-1|-1|-1|-1|-1|-1',
4490 `QuarterFinals` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '-1|-1|-1|-1|-1|-1|-1|-1',
4491 `SemiFinals` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '-1|-1|-1|-1',
4492 `Finals` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '-1|-1',
4493 `Winner` int(11) NOT NULL DEFAULT '-1',
4494 `Tournament` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'Tournament Name',
4495 `active` int(11) NOT NULL DEFAULT '1',
4496 PRIMARY KEY (`id`)
4497) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
4498
4499-- --------------------------------------------------------
4500
4501--
4502-- Table structure for table `toys`
4503--
4504
4505CREATE TABLE IF NOT EXISTS `toys` (
4506 `id` int(11) NOT NULL AUTO_INCREMENT,
4507 `player` int(11) NOT NULL,
4508 `modelid` int(11) NOT NULL,
4509 `bone` int(11) NOT NULL,
4510 `posx` float NOT NULL,
4511 `posy` float NOT NULL,
4512 `posz` float NOT NULL,
4513 `rotx` float NOT NULL,
4514 `roty` float NOT NULL,
4515 `rotz` float NOT NULL,
4516 `scalex` float NOT NULL,
4517 `scaley` float NOT NULL,
4518 `scalez` float NOT NULL,
4519 `tradable` int(11) NOT NULL DEFAULT '0',
4520 `special` int(11) NOT NULL,
4521 PRIMARY KEY (`id`)
4522) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4523
4524-- --------------------------------------------------------
4525
4526--
4527-- Table structure for table `track_backdoor`
4528--
4529
4530CREATE TABLE IF NOT EXISTS `track_backdoor` (
4531 `id` int(11) NOT NULL AUTO_INCREMENT,
4532 `player_id` int(11) NOT NULL,
4533 `order_id` varchar(11) NOT NULL,
4534 `house_id` int(11) NOT NULL,
4535 `door_id` int(11) NOT NULL,
4536 `admin_id` int(11) NOT NULL,
4537 `date` datetime NOT NULL,
4538 PRIMARY KEY (`id`)
4539) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4540
4541-- --------------------------------------------------------
4542
4543--
4544-- Table structure for table `track_gate`
4545--
4546
4547CREATE TABLE IF NOT EXISTS `track_gate` (
4548 `id` int(11) NOT NULL AUTO_INCREMENT,
4549 `player_id` int(11) NOT NULL,
4550 `order_id` varchar(11) NOT NULL,
4551 `house_id` int(11) NOT NULL,
4552 `gate_id` int(11) NOT NULL,
4553 `gate_move` int(1) NOT NULL,
4554 `admin_id` int(11) NOT NULL,
4555 `date` datetime NOT NULL,
4556 PRIMARY KEY (`id`)
4557) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4558
4559-- --------------------------------------------------------
4560
4561--
4562-- Table structure for table `track_gvip`
4563--
4564
4565CREATE TABLE IF NOT EXISTS `track_gvip` (
4566 `id` int(11) NOT NULL AUTO_INCREMENT,
4567 `player_id` int(11) NOT NULL,
4568 `order_id` varchar(11) NOT NULL,
4569 `vipm` int(11) NOT NULL,
4570 `renewal` int(1) NOT NULL,
4571 `gift` int(1) NOT NULL,
4572 `expiration` int(11) NOT NULL,
4573 `admin_id` int(11) NOT NULL,
4574 `date` datetime NOT NULL,
4575 PRIMARY KEY (`id`)
4576) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4577
4578-- --------------------------------------------------------
4579
4580--
4581-- Table structure for table `track_house`
4582--
4583
4584CREATE TABLE IF NOT EXISTS `track_house` (
4585 `id` int(11) NOT NULL AUTO_INCREMENT,
4586 `player_id` int(11) NOT NULL,
4587 `house_id` int(11) NOT NULL,
4588 `order_id` varchar(11) NOT NULL,
4589 `house_move` int(2) NOT NULL,
4590 `admin_id` int(11) NOT NULL,
4591 `date` datetime NOT NULL,
4592 PRIMARY KEY (`id`)
4593) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4594
4595-- --------------------------------------------------------
4596
4597--
4598-- Table structure for table `track_pvip`
4599--
4600
4601CREATE TABLE IF NOT EXISTS `track_pvip` (
4602 `id` int(11) NOT NULL AUTO_INCREMENT,
4603 `player_id` int(11) NOT NULL,
4604 `vipm` int(11) NOT NULL,
4605 `shop_email` varchar(128) NOT NULL,
4606 `restrict_veh` int(3) NOT NULL,
4607 `donate` int(11) NOT NULL DEFAULT '0',
4608 `admin_id` int(11) NOT NULL,
4609 `date` datetime NOT NULL,
4610 PRIMARY KEY (`id`)
4611) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4612
4613-- --------------------------------------------------------
4614
4615--
4616-- Table structure for table `track_ts`
4617--
4618
4619CREATE TABLE IF NOT EXISTS `track_ts` (
4620 `id` int(11) NOT NULL AUTO_INCREMENT,
4621 `name` varchar(128) NOT NULL,
4622 `order_id` varchar(11) NOT NULL,
4623 `database_id` int(11) NOT NULL,
4624 `channel_name` varchar(128) NOT NULL,
4625 `admin_id` int(11) NOT NULL,
4626 `date` datetime NOT NULL,
4627 PRIMARY KEY (`id`)
4628) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4629
4630-- --------------------------------------------------------
4631
4632--
4633-- Table structure for table `track_vip`
4634--
4635
4636CREATE TABLE IF NOT EXISTS `track_vip` (
4637 `id` int(11) NOT NULL AUTO_INCREMENT,
4638 `player_id` int(11) NOT NULL,
4639 `vip` int(1) NOT NULL,
4640 `order_id` varchar(11) NOT NULL,
4641 `vipm` int(11) NOT NULL,
4642 `expiration` int(11) NOT NULL,
4643 `admin_id` int(11) NOT NULL,
4644 `date` datetime NOT NULL,
4645 PRIMARY KEY (`id`)
4646) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4647
4648-- --------------------------------------------------------
4649
4650--
4651-- Table structure for table `turfs`
4652--
4653
4654CREATE TABLE IF NOT EXISTS `turfs` (
4655 `id` int(11) NOT NULL AUTO_INCREMENT,
4656 `data` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'None|-1|0|0|12|0.000000|0.000000|0.000000|0.000000',
4657 PRIMARY KEY (`id`)
4658) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
4659
4660-- --------------------------------------------------------
4661
4662--
4663-- Table structure for table `user`
4664--
4665
4666CREATE TABLE IF NOT EXISTS `user` (
4667 `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
4668 `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
4669 `Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
4670 `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4671 `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4672 `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4673 `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4674 `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4675 `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4676 `Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4677 `Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4678 `Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4679 `File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4680 `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4681 `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4682 `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4683 `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4684 `Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4685 `Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4686 `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4687 `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4688 `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4689 `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4690 `Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4691 `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4692 `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4693 `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4694 `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4695 `Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4696 `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4697 `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4698 `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
4699 `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
4700 `ssl_cipher` blob NOT NULL,
4701 `x509_issuer` blob NOT NULL,
4702 `x509_subject` blob NOT NULL,
4703 `max_questions` int(11) unsigned NOT NULL DEFAULT '0',
4704 `max_updates` int(11) unsigned NOT NULL DEFAULT '0',
4705 `max_connections` int(11) unsigned NOT NULL DEFAULT '0',
4706 `max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',
4707 `plugin` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
4708 `authentication_string` text COLLATE utf8_bin NOT NULL,
4709 PRIMARY KEY (`Host`,`User`)
4710) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';
4711
4712-- --------------------------------------------------------
4713
4714--
4715-- Table structure for table `user_leaves`
4716--
4717
4718CREATE TABLE IF NOT EXISTS `user_leaves` (
4719 `id` int(8) NOT NULL AUTO_INCREMENT,
4720 `uid` varchar(9) NOT NULL,
4721 `date_leave` date NOT NULL,
4722 `date_return` date NOT NULL,
4723 `reason` varchar(512) NOT NULL,
4724 `status` int(9) NOT NULL,
4725 `accept_uid` int(9) NOT NULL,
4726 PRIMARY KEY (`id`)
4727) ENGINE=MyISAM DEFAULT CHARSET=latin1;
4728
4729-- --------------------------------------------------------
4730
4731--
4732-- Table structure for table `user_notes`
4733--
4734
4735CREATE TABLE IF NOT EXISTS `user_notes` (
4736 `id` int(6) NOT NULL AUTO_INCREMENT,
4737 `uid` varchar(256) NOT NULL,
4738 `note` varchar(512) NOT NULL,
4739 `addDate` date NOT NULL,
4740 `invokeid` varchar(256) NOT NULL,
4741 `type` int(6) NOT NULL,
4742 `points` int(6) NOT NULL,
4743 `status` int(6) NOT NULL,
4744 PRIMARY KEY (`id`)
4745) ENGINE=MyISAM DEFAULT CHARSET=latin1;
4746
4747-- --------------------------------------------------------
4748
4749--
4750-- Table structure for table `vehicles`
4751--
4752
4753CREATE TABLE IF NOT EXISTS `vehicles` (
4754 `id` int(11) NOT NULL AUTO_INCREMENT,
4755 `sqlID` int(11) NOT NULL DEFAULT '0',
4756 `pvModelId` int(11) NOT NULL DEFAULT '0',
4757 `pvPosX` float NOT NULL DEFAULT '0',
4758 `pvPosY` float NOT NULL DEFAULT '0',
4759 `pvPosZ` float NOT NULL DEFAULT '0',
4760 `pvPosAngle` float NOT NULL DEFAULT '0',
4761 `pvLock` int(11) NOT NULL DEFAULT '0',
4762 `pvLocked` int(11) NOT NULL DEFAULT '0',
4763 `pvPaintJob` int(11) NOT NULL DEFAULT '0',
4764 `pvColor1` int(11) NOT NULL DEFAULT '0',
4765 `pvColor2` int(11) NOT NULL DEFAULT '0',
4766 `pvPrice` int(11) NOT NULL DEFAULT '0',
4767 `pvTicket` int(11) NOT NULL DEFAULT '0',
4768 `pvRestricted` int(11) NOT NULL DEFAULT '0',
4769 `pvWeapon0` int(11) NOT NULL DEFAULT '0',
4770 `pvWeapon1` int(11) NOT NULL DEFAULT '0',
4771 `pvWeapon2` int(11) NOT NULL DEFAULT '0',
4772 `pvWepUpgrade` int(11) NOT NULL DEFAULT '0',
4773 `pvFuel` float NOT NULL DEFAULT '0',
4774 `pvImpound` int(11) NOT NULL DEFAULT '0',
4775 `pvDisabled` int(11) NOT NULL DEFAULT '0',
4776 `pvPlate` varchar(32) NOT NULL DEFAULT 'None',
4777 `pvMod0` int(11) NOT NULL DEFAULT '0',
4778 `pvMod1` int(11) NOT NULL DEFAULT '0',
4779 `pvMod2` int(11) NOT NULL DEFAULT '0',
4780 `pvMod3` int(11) NOT NULL DEFAULT '0',
4781 `pvMod4` int(11) NOT NULL DEFAULT '0',
4782 `pvMod5` int(11) NOT NULL DEFAULT '0',
4783 `pvMod6` int(11) NOT NULL DEFAULT '0',
4784 `pvMod7` int(11) NOT NULL DEFAULT '0',
4785 `pvMod8` int(11) NOT NULL DEFAULT '0',
4786 `pvMod9` int(11) NOT NULL DEFAULT '0',
4787 `pvMod10` int(11) NOT NULL DEFAULT '0',
4788 `pvMod11` int(11) NOT NULL DEFAULT '0',
4789 `pvMod12` int(11) NOT NULL DEFAULT '0',
4790 `pvMod13` int(11) NOT NULL DEFAULT '0',
4791 `pvMod14` int(11) NOT NULL DEFAULT '0',
4792 `pvVW` int(11) NOT NULL DEFAULT '0',
4793 `pvInt` int(11) NOT NULL DEFAULT '0',
4794 `pvCrashFlag` int(11) NOT NULL,
4795 `pvCrashVW` int(11) NOT NULL,
4796 `pvCrashX` float NOT NULL,
4797 `pvCrashY` float NOT NULL,
4798 `pvCrashZ` float NOT NULL,
4799 `pvCrashAngle` float NOT NULL,
4800 `pvAlarm` int(11) NOT NULL DEFAULT '0',
4801 `pvLastLockPickedBy` varchar(24) NOT NULL DEFAULT 'Empty',
4802 `pvLocksLeft` int(11) NOT NULL DEFAULT '5',
4803 `pvHealth` float NOT NULL DEFAULT '1000',
4804 PRIMARY KEY (`id`)
4805) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4806
4807-- --------------------------------------------------------
4808
4809--
4810-- Table structure for table `vehicles2`
4811--
4812
4813CREATE TABLE IF NOT EXISTS `vehicles2` (
4814 `id` int(11) NOT NULL AUTO_INCREMENT,
4815 `sqlID` int(11) NOT NULL DEFAULT '0',
4816 `pvModelId` int(11) NOT NULL DEFAULT '0',
4817 `pvPosX` float NOT NULL DEFAULT '0',
4818 `pvPosY` float NOT NULL DEFAULT '0',
4819 `pvPosZ` float NOT NULL DEFAULT '0',
4820 `pvPosAngle` float NOT NULL DEFAULT '0',
4821 `pvLock` int(11) NOT NULL DEFAULT '0',
4822 `pvLocked` int(11) NOT NULL DEFAULT '0',
4823 `pvPaintJob` int(11) NOT NULL DEFAULT '0',
4824 `pvColor1` int(11) NOT NULL DEFAULT '0',
4825 `pvColor2` int(11) NOT NULL DEFAULT '0',
4826 `pvPrice` int(11) NOT NULL DEFAULT '0',
4827 `pvTicket` int(11) NOT NULL DEFAULT '0',
4828 `pvRestricted` int(11) NOT NULL DEFAULT '0',
4829 `pvWeapon0` int(11) NOT NULL DEFAULT '0',
4830 `pvWeapon1` int(11) NOT NULL DEFAULT '0',
4831 `pvWeapon2` int(11) NOT NULL DEFAULT '0',
4832 `pvWepUpgrade` int(11) NOT NULL DEFAULT '0',
4833 `pvFuel` float NOT NULL DEFAULT '0',
4834 `pvImpound` int(11) NOT NULL DEFAULT '0',
4835 `pvDisabled` int(11) NOT NULL DEFAULT '0',
4836 `pvPlate` varchar(32) NOT NULL DEFAULT 'None',
4837 `pvMod0` int(11) NOT NULL DEFAULT '0',
4838 `pvMod1` int(11) NOT NULL DEFAULT '0',
4839 `pvMod2` int(11) NOT NULL DEFAULT '0',
4840 `pvMod3` int(11) NOT NULL DEFAULT '0',
4841 `pvMod4` int(11) NOT NULL DEFAULT '0',
4842 `pvMod5` int(11) NOT NULL DEFAULT '0',
4843 `pvMod6` int(11) NOT NULL DEFAULT '0',
4844 `pvMod7` int(11) NOT NULL DEFAULT '0',
4845 `pvMod8` int(11) NOT NULL DEFAULT '0',
4846 `pvMod9` int(11) NOT NULL DEFAULT '0',
4847 `pvMod10` int(11) NOT NULL DEFAULT '0',
4848 `pvMod11` int(11) NOT NULL DEFAULT '0',
4849 `pvMod12` int(11) NOT NULL DEFAULT '0',
4850 `pvMod13` int(11) NOT NULL DEFAULT '0',
4851 `pvMod14` int(11) NOT NULL DEFAULT '0',
4852 PRIMARY KEY (`id`)
4853) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4854
4855-- --------------------------------------------------------
4856
4857--
4858-- Table structure for table `watchdog_reports`
4859--
4860
4861CREATE TABLE IF NOT EXISTS `watchdog_reports` (
4862 `id` int(11) NOT NULL AUTO_INCREMENT,
4863 `reporter` int(11) NOT NULL DEFAULT '0',
4864 `report` text NOT NULL,
4865 `reported` int(11) NOT NULL DEFAULT '0',
4866 `type` int(11) NOT NULL DEFAULT '0' COMMENT '1 = DM | 2 = Refer',
4867 `time` int(11) NOT NULL DEFAULT '0' COMMENT 'Unix Timestamp',
4868 PRIMARY KEY (`id`)
4869) ENGINE=InnoDB DEFAULT CHARSET=latin1;
4870
4871-- --------------------------------------------------------
4872
4873--
4874-- Table structure for table `zombie`
4875--
4876
4877CREATE TABLE IF NOT EXISTS `zombie` (
4878 `id` int(11) NOT NULL DEFAULT '0',
4879 PRIMARY KEY (`id`)
4880) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4881
4882-- --------------------------------------------------------
4883
4884--
4885-- Table structure for table `zombieheals`
4886--
4887
4888CREATE TABLE IF NOT EXISTS `zombieheals` (
4889 `id` int(11) NOT NULL DEFAULT '0',
4890 `num` int(11) NOT NULL DEFAULT '0',
4891 PRIMARY KEY (`id`)
4892) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4893
4894-- --------------------------------------------------------
4895
4896--
4897-- Table structure for table `zombiekills`
4898--
4899
4900CREATE TABLE IF NOT EXISTS `zombiekills` (
4901 `id` int(11) NOT NULL DEFAULT '0',
4902 `num` int(11) NOT NULL DEFAULT '0',
4903 PRIMARY KEY (`id`)
4904) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4905
4906/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
4907/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
4908/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;