CREATE TABLE `useronline` (
  `timestamp` int(15) NOT NULL default '0',
  `ip` varchar(40) NOT NULL default '',
  `file` varchar(100) NOT NULL default '',
  `username` varchar(255) NOT NULL default '',
  `guest` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`timestamp`),
  KEY `ip` (`ip`),
  KEY `file` (`file`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `hits` (
  `id` int(11) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `stats` (
  `IP` varchar(15) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  UNIQUE KEY `IP` (`IP`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;