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,
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=3 ;