-- Adminer 4.2.3 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `stats`;
CREATE TABLE `stats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `version` varchar(10) NOT NULL,
  `version_full` varchar(255) NOT NULL,
  `os` varchar(255) NOT NULL,
  `user_agent` text NOT NULL,
  `mobile` tinyint(1) NOT NULL,
  `core` varchar(255) NOT NULL,
  `ip` char(15) NOT NULL,
  `language` varchar(3) NOT NULL,
  `fingerprint` char(40) NOT NULL,
  `year` year(4) NOT NULL,
  `month` tinyint(4) NOT NULL,
  `day` tinyint(4) NOT NULL,
  `hour` tinyint(4) NOT NULL,
  `minute` tinyint(4) NOT NULL,
  `second` tinyint(4) NOT NULL,
  `datetime` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `year` (`year`),
  KEY `month` (`month`),
  KEY `day` (`day`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- 2016-05-01 21:24:54
