mysql> SHOW CREATE TABLE bts_torrents;
+--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table        | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
+--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| bts_torrents | CREATE TABLE `bts_torrents` (
  `torrentid` int(10) unsigned NOT NULL auto_increment,
  `fid` int(4) default NULL,
  `name` text NOT NULL,
  `filename` varchar(255) NOT NULL default '',
  `announce` text NOT NULL,
  `catid` int(11) NOT NULL default '0',
  `subcat` int(10) unsigned NOT NULL default '0',
  `files` text NOT NULL,
  `info` text NOT NULL,
  `filesize` float NOT NULL default '0',
  `info_hash` blob NOT NULL,
  `info_hash2` text NOT NULL,
  `description` text NOT NULL,
  `submitter` text NOT NULL,
  `ip` varchar(15) NOT NULL default '',
  `submit_date` varchar(255) NOT NULL default '00',
  `moderator` int(11) NOT NULL default '0',
  `viewed` int(11) NOT NULL default '0',
  `downloaded` int(11) NOT NULL default '0',
  `votes` int(11) NOT NULL default '0',
  `score` int(11) NOT NULL default '0',
  `hidden` char(1) NOT NULL default '0',
  `dead` char(1) NOT NULL default '0',
  `dtime` varchar(255) default NULL,
  PRIMARY KEY  (`torrentid`)
) ENGINE=MyISAM AUTO_INCREMENT=37952 DEFAULT CHARSET=latin1 |
+--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)