· 8 years ago · Jun 19, 2018, 07:08 PM
1CREATE TABLE IF NOT EXISTS `torrents` (
2 `TorrentID` int(10) NOT NULL AUTO_INCREMENT,
3 `TorrentDate` int(10) NOT NULL,
4 `TorrentPubDate` int(10) NOT NULL,
5 `TorrentURI` varchar(255) CHARACTER SET latin1 NOT NULL,
6 `TorrentTitle` varchar(255) CHARACTER SET latin1 NOT NULL,
7 `TorrentSize` varchar(20) CHARACTER SET latin1 NOT NULL,
8 `TorrentCategory` varchar(255) CHARACTER SET latin1 NOT NULL,
9 `RSSKey` int(4) NOT NULL,
10 PRIMARY KEY (`TorrentID`),
11 KEY `TorrentTitle` (`TorrentTitle`),
12 KEY `RSSKey` (`RSSKey`)
13) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=85612 ;