| | #
# Structure for the `users` table :
#
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(40) NOT NULL default '',
`old_password` varchar(40) NOT NULL default '',
`passhash` varchar(32) NOT NULL default '',
`secret` varchar(20) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`status` enum('pending','confirmed') NOT NULL default 'pending',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`last_login` datetime NOT NULL default '0000-00-00 00:00:00',
`last_access` datetime NOT NULL default '0000-00-00 00:00:00',
`editsecret` varchar(20) NOT NULL default '',
`privacy` enum('strong','normal','low') NOT NULL default 'normal',
`stylesheet` int(10) default '1',
`info` text,
`acceptpms` enum('yes','friends','no') NOT NULL default 'yes',
`ip` varchar(15) NOT NULL default '',
`class` tinyint(3) unsigned NOT NULL default '0',
`override_class` tinyint(3) unsigned NOT NULL default '255',
`support` enum('no','yes') NOT NULL default 'no',
`supportfor` text,
`avatar` varchar(100) NOT NULL default '',
`icq` varchar(255) NOT NULL default '',
`msn` varchar(255) NOT NULL default '',
`aim` varchar(255) NOT NULL default '',
`yahoo` varchar(255) NOT NULL default '',
`skype` varchar(255) NOT NULL default '',
`mirc` varchar(255) NOT NULL default '',
`website` varchar(50) NOT NULL default '',
`uploaded` bigint(20) unsigned NOT NULL default '0',
`downloaded` bigint(20) unsigned NOT NULL default '0',
`bonus` decimal(5,2) NOT NULL default '0.00',
`title` varchar(30) NOT NULL default '',
`country` int(10) unsigned NOT NULL default '0',
`notifs` varchar(100) NOT NULL default '',
`modcomment` text,
`enabled` enum('yes','no') NOT NULL default 'yes',
`parked` enum('yes','no') NOT NULL default 'no',
`avatars` enum('yes','no') NOT NULL default 'yes',
`donor` enum('yes','no') NOT NULL default 'no',
`simpaty` int(10) unsigned NOT NULL default '0',
`warned` enum('yes','no') NOT NULL default 'no',
`warneduntil` datetime NOT NULL default '0000-00-00 00:00:00',
`torrentsperpage` int(3) unsigned NOT NULL default '0',
`topicsperpage` int(3) unsigned NOT NULL default '0',
`postsperpage` int(3) unsigned NOT NULL default '0',
`deletepms` enum('yes','no') NOT NULL default 'yes',
`savepms` enum('yes','no') NOT NULL default 'no',
`gender` enum('1','2','3') NOT NULL default '1',
`birthday` date default '0000-00-00',
`passkey` varchar(32) NOT NULL default '',
`language` varchar(255) NOT NULL default 'russian',
`invites` int(10) NOT NULL default '0',
`invitedby` int(10) NOT NULL default '0',
`invitedroot` int(10) NOT NULL default '0',
`passkey_ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
KEY `status_added` (`status`,`added`),
KEY `ip` (`ip`),
KEY `uploaded` (`uploaded`),
KEY `downloaded` (`downloaded`),
KEY `country` (`country`),
KEY `last_access` (`last_access`),
KEY `enabled` (`enabled`),
KEY `warned` (`warned`),
KEY `user` (`id`,`status`,`enabled`)
) ENGINE=MyISAM;
Запрос долго искать (готовый трекер) | |
