Новая установка:
-----------------------------------------------
CREATE TABLE dle_referer (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL default '',
  `date` varchar(20) default NULL,
  `host` varchar(50) default NULL,
  `hits` int(11) unsigned NOT NULL default '1',
  `lastip` varchar(16) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;
-----------------------------------------------



Обновление до 3.9: 
-----------------------------------------------
DROP TABLE dle_referer;
CREATE TABLE dle_referer (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL default '',
  `date` varchar(20) default NULL,
  `host` varchar(50) default NULL,
  `hits` int(11) unsigned NOT NULL default '1',
  `lastip` varchar(16) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;
-----------------------------------------------