CREATE TABLE `opl_srchLog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `page` varchar(100) DEFAULT '',
  `searchType` varchar(100) DEFAULT 'regular',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `query` text,
  `hits` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ind_1` (`page`,`hits`,`date`,`searchType`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

