PHP Code:
CREATE TABLE IF NOT EXISTS `torrents` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`info_hash` char(20) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`filename` varchar(255) NOT NULL DEFAULT '',
`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',
`numfiles` int(10) unsigned NOT NULL DEFAULT '0',
`comments` 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',
`free` enum('yes','no') DEFAULT 'no',
`anonymous` enum('yes','no') NOT NULL DEFAULT 'no',
`sticky` enum('yes','no') NOT NULL DEFAULT 'no',
`offensive` enum('yes','no') NOT NULL DEFAULT 'no',
`silver` enum('yes','no') NOT NULL DEFAULT 'no',
`t_image` varchar(255) NOT NULL DEFAULT '',
`t_link` text NOT NULL,
`isnuked` enum('yes','no') NOT NULL DEFAULT 'no',
`WhyNuked` varchar(255) NOT NULL DEFAULT 'Bad quality!',
`isrequest` enum('yes','no') NOT NULL DEFAULT 'no',
`ts_external` enum('yes','no') NOT NULL DEFAULT 'no',
`ts_external_url` varchar(128) NOT NULL DEFAULT '',
`ts_external_lastupdate` int(10) unsigned NOT NULL DEFAULT '0',
`allowcomments` enum('yes','no') NOT NULL DEFAULT 'yes',
`doubleupload` enum('yes','no') NOT NULL DEFAULT 'no',
`isScene` int(11) unsigned NOT NULL DEFAULT '0',
`moderated` enum('yes','error','no') NOT NULL DEFAULT 'no',
`moderator` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`error` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`genre` varchar(40) NOT NULL,
`Torrent név Eng` varchar(80) default NULL,
PRIMARY KEY (`id`),
KEY `info_hash` (`info_hash`),
KEY `category` (`category`),
KEY `times_completed` (`times_completed`,`leechers`,`seeders`),
KEY `visible` (`visible`,`banned`),
KEY `t_image` (`t_image`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2856 ;