· 7 years ago · Feb 02, 2019, 02:32 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Versión del servidor: 10.1.37-MariaDB - mariadb.org binary distribution
4-- SO del servidor: Win32
5-- HeidiSQL Versión: 9.5.0.5196
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Volcando estructura de base de datos para a3life
16CREATE DATABASE IF NOT EXISTS `a3life` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `a3life`;
18
19-- Volcando estructura para procedimiento a3life.deleteOldGangs
20DELIMITER //
21CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
22BEGIN
23 DELETE FROM `gangs` WHERE `active` = 0;
24END//
25DELIMITER ;
26
27-- Volcando estructura para procedimiento a3life.deleteOldHouses
28DELIMITER //
29CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
30BEGIN
31 DELETE FROM `houses` WHERE `owned` = 0;
32END//
33DELIMITER ;
34
35-- Volcando estructura para procedimiento a3life.deleteOldWanted
36DELIMITER //
37CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldWanted`()
38BEGIN
39 DELETE FROM `wanted` WHERE `active` = 0;
40END//
41DELIMITER ;
42
43-- Volcando estructura para tabla a3life.gangs
44CREATE TABLE IF NOT EXISTS `gangs` (
45 `id` int(11) NOT NULL AUTO_INCREMENT,
46 `owner` varchar(32) DEFAULT NULL,
47 `name` varchar(32) DEFAULT NULL,
48 `members` text,
49 `maxmembers` int(2) DEFAULT '8',
50 `bank` int(100) DEFAULT '0',
51 `active` tinyint(4) DEFAULT '1',
52 PRIMARY KEY (`id`),
53 UNIQUE KEY `name_UNIQUE` (`name`)
54) ENGINE=InnoDB DEFAULT CHARSET=latin1;
55
56-- Volcando datos para la tabla a3life.gangs: ~0 rows (aproximadamente)
57/*!40000 ALTER TABLE `gangs` DISABLE KEYS */;
58/*!40000 ALTER TABLE `gangs` ENABLE KEYS */;
59
60-- Volcando estructura para tabla a3life.houses
61CREATE TABLE IF NOT EXISTS `houses` (
62 `id` int(11) NOT NULL AUTO_INCREMENT,
63 `pid` varchar(32) NOT NULL,
64 `pos` varchar(64) DEFAULT NULL,
65 `inventory` text,
66 `containers` text,
67 `owned` tinyint(4) DEFAULT '0',
68 PRIMARY KEY (`id`,`pid`)
69) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
70
71-- Volcando datos para la tabla a3life.houses: ~2 rows (aproximadamente)
72/*!40000 ALTER TABLE `houses` DISABLE KEYS */;
73REPLACE INTO `houses` (`id`, `pid`, `pos`, `inventory`, `containers`, `owned`) VALUES
74 (2, '76561198191181079', '[8479.65,6497.55,1.04904e-005]', '[[],0]', '[]', 1);
75/*!40000 ALTER TABLE `houses` ENABLE KEYS */;
76
77-- Volcando estructura para tabla a3life.market
78CREATE TABLE IF NOT EXISTS `market` (
79 `id` int(11) NOT NULL AUTO_INCREMENT,
80 `prices` text,
81 PRIMARY KEY (`id`)
82) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
83
84-- Volcando datos para la tabla a3life.market: ~0 rows (aproximadamente)
85/*!40000 ALTER TABLE `market` DISABLE KEYS */;
86REPLACE INTO `market` (`id`, `prices`) VALUES
87 (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]');
88/*!40000 ALTER TABLE `market` ENABLE KEYS */;
89
90-- Volcando estructura para tabla a3life.players
91CREATE TABLE IF NOT EXISTS `players` (
92 `uid` int(12) NOT NULL AUTO_INCREMENT,
93 `name` varchar(32) NOT NULL,
94 `playerid` varchar(50) NOT NULL,
95 `cash` int(100) NOT NULL DEFAULT '0',
96 `bankacc` int(100) NOT NULL DEFAULT '0',
97 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
98 `cop_licenses` text,
99 `civ_licenses` text,
100 `med_licenses` text,
101 `cop_gear` text NOT NULL,
102 `med_gear` text NOT NULL,
103 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
104 `arrested` tinyint(1) NOT NULL DEFAULT '0',
105 `aliases` text NOT NULL,
106 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
107 `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
108 `civ_gear` text NOT NULL,
109 `experiencia` text,
110 `jailtime` int(100) DEFAULT '0',
111 `arrestreason` text,
112 `op_licenses` text,
113 `op_gear` text NOT NULL,
114 `oplevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
115 `mafialvl` enum('0','1','2') NOT NULL DEFAULT '0',
116 `terrolvl` enum('0','1','2') NOT NULL DEFAULT '0',
117 `splvl` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
118 PRIMARY KEY (`uid`),
119 UNIQUE KEY `playerid` (`playerid`),
120 KEY `name` (`name`)
121) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
122
123-- Volcando datos para la tabla a3life.players: ~0 rows (aproximadamente)
124/*!40000 ALTER TABLE `players` DISABLE KEYS */;
125REPLACE INTO `players` (`uid`, `name`, `playerid`, `cash`, `bankacc`, `coplevel`, `cop_licenses`, `civ_licenses`, `med_licenses`, `cop_gear`, `med_gear`, `mediclevel`, `arrested`, `aliases`, `adminlevel`, `donatorlvl`, `civ_gear`, `experiencia`, `jailtime`, `arrestreason`, `op_licenses`, `op_gear`, `oplevel`, `mafialvl`, `terrolvl`, `splvl`) VALUES
126 (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'),
127 (16, 'Juanjo Gutierrez', '76561198191181079', 0, 2147377024, '7', '"[[`license_cop_air`,0],[`license_cop_swat`,0],[`license_cop_cg`,0]]"', '"[[`license_civ_driver`,0],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_truck`,0],[`license_civ_depan`,0],[`license_civ_gun`,0],[`license_civ_rebel`,0],[`license_civ_home`,1],[`license_civ_bus`,0],[`license_civ_taxita`,0],[`license_civ_Periodista`,0],[`license_civ_transporte`,0],[`license_civ_donator`,0],[`license_civ_alcalde`,0]]"', '"[]"', '"[`GC2_Pop`,``,``,``,``,[`ItemMap`,`ItemCompass`,`Itemwatch`,`ItemGPS`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``]]"', '"[]"', '0', 0, '"[`Juanjo Gutierrez`]"', '5', '0', '"[``,``,``,``,``,[],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``]]"', '[100,1,550,0,0,0,0,0,0,0,0,0,0,0]', 0, '""', '"[]"', '"[]"', '0', '0', '0', '0');
128/*!40000 ALTER TABLE `players` ENABLE KEYS */;
129
130-- Volcando estructura para tabla a3life.politica
131CREATE TABLE IF NOT EXISTS `politica` (
132 `id` varchar(50) NOT NULL,
133 `nombre` varchar(50) NOT NULL,
134 `votos` int(11) NOT NULL DEFAULT '0',
135 PRIMARY KEY (`id`)
136) ENGINE=InnoDB DEFAULT CHARSET=latin1;
137
138-- Volcando datos para la tabla a3life.politica: ~0 rows (aproximadamente)
139/*!40000 ALTER TABLE `politica` DISABLE KEYS */;
140/*!40000 ALTER TABLE `politica` ENABLE KEYS */;
141
142-- Volcando estructura para tabla a3life.politicados
143CREATE TABLE IF NOT EXISTS `politicados` (
144 `votantes` varchar(50) DEFAULT NULL,
145 `candidato` varchar(50) DEFAULT NULL
146) ENGINE=InnoDB DEFAULT CHARSET=latin1;
147
148-- Volcando datos para la tabla a3life.politicados: ~0 rows (aproximadamente)
149/*!40000 ALTER TABLE `politicados` DISABLE KEYS */;
150/*!40000 ALTER TABLE `politicados` ENABLE KEYS */;
151
152-- Volcando estructura para procedimiento a3life.resetLifeVehicles
153DELIMITER //
154CREATE DEFINER=`arma3`@`localhost` PROCEDURE `resetLifeVehicles`()
155BEGIN
156 UPDATE `vehicles` SET `active`= 0;
157END//
158DELIMITER ;
159
160-- Volcando estructura para tabla a3life.storages
161CREATE TABLE IF NOT EXISTS `storages` (
162 `pid` varchar(32) NOT NULL,
163 `inventario` text,
164 `capacidad` int(4) NOT NULL,
165 `id` int(12) NOT NULL AUTO_INCREMENT,
166 PRIMARY KEY (`id`),
167 UNIQUE KEY `pid` (`pid`)
168) ENGINE=InnoDB DEFAULT CHARSET=latin1;
169
170-- Volcando datos para la tabla a3life.storages: ~0 rows (aproximadamente)
171/*!40000 ALTER TABLE `storages` DISABLE KEYS */;
172/*!40000 ALTER TABLE `storages` ENABLE KEYS */;
173
174-- Volcando estructura para tabla a3life.vehicles
175CREATE TABLE IF NOT EXISTS `vehicles` (
176 `id` int(12) NOT NULL AUTO_INCREMENT,
177 `side` varchar(15) NOT NULL,
178 `classname` varchar(32) NOT NULL,
179 `type` varchar(12) NOT NULL,
180 `pid` varchar(32) NOT NULL,
181 `alive` tinyint(1) NOT NULL DEFAULT '1',
182 `active` tinyint(1) NOT NULL DEFAULT '0',
183 `plate` varchar(8) NOT NULL,
184 `color` int(20) NOT NULL,
185 `fuel` varchar(16) NOT NULL DEFAULT '"1"',
186 PRIMARY KEY (`id`),
187 KEY `side` (`side`),
188 KEY `pid` (`pid`),
189 KEY `type` (`type`)
190) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
191
192-- Volcando datos para la tabla a3life.vehicles: ~0 rows (aproximadamente)
193/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
194REPLACE INTO `vehicles` (`id`, `side`, `classname`, `type`, `pid`, `alive`, `active`, `plate`, `color`, `fuel`) VALUES
195 (1, 'cop', 'pop_nissan_pathfinder_g', 'Car', '76561198191181079', 1, 1, '53445', 0, '"1"'),
196 (2, 'cop', 'citroen_c4_picasso_2016', 'Car', '76561198191181079', 1, 1, '412055', 0, '"1"');
197/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
198
199-- Volcando estructura para tabla a3life.wanted
200CREATE TABLE IF NOT EXISTS `wanted` (
201 `wantedID` varchar(64) NOT NULL,
202 `wantedName` varchar(32) NOT NULL,
203 `wantedCrimes` text NOT NULL,
204 `wantedBounty` int(100) NOT NULL,
205 `active` tinyint(1) NOT NULL DEFAULT '0',
206 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
207 PRIMARY KEY (`wantedID`)
208) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
209
210-- Volcando datos para la tabla a3life.wanted: ~0 rows (aproximadamente)
211/*!40000 ALTER TABLE `wanted` DISABLE KEYS */;
212/*!40000 ALTER TABLE `wanted` ENABLE KEYS */;
213
214/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
215/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
216/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;