ZxMSDwVd

1-- --------------------------------------------------------
2-- Host:                         127.0.0.1
3-- Versión del servidor:         5.7.10-log - MySQL Community Server (GPL)
4-- SO del servidor:              Win64
5-- HeidiSQL Versión:             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
14
15
16--
17-- Table structure for table `market`
18--
19
20DROP TABLE IF EXISTS `market`;
21/*!40101 SET @saved_cs_client     = @@character_set_client */;
22/*!40101 SET character_set_client = utf8 */;
23CREATE TABLE `market` (
24  `id` int(11) NOT NULL AUTO_INCREMENT,
25  `prices` text,
26  PRIMARY KEY (`id`)
27) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
28/*!40101 SET character_set_client = @saved_cs_client */;
29
30--
31-- Dumping data for table `market`
32--
33
34LOCK TABLES `market` WRITE;
35/*!40000 ALTER TABLE `market` DISABLE KEYS */;
36INSERT INTO `market` VALUES (1,'[139,914,464,4,1000,986,312,248,0,0,0,0,53,731,388,0,0,0,0,0,297,0,0,0,0,0,0,0,0,0,3,3,1,2,29,8,200,200,0,0,0,0]');
37/*!40000 ALTER TABLE `market` ENABLE KEYS */;
38UNLOCK TABLES;
39
40
41-- Volcando estructura para tabla altislife.containers
42CREATE TABLE IF NOT EXISTS `containers` (
43  `id` int(6) NOT NULL AUTO_INCREMENT,
44  `pid` varchar(17) NOT NULL,
45  `classname` varchar(32) NOT NULL,
46  `pos` varchar(64) DEFAULT NULL,
47  `inventory` text NOT NULL,
48  `gear` text NOT NULL,
49  `dir` varchar(128) DEFAULT NULL,
50  `active` tinyint(1) NOT NULL DEFAULT '0',
51  `owned` tinyint(1) DEFAULT '0',
52  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
53  `apto` tinyint(2) NOT NULL DEFAULT '0',
54  PRIMARY KEY (`id`,`pid`)
55) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4;
56
57
58-- Volcando estructura para procedimiento altislife.deleteDeadVehicles
59DELIMITER //
60CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteDeadVehicles`()
61BEGIN
62  DELETE FROM `vehicles` WHERE `alive` = 0;
63END//
64DELIMITER ;
65
66
67-- Volcando estructura para procedimiento altislife.deleteOldContainers
68DELIMITER //
69CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldContainers`()
70BEGIN
71  DELETE FROM `containers` WHERE `owned` = 0;
72END//
73DELIMITER ;
74
75
76-- Volcando estructura para procedimiento altislife.deleteOldGangs
77DELIMITER //
78CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldGangs`()
79BEGIN
80  DELETE FROM `gangs` WHERE `active` = 0;
81END//
82DELIMITER ;
83
84
85-- Volcando estructura para procedimiento altislife.deleteOldHouses
86DELIMITER //
87CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldHouses`()
88BEGIN
89  DELETE FROM `houses` WHERE `owned` = 0;
90END//
91DELIMITER ;
92
93
94-- Volcando estructura para procedimiento altislife.deleteOldWanted
95DELIMITER //
96CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldWanted`()
97BEGIN
98  DELETE FROM `wanted` WHERE `active` = 0;
99END//
100DELIMITER ;
101
102
103-- Volcando estructura para tabla altislife.gangs
104CREATE TABLE IF NOT EXISTS `gangs` (
105  `id` int(6) NOT NULL AUTO_INCREMENT,
106  `owner` varchar(32) DEFAULT NULL,
107  `name` varchar(32) DEFAULT NULL,
108  `members` text,
109  `maxmembers` int(3) DEFAULT '8',
110  `bank` int(100) DEFAULT '0',
111  `active` tinyint(1) DEFAULT '1',
112  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
113  `zona` int(1) DEFAULT '0',
114  `casa` varchar(32) DEFAULT '"[]"',
115  PRIMARY KEY (`id`),
116  UNIQUE KEY `name_UNIQUE` (`name`)
117) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;
118
119
120
121
122-- Volcando estructura para tabla altislife.granjas
123CREATE TABLE IF NOT EXISTS `granjas` (
124  `id` int(6) NOT NULL AUTO_INCREMENT,
125  `pid` varchar(17) NOT NULL,
126  `pos` varchar(64) DEFAULT NULL,
127  `owned` tinyint(1) DEFAULT '0',
128  `garage` tinyint(1) NOT NULL DEFAULT '0',
129  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
130  PRIMARY KEY (`id`,`pid`)
131) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
132
133-- Volcando datos para la tabla altislife.granjas: ~0 rows (aproximadamente)
134/*!40000 ALTER TABLE `granjas` DISABLE KEYS */;
135/*!40000 ALTER TABLE `granjas` ENABLE KEYS */;
136
137
138-- Volcando estructura para tabla altislife.houses
139CREATE TABLE IF NOT EXISTS `houses` (
140  `id` int(6) NOT NULL AUTO_INCREMENT,
141  `pid` varchar(17) NOT NULL,
142  `pos` varchar(64) DEFAULT NULL,
143  `owned` tinyint(1) DEFAULT '0',
144  `garage` tinyint(1) NOT NULL DEFAULT '0',
145  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
146  `apto` tinyint(2) DEFAULT '0',
147  PRIMARY KEY (`id`,`pid`)
148) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4;
149
150-- Volcando estructura para tabla altislife.negocios
151CREATE TABLE IF NOT EXISTS `negocios` (
152  `id` int(6) NOT NULL AUTO_INCREMENT,
153  `pid` varchar(17) NOT NULL,
154  `classname` varchar(50) DEFAULT NULL,
155  `pos` varchar(64) DEFAULT NULL,
156  `owned` tinyint(1) DEFAULT '0',
157  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
158  PRIMARY KEY (`id`,`pid`)
159) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
160
161-- Volcando datos para la tabla altislife.negocios: ~0 rows (aproximadamente)
162/*!40000 ALTER TABLE `negocios` DISABLE KEYS */;
163/*!40000 ALTER TABLE `negocios` ENABLE KEYS */;
164
165
166-- Volcando estructura para tabla altislife.players
167CREATE TABLE IF NOT EXISTS `players` (
168  `uid` int(6) NOT NULL AUTO_INCREMENT,
169  `name` varchar(32) NOT NULL,
170  `aliases` text NOT NULL,
171  `pid` varchar(17) NOT NULL,
172  `cash` int(100) NOT NULL DEFAULT '0',
173  `bankacc` int(100) NOT NULL DEFAULT '0',
174  `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
175  `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
176  `civ_licenses` text NOT NULL,
177  `cop_licenses` text NOT NULL,
178  `med_licenses` text NOT NULL,
179  `civ_gear` text NOT NULL,
180  `cop_gear` text NOT NULL,
181  `med_gear` text NOT NULL,
182  `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
183  `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
184  `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
185  `arrested` tinyint(1) NOT NULL DEFAULT '0',
186  `experiencia` varchar(50) DEFAULT '"[100,1,0,0,0,0,0,0,0,0,0,0,0,0]"',
187  `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
188  `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
189  `blacklist` tinyint(1) NOT NULL DEFAULT '0',
190  `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
191  `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
192  `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
193  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
194  `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
195  `terrolvl` enum('0','1','2','3','4') DEFAULT '0',
196  `mafialvl` enum('0','1','2','3','4') DEFAULT '0',
197  `splvl` enum('0','1','2','3','4') DEFAULT '0',
198  PRIMARY KEY (`uid`),
199  UNIQUE KEY `pid` (`pid`),
200  KEY `name` (`name`),
201  KEY `blacklist` (`blacklist`)
202) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;
203
204
205
206
207-- Volcando estructura para procedimiento altislife.resetLifeVehicles
208DELIMITER //
209CREATE DEFINER=`arma3`@`localhost` PROCEDURE `resetLifeVehicles`()
210BEGIN
211  UPDATE `vehicles` SET `active`= 0;
212END//
213DELIMITER ;
214
215
216-- Volcando estructura para tabla altislife.vehicles
217CREATE TABLE IF NOT EXISTS `vehicles` (
218  `id` int(6) NOT NULL AUTO_INCREMENT,
219  `side` varchar(16) NOT NULL,
220  `classname` varchar(64) NOT NULL,
221  `type` varchar(16) NOT NULL,
222  `pid` varchar(17) NOT NULL,
223  `alive` tinyint(1) NOT NULL DEFAULT '1',
224  `blacklist` tinyint(1) NOT NULL DEFAULT '0',
225  `active` tinyint(1) NOT NULL DEFAULT '0',
226  `plate` int(20) NOT NULL,
227  `color` int(20) NOT NULL,
228  `inventory` text NOT NULL,
229  `gear` text NOT NULL,
230  `fuel` double NOT NULL DEFAULT '1',
231  `damage` varchar(256) NOT NULL,
232  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
233  PRIMARY KEY (`id`),
234  KEY `side` (`side`),
235  KEY `pid` (`pid`),
236  KEY `type` (`type`)
237) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
238
239-- Volcando estructura para tabla altislife.wanted
240CREATE TABLE IF NOT EXISTS `wanted` (
241  `wantedID` varchar(64) NOT NULL,
242  `wantedName` varchar(32) NOT NULL,
243  `wantedCrimes` text NOT NULL,
244  `wantedBounty` int(100) NOT NULL,
245  `active` tinyint(1) NOT NULL DEFAULT '0',
246  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
247  PRIMARY KEY (`wantedID`)
248) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;