· 7 years ago · Dec 07, 2018, 04:38 AM
1CREATE DATABASE IF NOT EXISTS `life` /*!40100 DEFAULT CHARACTER SET latin1 */;
2USE `life`;
3-- MySQL dump 10.13 Distrib 8.0.13, for Win64 (x86_64)
4--
5-- Host: localhost Database: life
6-- ------------------------------------------------------
7-- Server version 8.0.13
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12 SET NAMES utf8 ;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `faction_ranks`
22--
23
24DROP TABLE IF EXISTS `faction_ranks`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26 SET character_set_client = utf8mb4 ;
27CREATE TABLE `faction_ranks` (
28 `id` int(6) NOT NULL AUTO_INCREMENT,
29 `fid` int(6) NOT NULL,
30 `name` varchar(50) NOT NULL,
31 `level` int(11) NOT NULL DEFAULT '1',
32 `paycheck` int(100) NOT NULL DEFAULT '1000',
33 `cap` int(100) NOT NULL DEFAULT '1000',
34 PRIMARY KEY (`id`)
35) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Dumping data for table `faction_ranks`
40--
41
42LOCK TABLES `faction_ranks` WRITE;
43/*!40000 ALTER TABLE `faction_ranks` DISABLE KEYS */;
44INSERT INTO `faction_ranks` VALUES (1,2,'Seaman Recruit',1,500,3000),(2,2,'Seaman Apprentice',2,1000,3000),(3,2,'Seaman',3,1000,3000),(4,2,'Petty Officer',4,1600,3000),(5,2,'Chief Petty Officer',5,1650,3000),(6,2,'Senior Chief Petty Officer',6,1700,3000),(7,2,'Master Chief Petty Officer',7,1,3000),(8,2,'Command Master Chief Petty Officer',8,1,3000),(9,2,'Ensign',9,2000,3000),(10,2,'Lieutenant, Junior Grade',10,1,3000),(11,2,'Lieutenant',11,1,3000),(12,2,'Lieutenant Commander ',12,2000,3000),(13,2,'Commander',13,2500,3000),(14,2,'Captain',14,3000,3000),(15,1,'Cadet',1,250,3000),(16,1,'Deputy',2,500,3000),(17,1,'Senior Deputy',3,1000,3000),(18,1,'Sergeant',4,1250,3000),(19,1,'Lieutenant',5,1500,3000),(20,1,'Captain',6,2000,3000),(21,1,'UnderSheriff',7,3000,3000),(22,1,'Sheriff',8,3000,3000),(23,3,'Chief',11,1000,3000),(24,3,'Deputy Chief',10,2250,3000),(25,3,'Battalion Chief',9,1700,3000),(26,3,'Captin',8,1,3000),(27,3,'Lieutenant',7,1950,3000),(28,3,'Engineer / Paramedic',6,1550,3000),(29,3,'Firefighter / Paramedic',5,1,3000),(30,3,'Firefighter / EMT',4,1,3000),(31,3,'Probationary',3,1,3000),(32,3,'Recruit',2,1250,3000),(33,3,'Volunteer',1,1250,3000),(34,4,'Chief Justice',6,2000,3000),(35,4,'Assistant Chief Justice',5,1,3000),(36,4,'Executive Judge',4,3000,3000),(37,4,'District Attorney',3,1700,3000),(38,4,'State Prosecutor',2,1400,3000),(39,4,'Lawyer',1,1800,3000),(40,5,'Manager',3,3000,3000),(41,5,'Assistant Manager',2,3000,3000),(42,5,'Employee',1,3000,3000),(43,6,'Manager',2,2500,3000),(44,6,'Employee',1,2500,3000);
45/*!40000 ALTER TABLE `faction_ranks` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `faction_vehicle_shop`
50--
51
52DROP TABLE IF EXISTS `faction_vehicle_shop`;
53/*!40101 SET @saved_cs_client = @@character_set_client */;
54 SET character_set_client = utf8mb4 ;
55CREATE TABLE `faction_vehicle_shop` (
56 `id` int(11) NOT NULL AUTO_INCREMENT,
57 `var` varchar(50) NOT NULL,
58 `type` enum('fifr','police','uscg','uscg_h','uscg_b','dmv','faa','doj') NOT NULL,
59 `stock` varchar(50) NOT NULL,
60 PRIMARY KEY (`id`)
61) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
62/*!40101 SET character_set_client = @saved_cs_client */;
63
64--
65-- Dumping data for table `faction_vehicle_shop`
66--
67
68LOCK TABLES `faction_vehicle_shop` WRITE;
69/*!40000 ALTER TABLE `faction_vehicle_shop` DISABLE KEYS */;
70INSERT INTO `faction_vehicle_shop` VALUES (1,'FIFR_VEHICLE_STOCK','fifr','[10,10,10,10,10,10,10,10]'),(2,'USCG_VEHICLE_STOCK','uscg','[10,10,10,10,10,10,10]'),(3,'POLICE_VEHICLE_STOCK','police','[10,10,10,10,10,10,10,10,10,10,10]'),(4,'USCG_HELI_STOCK','uscg_h','[10,10,10,10,10,10]'),(5,'USCG_BOAT_STOCK','uscg_b','[10,10,10,10,10]'),(6,'DMV_VEHICLE_STOCK','dmv','[10,10,10,10,10]'),(7,'FAA_VEHICLE_STOCK','faa','[10,10,10,10,10,10]'),(8,'DOJ_VEHICLE_STOCK','doj','[10,10]');
71/*!40000 ALTER TABLE `faction_vehicle_shop` ENABLE KEYS */;
72UNLOCK TABLES;
73
74--
75-- Table structure for table `factions`
76--
77
78DROP TABLE IF EXISTS `factions`;
79/*!40101 SET @saved_cs_client = @@character_set_client */;
80 SET character_set_client = utf8mb4 ;
81CREATE TABLE `factions` (
82 `id` int(6) NOT NULL AUTO_INCREMENT,
83 `leader` varchar(17) NOT NULL,
84 `type` varchar(50) NOT NULL,
85 `max_rank` int(11) NOT NULL DEFAULT '1',
86 PRIMARY KEY (`id`)
87) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
88/*!40101 SET character_set_client = @saved_cs_client */;
89
90--
91-- Dumping data for table `factions`
92--
93
94LOCK TABLES `factions` WRITE;
95/*!40000 ALTER TABLE `factions` DISABLE KEYS */;
96INSERT INTO `factions` VALUES (1,'0','police',8),(2,'0','uscg',14),(3,'0','fifr',11),(4,'0','doj',6),(5,'0','dmv',3),(6,'0','faa',2);
97/*!40000 ALTER TABLE `factions` ENABLE KEYS */;
98UNLOCK TABLES;
99
100--
101-- Table structure for table `government_balances`
102--
103
104DROP TABLE IF EXISTS `government_balances`;
105/*!40101 SET @saved_cs_client = @@character_set_client */;
106 SET character_set_client = utf8mb4 ;
107CREATE TABLE `government_balances` (
108 `id` int(11) NOT NULL AUTO_INCREMENT,
109 `var` varchar(50) DEFAULT NULL,
110 `balance` bigint(20) DEFAULT '0',
111 PRIMARY KEY (`id`)
112) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 COMMENT='Contains balances for government fund and the current tax rates';
113/*!40101 SET character_set_client = @saved_cs_client */;
114
115--
116-- Dumping data for table `government_balances`
117--
118
119LOCK TABLES `government_balances` WRITE;
120/*!40000 ALTER TABLE `government_balances` DISABLE KEYS */;
121INSERT INTO `government_balances` VALUES (1,'FEDERAL_GRANT',1000000),(2,'PD_BUDGET',1000000),(3,'FD_BUDGET',1000000),(4,'CG_BUDGET',1000000),(5,'DMV_BUDGET',1000000),(6,'DOJ_BUDGET',1000000),(7,'FAA_BUDGET',1000000),(8,'SALES_TAX',5),(9,'INCOME_TAX',5),(10,'PROPERTY_TAX',5),(11,'IMPORT_TAX',5),(12,'SALES_TAX_BAL',100000),(13,'INCOME_TAX_BAL',100000),(14,'PROPERTY_TAX_BAL',100000),(15,'IMPORT_TAX_BAL',100000);
122/*!40000 ALTER TABLE `government_balances` ENABLE KEYS */;
123UNLOCK TABLES;
124
125--
126-- Table structure for table `government_laws`
127--
128
129DROP TABLE IF EXISTS `government_laws`;
130/*!40101 SET @saved_cs_client = @@character_set_client */;
131 SET character_set_client = utf8mb4 ;
132CREATE TABLE `government_laws` (
133 `id` int(11) NOT NULL AUTO_INCREMENT,
134 `law` text NOT NULL,
135 `added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
136 PRIMARY KEY (`id`)
137) ENGINE=InnoDB DEFAULT CHARSET=latin1;
138/*!40101 SET character_set_client = @saved_cs_client */;
139
140--
141-- Dumping data for table `government_laws`
142--
143
144LOCK TABLES `government_laws` WRITE;
145/*!40000 ALTER TABLE `government_laws` DISABLE KEYS */;
146/*!40000 ALTER TABLE `government_laws` ENABLE KEYS */;
147UNLOCK TABLES;
148
149--
150-- Table structure for table `houses`
151--
152
153DROP TABLE IF EXISTS `houses`;
154/*!40101 SET @saved_cs_client = @@character_set_client */;
155 SET character_set_client = utf8mb4 ;
156CREATE TABLE `houses` (
157 `uid` varchar(50) DEFAULT NULL,
158 `location` varchar(50) DEFAULT NULL,
159 `doorid` varchar(50) DEFAULT NULL,
160 `items` varchar(7000) DEFAULT '[[],[],[]]',
161 `vitems` varchar(7000) DEFAULT '[]',
162 `pitems` varchar(7000) DEFAULT '[]',
163 UNIQUE KEY `location` (`location`) USING BTREE
164) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
165/*!40101 SET character_set_client = @saved_cs_client */;
166
167--
168-- Dumping data for table `houses`
169--
170
171LOCK TABLES `houses` WRITE;
172/*!40000 ALTER TABLE `houses` DISABLE KEYS */;
173/*!40000 ALTER TABLE `houses` ENABLE KEYS */;
174UNLOCK TABLES;
175
176--
177-- Table structure for table `import_export`
178--
179
180DROP TABLE IF EXISTS `import_export`;
181/*!40101 SET @saved_cs_client = @@character_set_client */;
182 SET character_set_client = utf8mb4 ;
183CREATE TABLE `import_export` (
184 `item` varchar(50) DEFAULT NULL,
185 `import` int(25) DEFAULT NULL,
186 `export` int(25) DEFAULT NULL
187) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
188/*!40101 SET character_set_client = @saved_cs_client */;
189
190--
191-- Dumping data for table `import_export`
192--
193
194LOCK TABLES `import_export` WRITE;
195/*!40000 ALTER TABLE `import_export` DISABLE KEYS */;
196INSERT INTO `import_export` VALUES ('Crude_Oil',99999,800),('Gunpowder',200,50),('Synthetic_Fibre',50,10),('Glass_Fibre',75,10),('Plastic',150,40),('Glass',50,4),('Polyester',50,10),('Aramid',75,30),('Rubber',220,75),('Petrol',1600,200),('LPG',600,200),('Kerosene',8000,4000),('CanisterOil',175,30);
197/*!40000 ALTER TABLE `import_export` ENABLE KEYS */;
198UNLOCK TABLES;
199
200--
201-- Table structure for table `logs_admin`
202--
203
204DROP TABLE IF EXISTS `logs_admin`;
205/*!40101 SET @saved_cs_client = @@character_set_client */;
206 SET character_set_client = utf8mb4 ;
207CREATE TABLE `logs_admin` (
208 `ID` int(11) NOT NULL AUTO_INCREMENT,
209 `adminname` varchar(50) NOT NULL,
210 `uid` varchar(50) NOT NULL,
211 `type` varchar(50) NOT NULL,
212 `data` text NOT NULL,
213 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
214 PRIMARY KEY (`ID`) USING BTREE
215) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
216/*!40101 SET character_set_client = @saved_cs_client */;
217
218--
219-- Dumping data for table `logs_admin`
220--
221
222LOCK TABLES `logs_admin` WRITE;
223/*!40000 ALTER TABLE `logs_admin` DISABLE KEYS */;
224/*!40000 ALTER TABLE `logs_admin` ENABLE KEYS */;
225UNLOCK TABLES;
226
227--
228-- Table structure for table `logs_caue`
229--
230
231DROP TABLE IF EXISTS `logs_caue`;
232/*!40101 SET @saved_cs_client = @@character_set_client */;
233 SET character_set_client = utf8mb4 ;
234CREATE TABLE `logs_caue` (
235 `ID` int(11) NOT NULL AUTO_INCREMENT,
236 `uid` varchar(50) NOT NULL,
237 `type` varchar(50) NOT NULL,
238 `data` text NOT NULL,
239 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
240 PRIMARY KEY (`ID`) USING BTREE
241) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
242/*!40101 SET character_set_client = @saved_cs_client */;
243
244--
245-- Dumping data for table `logs_caue`
246--
247
248LOCK TABLES `logs_caue` WRITE;
249/*!40000 ALTER TABLE `logs_caue` DISABLE KEYS */;
250/*!40000 ALTER TABLE `logs_caue` ENABLE KEYS */;
251UNLOCK TABLES;
252
253--
254-- Table structure for table `logs_chat`
255--
256
257DROP TABLE IF EXISTS `logs_chat`;
258/*!40101 SET @saved_cs_client = @@character_set_client */;
259 SET character_set_client = utf8mb4 ;
260CREATE TABLE `logs_chat` (
261 `name` tinytext,
262 `steamid` tinytext,
263 `chatmessage` tinytext,
264 `messageinfo` varchar(500) DEFAULT '[``,`#ed7202`,`#B5B5B5`]',
265 `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
266) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
267/*!40101 SET character_set_client = @saved_cs_client */;
268
269--
270-- Dumping data for table `logs_chat`
271--
272
273LOCK TABLES `logs_chat` WRITE;
274/*!40000 ALTER TABLE `logs_chat` DISABLE KEYS */;
275/*!40000 ALTER TABLE `logs_chat` ENABLE KEYS */;
276UNLOCK TABLES;
277
278--
279-- Table structure for table `logs_misc`
280--
281
282DROP TABLE IF EXISTS `logs_misc`;
283/*!40101 SET @saved_cs_client = @@character_set_client */;
284 SET character_set_client = utf8mb4 ;
285CREATE TABLE `logs_misc` (
286 `ID` int(255) NOT NULL AUTO_INCREMENT,
287 `uid` varchar(50) NOT NULL,
288 `type` varchar(50) NOT NULL,
289 `data` text NOT NULL,
290 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
291 PRIMARY KEY (`ID`) USING BTREE
292) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
293/*!40101 SET character_set_client = @saved_cs_client */;
294
295--
296-- Dumping data for table `logs_misc`
297--
298
299LOCK TABLES `logs_misc` WRITE;
300/*!40000 ALTER TABLE `logs_misc` DISABLE KEYS */;
301/*!40000 ALTER TABLE `logs_misc` ENABLE KEYS */;
302UNLOCK TABLES;
303
304--
305-- Table structure for table `logs_shop`
306--
307
308DROP TABLE IF EXISTS `logs_shop`;
309/*!40101 SET @saved_cs_client = @@character_set_client */;
310 SET character_set_client = utf8mb4 ;
311CREATE TABLE `logs_shop` (
312 `ID` int(255) NOT NULL AUTO_INCREMENT,
313 `uid` varchar(50) NOT NULL,
314 `shop` varchar(50) NOT NULL,
315 `type` varchar(50) NOT NULL,
316 `item` varchar(50) NOT NULL,
317 `amount` varchar(50) NOT NULL,
318 `value` varchar(50) NOT NULL,
319 `cashtotal` varchar(50) NOT NULL,
320 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
321 PRIMARY KEY (`ID`) USING BTREE
322) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
323/*!40101 SET character_set_client = @saved_cs_client */;
324
325--
326-- Dumping data for table `logs_shop`
327--
328
329LOCK TABLES `logs_shop` WRITE;
330/*!40000 ALTER TABLE `logs_shop` DISABLE KEYS */;
331/*!40000 ALTER TABLE `logs_shop` ENABLE KEYS */;
332UNLOCK TABLES;
333
334--
335-- Table structure for table `objects`
336--
337
338DROP TABLE IF EXISTS `objects`;
339/*!40101 SET @saved_cs_client = @@character_set_client */;
340 SET character_set_client = utf8mb4 ;
341CREATE TABLE `objects` (
342 `aiid` int(11) NOT NULL AUTO_INCREMENT,
343 `id` varchar(50) NOT NULL,
344 `type` varchar(50) NOT NULL DEFAULT 'object',
345 `class` varchar(50) NOT NULL,
346 `uid` varchar(50) NOT NULL,
347 `plystorage` tinyint(1) NOT NULL DEFAULT '0',
348 `spawn` tinyint(1) NOT NULL DEFAULT '0',
349 `pos` varchar(50) NOT NULL DEFAULT '[]',
350 `vars` varchar(50) NOT NULL DEFAULT '[]',
351 `impounded` tinyint(1) NOT NULL DEFAULT '0',
352 `fuel` float NOT NULL DEFAULT '1',
353 `color` varchar(300) NOT NULL DEFAULT '#(argb,8,8,3)color(1,1,1,1.0,co)',
354 PRIMARY KEY (`aiid`),
355 UNIQUE KEY `id` (`id`) USING BTREE
356) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
357/*!40101 SET character_set_client = @saved_cs_client */;
358
359--
360-- Dumping data for table `objects`
361--
362
363LOCK TABLES `objects` WRITE;
364/*!40000 ALTER TABLE `objects` DISABLE KEYS */;
365/*!40000 ALTER TABLE `objects` ENABLE KEYS */;
366UNLOCK TABLES;
367
368--
369-- Table structure for table `persistent_vars`
370--
371
372DROP TABLE IF EXISTS `persistent_vars`;
373/*!40101 SET @saved_cs_client = @@character_set_client */;
374 SET character_set_client = utf8mb4 ;
375CREATE TABLE `persistent_vars` (
376 `var` varchar(50) DEFAULT NULL,
377 `value` varchar(5000) DEFAULT '[]',
378 `pv` tinyint(1) DEFAULT '0',
379 UNIQUE KEY `var` (`var`) USING BTREE
380) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
381/*!40101 SET character_set_client = @saved_cs_client */;
382
383--
384-- Dumping data for table `persistent_vars`
385--
386
387LOCK TABLES `persistent_vars` WRITE;
388/*!40000 ALTER TABLE `persistent_vars` DISABLE KEYS */;
389INSERT INTO `persistent_vars` VALUES ('Server_JobVDelivery_JobList','[]',0),('Server_Government_Candidates','[]',1),('A3PL_Mayor','[`76561198166982296`,`Caue`]',1),('NoTaskForce','[`76561198166982296`]',1);
390/*!40000 ALTER TABLE `persistent_vars` ENABLE KEYS */;
391UNLOCK TABLES;
392
393--
394-- Table structure for table `players`
395--
396
397DROP TABLE IF EXISTS `players`;
398/*!40101 SET @saved_cs_client = @@character_set_client */;
399 SET character_set_client = utf8mb4 ;
400CREATE TABLE `players` (
401 `ID` int(10) NOT NULL AUTO_INCREMENT,
402 `uid` varchar(50) DEFAULT NULL,
403 `name` varchar(50) DEFAULT '',
404 `job` varchar(50) DEFAULT 'unemployed',
405 `gender` varchar(50) DEFAULT 'male',
406 `dob` varchar(50) DEFAULT '1/1/1990',
407 `pasportdate` varchar(50) DEFAULT NULL,
408 `lastseen` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
409 `cash` int(11) DEFAULT '0',
410 `bank` int(11) DEFAULT '500',
411 `faction` varchar(50) DEFAULT 'citizen',
412 `faction_rank` int(11) NOT NULL DEFAULT '0',
413 `position` varchar(50) DEFAULT '[2786.83,5387.44,0.00146484]',
414 `userkey` varchar(500) DEFAULT '[]',
415 `licenses` varchar(75) DEFAULT '[]',
416 `loadout` varchar(3000) DEFAULT '[]',
417 `virtualinv` varchar(2000) DEFAULT '[]',
418 `player_fstorage` varchar(5000) DEFAULT '[]',
419 `jail` int(20) unsigned DEFAULT '0',
420 `adminpowers` varchar(750) DEFAULT '[]',
421 `stafftitle` varchar(50) NOT NULL,
422 `twitterprofile` varchar(500) NOT NULL DEFAULT '[`\\A3PL_Common\\icons\\citizen.paa`,`#ed7202`,`#B5B5B5`,[[`\\A3PL_Common\\icons\\citizen.paa`,`Cidadao`]],[[`#ed7202`,`Citizen`]],[[`#B5B5B5`,`Padrao`]]]',
423 PRIMARY KEY (`ID`) USING BTREE,
424 UNIQUE KEY `uid` (`uid`) USING BTREE
425) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Admin powers: [`debug`,`spectate`,`players`,`editplayer`,`vehicles`,`cursortarget`,`admintag`,`globalmessage`,`factories`,`mapmarkers`,`mapteleporting`,`twitter`,`createfire`,`removefire`,`mayorvote`]\r\nTwitter Profile: [`DIRECTORTAG`,`#fff200`,[[`DIRECTORTAG`,Director`],[`CIVTAG`,`Civ`]],[]]';
426/*!40101 SET character_set_client = @saved_cs_client */;
427
428--
429-- Dumping data for table `players`
430--
431
432LOCK TABLES `players` WRITE;
433/*!40000 ALTER TABLE `players` DISABLE KEYS */;
434/*!40000 ALTER TABLE `players` ENABLE KEYS */;
435UNLOCK TABLES;
436
437--
438-- Table structure for table `policedatabase`
439--
440
441DROP TABLE IF EXISTS `policedatabase`;
442/*!40101 SET @saved_cs_client = @@character_set_client */;
443 SET character_set_client = utf8mb4 ;
444CREATE TABLE `policedatabase` (
445 `ID` int(20) NOT NULL AUTO_INCREMENT,
446 `UID` varchar(50) DEFAULT NULL,
447 `Actiontype` varchar(50) DEFAULT NULL,
448 `Info` varchar(500) DEFAULT NULL,
449 `Time` varchar(50) DEFAULT NULL,
450 `Title` varchar(100) DEFAULT NULL,
451 `Amount` mediumint(20) unsigned DEFAULT '0',
452 `IssuedBy` varchar(50) DEFAULT NULL,
453 UNIQUE KEY `ID` (`ID`) USING BTREE
454) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
455/*!40101 SET character_set_client = @saved_cs_client */;
456
457--
458-- Dumping data for table `policedatabase`
459--
460
461LOCK TABLES `policedatabase` WRITE;
462/*!40000 ALTER TABLE `policedatabase` DISABLE KEYS */;
463/*!40000 ALTER TABLE `policedatabase` ENABLE KEYS */;
464UNLOCK TABLES;
465
466--
467-- Table structure for table `referal_system`
468--
469
470DROP TABLE IF EXISTS `referal_system`;
471/*!40101 SET @saved_cs_client = @@character_set_client */;
472 SET character_set_client = utf8mb4 ;
473CREATE TABLE `referal_system` (
474 `id` int(11) NOT NULL AUTO_INCREMENT,
475 `token` varchar(50) DEFAULT NULL,
476 `reward` text,
477 `limit` int(11) DEFAULT '0',
478 `count` int(11) DEFAULT '0',
479 `uid` varchar(50) DEFAULT NULL,
480 `rewardCreator` int(11) DEFAULT '0',
481 PRIMARY KEY (`id`),
482 UNIQUE KEY `token` (`token`)
483) ENGINE=InnoDB DEFAULT CHARSET=latin1;
484/*!40101 SET character_set_client = @saved_cs_client */;
485
486--
487-- Dumping data for table `referal_system`
488--
489
490LOCK TABLES `referal_system` WRITE;
491/*!40000 ALTER TABLE `referal_system` DISABLE KEYS */;
492/*!40000 ALTER TABLE `referal_system` ENABLE KEYS */;
493UNLOCK TABLES;
494
495--
496-- Table structure for table `shops`
497--
498
499DROP TABLE IF EXISTS `shops`;
500/*!40101 SET @saved_cs_client = @@character_set_client */;
501 SET character_set_client = utf8mb4 ;
502CREATE TABLE `shops` (
503 `id` smallint(6) NOT NULL AUTO_INCREMENT,
504 `shop` varchar(50) NOT NULL DEFAULT 'Shop_Vehicles_Supplies_Vendor',
505 `object` varchar(30) NOT NULL DEFAULT '',
506 `stock` varchar(500) NOT NULL DEFAULT '[]',
507 UNIQUE KEY `id` (`id`) USING BTREE
508) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
509/*!40101 SET character_set_client = @saved_cs_client */;
510
511--
512-- Dumping data for table `shops`
513--
514
515LOCK TABLES `shops` WRITE;
516/*!40000 ALTER TABLE `shops` DISABLE KEYS */;
517INSERT INTO `shops` VALUES (1,'Hunting','npc_hunting','[50,500,500,500,500,500]'),(2,'Guns','npc_guns','[50,500,50,500]'),(3,'Guns','npc_guns_1','[50,500,50,500]'),(4,'Market','npc_supermarket','[500,500,500,500,500,500,500,500,500,500]'),(5,'Market','npc_supermarket_1','[500,500,500,500,500,500,500,500,500,500]'),(6,'Vehicles','NPC_vehicles_1','[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]');
518/*!40000 ALTER TABLE `shops` ENABLE KEYS */;
519UNLOCK TABLES;
520
521--
522-- Dumping events for database 'life'
523--
524
525--
526-- Dumping routines for database 'life'
527--
528/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
529
530/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
531/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
532/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
533/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
534/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
535/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
536/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
537
538-- Dump completed on 2018-12-06 23:30:44