h7vnYP7d

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