Code:
CREATE TABLE `torrents` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`info_hash` varchar(40) DEFAULT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`filename` varchar(255) NOT NULL DEFAULT '',
`save_as` varchar(255) NOT NULL DEFAULT '',
`descr` text NOT NULL,
`image1` text NOT NULL,
`image2` text NOT NULL,
`category` int(10) unsigned NOT NULL DEFAULT 0,
`size` bigint(20) unsigned NOT NULL DEFAULT 0,
`added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`type` enum('single','multi') NOT NULL DEFAULT 'single',
`numfiles` int(10) unsigned NOT NULL DEFAULT 0,
`comments` int(10) unsigned NOT NULL DEFAULT 0,
`views` int(10) unsigned NOT NULL DEFAULT 0,
`hits` int(10) unsigned NOT NULL DEFAULT 0,
`times_completed` int(10) unsigned NOT NULL DEFAULT 0,
`leechers` int(10) unsigned NOT NULL DEFAULT 0,
`seeders` int(10) unsigned NOT NULL DEFAULT 0,
`last_action` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`visible` enum('yes','no') NOT NULL DEFAULT 'yes',
`banned` enum('yes','no') NOT NULL DEFAULT 'no',
`owner` int(10) unsigned NOT NULL DEFAULT 0,
`anon` enum('yes','no') NOT NULL DEFAULT 'no',
`numratings` int(10) unsigned NOT NULL DEFAULT 0,
`ratingsum` int(10) unsigned NOT NULL DEFAULT 0,
`nfo` enum('yes','no') NOT NULL DEFAULT 'no',
`announce` varchar(255) NOT NULL DEFAULT '',
`external` enum('yes','no') NOT NULL DEFAULT 'no',
`torrentlang` int(10) unsigned NOT NULL DEFAULT 1,
`freeleech` enum('0','1') NOT NULL DEFAULT '0',
`url` varchar(80) CHARACTER SET utf8 DEFAULT NULL,
`tube` varchar(100) DEFAULT NULL,
`sticky` enum('yes','no') DEFAULT 'no',
`thanks` longtext DEFAULT NULL,
`webseed` enum('0','1') NOT NULL DEFAULT '0',
`recommended` enum('yes','no') NOT NULL DEFAULT 'no',
`torrentgenres` int(10) unsigned NOT NULL DEFAULT 100,
PRIMARY KEY (`id`),
UNIQUE KEY `info_hash` (`info_hash`(20)),
KEY `owner` (`owner`),
KEY `visible` (`visible`),
KEY `category_visible` (`category`,`visible`),
FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=717 DEFAULT CHARSET=latin1