Файл: install/db_tables/visit.sql
Строк: 7
CREATE TABLE IF NOT EXISTS `visit_everyday` (
  `time` int(11) NOT NULL,
 
`host` int(11) NOT NULL,
  `hit` int(11) NOT NULL,
  `host_ip_ua` int(11)
NOT NULL,
  KEY `time` (`time`),
  KEY `host` (`host`),
  KEY `hit`
(`hit`),
  KEY `host_ip_ua` (`host_ip_ua`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `visit_today` (
  `ip` bigint(11)
NOT NULL,
  `ua` varchar(128) DEFAULT NULL,
  `time` int(11) NOT NULL,
 
KEY `ip` (`ip`),
  KEY `ua` (`ua`),
  KEY `time` (`time`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;