-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tempo de Geração: Set 06, 2014 as 10:16
-- Versão do Servidor: 5.1.41
-- Versão do PHP: 5.3.1
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 */;
--
-- Banco de Dados: `close`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `users`
--
CREATE table IF NOT EXISTS `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`real_name` varchar(100) NOT NULL DEFAULT '',
`password` varchar(500) NOT NULL,
`mail` varchar(250) NOT NULL DEFAULT 'defaultuser@meth0d.org',
`auth_ticket` varchar(500) DEFAULT NULL,
`rank` int(11) unsigned NOT NULL DEFAULT '1',
`credits` int(11) NOT NULL DEFAULT '50000',
`seasonal_credits` int(11) NOT NULL DEFAULT '0',
`vip_points` int(11) NOT NULL DEFAULT '0',
`activity_points` int(11) NOT NULL DEFAULT '0',
`activity_points_lastupdate` double NOT NULL DEFAULT '0',
`look` text NOT NULL,
`gender` enum('M','F') NOT NULL DEFAULT 'M',
`motto` varchar(50) NOT NULL,
`last_online` int(250) NOT NULL,
`account_created` double NOT NULL DEFAULT '0',
`online` enum('0','1') NOT NULL DEFAULT '0',
`ip_last` varchar(120) NOT NULL,
`ip_reg` varchar(120) NOT NULL,
`home_room` int(10) unsigned NOT NULL DEFAULT '0',
`respect` int(11) NOT NULL DEFAULT '0',
`daily_respect_points` int(11) NOT NULL DEFAULT '3',
`daily_pet_respect_points` int(11) NOT NULL DEFAULT '3',
`newbie_status` int(11) NOT NULL DEFAULT '0',
`is_muted` enum('0','1') NOT NULL DEFAULT '0',
`mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0',
`mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
`block_newfriends` enum('0','1') NOT NULL DEFAULT '0',
`hide_online` enum('0','1') NOT NULL DEFAULT '0',
`hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
`mail_verified` varchar(6) NOT NULL DEFAULT '0',
`vip` enum('0','1') NOT NULL DEFAULT '0',
`client_volume` int(11) NOT NULL DEFAULT '100',
`volume` varchar(12) NOT NULL DEFAULT '100,100,100',
`last_login` int(11) NOT NULL DEFAULT '0',
`accept_trading` enum('0','1') NOT NULL DEFAULT '1',
`whisper_enabled` enum('0','1') NOT NULL DEFAULT '1',
`is_guide` enum('0','1') NOT NULL DEFAULT '1',
`last_change` int(20) NOT NULL DEFAULT '0',
`key_colour` int(11) NOT NULL DEFAULT '0',
`position` varchar(30) NOT NULL,
`acc_pornbanned` enum('0','1') NOT NULL DEFAULT '0',
`acc_flagged` enum('0','1') NOT NULL DEFAULT '0',
`points` int(11) NOT NULL DEFAULT '0',
`staff_pin` int(4) NOT NULL DEFAULT '1234',
`failed_pins` int(4) NOT NULL DEFAULT '0',
`belcredits` int(11) NOT NULL DEFAULT '0',
`working` varchar(50) NOT NULL DEFAULT '0',
`secretcode` varchar(50) NOT NULL DEFAULT '0',
`mymusik` varchar(50) NOT NULL DEFAULT '0',
`securityTokens` varchar(255) NOT NULL DEFAULT '',
`account_creates` int(20) NOT NULL DEFAULT '0',
`quests` varchar(200) NOT NULL DEFAULT '',
`vinculId` int(255) NOT NULL DEFAULT '0',
`visibility` enum('NOBODY','EVERYONE') NOT NULL DEFAULT 'EVERYONE',
`birth` varchar(100) NOT NULL DEFAULT '',
`browser` text NOT NULL,
`web_online` varchar(100) NOT NULL DEFAULT '',
`rpx_name` varchar(100) NOT NULL DEFAULT '',
`rpxid` varchar(200) NOT NULL,
`rpx_type` varchar(100) NOT NULL,
`seckey` varchar(999) DEFAULT NULL,
`last_account_used` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
KEY `auth_ticket` (`auth_ticket`),
KEY `online` (`online`),
KEY `rank` (`rank`),
KEY `ip_last` (`ip_last`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Extraindo dados da tabela `users`
--
/*!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 */;