· 9 years ago · Dec 18, 2016, 03:50 AM
1-- MySQL dump 10.13 Distrib 5.7.16, for Win32 (AMD64)
2--
3-- Host: localhost Database: samp_lsp
4-- ------------------------------------------------------
5-- Server version 5.7.16
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `accounts`
20--
21
22DROP TABLE IF EXISTS `accounts`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `accounts` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `username` varchar(24) NOT NULL,
28 `password` char(64) NOT NULL,
29 `salt` char(10) NOT NULL,
30 `adminlevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
31 `registered` int(11) NOT NULL DEFAULT '0',
32 `lastlogged` int(11) NOT NULL DEFAULT '0',
33 `ip` varchar(16) NOT NULL,
34 `money` int(11) NOT NULL DEFAULT '10000',
35 `email` varchar(128) NOT NULL DEFAULT '',
36 `kills` mediumint(8) unsigned NOT NULL DEFAULT '0',
37 `deaths` mediumint(8) unsigned NOT NULL DEFAULT '0',
38 `mutetime` int(11) NOT NULL DEFAULT '0',
39 `xp` int(10) unsigned NOT NULL DEFAULT '0',
40 `coins` int(11) NOT NULL DEFAULT '0',
41 `logintime` int(11) NOT NULL DEFAULT '0',
42 `weaponpack` tinyint(4) NOT NULL DEFAULT '-1',
43 `housespawn` int(11) DEFAULT NULL,
44 PRIMARY KEY (`id`),
45 UNIQUE KEY `username` (`username`),
46 KEY `housespawn` (`housespawn`),
47 CONSTRAINT `accounts_ibfk_1` FOREIGN KEY (`housespawn`) REFERENCES `houses` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
48) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
49/*!40101 SET character_set_client = @saved_cs_client */;
50
51--
52-- Dumping data for table `accounts`
53--
54
55LOCK TABLES `accounts` WRITE;
56/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
57/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
58UNLOCK TABLES;
59
60--
61-- Table structure for table `achievements`
62--
63
64DROP TABLE IF EXISTS `achievements`;
65/*!40101 SET @saved_cs_client = @@character_set_client */;
66/*!40101 SET character_set_client = utf8 */;
67CREATE TABLE `achievements` (
68 `id` int(11) NOT NULL AUTO_INCREMENT,
69 `playerid` int(11) NOT NULL,
70 `achid` tinyint(3) unsigned NOT NULL,
71 PRIMARY KEY (`id`),
72 UNIQUE KEY `playerid_2` (`playerid`,`achid`),
73 KEY `playerid` (`playerid`),
74 CONSTRAINT `achievements_ibfk_1` FOREIGN KEY (`playerid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
75) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
76/*!40101 SET character_set_client = @saved_cs_client */;
77
78--
79-- Dumping data for table `achievements`
80--
81
82LOCK TABLES `achievements` WRITE;
83/*!40000 ALTER TABLE `achievements` DISABLE KEYS */;
84/*!40000 ALTER TABLE `achievements` ENABLE KEYS */;
85UNLOCK TABLES;
86
87--
88-- Table structure for table `activity`
89--
90
91DROP TABLE IF EXISTS `activity`;
92/*!40101 SET @saved_cs_client = @@character_set_client */;
93/*!40101 SET character_set_client = utf8 */;
94CREATE TABLE `activity` (
95 `id` int(11) NOT NULL AUTO_INCREMENT,
96 `playerid` int(11) NOT NULL,
97 `ip` varchar(16) NOT NULL,
98 `action` varchar(128) NOT NULL,
99 `time` int(11) NOT NULL DEFAULT '0',
100 PRIMARY KEY (`id`),
101 KEY `playerid` (`playerid`),
102 CONSTRAINT `activity_ibfk_1` FOREIGN KEY (`playerid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
103) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;
104/*!40101 SET character_set_client = @saved_cs_client */;
105
106--
107-- Dumping data for table `activity`
108--
109
110LOCK TABLES `activity` WRITE;
111/*!40000 ALTER TABLE `activity` DISABLE KEYS */;
112/*!40000 ALTER TABLE `activity` ENABLE KEYS */;
113UNLOCK TABLES;
114
115--
116-- Table structure for table `adminlogs`
117--
118
119DROP TABLE IF EXISTS `adminlogs`;
120/*!40101 SET @saved_cs_client = @@character_set_client */;
121/*!40101 SET character_set_client = utf8 */;
122CREATE TABLE `adminlogs` (
123 `id` int(11) NOT NULL AUTO_INCREMENT,
124 `adminid` int(11) DEFAULT NULL,
125 `playerid` int(11) DEFAULT NULL,
126 `action` varchar(128) NOT NULL,
127 `value` varchar(256) NOT NULL,
128 `time` int(11) NOT NULL DEFAULT '0',
129 PRIMARY KEY (`id`),
130 KEY `adminid` (`adminid`),
131 KEY `playerid` (`playerid`),
132 CONSTRAINT `adminlogs_ibfk_1` FOREIGN KEY (`adminid`) REFERENCES `accounts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
133 CONSTRAINT `adminlogs_ibfk_2` FOREIGN KEY (`playerid`) REFERENCES `accounts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
134) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
135/*!40101 SET character_set_client = @saved_cs_client */;
136
137--
138-- Dumping data for table `adminlogs`
139--
140
141--
142-- Table structure for table `bans`
143--
144
145DROP TABLE IF EXISTS `bans`;
146/*!40101 SET @saved_cs_client = @@character_set_client */;
147/*!40101 SET character_set_client = utf8 */;
148CREATE TABLE `bans` (
149 `id` int(11) NOT NULL AUTO_INCREMENT,
150 `playerid` int(11) NOT NULL,
151 `adminid` int(11) DEFAULT NULL,
152 `bantime` int(10) unsigned NOT NULL DEFAULT '0',
153 `days` int(11) NOT NULL DEFAULT '0',
154 `reason` varchar(56) NOT NULL,
155 `expired` tinyint(1) NOT NULL DEFAULT '0',
156 PRIMARY KEY (`id`),
157 KEY `playerid` (`playerid`),
158 KEY `adminid` (`adminid`),
159 CONSTRAINT `bans_ibfk_1` FOREIGN KEY (`playerid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
160 CONSTRAINT `bans_ibfk_2` FOREIGN KEY (`adminid`) REFERENCES `accounts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
161) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
162/*!40101 SET character_set_client = @saved_cs_client */;
163
164--
165-- Dumping data for table `bans`
166--
167
168LOCK TABLES `bans` WRITE;
169/*!40000 ALTER TABLE `bans` DISABLE KEYS */;
170/*!40000 ALTER TABLE `bans` ENABLE KEYS */;
171UNLOCK TABLES;
172
173--
174-- Table structure for table `dealership`
175--
176
177DROP TABLE IF EXISTS `dealership`;
178/*!40101 SET @saved_cs_client = @@character_set_client */;
179/*!40101 SET character_set_client = utf8 */;
180CREATE TABLE `dealership` (
181 `id` int(11) NOT NULL AUTO_INCREMENT,
182 `x` float NOT NULL,
183 `y` float NOT NULL,
184 `z` float NOT NULL,
185 `spawnx` float NOT NULL,
186 `spawny` float NOT NULL,
187 `spawnz` float NOT NULL,
188 `spawna` float NOT NULL,
189 `intid` smallint(5) unsigned NOT NULL DEFAULT '0',
190 `spawnintid` smallint(5) unsigned NOT NULL DEFAULT '0',
191 `vwid` smallint(5) unsigned NOT NULL DEFAULT '0',
192 `spawnvwid` smallint(5) unsigned NOT NULL DEFAULT '0',
193 `name` varchar(56) NOT NULL,
194 PRIMARY KEY (`id`)
195) ENGINE=InnoDB DEFAULT CHARSET=latin1;
196/*!40101 SET character_set_client = @saved_cs_client */;
197
198--
199-- Dumping data for table `dealership`
200--
201
202LOCK TABLES `dealership` WRITE;
203/*!40000 ALTER TABLE `dealership` DISABLE KEYS */;
204/*!40000 ALTER TABLE `dealership` ENABLE KEYS */;
205UNLOCK TABLES;
206
207--
208-- Table structure for table `dealership_data`
209--
210
211DROP TABLE IF EXISTS `dealership_data`;
212/*!40101 SET @saved_cs_client = @@character_set_client */;
213/*!40101 SET character_set_client = utf8 */;
214CREATE TABLE `dealership_data` (
215 `id` int(11) NOT NULL AUTO_INCREMENT,
216 `dealership` int(11) NOT NULL,
217 `vmodel` smallint(5) unsigned NOT NULL,
218 `price` int(10) unsigned NOT NULL,
219 PRIMARY KEY (`id`),
220 UNIQUE KEY `dealership_2` (`dealership`,`vmodel`),
221 KEY `dealership` (`dealership`),
222 CONSTRAINT `dealership_data_ibfk_1` FOREIGN KEY (`dealership`) REFERENCES `dealership` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
223) ENGINE=InnoDB DEFAULT CHARSET=latin1;
224/*!40101 SET character_set_client = @saved_cs_client */;
225
226--
227-- Dumping data for table `dealership_data`
228--
229
230LOCK TABLES `dealership_data` WRITE;
231/*!40000 ALTER TABLE `dealership_data` DISABLE KEYS */;
232/*!40000 ALTER TABLE `dealership_data` ENABLE KEYS */;
233UNLOCK TABLES;
234
235--
236-- Table structure for table `drift`
237--
238
239DROP TABLE IF EXISTS `drift`;
240/*!40101 SET @saved_cs_client = @@character_set_client */;
241/*!40101 SET character_set_client = utf8 */;
242CREATE TABLE `drift` (
243 `id` int(11) NOT NULL AUTO_INCREMENT,
244 `name` varchar(56) DEFAULT NULL,
245 `x` float NOT NULL,
246 `y` float NOT NULL,
247 `z` float NOT NULL,
248 `a` float NOT NULL,
249 `intid` tinyint(3) unsigned NOT NULL,
250 `endx` float NOT NULL,
251 `endy` float NOT NULL,
252 `endz` float NOT NULL,
253 PRIMARY KEY (`id`),
254 UNIQUE KEY `name` (`name`)
255) ENGINE=InnoDB DEFAULT CHARSET=latin1;
256/*!40101 SET character_set_client = @saved_cs_client */;
257
258--
259-- Dumping data for table `drift`
260--
261
262LOCK TABLES `drift` WRITE;
263/*!40000 ALTER TABLE `drift` DISABLE KEYS */;
264/*!40000 ALTER TABLE `drift` ENABLE KEYS */;
265UNLOCK TABLES;
266
267--
268-- Table structure for table `drift_checkpoints`
269--
270
271DROP TABLE IF EXISTS `drift_checkpoints`;
272/*!40101 SET @saved_cs_client = @@character_set_client */;
273/*!40101 SET character_set_client = utf8 */;
274CREATE TABLE `drift_checkpoints` (
275 `id` int(11) NOT NULL AUTO_INCREMENT,
276 `driftid` int(11) NOT NULL,
277 `cpx` float NOT NULL,
278 `cpy` float NOT NULL,
279 `cpz` float NOT NULL,
280 PRIMARY KEY (`id`),
281 KEY `driftid` (`driftid`),
282 CONSTRAINT `drift_checkpoints_ibfk_1` FOREIGN KEY (`driftid`) REFERENCES `drift` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
283) ENGINE=InnoDB DEFAULT CHARSET=latin1;
284/*!40101 SET character_set_client = @saved_cs_client */;
285
286--
287-- Dumping data for table `drift_checkpoints`
288--
289
290LOCK TABLES `drift_checkpoints` WRITE;
291/*!40000 ALTER TABLE `drift_checkpoints` DISABLE KEYS */;
292/*!40000 ALTER TABLE `drift_checkpoints` ENABLE KEYS */;
293UNLOCK TABLES;
294
295--
296-- Table structure for table `drift_points`
297--
298
299DROP TABLE IF EXISTS `drift_points`;
300/*!40101 SET @saved_cs_client = @@character_set_client */;
301/*!40101 SET character_set_client = utf8 */;
302CREATE TABLE `drift_points` (
303 `id` int(11) NOT NULL AUTO_INCREMENT,
304 `playerid` int(11) NOT NULL,
305 `driftid` int(11) NOT NULL,
306 `point` int(10) unsigned NOT NULL,
307 `combo` int(10) unsigned NOT NULL,
308 PRIMARY KEY (`id`),
309 KEY `playerid` (`playerid`),
310 KEY `driftid` (`driftid`),
311 CONSTRAINT `drift_points_ibfk_1` FOREIGN KEY (`playerid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
312 CONSTRAINT `drift_points_ibfk_2` FOREIGN KEY (`driftid`) REFERENCES `drift` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
313) ENGINE=InnoDB DEFAULT CHARSET=latin1;
314/*!40101 SET character_set_client = @saved_cs_client */;
315
316--
317-- Dumping data for table `drift_points`
318--
319
320LOCK TABLES `drift_points` WRITE;
321/*!40000 ALTER TABLE `drift_points` DISABLE KEYS */;
322/*!40000 ALTER TABLE `drift_points` ENABLE KEYS */;
323UNLOCK TABLES;
324
325--
326-- Table structure for table `fuelstation`
327--
328
329DROP TABLE IF EXISTS `fuelstation`;
330/*!40101 SET @saved_cs_client = @@character_set_client */;
331/*!40101 SET character_set_client = utf8 */;
332CREATE TABLE `fuelstation` (
333 `id` int(11) NOT NULL AUTO_INCREMENT,
334 `x` float NOT NULL,
335 `y` float NOT NULL,
336 `z` float NOT NULL,
337 `intid` smallint(5) unsigned NOT NULL,
338 `vwid` smallint(5) unsigned NOT NULL,
339 PRIMARY KEY (`id`)
340) ENGINE=InnoDB DEFAULT CHARSET=latin1;
341/*!40101 SET character_set_client = @saved_cs_client */;
342
343--
344-- Dumping data for table `fuelstation`
345--
346
347LOCK TABLES `fuelstation` WRITE;
348/*!40000 ALTER TABLE `fuelstation` DISABLE KEYS */;
349/*!40000 ALTER TABLE `fuelstation` ENABLE KEYS */;
350UNLOCK TABLES;
351
352--
353-- Table structure for table `ganglogs`
354--
355
356DROP TABLE IF EXISTS `ganglogs`;
357/*!40101 SET @saved_cs_client = @@character_set_client */;
358/*!40101 SET character_set_client = utf8 */;
359CREATE TABLE `ganglogs` (
360 `id` int(11) NOT NULL AUTO_INCREMENT,
361 `gangid` int(11) NOT NULL,
362 `playerid` int(11) DEFAULT NULL,
363 `log` varchar(256) NOT NULL,
364 `time` int(11) NOT NULL DEFAULT '0',
365 PRIMARY KEY (`id`),
366 KEY `playerid` (`playerid`),
367 KEY `gangid` (`gangid`),
368 CONSTRAINT `ganglogs_ibfk_1` FOREIGN KEY (`gangid`) REFERENCES `gangs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
369 CONSTRAINT `ganglogs_ibfk_2` FOREIGN KEY (`playerid`) REFERENCES `accounts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
370) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
371/*!40101 SET character_set_client = @saved_cs_client */;
372
373--
374-- Dumping data for table `ganglogs`
375--
376
377LOCK TABLES `ganglogs` WRITE;
378/*!40000 ALTER TABLE `ganglogs` DISABLE KEYS */;
379/*!40000 ALTER TABLE `ganglogs` ENABLE KEYS */;
380UNLOCK TABLES;
381
382--
383-- Table structure for table `gangranks`
384--
385
386DROP TABLE IF EXISTS `gangranks`;
387/*!40101 SET @saved_cs_client = @@character_set_client */;
388/*!40101 SET character_set_client = utf8 */;
389CREATE TABLE `gangranks` (
390 `id` int(11) NOT NULL AUTO_INCREMENT,
391 `name` varchar(25) NOT NULL,
392 `gangid` int(11) NOT NULL,
393 `value` tinyint(4) NOT NULL,
394 PRIMARY KEY (`id`),
395 KEY `gangid` (`gangid`),
396 CONSTRAINT `gangranks_ibfk_1` FOREIGN KEY (`gangid`) REFERENCES `gangs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
397) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
398/*!40101 SET character_set_client = @saved_cs_client */;
399
400--
401-- Dumping data for table `gangranks`
402--
403
404LOCK TABLES `gangranks` WRITE;
405/*!40000 ALTER TABLE `gangranks` DISABLE KEYS */;
406/*!40000 ALTER TABLE `gangranks` ENABLE KEYS */;
407UNLOCK TABLES;
408
409--
410-- Table structure for table `gangs`
411--
412
413DROP TABLE IF EXISTS `gangs`;
414/*!40101 SET @saved_cs_client = @@character_set_client */;
415/*!40101 SET character_set_client = utf8 */;
416CREATE TABLE `gangs` (
417 `id` int(11) NOT NULL AUTO_INCREMENT,
418 `name` varchar(24) NOT NULL,
419 `tag` varchar(4) NOT NULL,
420 `color` char(6) NOT NULL DEFAULT 'FFFFFF',
421 `reputation` mediumint(9) NOT NULL DEFAULT '0',
422 `kills` mediumint(9) NOT NULL DEFAULT '0',
423 `deaths` mediumint(9) NOT NULL DEFAULT '0',
424 `created` int(11) NOT NULL,
425 `slots` tinyint(3) unsigned NOT NULL DEFAULT '12',
426 `mode` tinyint(3) unsigned NOT NULL DEFAULT '1',
427 `minimumscore` int(10) unsigned NOT NULL DEFAULT '0',
428 PRIMARY KEY (`id`),
429 UNIQUE KEY `name` (`name`),
430 UNIQUE KEY `tag` (`tag`),
431 KEY `name_2` (`name`),
432 KEY `tag_2` (`tag`)
433) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
434/*!40101 SET character_set_client = @saved_cs_client */;
435
436--
437-- Dumping data for table `gangs`
438--
439
440LOCK TABLES `gangs` WRITE;
441/*!40000 ALTER TABLE `gangs` DISABLE KEYS */;
442/*!40000 ALTER TABLE `gangs` ENABLE KEYS */;
443UNLOCK TABLES;
444/*!50003 SET @saved_cs_client = @@character_set_client */ ;
445/*!50003 SET @saved_cs_results = @@character_set_results */ ;
446/*!50003 SET @saved_col_connection = @@collation_connection */ ;
447/*!50003 SET character_set_client = cp850 */ ;
448/*!50003 SET character_set_results = cp850 */ ;
449/*!50003 SET collation_connection = cp850_general_ci */ ;
450/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
451/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;
452DELIMITER ;;
453/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 trigger gang_update after insert on gangs
454for each row
455begin
456insert into gangranks(name, value, gangid) values('FOUNDER', 3, NEW.id);
457insert into gangranks(name, value, gangid) values('STAFF', 2, NEW.id);
458insert into gangranks(name, value, gangid) values('MEMBER', 1, NEW.id);
459end */;;
460DELIMITER ;
461/*!50003 SET sql_mode = @saved_sql_mode */ ;
462/*!50003 SET character_set_client = @saved_cs_client */ ;
463/*!50003 SET character_set_results = @saved_cs_results */ ;
464/*!50003 SET collation_connection = @saved_col_connection */ ;
465
466--
467-- Table structure for table `house_furnitures`
468--
469
470DROP TABLE IF EXISTS `house_furnitures`;
471/*!40101 SET @saved_cs_client = @@character_set_client */;
472/*!40101 SET character_set_client = utf8 */;
473CREATE TABLE `house_furnitures` (
474 `id` int(11) NOT NULL AUTO_INCREMENT,
475 `houseid` int(11) NOT NULL,
476 `modelid` int(11) NOT NULL,
477 `x` float NOT NULL,
478 `y` float NOT NULL,
479 `z` float NOT NULL,
480 `rx` float NOT NULL,
481 `ry` float NOT NULL,
482 `rz` float NOT NULL,
483 PRIMARY KEY (`id`)
484) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
485/*!40101 SET character_set_client = @saved_cs_client */;
486
487--
488-- Dumping data for table `house_furnitures`
489--
490
491--
492-- Table structure for table `house_interiors`
493--
494
495DROP TABLE IF EXISTS `house_interiors`;
496/*!40101 SET @saved_cs_client = @@character_set_client */;
497/*!40101 SET character_set_client = utf8 */;
498CREATE TABLE `house_interiors` (
499 `id` int(11) NOT NULL AUTO_INCREMENT,
500 `name` varchar(56) NOT NULL,
501 `x` float NOT NULL,
502 `y` float NOT NULL,
503 `z` float NOT NULL,
504 `a` float NOT NULL,
505 `intid` tinyint(3) unsigned NOT NULL,
506 `price` int(10) unsigned NOT NULL,
507 `intmode` tinyint(3) unsigned NOT NULL,
508 PRIMARY KEY (`id`),
509 UNIQUE KEY `name` (`name`)
510) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
511/*!40101 SET character_set_client = @saved_cs_client */;
512
513--
514-- Dumping data for table `house_interiors`
515--
516
517LOCK TABLES `house_interiors` WRITE;
518/*!40000 ALTER TABLE `house_interiors` DISABLE KEYS */;
519INSERT INTO `house_interiors` VALUES (1,'Mansion Interior',1261.22,-785.469,1091.91,269.685,5,2000000,0),(2,'Small Apartment Interior',2233.74,-1114.95,1050.88,0.949357,5,100000,0),(3,'2 Floor Big Interior',2317.86,-1026.33,1050.22,358.733,9,1500000,0),(4,'Small Dirty Apartment Interior',223.181,1287.45,1082.14,359.626,1,50000,1),(5,'2 Floor Medium Interior',226.695,1114.23,1080.99,268.006,5,1000000,0),(6,'2 Floor Medium Interior 2',2324.45,-1148.9,1050.71,1.40137,12,1000000,0);
520/*!40000 ALTER TABLE `house_interiors` ENABLE KEYS */;
521UNLOCK TABLES;
522
523--
524-- Table structure for table `house_keys`
525--
526
527DROP TABLE IF EXISTS `house_keys`;
528/*!40101 SET @saved_cs_client = @@character_set_client */;
529/*!40101 SET character_set_client = utf8 */;
530CREATE TABLE `house_keys` (
531 `id` int(11) NOT NULL AUTO_INCREMENT,
532 `houseid` int(11) NOT NULL,
533 `playerid` int(11) NOT NULL,
534 PRIMARY KEY (`id`),
535 UNIQUE KEY `houseid` (`houseid`,`playerid`)
536) ENGINE=InnoDB DEFAULT CHARSET=latin1;
537/*!40101 SET character_set_client = @saved_cs_client */;
538
539--
540-- Dumping data for table `house_keys`
541--
542
543LOCK TABLES `house_keys` WRITE;
544/*!40000 ALTER TABLE `house_keys` DISABLE KEYS */;
545/*!40000 ALTER TABLE `house_keys` ENABLE KEYS */;
546UNLOCK TABLES;
547
548--
549-- Table structure for table `houses`
550--
551
552DROP TABLE IF EXISTS `houses`;
553/*!40101 SET @saved_cs_client = @@character_set_client */;
554/*!40101 SET character_set_client = utf8 */;
555CREATE TABLE `houses` (
556 `id` int(11) NOT NULL AUTO_INCREMENT,
557 `owner` int(11) DEFAULT NULL,
558 `title` varchar(56) NOT NULL,
559 `x` float NOT NULL,
560 `y` float NOT NULL,
561 `z` float NOT NULL,
562 `a` float NOT NULL,
563 `privacy` tinyint(3) unsigned NOT NULL,
564 `price` int(10) unsigned NOT NULL,
565 `intid` int(11) NOT NULL,
566 `status` tinyint(3) unsigned NOT NULL,
567 `saleprice` int(11) NOT NULL,
568 `song` varchar(256) NOT NULL DEFAULT '',
569 `gang` int(11) DEFAULT NULL,
570 PRIMARY KEY (`id`),
571 KEY `intid` (`intid`),
572 KEY `owner` (`owner`),
573 KEY `gang` (`gang`),
574 CONSTRAINT `houses_ibfk_1` FOREIGN KEY (`intid`) REFERENCES `house_interiors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
575 CONSTRAINT `houses_ibfk_2` FOREIGN KEY (`owner`) REFERENCES `accounts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
576 CONSTRAINT `houses_ibfk_3` FOREIGN KEY (`gang`) REFERENCES `gangs` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
577) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
578/*!40101 SET character_set_client = @saved_cs_client */;
579
580--
581-- Dumping data for table `houses`
582--
583
584--
585-- Table structure for table `interior_data`
586--
587
588DROP TABLE IF EXISTS `interior_data`;
589/*!40101 SET @saved_cs_client = @@character_set_client */;
590/*!40101 SET character_set_client = utf8 */;
591CREATE TABLE `interior_data` (
592 `id` int(11) NOT NULL AUTO_INCREMENT,
593 `intid` int(11) NOT NULL,
594 `safex` float NOT NULL DEFAULT '0',
595 `safey` float NOT NULL DEFAULT '0',
596 `safez` float NOT NULL DEFAULT '0',
597 `safea` float NOT NULL DEFAULT '0',
598 `actorx` float NOT NULL DEFAULT '0',
599 `actory` float NOT NULL DEFAULT '0',
600 `actorz` float NOT NULL DEFAULT '0',
601 `actora` float NOT NULL DEFAULT '0',
602 `actorskin` smallint(5) unsigned NOT NULL DEFAULT '0',
603 PRIMARY KEY (`id`),
604 UNIQUE KEY `intid_2` (`intid`),
605 KEY `intid` (`intid`),
606 CONSTRAINT `interior_data_ibfk_1` FOREIGN KEY (`intid`) REFERENCES `interiors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
607) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
608/*!40101 SET character_set_client = @saved_cs_client */;
609
610--
611-- Dumping data for table `interior_data`
612--
613
614LOCK TABLES `interior_data` WRITE;
615/*!40000 ALTER TABLE `interior_data` DISABLE KEYS */;
616INSERT INTO `interior_data` VALUES (1,59,371.939,-5.22673,1002.35,0.24866,0,0,0,0,0),(2,31,381.698,-56.924,1000.97,358.733,0,0,0,0,0),(3,1,755.47,7.43474,1000.14,91.6867,0,0,0,0,0),(4,6,418.598,-74.2216,1001.22,358.699,0,0,0,0,0),(5,9,204.285,-126.556,1002.95,357.72,0,0,0,0,0),(6,10,-103.877,-9.61382,1001.26,-179.731,0,0,0,0,0),(7,11,-200.299,-43.9305,1001.71,269.382,0,0,0,0,0),(8,12,-200.388,-8.6119,1001.76,-89.8829,0,0,0,0,0),(9,13,-29.2502,-186.031,1003.96,-0.73877,0,0,0,0,0),(10,14,380.325,-116.334,1000.96,-90.1278,0,0,0,0,0),(11,15,382.337,-188.129,1000.1,270.093,0,0,0,0,0),(12,16,315.414,-133.925,1000.04,89.1882,0,0,0,0,0),(13,17,205.532,-9.13977,1001.73,-90.6139,0,0,0,0,0),(14,23,294.383,-39.5062,1001.97,0.296039,0,0,0,0,0),(15,24,204.119,-42.3584,1002.24,-179.541,0,0,0,0,0),(16,33,414.368,-9.75994,1001.24,0.346798,0,0,0,0,0),(17,37,203.287,-158.508,1000.99,-179.807,0,0,0,0,0),(18,41,-200.29,-26.8884,1001.74,270.803,0,0,0,0,0),(19,43,207.473,-96.8139,1004.72,1.71201,0,0,0,0,0),(20,45,-217.786,1404,27.2034,270.362,0,0,0,0,0),(21,46,293.626,-83.2948,1000.95,91.384,0,0,0,0,0),(22,49,409.719,-54.2507,1002.16,270.276,0,0,0,0,0),(23,53,1489.61,1305.31,1093.58,89.5362,0,0,0,0,0),(24,55,-2221.62,133.775,1035.63,-179.748,0,0,0,0,0),(25,56,286.237,-109.397,1001.97,-89.9247,0,0,0,0,0),(26,57,314.24,-168.933,1000.05,272.761,0,0,0,0,0),(27,60,-2034.11,-117.951,1035.43,90.3186,0,0,0,0,0),(28,62,495.077,-80.6559,998.298,-90.5451,0,0,0,0,0);
617/*!40000 ALTER TABLE `interior_data` ENABLE KEYS */;
618UNLOCK TABLES;
619
620--
621-- Table structure for table `interiors`
622--
623
624DROP TABLE IF EXISTS `interiors`;
625/*!40101 SET @saved_cs_client = @@character_set_client */;
626/*!40101 SET character_set_client = utf8 */;
627CREATE TABLE `interiors` (
628 `id` int(11) NOT NULL AUTO_INCREMENT,
629 `x` float NOT NULL,
630 `y` float NOT NULL,
631 `z` float NOT NULL,
632 `a` float NOT NULL,
633 `intid` smallint(5) unsigned NOT NULL,
634 `name` varchar(56) NOT NULL,
635 PRIMARY KEY (`id`)
636) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;
637/*!40101 SET character_set_client = @saved_cs_client */;
638
639--
640-- Dumping data for table `interiors`
641--
642
643LOCK TABLES `interiors` WRITE;
644/*!40000 ALTER TABLE `interiors` DISABLE KEYS */;
645INSERT INTO `interiors` VALUES (1,772.338,-4.71256,1000.73,0.430693,5,'Ganton Gym'),(2,1212.07,-26.4334,1000.95,178.688,3,'The Big Spread Ranch'),(3,1304.95,4.09842,1001.03,89.9094,18,'Warehouse 1'),(4,1416,3.99476,1000.93,89.5543,1,'Warehouse 2'),(5,616.675,-124.209,997.992,269.769,3,'Mod Interior'),(6,418.66,-84.0487,1001.8,359.344,3,'Barber Shop'),(7,390.017,173.859,1008.38,89.8986,3,'Planning Department'),(8,288.797,167.771,1007.17,359.43,3,'LVPD'),(9,207.08,-139.932,1003.51,356.945,3,'Pro-Laps'),(10,-100.349,-24.8062,1000.72,359.43,3,'Sex Shop'),(11,-204.348,-44.0673,1002.27,357.655,3,'LV Tattoo'),(12,-204.372,-8.58496,1002.27,359.872,17,'SF Tattoo'),(13,-25.8777,-187.559,1003.55,358.096,17,'247 V1'),(14,372.357,-133.215,1001.49,358.892,5,'Pizza Stack'),(15,377.12,-193.064,1000.64,359.966,17,'Rusty Brown\'s Donuts'),(16,315.733,-143.308,999.602,354.276,7,'Ammu-nation'),(17,226.996,-8.15288,1002.21,87.585,5,'Victim'),(18,615.796,-74.6587,997.992,93.6219,2,'Mod Interior'),(19,246.435,107.868,1003.22,358.096,10,'SFPD'),(20,6.10767,-31.3891,1003.55,356.762,10,'247 V2'),(21,773.912,-78.4111,1000.66,357.827,7,'Below The Belt Gym'),(22,611.044,-22.0301,1004.78,5.67399,1,'Transfender'),(23,285.411,-41.175,1001.52,355.774,1,'Ammu-nation V2'),(24,203.821,-50.1534,1001.8,359.325,1,'SubUrban'),(25,-1402.66,106.39,1032.27,105.14,1,'Oval Stadium'),(26,-1403.01,-250.45,1043.53,355.86,7,'8-Track Stadium'),(27,1204.83,-13.5182,1000.92,353.272,2,'The Pig Pen'),(28,2018.82,1017.96,996.875,84.8916,10,'Four Dragons'),(29,-741.85,493,1371.98,71.78,1,'Liberty City'),(30,-1129.89,1057.54,1346.41,274.53,10,'RC Battlefield'),(31,363.228,-74.8787,1001.51,308.076,10,'Burger Shot'),(32,2233.9,1714.12,1012.35,179.61,1,'Caligula\'s Casino'),(33,411.643,-22.9305,1001.8,358.588,2,'Reece\'s Barber Shop'),(34,-30.9642,-91.8107,1003.55,355.478,18,'247 V3'),(35,161.438,-96.5795,1001.8,0.804543,18,'Zip'),(36,-2636.69,1402.66,906.461,1.51478,3,'The Pleasure Domes'),(37,204.36,-168.47,1000.52,359.912,14,'Didier Sachs'),(38,-1420.43,1616.92,1052.53,159.13,14,'Kickstart Stadium'),(39,493.422,-24.257,1000.68,359.321,17,'Club'),(40,1726.85,-1640.25,20.2241,175.372,18,'Atrium'),(41,-204.37,-27.102,1002.27,0.027976,16,'LS Tattoo'),(42,-25.8627,-141.241,1003.55,357.276,16,'247 V4'),(43,207.695,-111.03,1005.13,359.579,15,'Binco'),(44,-1417.89,932.45,1041.53,0.699975,15,'Blood Bowl Stadium'),(45,-229.059,1401.16,27.7656,267.777,18,'Lil Probe Inn'),(46,285.798,-86.2021,1001.52,359.128,4,'Ammu-nation V3'),(47,460.233,-88.5987,999.555,87.551,4,'Jay\'s Diner'),(48,947.676,2111.11,1011.03,91.0482,1,'Sindacco Abatoir'),(49,411.998,-54.0755,1001.9,1.24741,12,'Barber Shop'),(50,-1421.56,-663.83,1059.56,170.93,4,'Dirtbike Stadium'),(51,774.149,-50.0121,1000.59,355.277,6,'Cobra Gym'),(52,246.841,63.0787,1003.64,359.184,6,'LSPD'),(53,1494.42,1304.12,1093.29,356.256,3,'Bike School'),(54,-1401.07,1265.37,1039.87,178.65,16,'Vice Stadium'),(55,-2240.32,137.095,1035.41,266.057,6,'Zero\'s RC Shop'),(56,296.852,-111.586,1001.52,358.387,6,'Ammu-nation V4'),(57,316.46,-169.572,999.601,357.677,6,'Ammu-nation V5'),(58,-27.3252,-57.8231,1003.55,359.722,6,'247 V6'),(59,364.963,-11.2915,1001.85,357.408,9,'Cluckin\' Bell'),(60,-2029.71,-118.982,1035.17,355.277,3,'Driving School'),(61,315.776,1016.99,1951.53,359.937,9,'Andromada'),(62,501.901,-68.0155,998.758,182.153,11,'Bar'),(63,1456.18,-983.904,996.105,86.8962,1,'Bank 1'),(64,1411.87,1315.82,1501.08,92.137,2,'Bank 2');
646/*!40000 ALTER TABLE `interiors` ENABLE KEYS */;
647UNLOCK TABLES;
648
649--
650-- Table structure for table `items`
651--
652
653DROP TABLE IF EXISTS `items`;
654/*!40101 SET @saved_cs_client = @@character_set_client */;
655/*!40101 SET character_set_client = utf8 */;
656CREATE TABLE `items` (
657 `id` int(11) NOT NULL AUTO_INCREMENT,
658 `playerid` int(11) NOT NULL,
659 `itemid` tinyint(3) unsigned NOT NULL DEFAULT '0',
660 `qty` int(11) NOT NULL DEFAULT '0',
661 PRIMARY KEY (`id`),
662 UNIQUE KEY `playerid` (`playerid`,`itemid`),
663 KEY `playerid_2` (`playerid`),
664 CONSTRAINT `items_ibfk_1` FOREIGN KEY (`playerid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
665) ENGINE=InnoDB DEFAULT CHARSET=latin1;
666/*!40101 SET character_set_client = @saved_cs_client */;
667
668--
669-- Dumping data for table `items`
670--
671
672LOCK TABLES `items` WRITE;
673/*!40000 ALTER TABLE `items` DISABLE KEYS */;
674/*!40000 ALTER TABLE `items` ENABLE KEYS */;
675UNLOCK TABLES;
676
677--
678-- Table structure for table `members`
679--
680
681DROP TABLE IF EXISTS `members`;
682/*!40101 SET @saved_cs_client = @@character_set_client */;
683/*!40101 SET character_set_client = utf8 */;
684CREATE TABLE `members` (
685 `playerid` int(11) NOT NULL,
686 `gangid` int(11) DEFAULT NULL,
687 `status` int(11) NOT NULL,
688 UNIQUE KEY `playerid` (`playerid`),
689 KEY `gangid` (`gangid`),
690 KEY `status` (`status`),
691 CONSTRAINT `members_ibfk_1` FOREIGN KEY (`playerid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
692 CONSTRAINT `members_ibfk_2` FOREIGN KEY (`gangid`) REFERENCES `gangs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
693 CONSTRAINT `members_ibfk_3` FOREIGN KEY (`status`) REFERENCES `gangranks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
694) ENGINE=InnoDB DEFAULT CHARSET=latin1;
695/*!40101 SET character_set_client = @saved_cs_client */;
696
697--
698-- Dumping data for table `members`
699--
700
701LOCK TABLES `members` WRITE;
702/*!40000 ALTER TABLE `members` DISABLE KEYS */;
703/*!40000 ALTER TABLE `members` ENABLE KEYS */;
704UNLOCK TABLES;
705
706--
707-- Table structure for table `messages`
708--
709
710DROP TABLE IF EXISTS `messages`;
711/*!40101 SET @saved_cs_client = @@character_set_client */;
712/*!40101 SET character_set_client = utf8 */;
713CREATE TABLE `messages` (
714 `id` int(11) NOT NULL AUTO_INCREMENT,
715 `userid` int(11) NOT NULL,
716 `sender` int(11) DEFAULT NULL,
717 `message` varchar(500) NOT NULL,
718 `time` int(11) NOT NULL DEFAULT '0',
719 `status` tinyint(4) NOT NULL DEFAULT '0',
720 PRIMARY KEY (`id`),
721 KEY `userid` (`userid`),
722 KEY `sender` (`sender`),
723 CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
724 CONSTRAINT `messages_ibfk_2` FOREIGN KEY (`sender`) REFERENCES `accounts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
725) ENGINE=InnoDB DEFAULT CHARSET=latin1;
726/*!40101 SET character_set_client = @saved_cs_client */;
727
728--
729-- Dumping data for table `messages`
730--
731
732LOCK TABLES `messages` WRITE;
733/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
734/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
735UNLOCK TABLES;
736
737--
738-- Table structure for table `mods`
739--
740
741DROP TABLE IF EXISTS `mods`;
742/*!40101 SET @saved_cs_client = @@character_set_client */;
743/*!40101 SET character_set_client = utf8 */;
744CREATE TABLE `mods` (
745 `vehicleid` int(11) NOT NULL,
746 `slot` tinyint(3) unsigned NOT NULL,
747 `componentid` smallint(5) unsigned NOT NULL,
748 UNIQUE KEY `vehicleid_2` (`vehicleid`,`slot`),
749 KEY `vehicleid` (`vehicleid`),
750 CONSTRAINT `mods_ibfk_1` FOREIGN KEY (`vehicleid`) REFERENCES `vehicles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
751) ENGINE=InnoDB DEFAULT CHARSET=latin1;
752/*!40101 SET character_set_client = @saved_cs_client */;
753
754--
755-- Dumping data for table `mods`
756--
757
758LOCK TABLES `mods` WRITE;
759/*!40000 ALTER TABLE `mods` DISABLE KEYS */;
760/*!40000 ALTER TABLE `mods` ENABLE KEYS */;
761UNLOCK TABLES;
762
763--
764-- Table structure for table `property`
765--
766
767DROP TABLE IF EXISTS `property`;
768/*!40101 SET @saved_cs_client = @@character_set_client */;
769/*!40101 SET character_set_client = utf8 */;
770CREATE TABLE `property` (
771 `id` int(11) NOT NULL AUTO_INCREMENT,
772 `x` float NOT NULL,
773 `y` float NOT NULL,
774 `z` float NOT NULL,
775 `a` float NOT NULL,
776 `type` bit(32) NOT NULL,
777 `intid` int(11) NOT NULL,
778 `name` varchar(128) NOT NULL,
779 `price` int(11) NOT NULL,
780 `mapicon` tinyint(3) unsigned NOT NULL,
781 `status` tinyint(3) unsigned NOT NULL,
782 `point` int(10) unsigned NOT NULL,
783 `saleprice` int(11) NOT NULL DEFAULT '0',
784 `owner` int(11) DEFAULT NULL,
785 PRIMARY KEY (`id`),
786 KEY `intid` (`intid`),
787 KEY `owner` (`owner`),
788 CONSTRAINT `property_ibfk_1` FOREIGN KEY (`intid`) REFERENCES `interiors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
789 CONSTRAINT `property_ibfk_2` FOREIGN KEY (`owner`) REFERENCES `accounts` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
790) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
791/*!40101 SET character_set_client = @saved_cs_client */;
792
793--
794-- Dumping data for table `property`
795--
796
797--
798-- Table structure for table `toys`
799--
800
801DROP TABLE IF EXISTS `toys`;
802/*!40101 SET @saved_cs_client = @@character_set_client */;
803/*!40101 SET character_set_client = utf8 */;
804CREATE TABLE `toys` (
805 `id` int(11) NOT NULL AUTO_INCREMENT,
806 `playerid` int(11) NOT NULL,
807 `ind` tinyint(3) unsigned NOT NULL,
808 `modelid` int(10) unsigned NOT NULL,
809 `bone` tinyint(3) unsigned NOT NULL,
810 `x` float NOT NULL,
811 `y` float NOT NULL,
812 `z` float NOT NULL,
813 `rx` float NOT NULL,
814 `ry` float NOT NULL,
815 `rz` float NOT NULL,
816 `sx` float NOT NULL,
817 `sy` float NOT NULL,
818 `sz` float NOT NULL,
819 `color1` tinyint(3) unsigned NOT NULL,
820 `color2` tinyint(3) unsigned NOT NULL,
821 PRIMARY KEY (`id`),
822 UNIQUE KEY `playerid` (`playerid`,`ind`),
823 KEY `playerid_2` (`playerid`),
824 CONSTRAINT `toys_ibfk_1` FOREIGN KEY (`playerid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
825) ENGINE=InnoDB DEFAULT CHARSET=latin1;
826/*!40101 SET character_set_client = @saved_cs_client */;
827
828--
829-- Dumping data for table `toys`
830--
831
832LOCK TABLES `toys` WRITE;
833/*!40000 ALTER TABLE `toys` DISABLE KEYS */;
834/*!40000 ALTER TABLE `toys` ENABLE KEYS */;
835UNLOCK TABLES;
836
837--
838-- Table structure for table `vehicles`
839--
840
841DROP TABLE IF EXISTS `vehicles`;
842/*!40101 SET @saved_cs_client = @@character_set_client */;
843/*!40101 SET character_set_client = utf8 */;
844CREATE TABLE `vehicles` (
845 `id` int(11) NOT NULL AUTO_INCREMENT,
846 `model` smallint(5) unsigned NOT NULL,
847 `owner` int(11) NOT NULL,
848 `x` float NOT NULL DEFAULT '0',
849 `y` float NOT NULL DEFAULT '0',
850 `z` float NOT NULL DEFAULT '0',
851 `a` float NOT NULL DEFAULT '0',
852 `intid` smallint(5) unsigned NOT NULL DEFAULT '0',
853 `vw` smallint(5) unsigned NOT NULL DEFAULT '0',
854 `color1` tinyint(3) unsigned NOT NULL DEFAULT '1',
855 `color2` tinyint(3) unsigned NOT NULL DEFAULT '1',
856 `paintjob` tinyint(3) unsigned NOT NULL DEFAULT '3',
857 `plate` varchar(6) NOT NULL DEFAULT 'LSP',
858 `price` int(11) NOT NULL,
859 `boughttime` int(11) NOT NULL,
860 `vlock` tinyint(1) NOT NULL DEFAULT '0',
861 `fuel` float NOT NULL DEFAULT '100',
862 PRIMARY KEY (`id`),
863 KEY `owner` (`owner`),
864 CONSTRAINT `vehicles_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
865) ENGINE=InnoDB DEFAULT CHARSET=latin1;
866/*!40101 SET character_set_client = @saved_cs_client */;
867
868--
869-- Dumping data for table `vehicles`
870--
871
872LOCK TABLES `vehicles` WRITE;
873/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
874/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
875UNLOCK TABLES;
876
877--
878-- Table structure for table `weapon_data`
879--
880
881DROP TABLE IF EXISTS `weapon_data`;
882/*!40101 SET @saved_cs_client = @@character_set_client */;
883/*!40101 SET character_set_client = utf8 */;
884CREATE TABLE `weapon_data` (
885 `id` int(11) NOT NULL AUTO_INCREMENT,
886 `playerid` int(11) DEFAULT NULL,
887 `weaponid` tinyint(3) unsigned NOT NULL DEFAULT '0',
888 `fired` bigint(20) unsigned NOT NULL DEFAULT '0',
889 `hits` bigint(20) unsigned NOT NULL DEFAULT '0',
890 `max_continous_shots` int(10) unsigned NOT NULL DEFAULT '0',
891 `out_of_range` int(10) unsigned NOT NULL DEFAULT '0',
892 `random_aim` int(10) unsigned NOT NULL DEFAULT '0',
893 `proaim` int(10) unsigned NOT NULL DEFAULT '0',
894 PRIMARY KEY (`id`),
895 UNIQUE KEY `playerid_2` (`playerid`,`weaponid`),
896 KEY `playerid` (`playerid`),
897 CONSTRAINT `weapon_data_ibfk_1` FOREIGN KEY (`playerid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
898) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=latin1;
899/*!40101 SET character_set_client = @saved_cs_client */;
900
901--
902-- Dumping data for table `weapon_data`
903--
904
905LOCK TABLES `weapon_data` WRITE;
906/*!40000 ALTER TABLE `weapon_data` DISABLE KEYS */;
907/*!40000 ALTER TABLE `weapon_data` ENABLE KEYS */;
908UNLOCK TABLES;
909
910--
911-- Table structure for table `zones`
912--
913
914DROP TABLE IF EXISTS `zones`;
915/*!40101 SET @saved_cs_client = @@character_set_client */;
916/*!40101 SET character_set_client = utf8 */;
917CREATE TABLE `zones` (
918 `id` int(11) NOT NULL AUTO_INCREMENT,
919 `name` varchar(56) NOT NULL,
920 `minx` float NOT NULL,
921 `miny` float NOT NULL,
922 `maxx` float NOT NULL,
923 `maxy` float NOT NULL,
924 `owner` int(11) DEFAULT NULL,
925 PRIMARY KEY (`id`),
926 KEY `owner` (`owner`),
927 CONSTRAINT `zones_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `gangs` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
928) ENGINE=InnoDB DEFAULT CHARSET=latin1;
929/*!40101 SET character_set_client = @saved_cs_client */;
930
931--
932-- Dumping data for table `zones`
933--
934
935LOCK TABLES `zones` WRITE;
936/*!40000 ALTER TABLE `zones` DISABLE KEYS */;
937/*!40000 ALTER TABLE `zones` ENABLE KEYS */;
938UNLOCK TABLES;
939/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
940
941/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
942/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
943/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
944/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
945/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
946/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
947/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
948
949-- Dump completed on 2016-12-18 10:29:46