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) |