mysql> show create table `peers`;
+-------+----------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------+
| peers | CREATE TABLE `peers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`torrent` int(10) unsigned NOT NULL DEFAULT '0',
`peer_id` varchar(20) NOT NULL DEFAULT '',
`ip` varchar(64) NOT NULL DEFAULT '',
`port` smallint(5) unsigned NOT NULL DEFAULT '0',
`uploaded` bigint(20) unsigned NOT NULL DEFAULT '0',
`downloaded` bigint(20) unsigned NOT NULL DEFAULT '0',
`uploadoffset` bigint(20) unsigned NOT NULL DEFAULT '0',
`downloadoffset` bigint(20) unsigned NOT NULL DEFAULT '0',
`to_go` bigint(20) unsigned NOT NULL DEFAULT '0',
`seeder` enum('yes','no') NOT NULL DEFAULT 'no',
`started` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_action` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`prev_action` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`connectable` enum('yes','no') NOT NULL DEFAULT 'yes',
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`agent` varchar(60) NOT NULL DEFAULT '',
`finishedat` int(10) unsigned NOT NULL DEFAULT '0',
`passkey` varchar(32) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `torrent_peer_id` (`torrent`,`peer_id`),
KEY `torrent` (`torrent`),
KEY `torrent_seeder` (`torrent`,`seeder`),
KEY `last_action` (`last_action`),
KEY `connectable` (`connectable`),
KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=4487 DEFAULT CHARSET=cp1251 |
+-------+----------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------+
1 row in set (0.00 sec)
|
