-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`real_name` varchar(100) NOT NULL DEFAULT 'Deutschland',
`password` text NOT NULL,
`mail` varchar(50) NOT NULL DEFAULT 'defaultuser@meth0d.org',
`auth_ticket` text NOT NULL,
`rank` int(11) unsigned NOT NULL DEFAULT '2',
`credits` int(11) NOT NULL DEFAULT '2500',
`vip_points` int(11) NOT NULL DEFAULT '0',
`activity_points` int(11) NOT NULL DEFAULT '2000',
`activity_points_lastupdate` double NOT NULL DEFAULT '0',
`look` varchar(255) NOT NULL DEFAULT 'ca-3175-62.ha-1006-82.hd-200-4.lg-275-82.sh-3252-62-62.cc-887-62.ch-215-63.hr-831-32',
`gender` varchar(50) NOT NULL DEFAULT 'M',
`motto` varchar(50) NOT NULL,
`account_created` varchar(50) NOT NULL,
`last_online` varchar(50) 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 '655',
`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 DEFAULT '1',
`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',
`badge_status` varchar(50) DEFAULT NULL,
`postcount` varchar(100) DEFAULT NULL,
`volume` int(3) NOT NULL DEFAULT '100',
`accept_trading` enum('0','1') NOT NULL DEFAULT '1',
PRIMARY KEY (`id`,`home_room`)
) ENGINE=MyISAM AUTO_INCREMENT=2209 DEFAULT CHARSET=latin1;