ddshow |
3rd January 2011 17:23 |
upload torrent id error
1 Attachment(s)
I fixed the problem of uploading torrent id error
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` --
|