-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 29-05-2012 a las 18:00:03
-- Versión del servidor: 5.5.8
-- Versión de PHP: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `novadb`
--

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

--
-- Estructura de tabla para la tabla `sys_config`
--

CREATE TABLE IF NOT EXISTS `sys_config` (
  `variable` varchar(50) NOT NULL,
  `value` varchar(255) NOT NULL,
  UNIQUE KEY `variable` (`variable`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcar la base de datos para la tabla `sys_config`
--

INSERT INTO `sys_config` (`variable`, `value`) VALUES
('emu_max_user', '500'),
('emu_register_open', 'true');

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

--
-- Estructura de tabla para la tabla `sys_friendship`
--

CREATE TABLE IF NOT EXISTS `sys_friendship` (
  `user_one_id` int(11) NOT NULL,
  `user_two_id` int(11) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '0',
  KEY `user_one_id` (`user_one_id`),
  KEY `user_two_id` (`user_two_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcar la base de datos para la tabla `sys_friendship`
--


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

--
-- Estructura de tabla para la tabla `sys_fuses`
--

CREATE TABLE IF NOT EXISTS `sys_fuses` (
  `fuse_min_rank_id` int(11) NOT NULL,
  `fuse_handler` varchar(100) NOT NULL,
  UNIQUE KEY `fuse_handler` (`fuse_handler`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcar la base de datos para la tabla `sys_fuses`
--

INSERT INTO `sys_fuses` (`fuse_min_rank_id`, `fuse_handler`) VALUES
(1, 'default'),
(1, 'fuse_buy_credits'),
(1, 'fuse_extended_buddylist'),
(1, 'fuse_login'),
(1, 'fuse_nuevo'),
(1, 'fuse_priority_access'),
(1, 'fuse_room_queue_default'),
(1, 'fuse_trade'),
(1, 'fuse_use_special_room_layouts'),
(1, 'pockethabbo_content_download_allowed'),
(1, 'pockethabbo_messenger_allowed');

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

--
-- Estructura de tabla para la tabla `sys_ranks`
--

CREATE TABLE IF NOT EXISTS `sys_ranks` (
  `rank_id` int(11) NOT NULL,
  `rank_name` varchar(50) NOT NULL,
  UNIQUE KEY `rank_id` (`rank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcar la base de datos para la tabla `sys_ranks`
--

INSERT INTO `sys_ranks` (`rank_id`, `rank_name`) VALUES
(1, 'habbo'),
(2, 'manager'),
(3, 'staff');

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

--
-- Estructura de tabla para la tabla `sys_users`
--

CREATE TABLE IF NOT EXISTS `sys_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(15) NOT NULL,
  `app` varchar(25) NOT NULL DEFAULT '1000118001270012900121001',
  `gender` enum('M','F') NOT NULL DEFAULT 'M',
  `email` varchar(46) NOT NULL DEFAULT 'habbo@mail.com',
  `birth` varchar(10) NOT NULL DEFAULT '00.00.0000',
  `receive_emails` tinyint(1) NOT NULL DEFAULT '0',
  `password` varchar(32) NOT NULL,
  `sso` varchar(36) NOT NULL,
  `rank` int(11) NOT NULL DEFAULT '1',
  `last_ip` text NOT NULL,
  `last_online` varchar(16) NOT NULL DEFAULT '00-00-0000 00:00',
  `figure` varchar(15) NOT NULL DEFAULT 'ch=s02/53,51,44',
  `films` bigint(20) NOT NULL DEFAULT '500',
  `credits` int(11) NOT NULL DEFAULT '500',
  `console_motto` varchar(25) NOT NULL DEFAULT 'Java power is real!',
  `motto` varchar(30) NOT NULL DEFAULT 'Nova socket manager',
  `tickets` bigint(20) NOT NULL DEFAULT '500',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

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

--
-- Estructura de tabla para la tabla `sys_vounchers`
--

CREATE TABLE IF NOT EXISTS `sys_vounchers` (
  `code` varchar(9) NOT NULL,
  `amount` int(11) NOT NULL,
  `type` enum('credits','tickets') NOT NULL,
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcar la base de datos para la tabla `sys_vounchers`
--

