CREATE TABLE IF NOT EXISTS `snatched` (
  `id` int(11) NOT NULL auto_increment,
  `torrentid` int(11) default '0',
  `userid` int(11) default '0',
  `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',
  `agent` varchar(60) NOT NULL default '',
  `peer_id` varchar(20) NOT NULL default '',
  `finished` enum('yes','no') NOT NULL default 'no',
  `complete_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `start_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
  `seed_end` datetime NOT NULL default '0000-00-00 00:00:00',
  `hitrun` datetime NOT NULL default '0000-00-00 00:00:00',
  `hitrunwarn` enum('yes','pending','no') NOT NULL default 'no',
  PRIMARY KEY  (`id`),
  KEY `torrentid` (`torrentid`,`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=50543 ;