DROP TABLE IF EXISTS `jos_keyword_stats`;
 
CREATE TABLE `jos_keyword_stats` (
  `Keyword` text,
  `Date` date NOT NULL,
  'Time' time,
  'Destination' mediumtext,
  'Location' mediumtext,
  'UserIP' text,
  'UserAgent' text,
  'id' int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

CREATE TABLE jos_keyword_stats 
( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT 
, Keyword      VARCHAR(99) NOT NULL
, MyDateTime   DATETIME    NOT NULL
, Destination  VARCHAR(99)
, Location     VARCHAR(99)
, UserIP       VARCHAR(15)
, UserAgent    VARCHAR(99)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;