я думаю сделать так:
CREATE TABLE `files` (
`id` int(11) unsigned NOT NULL auto_increment,
`dir` enum('0','1') NOT NULL default '0',
`dir_count` int(11) unsigned NOT NULL default '0',
`path` varchar(255) NOT NULL,
`infolder` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`rus_name` varchar(255) NOT NULL,
`priority` tinyint(3) NOT NULL default '0',
`loads` int(11) unsigned NOT NULL default '0',
`timeupload` int(11) unsigned NOT NULL,
`about` text NOT NULL,
`screen` text NOT NULL,
`descr` text NOT NULL,
`genre` varchar(32) NOT NULL,
`ips` text NOT NULL,
`yes` mediumint(4) unsigned NOT NULL default '0',
`no` mediumint(4) unsigned NOT NULL default '0',
`hidden` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `path` (`path`),
KEY `loads` (`loads`),
KEY `yes` (`yes`),
KEY `infolder` (`infolder`),
KEY `infolder_timeupload` (`infolder`,`timeupload`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Changed: Spwak (15.08.2010 / 13:02)