-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Máquina: localhost
-- Data de Criação: 29-Mai-2015 às 16:43
-- 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 */;
--
-- Base de Dados: `master`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `users`
--
CREATE tab
le IF NOT EXISTS `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) CHARACTER SET latin1 NOT NULL,
`real_name` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
`password` varchar(50) NOT NULL DEFAULT '',
`auth_ticket` varchar(240) CHARACTER SET latin1 NOT NULL DEFAULT '',
`rank` int(11) unsigned NOT NULL DEFAULT '1',
`vip_points` int(11) NOT NULL DEFAULT '0',
`credits` int(11) NOT NULL DEFAULT '50000',
`activity_points` int(11) NOT NULL DEFAULT '0',
`activity_points_lastupdate` double NOT NULL DEFAULT '0',
`seasonal_currency` int(11) NOT NULL DEFAULT '0',
`loyalty_points` int(11) NOT NULL DEFAULT '0',
`look` varchar(160) CHARACTER SET latin1 NOT NULL DEFAULT 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62',
`gender` enum('M','F') CHARACTER SET latin1 NOT NULL DEFAULT 'M',
`motto` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
`mail` varchar(255) NOT NULL DEFAULT 'undefined',
`account_created` double(50,0) NOT NULL DEFAULT '0',
`last_online` int(11) NOT NULL DEFAULT '0',
`online` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`ip_last` varchar(120) CHARACTER SET latin1 NOT NULL DEFAULT '',
`ip_reg` varchar(120) CHARACTER SET latin1 NOT NULL DEFAULT '',
`home_room` int(10) unsigned NOT NULL DEFAULT '0',
`newbie_status` int(11) NOT NULL DEFAULT '0',
`is_muted` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`mutant_penalty` enum('0','1','2') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
`trade_lock` enum('0','1') NOT NULL DEFAULT '0',
`trade_lock_expire` int(11) NOT NULL DEFAULT '0',
`block_newfriends` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`hide_online` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`hide_inroom` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`vip` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`vip_expire` timestamp NOT NULL DEFAULT '2014-05-13 18:59:36',
`birth` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
`talent_status` enum('citizenship','helper') NOT NULL DEFAULT 'citizenship',
`mysterybox_key_colour` int(11) NOT NULL DEFAULT '0',
`last_name_change` int(11) NOT NULL DEFAULT '0',
`client_volume` varchar(255) NOT NULL DEFAULT '100,100,100',
`nux_passed` enum('0','1') NOT NULL DEFAULT '0',
`seckey` varchar(999) NOT NULL DEFAULT '',
`voted` int(11) NOT NULL DEFAULT '0',
`owner` int(99) NOT NULL DEFAULT '0',
`novato` int(99) NOT NULL DEFAULT '0',
`fundom` varchar(255) NOT NULL DEFAULT '
#43AC6A',
`builders_expire` int(11) DEFAULT '3700',
`builders_items_max` int(11) NOT NULL DEFAULT '100',
`builders_items_used` int(11) NOT NULL DEFAULT '0',
`release_version` int(11) NOT NULL DEFAULT '2',
`on_duty` enum('0','1','2','3') NOT NULL DEFAULT '0',
`OnDuty` varchar(255) NOT NULL DEFAULT 'false',
`navilogs` varchar(255) DEFAULT 'Hello',
`navigator` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
`respect` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 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 */;