25VyKVDw

1CREATE TABLE IF NOT EXISTS `user` (
2  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3  `user_name` varbinary(255) NOT NULL DEFAULT '',
4  `user_real_name` varbinary(255) NOT NULL DEFAULT '',
5  `user_password` tinyblob NOT NULL,
6  `user_newpassword` tinyblob NOT NULL,
7  `user_newpass_time` binary(14) DEFAULT NULL,
8  `user_email` tinyblob NOT NULL,
9  `user_options` blob NOT NULL,
10  `user_touched` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
11  `user_token` binary(32) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
12  `user_email_authenticated` binary(14) DEFAULT NULL,
13  `user_email_token` binary(32) DEFAULT NULL,
14  `user_email_token_expires` binary(14) DEFAULT NULL,
15  `user_registration` binary(14) DEFAULT NULL,
16  `user_editcount` int(11) DEFAULT NULL,
17  PRIMARY KEY (`user_id`),
18  UNIQUE KEY `user_name` (`user_name`),
19  KEY `user_email_token` (`user_email_token`)
20) ENGINE=InnoDB  DEFAULT CHARSET=binary AUTO_INCREMENT=2158 ;