CREATE TABLE `highscores` (
  `id` int(11) NOT NULL auto_increment,
  `siteID` int(11) NOT NULL default '0',
  `gameID` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `pictureURL` varchar(255) NOT NULL default '',
  `facebookUserID` varchar(255) NOT NULL default '',
  `score` int(11) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `siteID` (`siteID`),
  KEY `gameID` (`gameID`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;