CREATE TABLE `k79h_statssearch` ( `id_statssearch` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_shop` int(10) unsigned NOT NULL DEFAULT '1', `id_shop_group` int(10) unsigned NOT NULL DEFAULT '1', `keywords` varchar(255) NOT NULL, `results` int(6) NOT NULL DEFAULT '0', `date_add` datetime NOT NULL, PRIMARY KEY (`id_statssearch`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;