PHP Code:
CREATE TABLE `torrents` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`info_hash` varchar(255) 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,
`descr_parsed` text NOT NULL,
`ori_descr` 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',
`numratings` int(10) unsigned NOT NULL default '0',
`ratingsum` int(10) unsigned NOT NULL default '0',
`nfo` text NOT NULL,
`completed_by` varchar(255) NOT NULL default '',
`forcevisible` enum('yes','no') NOT NULL default 'no',
`inverted_timestamp` int(10) unsigned NOT NULL default '0',
`description` varchar(120) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `info_hash` (`info_hash`),
KEY `owner` (`owner`),
KEY `visible` (`visible`),
KEY `category_visible` (`category`,`visible`),
KEY `seeders_lastaction` (`seeders`,`last_action`),
KEY `seeders_lastaction_added` (`seeders`,`last_action`,`added`),
KEY `visible_2` (`visible`,`inverted_timestamp`),
KEY `userdetails_torrents` (`owner`,`name`),
KEY `inverted_timestamp` (`inverted_timestamp`),
KEY `mytorrents` (`owner`,`banned`),
FULLTEXT KEY `ft_search` (`search_text`,`ori_descr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `torrents`
--