SunGlow-DB

-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 25-11-2012 a las 20:34:17
-- Versión del servidor: 5.5.27
-- Versión de PHP: 5.4.7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de datos: `sunglowdb`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `server_status`
--

CREATE TABLE IF NOT EXISTS `server_status` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `status` enum('0','1','2') NOT NULL DEFAULT '0',
  `users_online` INT(11) NOT NULL DEFAULT '0',
  `rooms_loaded` INT(11) NOT NULL DEFAULT '0',
  `server_ver` text NOT NULL,
  `stamp` DOUBLE NOT NULL,
  `minutesuptime` INT(11) NOT NULL,
  `userpeak` INT(11) NOT NULL DEFAULT '0',
  `bannerdata` VARCHAR(1000) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Volcado de datos para la tabla `server_status`
--

INSERT INTO `server_status` (`id`, `status`, `users_online`, `rooms_loaded`, `server_ver`, `stamp`, `minutesuptime`, `userpeak`, `bannerdata`) VALUES
(1, '0', 0, 0, 'Butterstorm Emulator r96', 1343756359, 53, 10001, '1464182135379351267453358448431176606237049043543757750791551:1369221309534549820136845458321324483021958400764361306161451');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` INT(250) NOT NULL,
  `username` VARCHAR(500) NOT NULL,
  `look` VARCHAR(500) NOT NULL,
  `realname` VARCHAR(500) NOT NULL,
  `password` VARCHAR(500) NOT NULL,
  `ssoTicket` VARCHAR(500) NOT NULL,
  `email` VARCHAR(500) NOT NULL,
  `coins` INT(250) NOT NULL DEFAULT '250000',
  `othercoins` INT(250) NOT NULL DEFAULT '250000',
  `mission` VARCHAR(500) NOT NULL,
  `Gender` enum('M','F') NOT NULL,
  `Habbo_Club` enum('0','1') NOT NULL,
  `Respects` INT(250) NOT NULL,
  `Max_Users_Respects` INT(250) NOT NULL DEFAULT '3',
  `Max_Pets_Respects` INT(250) NOT NULL DEFAULT '3',
  `rank` INT(250) NOT NULL,
  `ban_time` INT(250) NOT NULL,
  `Habbo_Club_Init` INT(250) NOT NULL,
  `Habbo_Club_Expire` INT(250) NOT NULL,
  `ban` enum('0','1') NOT NULL,
  `kuick` enum('0','1') NOT NULL,
  `last_ip` VARCHAR(500) NOT NULL,
  `registred_ip` VARCHAR(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `users`
--

INSERT INTO `users` (`id`, `username`, `look`, `realname`, `password`, `ssoTicket`, `email`, `coins`, `othercoins`, `mission`, `Gender`, `Habbo_Club`, `Respects`, `Max_Users_Respects`, `Max_Pets_Respects`, `rank`, `ban_time`, `Habbo_Club_Init`, `Habbo_Club_Expire`, `ban`, `kuick`, `last_ip`, `registred_ip`) VALUES
(1, 'forex', 'hr-115-1316.hd-209-1.ch-267-66.lg-270-66.sh-290-66.ea-1403-62.cc-260-66', 'Daniel', '', 'Forex-Test', 'forest_project@hotmail.es', 250000, 250000, 'The Best', 'M', '1', 0, 3, 3, 7, 0, 0, 0, '0', '0', '127.0.0.1', '127.0.0.1');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;