Вот запрос и здампа, я не пойму где здесь указываеться индекс
CREATE TABLE IF NOT EXISTS `fg5k_users` (
`id` int(3) NOT NULL AUTO_INCREMENT,
`name` varchar(70) NOT NULL,
`lastname` varchar(70) NOT NULL,
`nickname` varchar(40) NOT NULL,
`status` text NOT NULL,
`password` varchar(255) NOT NULL,
`email` varchar(100) NOT NULL,
`avatar` int(3) NOT NULL,
`rank_stady` int(3) NOT NULL DEFAULT '1',
`rank_balls` int(3) NOT NULL DEFAULT '0',
`hash` varchar(255) NOT NULL,
`pagename` varchar(80) NOT NULL,
`birthday` date NOT NULL,
`country` varchar(80) NOT NULL,
`city` varchar(80) NOT NULL,
`skype` varchar(80) NOT NULL,
`twitter` varchar(80) NOT NULL,
`facebook` varchar(80) NOT NULL,
`website` varchar(125) NOT NULL,
`edication` varchar(50) NOT NULL,
`school` varchar(255) NOT NULL,
`languages_for_programming` text NOT NULL,
`year_for_programming` year(4) NOT NULL,
`online` int(1) NOT NULL,
`lastvisit` varchar(250) NOT NULL,
`infovisited` text NOT NULL,
`friends` text NOT NULL,
`timezone` varchar(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`,`name`,`lastname`,`nickname`,`password`,`email`),
KEY `avatar` (`avatar`,`rank_stady`,`rank_balls`,`pagename`),
KEY `birthday` (`birthday`,`country`,`city`,`skype`,`twitter`,`facebook`,`website`,`edication`,`school`),
KEY `year_for_programming` (`year_for_programming`,`online`,`lastvisit`),
KEY `id_2` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;