use apache;

CREATE TABLE requests (
  server varchar(127) DEFAULT '',
  filename varchar(200) DEFAULT '',
  remoteip varchar(15) DEFAULT '',
  remotehost varchar(100) DEFAULT '',
  status smallint(6) DEFAULT '0',
  timeserved datetime,
  referer varchar(250) DEFAULT '',
  agent varchar(250) DEFAULT ''
);
CREATE INDEX server_idx ON requests (server);
CREATE INDEX timeserved_idx ON requests (timeserved);