Divers

public text v1 · immutable

#204929

·published 2006-10-16 11:33 UTC

CREATE TABLE stats_2006_10 (
  host varchar(65) NOT NULL default '',
  `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  request varchar(250) NOT NULL default '',
  octets int(25) NOT NULL default '0',
  referer varchar(250) NOT NULL default '',
  useragent varchar(180) NOT NULL default '',
  codehttp int(5) NOT NULL default '0',
  UNIQUE KEY hit (request,`datetime`,host)
) ENGINE=MyISAM;