CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` char(50) NOT NULL,
`real_name` char(100) NOT NULL DEFAULT '',
`password` char(42) NOT NULL,
`mail` varchar(50) NOT NULL DEFAULT 'defaultuser@meth0d.org',
`auth_ticket` varchar(60) NOT NULL,
`rank` int(1) unsigned NOT NULL DEFAULT '1',
`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(5,0) NOT NULL DEFAULT '0',
`look` char(100) NOT NULL DEFAULT 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62',
`gender` enum('M','F') NOT NULL DEFAULT 'M',
`motto` char(50) NOT NULL,
`account_created` char(12) NOT NULL,
`last_online` varchar(20) NOT NULL,
`online` enum('0','1') NOT NULL DEFAULT '0',
`ip_last` char(20) NOT NULL,
`ip_reg` char(20) NOT NULL,
`home_room` int(10) unsigned NOT NULL DEFAULT '0',
`respect` int(11) NOT NULL DEFAULT '0',
`daily_respect_points` int(1) NOT NULL DEFAULT '3',
`daily_pet_respect_points` int(1) NOT NULL DEFAULT '3',
`newbie_status` int(1) NOT NULL DEFAULT '3',
`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',
`lastdailycredits` char(18) NOT NULL DEFAULT '',
`points` int(11) NOT NULL DEFAULT '0',
`block_trade` enum('1','0') NOT NULL DEFAULT '0',
`crystals` int(11) NOT NULL DEFAULT '0',
`currentquestid` int(11) unsigned NOT NULL,
`currentquestprogress` int(11) NOT NULL,
`achievement_points` int(11) NOT NULL,
`working` varchar(50) NOT NULL DEFAULT '0',
`secretcode` varchar(8) NOT NULL DEFAULT '0',
`mymusik` varchar(100) NOT NULL DEFAULT '0',
`getmoney_date` varchar(20) NOT NULL DEFAULT '0',
`visibility` enum('EVERYONE','FRIENDS','NOBODY') NOT NULL DEFAULT 'EVERYONE',
`birth` varchar(10) NOT NULL DEFAULT '0',
`volume` int(3) NOT NULL DEFAULT '100',
`dolares` int(11) NOT NULL DEFAULT '100',
`accept_trading` enum('0','1') NOT NULL DEFAULT '1',
`refers_count` int(11) NOT NULL,
`one_password` varchar(500) NOT NULL DEFAULT '0',
`datosreg` varchar(500) NOT NULL DEFAULT '0',
`country` varchar(500) NOT NULL DEFAULT '0',
`vip` enum('0','1') NOT NULL DEFAULT '0',
`postcount` bigint(20) NOT NULL DEFAULT '0',
`hide_online` enum('0','1') NOT NULL DEFAULT '0',
`hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`username`),
UNIQUE KEY `id` (`id`) USING HASH,
UNIQUE KEY `username` (`username`) USING BTREE,
KEY `ip_last` (`ip_last`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;