umQiSrk8

1DROP TABLE IF EXISTS `users`;
2CREATE TABLE `users` (
3  `userid` int(11) unsigned NOT NULL auto_increment,
4  `login` varchar(255) NOT NULL,
5  `username` varchar(255) NOT NULL,
6  `password` varchar(255) NOT NULL,
7  `imageid` int(10) unsigned default NULL,
8  `langid` char(2) NOT NULL default 'en',
9  `active` tinyint(1) NOT NULL default '1',
10  `last_attempt` int(10) unsigned NOT NULL default '0',
11  `recent_attempts` tinyint(3) unsigned NOT NULL default '0',
12  `groupid` int(10) unsigned default NULL,
13  `join_date` int(10) unsigned default NULL,
14  `real_name` varchar(255) default NULL,
15  `about` text default '',
16  `reputation` int(10) default '0',
17  PRIMARY KEY  (`userid`),
18  UNIQUE KEY `login` (`login`),
19  KEY `username` (`username`),
20  KEY `active` (`active`)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8;