· 9 years ago · Feb 02, 2017, 01:04 AM
1-- phpMyAdmin SQL Dump
2-- version 3.5.2.2
3-- http://www.phpmyadmin.net
4--
5-- Servidor: 127.0.0.1
6-- Tiempo de generación: 02-02-2017 a las 02:01:47
7-- Versión del servidor: 5.5.27
8-- Versión de PHP: 5.4.7
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Base de datos: `id19832`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Estructura de tabla para la tabla `admin`
27--
28
29CREATE TABLE IF NOT EXISTS `admin` (
30 `id` int(12) NOT NULL AUTO_INCREMENT,
31 `nombre` varchar(33) NOT NULL,
32 `password` varchar(33) NOT NULL,
33 `steam` varchar(33) NOT NULL,
34 `ip` varchar(33) NOT NULL,
35 `shorthid` varchar(33) NOT NULL,
36 `flags` varchar(64) NOT NULL,
37 `acceso` varchar(3) NOT NULL,
38 `vencimiento` int(33) NOT NULL,
39 `servidores` varchar(33) NOT NULL,
40 `activo` int(2) NOT NULL DEFAULT '1',
41 `ultima_conexion` int(33) NOT NULL,
42 `sancion` varchar(128) NOT NULL,
43 `sanciontime` int(12) NOT NULL DEFAULT '-1',
44 PRIMARY KEY (`id`),
45 UNIQUE KEY `steam` (`steam`,`ip`,`shorthid`)
46) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=45 ;
47
48-- --------------------------------------------------------
49
50--
51-- Estructura de tabla para la tabla `amix_partidos`
52--
53
54CREATE TABLE IF NOT EXISTS `amix_partidos` (
55 `id` int(11) NOT NULL AUTO_INCREMENT,
56 `w_n` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
57 `l_n` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
58 `w_p` int(11) DEFAULT NULL,
59 `l_p` int(11) DEFAULT NULL,
60 `w_pj_1` varchar(255) CHARACTER SET ascii DEFAULT NULL,
61 `w_pj_1_k` int(11) DEFAULT NULL,
62 `w_pj_1_d` int(11) DEFAULT NULL,
63 `w_pj_1_hs` int(11) DEFAULT NULL,
64 `w_pj_1_dmg` int(11) DEFAULT NULL,
65 `w_pj_1_tks` int(11) NOT NULL DEFAULT '0',
66 `w_pj_2` varchar(255) CHARACTER SET ascii DEFAULT NULL,
67 `w_pj_2_k` int(11) DEFAULT NULL,
68 `w_pj_2_d` int(11) DEFAULT NULL,
69 `w_pj_2_hs` int(11) DEFAULT NULL,
70 `w_pj_2_dmg` int(11) DEFAULT NULL,
71 `w_pj_2_tks` int(11) NOT NULL DEFAULT '0',
72 `w_pj_3` varchar(255) CHARACTER SET ascii DEFAULT NULL,
73 `w_pj_3_k` int(11) DEFAULT NULL,
74 `w_pj_3_d` int(11) DEFAULT NULL,
75 `w_pj_3_hs` int(11) DEFAULT NULL,
76 `w_pj_3_dmg` int(11) DEFAULT NULL,
77 `w_pj_3_tks` int(11) NOT NULL DEFAULT '0',
78 `w_pj_4` varchar(255) CHARACTER SET ascii DEFAULT NULL,
79 `w_pj_4_k` int(11) DEFAULT NULL,
80 `w_pj_4_d` int(11) DEFAULT NULL,
81 `w_pj_4_hs` int(11) DEFAULT NULL,
82 `w_pj_4_dmg` int(11) DEFAULT NULL,
83 `w_pj_4_tks` int(11) NOT NULL DEFAULT '0',
84 `w_pj_5` varchar(255) CHARACTER SET ascii DEFAULT NULL,
85 `w_pj_5_k` int(11) DEFAULT NULL,
86 `w_pj_5_d` int(11) DEFAULT NULL,
87 `w_pj_5_hs` int(11) DEFAULT NULL,
88 `w_pj_5_dmg` int(11) DEFAULT NULL,
89 `w_pj_5_tks` int(11) NOT NULL DEFAULT '0',
90 `l_pj_1` varchar(255) CHARACTER SET ascii DEFAULT NULL,
91 `l_pj_1_k` int(11) DEFAULT NULL,
92 `l_pj_1_d` int(11) DEFAULT NULL,
93 `l_pj_1_hs` int(11) DEFAULT NULL,
94 `l_pj_1_dmg` int(11) DEFAULT NULL,
95 `l_pj_1_tks` int(11) NOT NULL DEFAULT '0',
96 `l_pj_2` varchar(255) CHARACTER SET ascii DEFAULT NULL,
97 `l_pj_2_k` int(11) DEFAULT NULL,
98 `l_pj_2_d` int(11) DEFAULT NULL,
99 `l_pj_2_hs` int(11) DEFAULT NULL,
100 `l_pj_2_dmg` int(11) DEFAULT NULL,
101 `l_pj_2_tks` int(11) NOT NULL DEFAULT '0',
102 `l_pj_3` varchar(255) CHARACTER SET ascii DEFAULT NULL,
103 `l_pj_3_k` int(11) DEFAULT NULL,
104 `l_pj_3_d` int(11) DEFAULT NULL,
105 `l_pj_3_hs` int(11) DEFAULT NULL,
106 `l_pj_3_dmg` int(11) DEFAULT NULL,
107 `l_pj_3_tks` int(11) NOT NULL DEFAULT '0',
108 `l_pj_4` varchar(255) CHARACTER SET ascii DEFAULT NULL,
109 `l_pj_4_k` int(11) DEFAULT NULL,
110 `l_pj_4_d` int(11) DEFAULT NULL,
111 `l_pj_4_hs` int(11) DEFAULT NULL,
112 `l_pj_4_dmg` int(11) DEFAULT NULL,
113 `l_pj_4_tks` int(11) NOT NULL DEFAULT '0',
114 `l_pj_5` varchar(255) CHARACTER SET ascii DEFAULT NULL,
115 `l_pj_5_k` int(11) DEFAULT NULL,
116 `l_pj_5_d` int(11) DEFAULT NULL,
117 `l_pj_5_hs` int(11) DEFAULT NULL,
118 `l_pj_5_dmg` int(11) DEFAULT NULL,
119 `l_pj_5_tks` int(11) NOT NULL DEFAULT '0',
120 `fecha` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
121 PRIMARY KEY (`id`)
122) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=66925 ;
123
124-- --------------------------------------------------------
125
126--
127-- Estructura de tabla para la tabla `conexion_log`
128--
129
130CREATE TABLE IF NOT EXISTS `conexion_log` (
131 `nombre` varchar(33) NOT NULL,
132 `server_id` int(3) NOT NULL,
133 `tiempo` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
134 `ip` varchar(33) NOT NULL,
135 `hid` varchar(33) NOT NULL,
136 `entro` int(2) NOT NULL DEFAULT '0',
137 `admin` int(2) NOT NULL DEFAULT '0'
138) ENGINE=MyISAM DEFAULT CHARSET=utf8;
139
140-- --------------------------------------------------------
141
142--
143-- Estructura de tabla para la tabla `estadisticas_2`
144--
145
146CREATE TABLE IF NOT EXISTS `estadisticas_2` (
147 `id` int(12) NOT NULL AUTO_INCREMENT,
148 `HID` varchar(33) DEFAULT NULL,
149 `nombre` varchar(33) NOT NULL,
150 `ultima_conexion` int(33) NOT NULL DEFAULT '0',
151 `frags` int(12) NOT NULL DEFAULT '0',
152 `deaths` int(12) NOT NULL DEFAULT '0',
153 `headshot` int(12) NOT NULL DEFAULT '0',
154 `hits` int(12) NOT NULL DEFAULT '0',
155 `bodyhit` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0,0',
156 `shots` int(12) NOT NULL DEFAULT '0',
157 `damage` int(12) NOT NULL DEFAULT '0',
158 PRIMARY KEY (`id`),
159 UNIQUE KEY `nombre` (`nombre`)
160) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
161
162-- --------------------------------------------------------
163
164--
165-- Estructura de tabla para la tabla `estadisticas_3`
166--
167
168CREATE TABLE IF NOT EXISTS `estadisticas_3` (
169 `id` int(12) NOT NULL AUTO_INCREMENT,
170 `HID` varchar(33) DEFAULT NULL,
171 `nombre` varchar(33) NOT NULL,
172 `ultima_conexion` int(33) NOT NULL DEFAULT '0',
173 `frags` int(12) NOT NULL DEFAULT '0',
174 `deaths` int(12) NOT NULL DEFAULT '0',
175 `headshot` int(12) NOT NULL DEFAULT '0',
176 `hits` int(12) NOT NULL DEFAULT '0',
177 `bodyhit` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0,0',
178 `shots` int(12) NOT NULL DEFAULT '0',
179 `damage` int(12) NOT NULL DEFAULT '0',
180 PRIMARY KEY (`id`),
181 UNIQUE KEY `nombre` (`nombre`)
182) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6169 ;
183
184-- --------------------------------------------------------
185
186--
187-- Estructura de tabla para la tabla `estadisticas_4`
188--
189
190CREATE TABLE IF NOT EXISTS `estadisticas_4` (
191 `id` int(12) NOT NULL AUTO_INCREMENT,
192 `HID` varchar(33) DEFAULT NULL,
193 `nombre` varchar(33) NOT NULL,
194 `ultima_conexion` int(33) NOT NULL DEFAULT '0',
195 `frags` int(12) NOT NULL DEFAULT '0',
196 `deaths` int(12) NOT NULL DEFAULT '0',
197 `headshot` int(12) NOT NULL DEFAULT '0',
198 `hits` int(12) NOT NULL DEFAULT '0',
199 `bodyhit` varchar(64) NOT NULL DEFAULT '0,0,0,0,0,0,0,0',
200 `shots` int(12) NOT NULL DEFAULT '0',
201 `damage` int(12) NOT NULL DEFAULT '0',
202 PRIMARY KEY (`id`),
203 UNIQUE KEY `nombre` (`nombre`)
204) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=633 ;
205
206-- --------------------------------------------------------
207
208--
209-- Estructura de tabla para la tabla `players`
210--
211
212CREATE TABLE IF NOT EXISTS `players` (
213 `server_id` int(3) NOT NULL,
214 `nombre` varchar(33) NOT NULL,
215 `hid` varchar(33) NOT NULL,
216 `ip` varchar(33) NOT NULL,
217 `uid` int(12) NOT NULL
218) ENGINE=MyISAM DEFAULT CHARSET=utf8;
219
220-- --------------------------------------------------------
221
222--
223-- Estructura de tabla para la tabla `servidores`
224--
225
226CREATE TABLE IF NOT EXISTS `servidores` (
227 `id` int(12) NOT NULL AUTO_INCREMENT,
228 `ip` varchar(22) NOT NULL,
229 `hostname` varchar(128) NOT NULL,
230 `players` int(3) NOT NULL DEFAULT '0',
231 `maxplayers` int(3) NOT NULL DEFAULT '12',
232 `map` varchar(64) NOT NULL DEFAULT 'de_dust2',
233 `password` varchar(33) NOT NULL,
234 PRIMARY KEY (`id`),
235 UNIQUE KEY `ip` (`ip`)
236) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
237
238/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
239/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
240/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;