· 6 years ago · Apr 15, 2019, 06:46 PM
1-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
2--
3-- Host: localhost Database: beachlife
4-- ------------------------------------------------------
5-- Server version 5.7.18-log
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
20-- Volcando estructura de base de datos para a3life
21CREATE DATABASE IF NOT EXISTS `a3life` /*!40100 DEFAULT CHARACTER SET latin1 */;
22USE `a3life`;
23
24
25-- Volcando estructura para procedimiento a3life.deleteDeadVehicles
26DELIMITER //
27CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
28BEGIN
29 DELETE FROM `vehicles` WHERE `alive` = 0;
30END//
31DELIMITER ;
32
33
34-- Volcando estructura para procedimiento a3life.deleteOldGangs
35DELIMITER //
36CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
37BEGIN
38 DELETE FROM `gangs` WHERE `active` = 0;
39END//
40DELIMITER ;
41
42
43-- Volcando estructura para procedimiento a3life.deleteOldHouses
44DELIMITER //
45CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
46BEGIN
47 DELETE FROM `houses` WHERE `owned` = 0;
48END//
49DELIMITER ;
50
51
52-- Table structure for table `gangs`
53--
54
55DROP TABLE IF EXISTS `gangs`;
56/*!40101 SET @saved_cs_client = @@character_set_client */;
57/*!40101 SET character_set_client = utf8 */;
58CREATE TABLE `gangs` (
59 `id` int(11) NOT NULL AUTO_INCREMENT,
60 `owner` varchar(32) DEFAULT NULL,
61 `name` varchar(32) DEFAULT NULL,
62 `members` text,
63 `maxmembers` int(2) DEFAULT '8',
64 `bank` int(100) DEFAULT '0',
65 `active` tinyint(4) DEFAULT '1',
66 PRIMARY KEY (`id`),
67 UNIQUE KEY `name_UNIQUE` (`name`)
68) ENGINE=InnoDB DEFAULT CHARSET=latin1;
69/*!40101 SET character_set_client = @saved_cs_client */;
70
71--
72-- Dumping data for table `gangs`
73--
74
75LOCK TABLES `gangs` WRITE;
76/*!40000 ALTER TABLE `gangs` DISABLE KEYS */;
77/*!40000 ALTER TABLE `gangs` ENABLE KEYS */;
78UNLOCK TABLES;
79
80--
81-- Table structure for table `houses`
82--
83
84DROP TABLE IF EXISTS `houses`;
85/*!40101 SET @saved_cs_client = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE `houses` (
88 `id` int(11) NOT NULL AUTO_INCREMENT,
89 `pid` varchar(32) NOT NULL,
90 `pos` varchar(64) DEFAULT NULL,
91 `inventory` text,
92 `containers` text,
93 `owned` tinyint(4) DEFAULT '0',
94 PRIMARY KEY (`id`,`pid`)
95) ENGINE=InnoDB DEFAULT CHARSET=latin1;
96/*!40101 SET character_set_client = @saved_cs_client */;
97
98--
99-- Dumping data for table `houses`
100--
101
102LOCK TABLES `houses` WRITE;
103/*!40000 ALTER TABLE `houses` DISABLE KEYS */;
104/*!40000 ALTER TABLE `houses` ENABLE KEYS */;
105UNLOCK TABLES;
106
107--
108-- Table structure for table `market`
109--
110
111DROP TABLE IF EXISTS `market`;
112/*!40101 SET @saved_cs_client = @@character_set_client */;
113/*!40101 SET character_set_client = utf8 */;
114CREATE TABLE `market` (
115 `id` int(11) NOT NULL AUTO_INCREMENT,
116 `prices` text,
117 PRIMARY KEY (`id`)
118) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
119/*!40101 SET character_set_client = @saved_cs_client */;
120
121--
122-- Dumping data for table `market`
123--
124
125LOCK TABLES `market` WRITE;
126/*!40000 ALTER TABLE `market` DISABLE KEYS */;
127INSERT INTO `market` VALUES (1,'[304,0,1000,124,413,649,1000,45,326,152,425,0,115,157,508,0,228,246,635,0,487,103,428,20,0,0,0,73,116,0,16,0,6,1,200,29,151,176,0,0,0,0]');
128/*!40000 ALTER TABLE `market` ENABLE KEYS */;
129UNLOCK TABLES;
130
131--
132-- Table structure for table `players`
133--
134
135DROP TABLE IF EXISTS `players`;
136/*!40101 SET @saved_cs_client = @@character_set_client */;
137/*!40101 SET character_set_client = utf8 */;
138CREATE TABLE `players` (
139 `uid` int(12) NOT NULL AUTO_INCREMENT,
140 `name` varchar(32) NOT NULL,
141 `playerid` varchar(50) NOT NULL,
142 `cash` int(100) NOT NULL DEFAULT '0',
143 `bankacc` int(100) NOT NULL DEFAULT '0',
144 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
145 `cop_licenses` text,
146 `civ_licenses` text,
147 `med_licenses` text,
148 `cop_gear` text NOT NULL,
149 `med_gear` text NOT NULL,
150 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
151 `arrested` tinyint(1) NOT NULL DEFAULT '0',
152 `aliases` text NOT NULL,
153 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
154 `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
155 `civ_gear` text NOT NULL,
156 `experiencia` text,
157 `jailtime` int(100) DEFAULT '0',
158 `arrestreason` text,
159 `op_licenses` text,
160 `op_gear` text NOT NULL,
161 `oplevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
162 `mafialvl` enum('0','1','2') NOT NULL DEFAULT '0',
163 `terrolvl` enum('0','1','2') NOT NULL DEFAULT '0',
164 `splvl` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
165 PRIMARY KEY (`uid`),
166 UNIQUE KEY `playerid` (`playerid`),
167 KEY `name` (`name`)
168) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
169/*!40101 SET character_set_client = @saved_cs_client */;
170
171--
172-- Dumping data for table `players`
173--
174
175LOCK TABLES `players` WRITE;
176/*!40000 ALTER TABLE `players` DISABLE KEYS */;
177INSERT INTO `players` VALUES (15,'barra','_SP_PLAYER_',0,2500,'0','\"[]\"','\"[]\"','\"[]\"','\"[]\"','\"[]\"','0',0,'\"[``barra``]\"','0','0','\"[]\"','\"[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]\"',0,'\"\"','\"[]\"','\"[]\"','0','0','0','0');
178/*!40000 ALTER TABLE `players` ENABLE KEYS */;
179UNLOCK TABLES;
180
181--
182-- Table structure for table `politica`
183--
184
185DROP TABLE IF EXISTS `politica`;
186/*!40101 SET @saved_cs_client = @@character_set_client */;
187/*!40101 SET character_set_client = utf8 */;
188CREATE TABLE `politica` (
189 `id` varchar(50) NOT NULL,
190 `nombre` varchar(50) NOT NULL,
191 `votos` int(11) NOT NULL DEFAULT '0',
192 PRIMARY KEY (`id`)
193) ENGINE=InnoDB DEFAULT CHARSET=latin1;
194/*!40101 SET character_set_client = @saved_cs_client */;
195
196--
197-- Dumping data for table `politica`
198--
199
200LOCK TABLES `politica` WRITE;
201/*!40000 ALTER TABLE `politica` DISABLE KEYS */;
202/*!40000 ALTER TABLE `politica` ENABLE KEYS */;
203UNLOCK TABLES;
204
205--
206-- Table structure for table `politicados`
207--
208
209DROP TABLE IF EXISTS `politicados`;
210/*!40101 SET @saved_cs_client = @@character_set_client */;
211/*!40101 SET character_set_client = utf8 */;
212CREATE TABLE `politicados` (
213 `votantes` varchar(50) DEFAULT NULL,
214 `candidato` varchar(50) DEFAULT NULL
215) ENGINE=InnoDB DEFAULT CHARSET=latin1;
216/*!40101 SET character_set_client = @saved_cs_client */;
217
218--
219-- Dumping data for table `politicados`
220--
221
222LOCK TABLES `politicados` WRITE;
223/*!40000 ALTER TABLE `politicados` DISABLE KEYS */;
224/*!40000 ALTER TABLE `politicados` ENABLE KEYS */;
225UNLOCK TABLES;
226
227--
228-- Table structure for table `storages`
229--
230
231DROP TABLE IF EXISTS `storages`;
232/*!40101 SET @saved_cs_client = @@character_set_client */;
233/*!40101 SET character_set_client = utf8 */;
234CREATE TABLE `storages` (
235 `pid` varchar(32) NOT NULL,
236 `inventario` text,
237 `capacidad` int(4) NOT NULL,
238 `id` int(12) NOT NULL AUTO_INCREMENT,
239 PRIMARY KEY (`id`),
240 UNIQUE KEY `pid` (`pid`)
241) ENGINE=InnoDB DEFAULT CHARSET=latin1;
242/*!40101 SET character_set_client = @saved_cs_client */;
243
244--
245-- Dumping data for table `storages`
246--
247
248LOCK TABLES `storages` WRITE;
249/*!40000 ALTER TABLE `storages` DISABLE KEYS */;
250/*!40000 ALTER TABLE `storages` ENABLE KEYS */;
251UNLOCK TABLES;
252
253--
254-- Table structure for table `vehicles`
255--
256
257DROP TABLE IF EXISTS `vehicles`;
258/*!40101 SET @saved_cs_client = @@character_set_client */;
259/*!40101 SET character_set_client = utf8 */;
260CREATE TABLE `vehicles` (
261 `id` int(12) NOT NULL AUTO_INCREMENT,
262 `side` varchar(15) NOT NULL,
263 `classname` varchar(32) NOT NULL,
264 `type` varchar(12) NOT NULL,
265 `pid` varchar(32) NOT NULL,
266 `alive` tinyint(1) NOT NULL DEFAULT '1',
267 `active` tinyint(1) NOT NULL DEFAULT '0',
268 `plate` varchar(8) NOT NULL,
269 `color` int(20) NOT NULL,
270 `fuel` varchar(16) NOT NULL DEFAULT '"1"',
271 PRIMARY KEY (`id`),
272 KEY `side` (`side`),
273 KEY `pid` (`pid`),
274 KEY `type` (`type`)
275) ENGINE=InnoDB DEFAULT CHARSET=latin1;
276/*!40101 SET character_set_client = @saved_cs_client */;
277
278--
279-- Dumping data for table `vehicles`
280--
281
282LOCK TABLES `vehicles` WRITE;
283/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
284/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
285UNLOCK TABLES;
286
287--
288-- Table structure for table `wanted`
289--
290
291DROP TABLE IF EXISTS `wanted`;
292/*!40101 SET @saved_cs_client = @@character_set_client */;
293/*!40101 SET character_set_client = utf8 */;
294CREATE TABLE `wanted` (
295 `wantedID` varchar(64) NOT NULL,
296 `wantedName` varchar(32) NOT NULL,
297 `wantedCrimes` text NOT NULL,
298 `wantedBounty` int(100) NOT NULL,
299 `active` tinyint(1) NOT NULL DEFAULT '0',
300 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
301 PRIMARY KEY (`wantedID`)
302) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
303/*!40101 SET character_set_client = @saved_cs_client */;
304
305--
306-- Dumping data for table `wanted`
307--
308
309LOCK TABLES `wanted` WRITE;
310/*!40000 ALTER TABLE `wanted` DISABLE KEYS */;
311/*!40000 ALTER TABLE `wanted` ENABLE KEYS */;
312UNLOCK TABLES;
313/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
314
315/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
316/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
317/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
318/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
319/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
320/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
321/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
322
323-- Dump completed on 2017-05-03 11:01:41