zBG84mcc

1-- ----------------------------
2-- Table structure for `users`
3-- ----------------------------
4DROP TABLE IF EXISTS `users`;
5CREATE TABLE `users` (
6  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
7  `username` varchar(50) NOT NULL,
8  `real_name` varchar(100) NOT NULL DEFAULT '',
9  `password` varchar(50) NOT NULL,
10  `mail` varchar(50) NOT NULL DEFAULT 'defaultuser@meth0d.org',
11  `auth_ticket` text NOT NULL,
12  `rank` int(11) unsigned NOT NULL DEFAULT '1',
13  `credits` int(11) NOT NULL DEFAULT '50000',
14  `vip_points` int(11) NOT NULL DEFAULT '0',
15  `activity_points` int(11) NOT NULL DEFAULT '0',
16  `activity_points_lastupdate` double NOT NULL DEFAULT '0',
17  `look` varchar(255) NOT NULL DEFAULT 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62',
18  `gender` enum('M','F') NOT NULL DEFAULT 'M',
19  `motto` varchar(50) NOT NULL DEFAULT 'I''m new here at Hablock',
20  `account_created` varchar(50) NOT NULL,
21  `last_online` varchar(50) NOT NULL,
22  `online` enum('0','1') NOT NULL DEFAULT '0',
23  `ip_last` varchar(120) NOT NULL,
24  `ip_reg` varchar(120) NOT NULL,
25  `home_room` int(10) unsigned NOT NULL DEFAULT '0',
26  `respect` int(11) NOT NULL DEFAULT '0',
27  `daily_respect_points` int(11) NOT NULL DEFAULT '3',
28  `daily_pet_respect_points` int(11) NOT NULL DEFAULT '3',
29  `newbie_status` int(11) NOT NULL DEFAULT '0',
30  `is_muted` enum('0','1') NOT NULL DEFAULT '0',
31  `mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0',
32  `mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
33  `block_newfriends` enum('0','1') NOT NULL DEFAULT '0',
34  `hide_online` enum('0','1') NOT NULL DEFAULT '0',
35  `hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
36  `mail_verified` varchar(6) NOT NULL DEFAULT '0',
37  `vip` enum('0','1') NOT NULL DEFAULT '1',
38  `expert` varchar(50) NOT NULL,
39  `forumname` varchar(50) NOT NULL,
40  PRIMARY KEY (`id`)
41) ENGINE=MyISAM AUTO_INCREMENT=197 DEFAULT CHARSET=latin1;