Mercury Emulador 2.3

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( 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 21: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',
  `staff_twitter` varchar(50) DEFAULT NULL,
  `staff_facebook` varchar(50) DEFAULT NULL,
  `forgot_ticket` varchar(50) DEFAULT NULL,
  `facebook_id` varchar(50) DEFAULT NULL,
  `pin` varchar(50) DEFAULT NULL,
  `facebook_change` varchar(50) DEFAULT NULL,
  `facebook` varchar(50) DEFAULT NULL,
  `staff_background_url` text,
  `staff_ocult` varchar(50) DEFAULT '0',
  `role` varchar(50) DEFAULT NULL,
  `country_cf` varchar(50) DEFAULT 'ec',
  `last_used` varchar(50) DEFAULT '0',
  `refer_count` varchar(50) DEFAULT '0',
  `staff_profileimage_url` varchar(150) 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=6754 ;