GitLab

数据库：wiki

表名：tb_company_wiki_visit_log

CREATE TABLE `tb_company_wiki_visit_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `guid` int(11) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `digest` varchar(32) NOT NULL,
  `user_agent` varchar(255) NOT NULL,
  `city` varchar(40) NOT NULL,
  `short_city` varchar(10) NOT NULL,
  `create_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  `create_time_index` int(4) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `create_time_index` (`create_time_index`) USING BTREE,
  KEY `digest` (`digest`) USING BTREE,
  KEY `guid` (`guid`) USING BTREE,
  KEY `short_city` (`short_city`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;