Cq915saB

1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Servidor: 127.0.0.1
6-- Tiempo de generación: 17-04-2015 a las 05:48:37
7-- Versión del servidor: 5.6.21
8-- Versión de PHP: 5.6.3
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: `panel_net`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Estructura de tabla para la tabla `clientes`
27--
28
29CREATE TABLE IF NOT EXISTS `clientes` (
30`user_id` int(11) NOT NULL,
31  `nombre` varchar(32) NOT NULL,
32  `password` varchar(129) NOT NULL,
33  `user_email` varchar(34) NOT NULL,
34  `rol` int(11) NOT NULL DEFAULT '0'
35) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
36
37--
38-- Volcado de datos para la tabla `clientes`
39--
40
41INSERT INTO `clientes` (`user_id`, `nombre`, `password`, `user_email`, `rol`) VALUES
42(1, '_Zume', 'Love', 'adler32mail@gmail.com', 1);
43
44-- --------------------------------------------------------
45
46--
47-- Estructura de tabla para la tabla `servers`
48--
49
50CREATE TABLE IF NOT EXISTS `servers` (
51`server_id` int(11) NOT NULL,
52  `propietario` int(11) NOT NULL,
53  `slots` int(11) NOT NULL,
54  `puerto` int(5) NOT NULL,
55  `hostname` varchar(35) NOT NULL DEFAULT 'Bienvenido al hosting!'
56) ENGINE=InnoDB DEFAULT CHARSET=latin1;
57
58--
59-- Índices para tablas volcadas
60--
61
62--
63-- Indices de la tabla `clientes`
64--
65ALTER TABLE `clientes`
66 ADD PRIMARY KEY (`user_id`), ADD UNIQUE KEY `user_email` (`user_email`);
67
68--
69-- Indices de la tabla `servers`
70--
71ALTER TABLE `servers`
72 ADD PRIMARY KEY (`server_id`), ADD UNIQUE KEY `puerto` (`puerto`);
73
74--
75-- AUTO_INCREMENT de las tablas volcadas
76--
77
78--
79-- AUTO_INCREMENT de la tabla `clientes`
80--
81ALTER TABLE `clientes`
82MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
83--
84-- AUTO_INCREMENT de la tabla `servers`
85--
86ALTER TABLE `servers`
87MODIFY `server_id` int(11) NOT NULL AUTO_INCREMENT;
88/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
89/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
90/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;