PHP Code:
CREATE TABLE `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', `recomandat` enum('Igen','Nem') NOT NULL default 'Nem', `sub` enum('Igen','Nem') NOT NULL default 'Nem', `seedbox` enum('Igen','Nem') NOT NULL default 'Nem', `trteam` enum('Igen','Nem') NOT NULL default 'Nem', `tube` text NOT NULL, `genre` varchar(40) NOT NULL, `nfo` varchar(255) NOT NULL, `ellenorizve` enum('yes','error','nincs') NOT NULL default 'nincs', `ellenorizte` varchar(40) character set latin1 collate latin1_general_ci NOT NULL, `elcomment` varchar(40) character set latin1 collate latin1_general_ci NOT NULL, `sebesseg` varchar(80) character set utf8 NOT NULL, `ido` varchar(80) character set utf8 NOT NULL, `port` varchar(80) NOT 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=8 ;
Bump: My torrent sql table
PHP Code:
CREATE TABLE `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', `recomandat` enum('Igen','Nem') NOT NULL default 'Nem', `sub` enum('Igen','Nem') NOT NULL default 'Nem', `seedbox` enum('Igen','Nem') NOT NULL default 'Nem', `trteam` enum('Igen','Nem') NOT NULL default 'Nem', `tube` text NOT NULL, `genre` varchar(40) NOT NULL, `nfo` varchar(255) NOT NULL, `ellenorizve` enum('yes','error','nincs') NOT NULL default 'nincs', `ellenorizte` varchar(40) character set latin1 collate latin1_general_ci NOT NULL, `elcomment` varchar(40) character set latin1 collate latin1_general_ci NOT NULL, `sebesseg` varchar(80) character set utf8 NOT NULL, `ido` varchar(80) character set utf8 NOT NULL, `port` varchar(80) NOT 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=8 ;
Bump: My torrent sql table
PHP Code:
CREATE TABLE `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', `recomandat` enum('Igen','Nem') NOT NULL default 'Nem', `sub` enum('Igen','Nem') NOT NULL default 'Nem', `seedbox` enum('Igen','Nem') NOT NULL default 'Nem', `trteam` enum('Igen','Nem') NOT NULL default 'Nem', `tube` text NOT NULL, `genre` varchar(40) NOT NULL, `nfo` varchar(255) NOT NULL, `ellenorizve` enum('yes','error','nincs') NOT NULL default 'nincs', `ellenorizte` varchar(40) character set latin1 collate latin1_general_ci NOT NULL, `elcomment` varchar(40) character set latin1 collate latin1_general_ci NOT NULL, `sebesseg` varchar(80) character set utf8 NOT NULL, `ido` varchar(80) character set utf8 NOT NULL, `port` varchar(80) NOT 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=8 ;
__________________
Sky-Tech Developer Team Hungary
|