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(164) NOT NULL,
`mail` varchar(50) NOT NULL DEFAULT 'defaultuser@meth0d.org',
`auth_ticket` varchar(500) NOT NULL,
`rank` int(11) unsigned NOT NULL DEFAULT '1',
`credits` int(50) NOT NULL DEFAULT '50000',
`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` varchar(250) NOT NULL,
`gender` enum('M','F') NOT NULL DEFAULT 'M',
`motto` varchar(50) NOT NULL,
`last_online` int(11) NOT NULL DEFAULT '0',
`account_created` varchar(255) NOT NULL,
`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,
`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,
`postcount` bigint(20) NOT NULL DEFAULT '0',
`token` varchar(20) NOT NULL DEFAULT '',
`client_token` varchar(50) NOT NULL DEFAULT '',
`newsletter` enum('0','1') NOT NULL DEFAULT '1',
`predermited` enum('Yes','No') NOT NULL DEFAULT 'Yes',
`account_creates` int(20) NOT NULL DEFAULT '0',
`suspend` enum('0','1') NOT NULL DEFAULT '0',
`referid` int(120) NOT NULL DEFAULT '0',
`RememberMeToken` text NOT NULL,
`AddonData` text NOT NULL,
`homeBg` varchar(120) NOT NULL DEFAULT 'b_bg_pattern_abstra ct2',
`visibility` enum('NOBODY','EVERYONE') NOT NULL DEFAULT 'EVERYONE',
`AccountID` text NOT NULL,
`AccountIdentifier` text NOT NULL,
`AccountName` varchar(255) NOT NULL DEFAULT '',
`AccountUserName` varchar(255) NOT NULL DEFAULT '',
`AccountPhoto` text NOT NULL,
`lastdailycredits` char(18) NOT NULL DEFAULT '',
`achievement_points` int(12) NOT NULL DEFAULT '0',
`quests` varchar(200) NOT NULL DEFAULT '',
`queststates` varchar(200) NOT NULL DEFAULT '',
`canchangename` enum('0','1') NOT NULL DEFAULT '1',
`passed_quiz` enum('0','1') NOT NULL DEFAULT '0',
`FavoriteGroup` int(12) NOT NULL DEFAULT '0',
`points_online` int(12) NOT NULL DEFAULT '0',
`ReceptionPased` enum('0','1') NOT NULL DEFAULT '0',
`namechanges` int(3) NOT NULL DEFAULT '0',
`currentquestid` int(11) NOT NULL DEFAULT '0',
`currentquestprogress` int(11) NOT NULL DEFAULT '0',
`vinculId` int(255) NOT NULL DEFAULT '0',
`securityTokens` varchar(255) NOT NULL DEFAULT '',
`working` varchar(50) NOT NULL DEFAULT 'Ninguna',
`secretcode` varchar(8) NOT NULL DEFAULT '0',
`mymusik` varchar(100) NOT NULL DEFAULT '0',
`getmoney_date` varchar(20) NOT NULL DEFAULT '0',
`volume` varchar(12) NOT NULL DEFAULT '100,100,100',
`dolares` int(11) NOT NULL DEFAULT '0',
`powers` int(11) NOT NULL DEFAULT '0',
`codice` text NOT NULL,
`client_volume` varchar(255) 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 DEFAULT '0',
`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',
`seckey` varchar(999) DEFAULT NULL,
`belcredits` int(11) NOT NULL,
`login` varchar(80) NOT NULL,
`elapsedtime` varchar(20) NOT NULL,
`block_trade` enum('0','1') NOT NULL DEFAULT '0',
`staffpicks` int(11) NOT NULL,
`equipo` enum('0','1') NOT NULL DEFAULT '1' COMMENT 'Diurno = 1, Nocturno = 0',
`rangoguia` int(11) NOT NULL DEFAULT '0',
`tarea` varchar(255) NOT NULL,
`visible` enum('0','1') NOT NULL DEFAULT '1',
`loyalty_points` int(11) NOT NULL DEFAULT '0',
`mysterybox_key_colour` int(11) NOT NULL DEFAULT '0',
`last_name_change` int(11) NOT NULL DEFAULT '0',
`talent_status` enum('citizenship','helper') NOT NULL DEFAULT 'citizenship',
`trade_lock` enum('0','1') CHARACTER SET utf8 NOT NULL DEFAULT '0',
`trade_lock_expire` int(11) NOT NULL DEFAULT '0',
`vip_expire` timestamp NOT NULL DEFAULT '2014-05-13 23:59:36' ON UPDATE CURRENT_TIMESTAMP,
`seasonal_currency` int(11) NOT NULL DEFAULT '0',
`rares` int(15) NOT NULL,
`nux_passed` enum('0','1') NOT NULL DEFAULT '0',
`ltd` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
KEY `auth_ticket` (`auth_ticket`),
KEY `online` (`online`),
KEY `rank` (`rank`),
KEY `ip_last` (`ip_last`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6732 ;
Alexs2F • 15.06.15 19:59
Error na Hora de Registar 15.06.15 19:59
lin0s • 16.06.15 17:15
