· 8 years ago · Apr 01, 2018, 02:24 AM
1-- --------------------------------------------------------
2-- Host: nykez.site.nfoservers.com
3-- Server version: 5.6.38 - Source distribution
4-- Server OS: Linux
5-- HeidiSQL Version: 9.3.0.4984
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Dumping structure for table pgrpdev_realsantos.achievements
14CREATE TABLE IF NOT EXISTS `achievements` (
15 `steamid` text NOT NULL,
16 `id` bigint(10) NOT NULL,
17 `progress` bigint(10) NOT NULL
18) ENGINE=MyISAM DEFAULT CHARSET=utf8;
19
20-- Dumping data for table pgrpdev_realsantos.achievements: 8 rows
21DELETE FROM `achievements`;
22/*!40000 ALTER TABLE `achievements` DISABLE KEYS */;
23INSERT INTO `achievements` (`steamid`, `id`, `progress`) VALUES
24 ('STEAM_0:1:25789514', 4, 186600),
25 ('BOT', 4, 7920),
26 ('STEAM_0:1:25789514', 31, 1),
27 ('STEAM_0:1:25789514', 1, 1),
28 ('STEAM_0:1:25789514', 34, 2),
29 ('STEAM_0:1:25789514', 37, 2),
30 ('STEAM_0:1:29285525', 4, 240),
31 ('STEAM_0:0:39588109', 4, 780);
32/*!40000 ALTER TABLE `achievements` ENABLE KEYS */;
33
34
35-- Dumping structure for table pgrpdev_realsantos.bans
36CREATE TABLE IF NOT EXISTS `bans` (
37 `BanID` int(255) NOT NULL AUTO_INCREMENT,
38 `OSteamID` varchar(255) NOT NULL,
39 `OName` varchar(255) DEFAULT NULL,
40 `Length` bigint(255) NOT NULL,
41 `Time` bigint(255) NOT NULL,
42 `AName` varchar(255) NOT NULL,
43 `ASteamID` varchar(255) NOT NULL,
44 `Reason` varchar(255) NOT NULL,
45 `ServerID` int(255) NOT NULL,
46 `MAdmin` varchar(255) NOT NULL,
47 `MTime` bigint(255) NOT NULL,
48 PRIMARY KEY (`BanID`)
49) ENGINE=InnoDB DEFAULT CHARSET=latin1;
50
51-- Dumping data for table pgrpdev_realsantos.bans: ~0 rows (approximately)
52DELETE FROM `bans`;
53/*!40000 ALTER TABLE `bans` DISABLE KEYS */;
54/*!40000 ALTER TABLE `bans` ENABLE KEYS */;
55
56
57-- Dumping structure for table pgrpdev_realsantos.blogs
58CREATE TABLE IF NOT EXISTS `blogs` (
59 `module` varchar(255) NOT NULL,
60 `log` text NOT NULL,
61 `involved` text,
62 `time` int(11) NOT NULL,
63 `ip_address` varchar(45) NOT NULL,
64 `session` mediumint(9) NOT NULL,
65 `id` mediumint(9) NOT NULL AUTO_INCREMENT,
66 PRIMARY KEY (`id`),
67 UNIQUE KEY `id` (`id`)
68) ENGINE=MyISAM DEFAULT CHARSET=utf8;
69
70-- Dumping data for table pgrpdev_realsantos.blogs: 0 rows
71DELETE FROM `blogs`;
72/*!40000 ALTER TABLE `blogs` DISABLE KEYS */;
73/*!40000 ALTER TABLE `blogs` ENABLE KEYS */;
74
75
76-- Dumping structure for table pgrpdev_realsantos.blogs_players
77CREATE TABLE IF NOT EXISTS `blogs_players` (
78 `steamid` varchar(85) DEFAULT NULL,
79 `steamid64` tinyint(17) DEFAULT NULL,
80 `lastnick` varchar(255) DEFAULT NULL,
81 UNIQUE KEY `steamid` (`steamid`,`steamid64`)
82) ENGINE=MyISAM DEFAULT CHARSET=utf8;
83
84-- Dumping data for table pgrpdev_realsantos.blogs_players: 0 rows
85DELETE FROM `blogs_players`;
86/*!40000 ALTER TABLE `blogs_players` DISABLE KEYS */;
87/*!40000 ALTER TABLE `blogs_players` ENABLE KEYS */;
88
89
90-- Dumping structure for table pgrpdev_realsantos.blogs_servers
91CREATE TABLE IF NOT EXISTS `blogs_servers` (
92 `ip_address` varchar(45) NOT NULL,
93 `name` varchar(255) DEFAULT NULL,
94 UNIQUE KEY `ip_address` (`ip_address`)
95) ENGINE=MyISAM DEFAULT CHARSET=utf8;
96
97-- Dumping data for table pgrpdev_realsantos.blogs_servers: 0 rows
98DELETE FROM `blogs_servers`;
99/*!40000 ALTER TABLE `blogs_servers` DISABLE KEYS */;
100/*!40000 ALTER TABLE `blogs_servers` ENABLE KEYS */;
101
102
103-- Dumping structure for table pgrpdev_realsantos.characters
104CREATE TABLE IF NOT EXISTS `characters` (
105 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
106 `player_id` int(10) unsigned NOT NULL,
107 `first_name` varchar(255) NOT NULL DEFAULT 'Minge',
108 `last_name` varchar(255) NOT NULL DEFAULT 'Bag',
109 `sex` enum('male','female') DEFAULT NULL,
110 `model` varchar(255) NOT NULL,
111 `model_override` varchar(255) DEFAULT NULL,
112 `skin` smallint(6) NOT NULL DEFAULT '0',
113 `money_held` int(10) unsigned NOT NULL DEFAULT '0',
114 `money_bank` int(10) unsigned NOT NULL DEFAULT '0',
115 `vehicles` longtext,
116 `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
117 `skateboard` enum('yes','no') DEFAULT NULL,
118 PRIMARY KEY (`id`),
119 KEY `player_id` (`player_id`),
120 KEY `first_name_last_name` (`first_name`,`last_name`)
121) ENGINE=InnoDB DEFAULT CHARSET=latin1;
122
123-- Dumping data for table pgrpdev_realsantos.characters: ~0 rows (approximately)
124DELETE FROM `characters`;
125/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
126/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
127
128
129-- Dumping structure for table pgrpdev_realsantos.character_data_store
130CREATE TABLE IF NOT EXISTS `character_data_store` (
131 `character_id` int(10) unsigned NOT NULL,
132 `key` varchar(255) NOT NULL,
133 `value` longtext,
134 UNIQUE KEY `character_id_key` (`character_id`,`key`),
135 KEY `character_id` (`character_id`),
136 KEY `key` (`key`)
137) ENGINE=InnoDB DEFAULT CHARSET=latin1;
138
139-- Dumping data for table pgrpdev_realsantos.character_data_store: ~0 rows (approximately)
140DELETE FROM `character_data_store`;
141/*!40000 ALTER TABLE `character_data_store` DISABLE KEYS */;
142/*!40000 ALTER TABLE `character_data_store` ENABLE KEYS */;
143
144
145-- Dumping structure for table pgrpdev_realsantos.character_equipped
146CREATE TABLE IF NOT EXISTS `character_equipped` (
147 `character_id` int(10) unsigned NOT NULL,
148 `slot_name` varchar(255) NOT NULL,
149 `item_name` varchar(255) NOT NULL,
150 UNIQUE KEY `character_id_slot_name` (`character_id`,`slot_name`),
151 KEY `character_id` (`character_id`)
152) ENGINE=InnoDB DEFAULT CHARSET=latin1;
153
154-- Dumping data for table pgrpdev_realsantos.character_equipped: ~0 rows (approximately)
155DELETE FROM `character_equipped`;
156/*!40000 ALTER TABLE `character_equipped` DISABLE KEYS */;
157/*!40000 ALTER TABLE `character_equipped` ENABLE KEYS */;
158
159
160-- Dumping structure for table pgrpdev_realsantos.character_inventory
161CREATE TABLE IF NOT EXISTS `character_inventory` (
162 `character_id` int(10) unsigned NOT NULL,
163 `item_name` varchar(255) NOT NULL,
164 `item_count` int(10) unsigned NOT NULL,
165 UNIQUE KEY `character_id_item_name` (`character_id`,`item_name`),
166 KEY `character_id` (`character_id`)
167) ENGINE=InnoDB DEFAULT CHARSET=latin1;
168
169-- Dumping data for table pgrpdev_realsantos.character_inventory: ~0 rows (approximately)
170DELETE FROM `character_inventory`;
171/*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
172/*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
173
174
175-- Dumping structure for table pgrpdev_realsantos.customize_car
176CREATE TABLE IF NOT EXISTS `customize_car` (
177 `steamid` text NOT NULL,
178 `carid` text,
179 `red` text,
180 `green` text,
181 `blue` text,
182 `bodygroup00` text,
183 `bodygroup01` text,
184 `bodygroup02` text,
185 `bodygroup03` text,
186 `bodygroup06` text,
187 `bodygroup04` text,
188 `bodygroup05` text,
189 `skin` text,
190 `NOS` text
191) ENGINE=InnoDB DEFAULT CHARSET=latin1;
192
193-- Dumping data for table pgrpdev_realsantos.customize_car: ~0 rows (approximately)
194DELETE FROM `customize_car`;
195/*!40000 ALTER TABLE `customize_car` DISABLE KEYS */;
196/*!40000 ALTER TABLE `customize_car` ENABLE KEYS */;
197
198
199-- Dumping structure for table pgrpdev_realsantos.evolve_bans
200CREATE TABLE IF NOT EXISTS `evolve_bans` (
201 `uid` bigint(255) NOT NULL,
202 `steamid` varchar(255) NOT NULL,
203 `ip` varchar(255) DEFAULT NULL,
204 `lenght` bigint(255) DEFAULT NULL,
205 `banend` bigint(255) DEFAULT NULL,
206 `reason` varchar(255) NOT NULL,
207 `admin` bigint(255) NOT NULL,
208 `nick` varchar(255) NOT NULL
209) ENGINE=InnoDB DEFAULT CHARSET=latin1;
210
211-- Dumping data for table pgrpdev_realsantos.evolve_bans: ~0 rows (approximately)
212DELETE FROM `evolve_bans`;
213/*!40000 ALTER TABLE `evolve_bans` DISABLE KEYS */;
214/*!40000 ALTER TABLE `evolve_bans` ENABLE KEYS */;
215
216
217-- Dumping structure for table pgrpdev_realsantos.gamemode_taxes
218CREATE TABLE IF NOT EXISTS `gamemode_taxes` (
219 `key` varchar(255) NOT NULL,
220 `value` float DEFAULT NULL,
221 UNIQUE KEY `key` (`key`)
222) ENGINE=InnoDB DEFAULT CHARSET=latin1;
223
224-- Dumping data for table pgrpdev_realsantos.gamemode_taxes: ~0 rows (approximately)
225DELETE FROM `gamemode_taxes`;
226/*!40000 ALTER TABLE `gamemode_taxes` DISABLE KEYS */;
227/*!40000 ALTER TABLE `gamemode_taxes` ENABLE KEYS */;
228
229
230-- Dumping structure for table pgrpdev_realsantos.gmadmin_sessions
231CREATE TABLE IF NOT EXISTS `gmadmin_sessions` (
232 `userid` int(10) NOT NULL,
233 `access` int(10) NOT NULL,
234 `last_action` int(20) NOT NULL,
235 `sessionid` int(10) NOT NULL,
236 PRIMARY KEY (`userid`),
237 UNIQUE KEY `sessionid` (`sessionid`)
238) ENGINE=InnoDB DEFAULT CHARSET=latin1;
239
240-- Dumping data for table pgrpdev_realsantos.gmadmin_sessions: ~0 rows (approximately)
241DELETE FROM `gmadmin_sessions`;
242/*!40000 ALTER TABLE `gmadmin_sessions` DISABLE KEYS */;
243/*!40000 ALTER TABLE `gmadmin_sessions` ENABLE KEYS */;
244
245
246-- Dumping structure for table pgrpdev_realsantos.gta_admins
247CREATE TABLE IF NOT EXISTS `gta_admins` (
248 `steamid` varchar(255) NOT NULL,
249 `name` varchar(255) DEFAULT NULL,
250 `assigned` varchar(255) DEFAULT '0',
251 `closed` varchar(255) DEFAULT NULL,
252 PRIMARY KEY (`steamid`)
253) ENGINE=MyISAM DEFAULT CHARSET=latin1;
254
255-- Dumping data for table pgrpdev_realsantos.gta_admins: 0 rows
256DELETE FROM `gta_admins`;
257/*!40000 ALTER TABLE `gta_admins` DISABLE KEYS */;
258/*!40000 ALTER TABLE `gta_admins` ENABLE KEYS */;
259
260
261-- Dumping structure for table pgrpdev_realsantos.gta_bname
262CREATE TABLE IF NOT EXISTS `gta_bname` (
263 `name` text NOT NULL
264) ENGINE=MyISAM DEFAULT CHARSET=latin1;
265
266-- Dumping data for table pgrpdev_realsantos.gta_bname: 0 rows
267DELETE FROM `gta_bname`;
268/*!40000 ALTER TABLE `gta_bname` DISABLE KEYS */;
269/*!40000 ALTER TABLE `gta_bname` ENABLE KEYS */;
270
271
272-- Dumping structure for table pgrpdev_realsantos.gta_cars
273CREATE TABLE IF NOT EXISTS `gta_cars` (
274 `id` int(16) NOT NULL,
275 `owner` varchar(16) NOT NULL,
276 `color` varchar(16) NOT NULL,
277 `underglow` varchar(16) NOT NULL,
278 `headlights` varchar(16) NOT NULL,
279 `hydraulics` int(16) NOT NULL
280) ENGINE=MyISAM DEFAULT CHARSET=utf8;
281
282-- Dumping data for table pgrpdev_realsantos.gta_cars: 0 rows
283DELETE FROM `gta_cars`;
284/*!40000 ALTER TABLE `gta_cars` DISABLE KEYS */;
285/*!40000 ALTER TABLE `gta_cars` ENABLE KEYS */;
286
287
288-- Dumping structure for table pgrpdev_realsantos.gta_custom
289CREATE TABLE IF NOT EXISTS `gta_custom` (
290 `steamid` text NOT NULL,
291 `bodygroup01` text,
292 `bodygroup02` text,
293 `bodygroup03` text,
294 `bodygroup04` text,
295 `skin` text
296) ENGINE=InnoDB DEFAULT CHARSET=latin1;
297
298-- Dumping data for table pgrpdev_realsantos.gta_custom: ~0 rows (approximately)
299DELETE FROM `gta_custom`;
300/*!40000 ALTER TABLE `gta_custom` DISABLE KEYS */;
301/*!40000 ALTER TABLE `gta_custom` ENABLE KEYS */;
302
303
304-- Dumping structure for table pgrpdev_realsantos.gta_fuel
305CREATE TABLE IF NOT EXISTS `gta_fuel` (
306 `uid` int(11) NOT NULL,
307 `1` int(11) NOT NULL DEFAULT '10000',
308 `2` int(11) NOT NULL DEFAULT '10000',
309 `3` int(11) NOT NULL DEFAULT '10000',
310 `4` int(11) NOT NULL DEFAULT '10000',
311 `5` int(11) NOT NULL DEFAULT '10000',
312 `6` int(11) NOT NULL DEFAULT '10000',
313 `7` int(11) NOT NULL DEFAULT '10000',
314 `8` int(11) NOT NULL DEFAULT '10000',
315 `9` int(11) NOT NULL DEFAULT '10000',
316 `10` int(11) NOT NULL DEFAULT '10000',
317 `11` int(11) NOT NULL DEFAULT '10000',
318 `12` int(11) NOT NULL DEFAULT '10000',
319 `13` int(11) NOT NULL DEFAULT '10000',
320 `14` int(11) NOT NULL DEFAULT '10000',
321 `15` int(11) NOT NULL DEFAULT '10000',
322 `16` int(11) NOT NULL DEFAULT '10000',
323 `17` int(11) NOT NULL DEFAULT '10000',
324 `18` int(11) NOT NULL DEFAULT '10000',
325 `19` int(11) NOT NULL DEFAULT '10000',
326 `20` int(11) NOT NULL DEFAULT '10000',
327 `21` int(11) NOT NULL DEFAULT '10000',
328 `22` int(11) NOT NULL DEFAULT '10000',
329 `23` int(11) NOT NULL DEFAULT '10000',
330 `24` int(11) NOT NULL DEFAULT '10000',
331 `25` int(11) NOT NULL DEFAULT '10000',
332 `26` int(11) NOT NULL DEFAULT '10000',
333 `27` int(11) NOT NULL DEFAULT '10000',
334 `28` int(11) NOT NULL DEFAULT '10000',
335 `29` int(11) NOT NULL DEFAULT '10000',
336 `30` int(11) NOT NULL DEFAULT '10000',
337 `31` int(11) NOT NULL DEFAULT '10000',
338 `32` int(11) NOT NULL DEFAULT '10000',
339 `33` int(11) NOT NULL DEFAULT '10000',
340 `34` int(11) NOT NULL DEFAULT '10000',
341 `35` int(11) NOT NULL DEFAULT '10000',
342 `36` int(11) NOT NULL DEFAULT '10000',
343 `37` int(11) NOT NULL DEFAULT '10000',
344 `38` int(11) NOT NULL DEFAULT '10000',
345 `39` int(11) NOT NULL DEFAULT '10000',
346 `40` int(11) NOT NULL DEFAULT '10000',
347 `41` int(11) NOT NULL DEFAULT '10000',
348 `42` int(11) NOT NULL DEFAULT '10000',
349 `43` int(11) NOT NULL DEFAULT '10000',
350 `44` int(11) NOT NULL DEFAULT '10000',
351 `45` int(11) NOT NULL DEFAULT '10000',
352 `46` int(11) NOT NULL DEFAULT '10000',
353 `47` int(11) NOT NULL DEFAULT '10000',
354 `48` int(11) NOT NULL DEFAULT '10000',
355 `49` int(11) NOT NULL DEFAULT '10000',
356 `50` int(11) NOT NULL DEFAULT '10000',
357 `51` int(11) NOT NULL DEFAULT '10000',
358 `52` int(11) NOT NULL DEFAULT '10000',
359 `53` int(11) NOT NULL DEFAULT '10000',
360 `54` int(11) NOT NULL DEFAULT '10000',
361 `55` int(11) NOT NULL DEFAULT '10000',
362 PRIMARY KEY (`uid`)
363) ENGINE=MyISAM DEFAULT CHARSET=latin1;
364
365-- Dumping data for table pgrpdev_realsantos.gta_fuel: 0 rows
366DELETE FROM `gta_fuel`;
367/*!40000 ALTER TABLE `gta_fuel` DISABLE KEYS */;
368/*!40000 ALTER TABLE `gta_fuel` ENABLE KEYS */;
369
370
371-- Dumping structure for table pgrpdev_realsantos.gta_organization
372CREATE TABLE IF NOT EXISTS `gta_organization` (
373 `name` text NOT NULL,
374 `motd` text NOT NULL,
375 `owner` text NOT NULL,
376 `id` int(11) NOT NULL AUTO_INCREMENT,
377 PRIMARY KEY (`id`)
378) ENGINE=MyISAM DEFAULT CHARSET=latin1;
379
380-- Dumping data for table pgrpdev_realsantos.gta_organization: 0 rows
381DELETE FROM `gta_organization`;
382/*!40000 ALTER TABLE `gta_organization` DISABLE KEYS */;
383/*!40000 ALTER TABLE `gta_organization` ENABLE KEYS */;
384
385
386-- Dumping structure for table pgrpdev_realsantos.gta_reports
387CREATE TABLE IF NOT EXISTS `gta_reports` (
388 `report_id` int(11) NOT NULL AUTO_INCREMENT,
389 `caller_steamid` varchar(255) DEFAULT NULL,
390 `caller_name` varchar(255) DEFAULT NULL,
391 `report_text` varchar(255) DEFAULT NULL,
392 `time` varchar(255) DEFAULT NULL,
393 `admin` varchar(255) DEFAULT NULL,
394 `reason` varchar(255) DEFAULT NULL,
395 PRIMARY KEY (`report_id`)
396) ENGINE=MyISAM DEFAULT CHARSET=latin1;
397
398-- Dumping data for table pgrpdev_realsantos.gta_reports: 0 rows
399DELETE FROM `gta_reports`;
400/*!40000 ALTER TABLE `gta_reports` DISABLE KEYS */;
401/*!40000 ALTER TABLE `gta_reports` ENABLE KEYS */;
402
403
404-- Dumping structure for table pgrpdev_realsantos.gta_system
405CREATE TABLE IF NOT EXISTS `gta_system` (
406 `key` text NOT NULL,
407 `value` text NOT NULL,
408 PRIMARY KEY (`key`(15))
409) ENGINE=MyISAM DEFAULT CHARSET=latin1;
410
411-- Dumping data for table pgrpdev_realsantos.gta_system: 0 rows
412DELETE FROM `gta_system`;
413/*!40000 ALTER TABLE `gta_system` DISABLE KEYS */;
414/*!40000 ALTER TABLE `gta_system` ENABLE KEYS */;
415
416
417-- Dumping structure for table pgrpdev_realsantos.gta_users
418CREATE TABLE IF NOT EXISTS `gta_users` (
419 `uid` bigint(11) NOT NULL,
420 `id` text NOT NULL,
421 `steamid` text NOT NULL,
422 `blacklists` text NOT NULL,
423 `rp_name_first` text NOT NULL,
424 `rp_name_last` text NOT NULL,
425 `time_played` bigint(20) NOT NULL,
426 `cash` bigint(20) NOT NULL,
427 `model` text NOT NULL,
428 `items` text NOT NULL,
429 `storage` text NOT NULL,
430 `skills` text NOT NULL,
431 `genes` text NOT NULL,
432 `formulas` text NOT NULL,
433 `organization` int(11) NOT NULL DEFAULT '0',
434 `bank` bigint(20) NOT NULL,
435 `ringtones` text NOT NULL,
436 `ammo_pistol` int(11) unsigned zerofill NOT NULL DEFAULT '00000000000',
437 `ammo_rifle` int(11) unsigned zerofill NOT NULL DEFAULT '00000000000',
438 `ammo_shotgun` int(11) unsigned zerofill NOT NULL DEFAULT '00000000000',
439 `ringtone` int(11) NOT NULL DEFAULT '1',
440 `last_played` text NOT NULL,
441 `fuelleft` int(11) NOT NULL DEFAULT '10000',
442 `ticket` int(11) DEFAULT NULL,
443 `vehicles` longtext,
444 `lastcar` longtext,
445 `skateboard` int(11) DEFAULT NULL,
446 `physgun` varchar(255) DEFAULT NULL,
447 `acccessory` text,
448 `accessory2` text,
449 `accessory3` text,
450 `rank` text NOT NULL,
451 `police_played` int(11) DEFAULT '0',
452 PRIMARY KEY (`uid`,`id`(15),`steamid`(15))
453) ENGINE=MyISAM DEFAULT CHARSET=latin1;
454
455-- Dumping data for table pgrpdev_realsantos.gta_users: 0 rows
456DELETE FROM `gta_users`;
457/*!40000 ALTER TABLE `gta_users` DISABLE KEYS */;
458/*!40000 ALTER TABLE `gta_users` ENABLE KEYS */;
459
460
461-- Dumping structure for table pgrpdev_realsantos.gta_warnings
462CREATE TABLE IF NOT EXISTS `gta_warnings` (
463 `steamid` varchar(255) DEFAULT NULL,
464 `rp_name` varchar(255) DEFAULT NULL,
465 `steam_name` varchar(255) DEFAULT NULL,
466 `admin_sid` varchar(255) DEFAULT NULL,
467 `admin_name` varchar(255) DEFAULT NULL,
468 `reason` varchar(255) DEFAULT NULL,
469 `time` varchar(255) DEFAULT NULL,
470 `time_` int(255) DEFAULT NULL,
471 UNIQUE KEY `time_` (`time_`)
472) ENGINE=MyISAM DEFAULT CHARSET=latin1;
473
474-- Dumping data for table pgrpdev_realsantos.gta_warnings: 0 rows
475DELETE FROM `gta_warnings`;
476/*!40000 ALTER TABLE `gta_warnings` DISABLE KEYS */;
477/*!40000 ALTER TABLE `gta_warnings` ENABLE KEYS */;
478
479
480-- Dumping structure for table pgrpdev_realsantos.ip_intel
481CREATE TABLE IF NOT EXISTS `ip_intel` (
482 `steamid` text NOT NULL,
483 `ip` text,
484 `name` text,
485 `first_seen` bigint(20) DEFAULT '0',
486 `last_seen` bigint(20) DEFAULT '0',
487 `num_seen` int(11) DEFAULT '0',
488 `unique_id` text,
489 `rp_name` text,
490 `play_time` bigint(20) DEFAULT '0',
491 `strikes` bigint(10) NOT NULL DEFAULT '0',
492 `prof_linked` bigint(10) DEFAULT '0',
493 PRIMARY KEY (`steamid`(20))
494) ENGINE=MyISAM DEFAULT CHARSET=latin1;
495
496-- Dumping data for table pgrpdev_realsantos.ip_intel: 6 rows
497DELETE FROM `ip_intel`;
498/*!40000 ALTER TABLE `ip_intel` DISABLE KEYS */;
499INSERT INTO `ip_intel` (`steamid`, `ip`, `name`, `first_seen`, `last_seen`, `num_seen`, `unique_id`, `rp_name`, `play_time`, `strikes`, `prof_linked`) VALUES
500 ('STEAM_0:1:25789514', '192.168.1.100', 'Nykez', 1497930093, 1515475905, 332, '2661280956', 'Jordan Doe', 196916, 0, 0),
501 ('BOT', 'Error!', 'Bot01', 1497936646, 1503353234, 9, '1513418020', '', 25894, 0, 0),
502 ('STEAM_0:1:41794181', '173.56.190.59', 'Labyrinth', 1503335988, 1503335988, 1, '1944270734', '', 11, 0, 0),
503 ('STEAM_0:1:29285525', '174.77.133.108', 'DeeCee', 1503348999, 1503348999, 1, '4136124092', 'Dee Dee', 255, 0, 0),
504 ('STEAM_0:0:51890499', '68.53.212.134', 'Huskey', 1503357452, 1503357452, 1, '3960752869', '', 30, 0, 0),
505 ('STEAM_0:0:39588109', '94.49.166.69', 'Ganged', 1503414450, 1503414450, 1, '1151441470', 'Ganged Dough', 822, 0, 0);
506/*!40000 ALTER TABLE `ip_intel` ENABLE KEYS */;
507
508
509-- Dumping structure for table pgrpdev_realsantos.logs
510CREATE TABLE IF NOT EXISTS `logs` (
511 `ID` int(11) NOT NULL AUTO_INCREMENT,
512 `TYPE` text NOT NULL,
513 `TIME` text NOT NULL,
514 `INFO` text NOT NULL,
515 `ADMIN` text NOT NULL,
516 `OPTIONAL` text NOT NULL,
517 `SERVER` text NOT NULL,
518 PRIMARY KEY (`ID`),
519 UNIQUE KEY `ID` (`ID`)
520) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
521
522-- Dumping data for table pgrpdev_realsantos.logs: ~24 rows (approximately)
523DELETE FROM `logs`;
524/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
525INSERT INTO `logs` (`ID`, `TYPE`, `TIME`, `INFO`, `ADMIN`, `OPTIONAL`, `SERVER`) VALUES
526 (1, 'ASS_ACL_TELEPORT', '1501533453', 'brought "Bot01" (BOT | Guest) to themself', 'Nykez', 'NA', 'APEXGaming.net Dev'),
527 (2, 'ASS_ACL_TELEPORT', '1501533473', 'brought "Bot01" (BOT | Guest) to themself', 'Nykez', 'NA', 'APEXGaming.net Dev'),
528 (3, 'ASS_ACL_REVIVE', '1501709820', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
529 (4, 'ASS_ACL_REVIVE', '1501710775', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
530 (5, 'ASS_ACL_REVIVE', '1501731577', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
531 (6, 'ASS_ACL_REVIVE', '1501864741', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
532 (7, 'ASS_ACL_MAP', '1501866271', 'changed map to rp_EvoCity2_v5p', 'Nykez', 'NA', 'APEXGaming.net Dev'),
533 (8, 'ASS_ACL_REVIVE', '1501867505', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
534 (9, 'ASS_ACL_REVIVE', '1502391044', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
535 (10, 'ASS_ACL_REVIVE', '1502392570', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
536 (11, 'ASS_ACL_TELEPORT', '1502402139', 'brought "Bot01" (BOT | Guest) to themself', 'Nykez', 'NA', 'APEXGaming.net Dev'),
537 (12, 'ASS_ACL_TELEPORT', '1502402159', 'brought "Bot02" (BOT | Guest) to themself', 'Nykez', 'NA', 'APEXGaming.net Dev'),
538 (13, 'ASS_ACL_TELEPORT', '1502402163', 'brought "Bot04" (BOT | Guest) to themself', 'Nykez', 'NA', 'APEXGaming.net Dev'),
539 (14, 'ASS_ACL_TELEPORT', '1502402164', 'brought "Bot04" (BOT | Guest) to themself', 'Nykez', 'NA', 'APEXGaming.net Dev'),
540 (15, 'ASS_ACL_REVIVE', '1502475325', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
541 (16, 'ASS_ACL_REVIVE', '1502758142', 'revived "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
542 (17, 'ASS_ACL_ARREST', '1502758527', 'arrested "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
543 (18, 'ASS_ACL_REVIVE', '1502823094', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
544 (19, 'ASS_ACL_REVIVE', '1502823671', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
545 (20, 'ASS_ACL_REVIVE', '1502832453', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
546 (21, 'ASS_ACL_REVIVE', '1502903229', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
547 (22, 'ASS_ACL_REVIVE', '1503016266', 'revived "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
548 (23, 'ASS_ACL_REVIVE', '1503016282', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev'),
549 (24, 'ASS_ACL_REVIVE', '1503351959', 'respawned "Nykez" (STEAM_0:1:25789514 | Manager)', 'Nykez', 'NA', 'APEXGaming.net Dev');
550/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
551
552
553-- Dumping structure for table pgrpdev_realsantos.messages
554CREATE TABLE IF NOT EXISTS `messages` (
555 `_Key` int(11) NOT NULL AUTO_INCREMENT,
556 `_ServerName` varchar(255) NOT NULL,
557 `_PlayerName` varchar(255) NOT NULL,
558 `_Text` text NOT NULL,
559 `_Color` varchar(255) NOT NULL,
560 PRIMARY KEY (`_Key`)
561) ENGINE=InnoDB DEFAULT CHARSET=latin1;
562
563-- Dumping data for table pgrpdev_realsantos.messages: ~0 rows (approximately)
564DELETE FROM `messages`;
565/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
566/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
567
568
569-- Dumping structure for table pgrpdev_realsantos.orgs_npcs
570CREATE TABLE IF NOT EXISTS `orgs_npcs` (
571 `id` int(11) NOT NULL AUTO_INCREMENT,
572 `pos` text NOT NULL,
573 `angle` text NOT NULL,
574 `map` text NOT NULL,
575 PRIMARY KEY (`id`)
576) ENGINE=MyISAM DEFAULT CHARSET=utf8;
577
578-- Dumping data for table pgrpdev_realsantos.orgs_npcs: 0 rows
579DELETE FROM `orgs_npcs`;
580/*!40000 ALTER TABLE `orgs_npcs` DISABLE KEYS */;
581/*!40000 ALTER TABLE `orgs_npcs` ENABLE KEYS */;
582
583
584-- Dumping structure for table pgrpdev_realsantos.orgs_orgs
585CREATE TABLE IF NOT EXISTS `orgs_orgs` (
586 `id` int(11) NOT NULL AUTO_INCREMENT,
587 `name` text NOT NULL,
588 `motd` text NOT NULL,
589 `bankbalance` int(11) NOT NULL,
590 PRIMARY KEY (`id`)
591) ENGINE=MyISAM DEFAULT CHARSET=utf8;
592
593-- Dumping data for table pgrpdev_realsantos.orgs_orgs: 0 rows
594DELETE FROM `orgs_orgs`;
595/*!40000 ALTER TABLE `orgs_orgs` DISABLE KEYS */;
596/*!40000 ALTER TABLE `orgs_orgs` ENABLE KEYS */;
597
598
599-- Dumping structure for table pgrpdev_realsantos.orgs_players
600CREATE TABLE IF NOT EXISTS `orgs_players` (
601 `id` int(11) NOT NULL AUTO_INCREMENT,
602 `steamid` text NOT NULL,
603 `name` text NOT NULL,
604 `rank` text NOT NULL,
605 `orgid` int(11) NOT NULL,
606 `lastseen` text NOT NULL,
607 PRIMARY KEY (`id`)
608) ENGINE=MyISAM DEFAULT CHARSET=utf8;
609
610-- Dumping data for table pgrpdev_realsantos.orgs_players: 0 rows
611DELETE FROM `orgs_players`;
612/*!40000 ALTER TABLE `orgs_players` DISABLE KEYS */;
613/*!40000 ALTER TABLE `orgs_players` ENABLE KEYS */;
614
615
616-- Dumping structure for table pgrpdev_realsantos.orgs_ranks
617CREATE TABLE IF NOT EXISTS `orgs_ranks` (
618 `id` int(11) NOT NULL AUTO_INCREMENT,
619 `name` text NOT NULL,
620 `flags` text NOT NULL,
621 `orgid` int(11) NOT NULL,
622 PRIMARY KEY (`id`)
623) ENGINE=MyISAM DEFAULT CHARSET=utf8;
624
625-- Dumping data for table pgrpdev_realsantos.orgs_ranks: 0 rows
626DELETE FROM `orgs_ranks`;
627/*!40000 ALTER TABLE `orgs_ranks` DISABLE KEYS */;
628/*!40000 ALTER TABLE `orgs_ranks` ENABLE KEYS */;
629
630
631-- Dumping structure for table pgrpdev_realsantos.perp_blacklists
632CREATE TABLE IF NOT EXISTS `perp_blacklists` (
633 `id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
634 `type` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
635 `expire` bigint(100) NOT NULL,
636 `value` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '',
637 `reason` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
638 `adminid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_cs DEFAULT NULL
639) ENGINE=InnoDB DEFAULT CHARSET=latin1;
640
641-- Dumping data for table pgrpdev_realsantos.perp_blacklists: ~0 rows (approximately)
642DELETE FROM `perp_blacklists`;
643/*!40000 ALTER TABLE `perp_blacklists` DISABLE KEYS */;
644/*!40000 ALTER TABLE `perp_blacklists` ENABLE KEYS */;
645
646
647-- Dumping structure for table pgrpdev_realsantos.perp_organization
648CREATE TABLE IF NOT EXISTS `perp_organization` (
649 `id` int(11) NOT NULL,
650 `name` text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
651 `motd` text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
652 `owner` text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
653 `approver` text NOT NULL
654) ENGINE=MyISAM DEFAULT CHARSET=latin1;
655
656-- Dumping data for table pgrpdev_realsantos.perp_organization: 2 rows
657DELETE FROM `perp_organization`;
658/*!40000 ALTER TABLE `perp_organization` DISABLE KEYS */;
659INSERT INTO `perp_organization` (`id`, `name`, `motd`, `owner`, `approver`) VALUES
660 (0, 'New Organization', 'No Current MOTD', 'STEAM_0:1:25789514', ''),
661 (0, 'New Organization', 'No Current MOTD', 'STEAM_0:1:25789514', '');
662/*!40000 ALTER TABLE `perp_organization` ENABLE KEYS */;
663
664
665-- Dumping structure for table pgrpdev_realsantos.perp_slack
666CREATE TABLE IF NOT EXISTS `perp_slack` (
667 `id` int(11) NOT NULL AUTO_INCREMENT,
668 `user` text NOT NULL,
669 `message` text NOT NULL,
670 PRIMARY KEY (`id`)
671) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
672
673-- Dumping data for table pgrpdev_realsantos.perp_slack: 9 rows
674DELETE FROM `perp_slack`;
675/*!40000 ALTER TABLE `perp_slack` DISABLE KEYS */;
676INSERT INTO `perp_slack` (`id`, `user`, `message`) VALUES
677 (20, 'nykez', ''),
678 (18, 'nykez', 'nigger'),
679 (19, 'nykez', 'nigger'),
680 (17, '', ''),
681 (15, 'nykez', 'hshss'),
682 (16, 'labyrinthlg', 'fuck niggersz'),
683 (21, 'nykez', ''),
684 (22, 'nykez', ''),
685 (23, '', '');
686/*!40000 ALTER TABLE `perp_slack` ENABLE KEYS */;
687
688
689-- Dumping structure for table pgrpdev_realsantos.perp_users
690CREATE TABLE IF NOT EXISTS `perp_users` (
691 `plate_id` int(10) NOT NULL,
692 `id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
693 `rp_name_first` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
694 `rp_name_last` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
695 `time_played` bigint(20) NOT NULL DEFAULT '0',
696 `cash` bigint(20) NOT NULL DEFAULT '0',
697 `bank` bigint(20) NOT NULL DEFAULT '0',
698 `model` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
699 `newmodel` text NOT NULL,
700 `items` text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
701 `skills` varchar(150) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
702 `genes` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
703 `formulas` varchar(150) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
704 `organization` int(11) NOT NULL DEFAULT '0',
705 `ammo` varchar(100) NOT NULL DEFAULT '0',
706 `ringtone` int(11) NOT NULL DEFAULT '1',
707 `last_played` int(11) NOT NULL DEFAULT '0',
708 `physgun_col` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
709 `job_times` varchar(150) CHARACTER SET utf8 DEFAULT NULL,
710 `skin` int(11) DEFAULT '0',
711 `ticket` longtext
712) ENGINE=MyISAM DEFAULT CHARSET=latin1;
713
714-- Dumping data for table pgrpdev_realsantos.perp_users: 1 rows
715DELETE FROM `perp_users`;
716/*!40000 ALTER TABLE `perp_users` DISABLE KEYS */;
717INSERT INTO `perp_users` (`plate_id`, `id`, `rp_name_first`, `rp_name_last`, `time_played`, `cash`, `bank`, `model`, `newmodel`, `items`, `skills`, `genes`, `formulas`, `organization`, `ammo`, `ringtone`, `last_played`, `physgun_col`, `job_times`, `skin`, `ticket`) VALUES
718 (0, 'STEAM_0:1:25789514', 'Jordan', 'Doe', 535097, 0, 439099, '1_1_8', '', '1,211,1;2,210,1;3,101,2;4,24,1;5,21,1;6,1104,1;7,205,1;8,1100,1;9,210,2;11,7,1;12,55,4;13,98,1;14,54,2;16,10,5;17,75,5;18,3,1;19,208,1;20,1500,2;21,15,1;', '260-0-0-75-0-0-0-0-0-0-22-145-0-', '5-0.0.0.0.0.', '75-41-400-', 0, '0-0-0', 1, 1515476619, '0.57,0.57,0.57', '50000;50000;50000;50000;50000;', 0, '[]');
719/*!40000 ALTER TABLE `perp_users` ENABLE KEYS */;
720
721
722-- Dumping structure for table pgrpdev_realsantos.perp_vehicles
723CREATE TABLE IF NOT EXISTS `perp_vehicles` (
724 `steamid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
725 `car_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
726 `paint_id` int(1) NOT NULL DEFAULT '1',
727 `headlight_id` int(3) NOT NULL DEFAULT '1',
728 `underglow_id` int(3) NOT NULL DEFAULT '0',
729 `anti-theft` int(1) NOT NULL DEFAULT '0',
730 `hydraulics` int(1) NOT NULL DEFAULT '0',
731 `custom_horn` int(1) NOT NULL DEFAULT '0',
732 `rgb_colour` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_cs DEFAULT '',
733 `bodygroups` varchar(200) CHARACTER SET latin1 COLLATE latin1_general_cs DEFAULT '',
734 `disabled` int(1) NOT NULL DEFAULT '0',
735 `fuel` int(5) NOT NULL DEFAULT '10000',
736 `tint` int(11) DEFAULT '0',
737 `plate_id` varchar(50) DEFAULT 'nil',
738 `trunk` longtext
739) ENGINE=InnoDB DEFAULT CHARSET=latin1;
740
741-- Dumping data for table pgrpdev_realsantos.perp_vehicles: ~3 rows (approximately)
742DELETE FROM `perp_vehicles`;
743/*!40000 ALTER TABLE `perp_vehicles` DISABLE KEYS */;
744INSERT INTO `perp_vehicles` (`steamid`, `car_id`, `paint_id`, `headlight_id`, `underglow_id`, `anti-theft`, `hydraulics`, `custom_horn`, `rgb_colour`, `bodygroups`, `disabled`, `fuel`, `tint`, `plate_id`, `trunk`) VALUES
745 ('STEAM_0:1:25789514', 'porsche_caymangt4', 1, 1, 0, 0, 0, 0, '', '', 0, 9434, 0, 'OEC-240', '[]'),
746 ('STEAM_0:1:25789514', 'dodge_3500laramie', 1, 1, 0, 0, 0, 0, '', '', 0, 8522, 0, 'EQX-085', '{"89":1,"75":1}'),
747 ('STEAM_0:1:25789514', 'nissan_370_nismo', 1, 1, 0, 0, 0, 0, '', '', 0, 9989, 0, 'ZWN-370', '{"1104":1,"84":1,"21":1,"1100":1,"98":1,"83":1,"10":1,"24":1,"33":1,"101":1,"7":1,"15":1,"75":1}');
748/*!40000 ALTER TABLE `perp_vehicles` ENABLE KEYS */;
749
750
751-- Dumping structure for table pgrpdev_realsantos.perp_vips
752CREATE TABLE IF NOT EXISTS `perp_vips` (
753 `steamid` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
754 `expire` bigint(20) NOT NULL,
755 `sent_vip` int(1) NOT NULL DEFAULT '0',
756 `txn_id` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_cs DEFAULT NULL,
757 `suspended` int(1) NOT NULL DEFAULT '0'
758) ENGINE=InnoDB DEFAULT CHARSET=latin1;
759
760-- Dumping data for table pgrpdev_realsantos.perp_vips: ~0 rows (approximately)
761DELETE FROM `perp_vips`;
762/*!40000 ALTER TABLE `perp_vips` DISABLE KEYS */;
763/*!40000 ALTER TABLE `perp_vips` ENABLE KEYS */;
764
765
766-- Dumping structure for table pgrpdev_realsantos.perp_warehouse
767CREATE TABLE IF NOT EXISTS `perp_warehouse` (
768 `steamid` text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
769 `itemid` int(10) NOT NULL,
770 `amount` int(10) NOT NULL
771) ENGINE=InnoDB DEFAULT CHARSET=latin1;
772
773-- Dumping data for table pgrpdev_realsantos.perp_warehouse: ~56 rows (approximately)
774DELETE FROM `perp_warehouse`;
775/*!40000 ALTER TABLE `perp_warehouse` DISABLE KEYS */;
776INSERT INTO `perp_warehouse` (`steamid`, `itemid`, `amount`) VALUES
777 ('STEAM_0:1:25789514', 104, 1),
778 ('STEAM_0:1:25789514', 132, 1),
779 ('STEAM_0:1:25789514', 2, 1),
780 ('STEAM_0:1:25789514', 10, 1),
781 ('STEAM_0:1:25789514', 10, 2),
782 ('STEAM_0:1:25789514', 10, 3),
783 ('STEAM_0:1:25789514', 10, 4),
784 ('STEAM_0:1:25789514', 10, 5),
785 ('STEAM_0:1:25789514', 131, 1),
786 ('STEAM_0:1:25789514', 96, 1),
787 ('STEAM_0:1:25789514', 86, 1),
788 ('STEAM_0:1:25789514', 86, 2),
789 ('STEAM_0:1:25789514', 97, 1),
790 ('STEAM_0:1:25789514', 92, 1),
791 ('STEAM_0:1:25789514', 94, 1),
792 ('STEAM_0:1:25789514', 87, 1),
793 ('STEAM_0:1:25789514', 10, 4),
794 ('STEAM_0:1:25789514', 90, 1),
795 ('STEAM_0:1:25789514', 100, 1),
796 ('STEAM_0:1:25789514', 90, 2),
797 ('STEAM_0:1:25789514', 99, 1),
798 ('STEAM_0:1:25789514', 91, 1),
799 ('STEAM_0:1:25789514', 10, 5),
800 ('STEAM_0:1:25789514', 501, 3),
801 ('STEAM_0:1:25789514', 112, 1),
802 ('STEAM_0:1:25789514', 93, 1),
803 ('STEAM_0:1:25789514', 87, 2),
804 ('STEAM_0:1:25789514', 1105, 2),
805 ('STEAM_0:1:25789514', 1101, 2),
806 ('STEAM_0:1:25789514', 1501, 2),
807 ('STEAM_0:1:25789514', 1502, 1),
808 ('STEAM_0:1:25789514', 1501, 3),
809 ('STEAM_0:1:25789514', 1502, 2),
810 ('STEAM_0:1:25789514', 1506, 2),
811 ('STEAM_0:1:25789514', 92, 2),
812 ('STEAM_0:1:25789514', 101, 1),
813 ('STEAM_0:1:25789514', 101, 2),
814 ('STEAM_0:1:25789514', 10, 4),
815 ('STEAM_0:1:25789514', 10, 3),
816 ('STEAM_0:1:25789514', 10, 2),
817 ('STEAM_0:1:25789514', 10, 1),
818 ('STEAM_0:1:25789514', 82, 1),
819 ('STEAM_0:1:25789514', 82, 2),
820 ('STEAM_0:1:25789514', 82, 3),
821 ('STEAM_0:1:25789514', 82, 4),
822 ('STEAM_0:1:25789514', 82, 5),
823 ('STEAM_0:1:25789514', 32, 1),
824 ('STEAM_0:1:25789514', 30, 1),
825 ('STEAM_0:1:25789514', 12, 1),
826 ('STEAM_0:1:25789514', 47, 1),
827 ('STEAM_0:1:25789514', 28, 1),
828 ('STEAM_0:1:25789514', 45, 1),
829 ('STEAM_0:1:25789514', 24, 2),
830 ('STEAM_0:1:25789514', 98, 2),
831 ('STEAM_0:1:25789514', 98, 1),
832 ('STEAM_0:1:25789514', 101, 1);
833/*!40000 ALTER TABLE `perp_warehouse` ENABLE KEYS */;
834
835
836-- Dumping structure for table pgrpdev_realsantos.perp_whitelist
837CREATE TABLE IF NOT EXISTS `perp_whitelist` (
838 `unique` int(11) NOT NULL,
839 `id` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
840 `type` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
841 `timestamp` bigint(100) NOT NULL,
842 `value` varchar(50) NOT NULL,
843 `note` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
844 `adminid` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL
845) ENGINE=InnoDB DEFAULT CHARSET=latin1;
846
847-- Dumping data for table pgrpdev_realsantos.perp_whitelist: ~4 rows (approximately)
848DELETE FROM `perp_whitelist`;
849/*!40000 ALTER TABLE `perp_whitelist` DISABLE KEYS */;
850INSERT INTO `perp_whitelist` (`unique`, `id`, `type`, `timestamp`, `value`, `note`, `adminid`) VALUES
851 (0, 'STEAM_0:1:25789514', 'job', 1501873479, 'TEAM_STATECOL', 'Nykez', 'STEAM_0:1:25789514'),
852 (0, 'STEAM_0:1:25789514', 'job', 1501873815, 'TEAM_STATEPOL', 'Nykez', 'STEAM_0:1:25789514'),
853 (0, 'STEAM_0:1:25789514', 'job', 1503161207, 'TEAM_STATEPOL', 'Nykez', 'STEAM_0:1:25789514'),
854 (0, 'STEAM_0:1:25789514', 'job', 1503161215, 'TEAM_STATECOL', 'Nykez', 'STEAM_0:1:25789514');
855/*!40000 ALTER TABLE `perp_whitelist` ENABLE KEYS */;
856
857
858-- Dumping structure for table pgrpdev_realsantos.players
859CREATE TABLE IF NOT EXISTS `players` (
860 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
861 `steamid` varchar(255) NOT NULL,
862 PRIMARY KEY (`id`),
863 KEY `steamid` (`steamid`)
864) ENGINE=InnoDB DEFAULT CHARSET=latin1;
865
866-- Dumping data for table pgrpdev_realsantos.players: ~0 rows (approximately)
867DELETE FROM `players`;
868/*!40000 ALTER TABLE `players` DISABLE KEYS */;
869/*!40000 ALTER TABLE `players` ENABLE KEYS */;
870
871
872-- Dumping structure for table pgrpdev_realsantos.pointshop_data
873CREATE TABLE IF NOT EXISTS `pointshop_data` (
874 `uniqueid` varchar(30) NOT NULL,
875 `points` int(32) NOT NULL,
876 `items` text NOT NULL,
877 PRIMARY KEY (`uniqueid`)
878) ENGINE=MyISAM DEFAULT CHARSET=latin1;
879
880-- Dumping data for table pgrpdev_realsantos.pointshop_data: 0 rows
881DELETE FROM `pointshop_data`;
882/*!40000 ALTER TABLE `pointshop_data` DISABLE KEYS */;
883/*!40000 ALTER TABLE `pointshop_data` ENABLE KEYS */;
884
885
886-- Dumping structure for table pgrpdev_realsantos.police_data
887CREATE TABLE IF NOT EXISTS `police_data` (
888 `id` int(11) NOT NULL AUTO_INCREMENT,
889 `steam_id` varchar(25) NOT NULL,
890 `name` varchar(255) NOT NULL,
891 `tickets` longtext,
892 `stats` longtext,
893 `license` varchar(255) NOT NULL,
894 `rank` varchar(255) NOT NULL,
895 PRIMARY KEY (`id`)
896) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
897
898-- Dumping data for table pgrpdev_realsantos.police_data: 2 rows
899DELETE FROM `police_data`;
900/*!40000 ALTER TABLE `police_data` DISABLE KEYS */;
901INSERT INTO `police_data` (`id`, `steam_id`, `name`, `tickets`, `stats`, `license`, `rank`) VALUES
902 (1, 'STEAM_0:0:0', 'Nykez', '[]', '[]', 'YWJ-333', '0'),
903 (2, 'STEAM_0:1:25789514', 'Jordan Howard', '[]', '[]', 'ZNK-905', '0');
904/*!40000 ALTER TABLE `police_data` ENABLE KEYS */;
905
906
907-- Dumping structure for table pgrpdev_realsantos.reports
908CREATE TABLE IF NOT EXISTS `reports` (
909 `id` int(11) NOT NULL,
910 `reporter_steamid` varchar(255) NOT NULL,
911 `reporter_nick` varchar(255) NOT NULL,
912 `reporter_rpname` varchar(255) NOT NULL,
913 `reported_steamid` varchar(255) NOT NULL,
914 `reported_nick` varchar(255) NOT NULL,
915 `reported_rpname` varchar(255) NOT NULL,
916 `reason` varchar(255) NOT NULL,
917 `description` text NOT NULL,
918 `time_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
919 `resolved_by` varchar(255) NOT NULL DEFAULT '',
920 `warning_level` int(11) DEFAULT NULL
921) ENGINE=InnoDB DEFAULT CHARSET=latin1;
922
923-- Dumping data for table pgrpdev_realsantos.reports: ~0 rows (approximately)
924DELETE FROM `reports`;
925/*!40000 ALTER TABLE `reports` DISABLE KEYS */;
926/*!40000 ALTER TABLE `reports` ENABLE KEYS */;
927
928
929-- Dumping structure for table pgrpdev_realsantos.servers
930CREATE TABLE IF NOT EXISTS `servers` (
931 `ServerID` text,
932 `IPAddress` text,
933 `HostName` text,
934 `Gamemode` text,
935 `Map` text
936) ENGINE=MyISAM DEFAULT CHARSET=utf8;
937
938-- Dumping data for table pgrpdev_realsantos.servers: 0 rows
939DELETE FROM `servers`;
940/*!40000 ALTER TABLE `servers` DISABLE KEYS */;
941/*!40000 ALTER TABLE `servers` ENABLE KEYS */;
942
943
944-- Dumping structure for table pgrpdev_realsantos.server_bans
945CREATE TABLE IF NOT EXISTS `server_bans` (
946 `steamid` text NOT NULL,
947 `unban_time` bigint(20) NOT NULL,
948 `banner_name` text NOT NULL,
949 `banner_steamid` text NOT NULL,
950 `reason` text NOT NULL,
951 `banned_name` text NOT NULL,
952 `time_banned` bigint(20) NOT NULL,
953 PRIMARY KEY (`steamid`(20))
954) ENGINE=MyISAM DEFAULT CHARSET=latin1;
955
956-- Dumping data for table pgrpdev_realsantos.server_bans: 0 rows
957DELETE FROM `server_bans`;
958/*!40000 ALTER TABLE `server_bans` DISABLE KEYS */;
959/*!40000 ALTER TABLE `server_bans` ENABLE KEYS */;
960
961
962-- Dumping structure for table pgrpdev_realsantos.server_bans_history
963CREATE TABLE IF NOT EXISTS `server_bans_history` (
964 `id` int(10) NOT NULL AUTO_INCREMENT,
965 `steamid` text NOT NULL,
966 `unban_time` bigint(20) NOT NULL,
967 `banner_name` text NOT NULL,
968 `banner_steamid` text NOT NULL,
969 `reason` text NOT NULL,
970 `banned_name` text NOT NULL,
971 `time_banned` text,
972 `type` varchar(20) DEFAULT 'server ban',
973 PRIMARY KEY (`id`),
974 UNIQUE KEY `id` (`id`)
975) ENGINE=MyISAM DEFAULT CHARSET=utf8;
976
977-- Dumping data for table pgrpdev_realsantos.server_bans_history: 0 rows
978DELETE FROM `server_bans_history`;
979/*!40000 ALTER TABLE `server_bans_history` DISABLE KEYS */;
980/*!40000 ALTER TABLE `server_bans_history` ENABLE KEYS */;
981
982
983-- Dumping structure for table pgrpdev_realsantos.server_bans_logs
984CREATE TABLE IF NOT EXISTS `server_bans_logs` (
985 `steamid` text NOT NULL,
986 `type` text NOT NULL,
987 `committed_by` text NOT NULL,
988 `reason` text NOT NULL
989) ENGINE=MyISAM DEFAULT CHARSET=utf8;
990
991-- Dumping data for table pgrpdev_realsantos.server_bans_logs: 0 rows
992DELETE FROM `server_bans_logs`;
993/*!40000 ALTER TABLE `server_bans_logs` DISABLE KEYS */;
994/*!40000 ALTER TABLE `server_bans_logs` ENABLE KEYS */;
995
996
997-- Dumping structure for table pgrpdev_realsantos.server_bans_points
998CREATE TABLE IF NOT EXISTS `server_bans_points` (
999 `steamid` text NOT NULL,
1000 `time` bigint(20) NOT NULL DEFAULT '0',
1001 `id` bigint(10) NOT NULL
1002) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1003
1004-- Dumping data for table pgrpdev_realsantos.server_bans_points: ~0 rows (approximately)
1005DELETE FROM `server_bans_points`;
1006/*!40000 ALTER TABLE `server_bans_points` DISABLE KEYS */;
1007/*!40000 ALTER TABLE `server_bans_points` ENABLE KEYS */;
1008
1009
1010-- Dumping structure for table pgrpdev_realsantos.server_status
1011CREATE TABLE IF NOT EXISTS `server_status` (
1012 `ip` varchar(32) NOT NULL,
1013 `gamemode` text NOT NULL,
1014 `hostname` text NOT NULL,
1015 `players` int(3) NOT NULL,
1016 `map` text NOT NULL,
1017 `password` text NOT NULL,
1018 `lastseen` bigint(20) NOT NULL,
1019 `otherinfo` text NOT NULL,
1020 `available` int(11) NOT NULL DEFAULT '1',
1021 PRIMARY KEY (`ip`)
1022) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1023
1024-- Dumping data for table pgrpdev_realsantos.server_status: 0 rows
1025DELETE FROM `server_status`;
1026/*!40000 ALTER TABLE `server_status` DISABLE KEYS */;
1027/*!40000 ALTER TABLE `server_status` ENABLE KEYS */;
1028
1029
1030-- Dumping structure for table pgrpdev_realsantos.ttt_skins
1031CREATE TABLE IF NOT EXISTS `ttt_skins` (
1032 `steamid` text,
1033 `wep_name` text,
1034 `skin_name` text
1035) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1036
1037-- Dumping data for table pgrpdev_realsantos.ttt_skins: 0 rows
1038DELETE FROM `ttt_skins`;
1039/*!40000 ALTER TABLE `ttt_skins` DISABLE KEYS */;
1040/*!40000 ALTER TABLE `ttt_skins` ENABLE KEYS */;
1041
1042
1043-- Dumping structure for table pgrpdev_realsantos.ttt_users
1044CREATE TABLE IF NOT EXISTS `ttt_users` (
1045 `steamid` text,
1046 `name` text,
1047 `rank` text,
1048 `ipaddress` text
1049) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1050
1051-- Dumping data for table pgrpdev_realsantos.ttt_users: 0 rows
1052DELETE FROM `ttt_users`;
1053/*!40000 ALTER TABLE `ttt_users` DISABLE KEYS */;
1054/*!40000 ALTER TABLE `ttt_users` ENABLE KEYS */;
1055
1056
1057-- Dumping structure for table pgrpdev_realsantos.vb_members_change_pw
1058CREATE TABLE IF NOT EXISTS `vb_members_change_pw` (
1059 `newpw` text NOT NULL,
1060 `steamid` text NOT NULL
1061) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1062
1063-- Dumping data for table pgrpdev_realsantos.vb_members_change_pw: 0 rows
1064DELETE FROM `vb_members_change_pw`;
1065/*!40000 ALTER TABLE `vb_members_change_pw` DISABLE KEYS */;
1066/*!40000 ALTER TABLE `vb_members_change_pw` ENABLE KEYS */;
1067
1068
1069-- Dumping structure for table pgrpdev_realsantos.vb_members_pending
1070CREATE TABLE IF NOT EXISTS `vb_members_pending` (
1071 `username` text NOT NULL,
1072 `nick` text NOT NULL,
1073 `steamid` text NOT NULL,
1074 `password` text NOT NULL,
1075 `setrank` text NOT NULL,
1076 `ipaddress` text NOT NULL
1077) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1078
1079-- Dumping data for table pgrpdev_realsantos.vb_members_pending: 0 rows
1080DELETE FROM `vb_members_pending`;
1081/*!40000 ALTER TABLE `vb_members_pending` DISABLE KEYS */;
1082/*!40000 ALTER TABLE `vb_members_pending` ENABLE KEYS */;
1083
1084
1085-- Dumping structure for table pgrpdev_realsantos._global_chat
1086CREATE TABLE IF NOT EXISTS `_global_chat` (
1087 `name` text,
1088 `text` text,
1089 `server` text
1090) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1091
1092-- Dumping data for table pgrpdev_realsantos._global_chat: ~0 rows (approximately)
1093DELETE FROM `_global_chat`;
1094/*!40000 ALTER TABLE `_global_chat` DISABLE KEYS */;
1095/*!40000 ALTER TABLE `_global_chat` ENABLE KEYS */;
1096
1097
1098-- Dumping structure for table pgrpdev_realsantos._rp_dealer
1099CREATE TABLE IF NOT EXISTS `_rp_dealer` (
1100 `item_id` int(10) NOT NULL DEFAULT '0',
1101 `item_amount` int(10) DEFAULT NULL,
1102 `dealer_id` int(10) DEFAULT NULL,
1103 `item_price` int(10) DEFAULT NULL,
1104 PRIMARY KEY (`item_id`)
1105) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1106
1107-- Dumping data for table pgrpdev_realsantos._rp_dealer: ~0 rows (approximately)
1108DELETE FROM `_rp_dealer`;
1109/*!40000 ALTER TABLE `_rp_dealer` DISABLE KEYS */;
1110/*!40000 ALTER TABLE `_rp_dealer` ENABLE KEYS */;
1111
1112
1113-- Dumping structure for table pgrpdev_realsantos._rp_lottery
1114CREATE TABLE IF NOT EXISTS `_rp_lottery` (
1115 `steamid` text NOT NULL,
1116 `amount` text NOT NULL
1117) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1118
1119-- Dumping data for table pgrpdev_realsantos._rp_lottery: ~0 rows (approximately)
1120DELETE FROM `_rp_lottery`;
1121/*!40000 ALTER TABLE `_rp_lottery` DISABLE KEYS */;
1122/*!40000 ALTER TABLE `_rp_lottery` ENABLE KEYS */;
1123
1124
1125-- Dumping structure for table pgrpdev_realsantos._rp_messages
1126CREATE TABLE IF NOT EXISTS `_rp_messages` (
1127 `message_id` int(11) NOT NULL AUTO_INCREMENT,
1128 `to_steamid` text,
1129 `to_name` text,
1130 `from_steamid` text,
1131 `from_name` text,
1132 `message` text,
1133 `curtime` int(11) DEFAULT NULL,
1134 PRIMARY KEY (`message_id`)
1135) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1136
1137-- Dumping data for table pgrpdev_realsantos._rp_messages: ~0 rows (approximately)
1138DELETE FROM `_rp_messages`;
1139/*!40000 ALTER TABLE `_rp_messages` DISABLE KEYS */;
1140/*!40000 ALTER TABLE `_rp_messages` ENABLE KEYS */;
1141
1142
1143-- Dumping structure for table pgrpdev_realsantos._rp_orgs
1144CREATE TABLE IF NOT EXISTS `_rp_orgs` (
1145 `org_id` int(10) NOT NULL AUTO_INCREMENT,
1146 `org_leader` text NOT NULL,
1147 `org_name` text NOT NULL,
1148 `org_motd` text NOT NULL,
1149 PRIMARY KEY (`org_id`)
1150) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1151
1152-- Dumping data for table pgrpdev_realsantos._rp_orgs: ~0 rows (approximately)
1153DELETE FROM `_rp_orgs`;
1154/*!40000 ALTER TABLE `_rp_orgs` DISABLE KEYS */;
1155/*!40000 ALTER TABLE `_rp_orgs` ENABLE KEYS */;
1156
1157
1158-- Dumping structure for table pgrpdev_realsantos._rp_users
1159CREATE TABLE IF NOT EXISTS `_rp_users` (
1160 `uniqueid` bigint(20) NOT NULL,
1161 `steamid` text NOT NULL,
1162 `rp_first_name` text,
1163 `rp_last_name` text,
1164 `phone_num` text,
1165 `model` text,
1166 `player_color` text,
1167 `accessory1` text,
1168 `accessory2` text,
1169 `skateboard` text,
1170 `inventory` text,
1171 `money` bigint(20) DEFAULT NULL,
1172 `org` int(11) DEFAULT NULL,
1173 `xp` int(11) DEFAULT NULL,
1174 `hunger` int(11) DEFAULT '100',
1175 `time_played` bigint(20) DEFAULT NULL,
1176 `last_joined` text,
1177 `physgun` varchar(255) DEFAULT NULL,
1178 PRIMARY KEY (`uniqueid`,`steamid`(15))
1179) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1180
1181-- Dumping data for table pgrpdev_realsantos._rp_users: 0 rows
1182DELETE FROM `_rp_users`;
1183/*!40000 ALTER TABLE `_rp_users` DISABLE KEYS */;
1184/*!40000 ALTER TABLE `_rp_users` ENABLE KEYS */;
1185
1186
1187-- Dumping structure for table pgrpdev_realsantos._rp_vehicles
1188CREATE TABLE IF NOT EXISTS `_rp_vehicles` (
1189 `unique_column` int(11) NOT NULL AUTO_INCREMENT,
1190 `steamid` text,
1191 `veh_id` int(60) DEFAULT NULL,
1192 `veh_col` text,
1193 `veh_parts` text,
1194 `veh_horn` int(11) NOT NULL DEFAULT '100',
1195 `veh_ugcol` text,
1196 `veh_nos` int(11) DEFAULT NULL,
1197 `veh_hyd` int(11) DEFAULT NULL,
1198 `veh_gas` float NOT NULL DEFAULT '50',
1199 PRIMARY KEY (`unique_column`),
1200 UNIQUE KEY `unique` (`unique_column`)
1201) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1202
1203-- Dumping data for table pgrpdev_realsantos._rp_vehicles: ~0 rows (approximately)
1204DELETE FROM `_rp_vehicles`;
1205/*!40000 ALTER TABLE `_rp_vehicles` DISABLE KEYS */;
1206/*!40000 ALTER TABLE `_rp_vehicles` ENABLE KEYS */;
1207/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
1208/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
1209/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;