soult / nanotrack
watch download tarball
public
Forks0Right
Watchers3Right
Description: Tiny PHP+mySQL BitTorrent tracker
Homepage: http://soultcer.net/wiki/Code/nanotrack
Clone URL: git://github.com/soult/nanotrack.git
nanotrack / table.sql
100644 9 lines (8 sloc) 0.378 kb
raw blame history 
1
2
3
4
5
6
7
8
9

CREATE TABLE IF NOT EXISTS `nanotrack` (
  `info_hash` binary(20) NOT NULL default '',
  `ip` int(10) unsigned NOT NULL default '0',
  `port` smallint(5) unsigned NOT NULL default '0',
  `last_seen` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`info_hash`,`ip`),
  KEY `last_seen` (`last_seen`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;