CREATE TABLE `torrents` (
`id` int(10) unsigned NOT NULL auto_increment,
`info_hash` varbinary(40) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`filename` varchar(255) NOT NULL default '',
`save_as` varchar(255) NOT NULL default '',
`search_text` text NOT NULL,
`descr` text NOT NULL,
`ori_descr` text NOT NULL,
`image1` text NOT NULL,
`image2` text NOT NULL,
`image3` text NOT NULL,
`image4` text NOT NULL,
`image5` 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',
`last_reseed` 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',
`numratings` int(10) unsigned NOT NULL default '0',
`ratingsum` int(10) unsigned NOT NULL default '0',
`free` enum('yes','no') default 'no',
`sticky` enum('yes','no') NOT NULL default 'no',
`moderated` enum('yes','no') NOT NULL default 'no',
`moderatedby` int(10) unsigned default '0',
UNIQUE
KEY `info_hash`
(`info_hash`
), KEY `visible`
(`visible`
), KEY `category_visible`
(`category`
,`visible`
), FULLTEXT
KEY `ft_search`
(`search_text`
,`ori_descr`
)) ENGINE=MyISAM;