Файл: 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;