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
|