GitLab

数据库：wiki

表名：tb_company_wiki_onebox_log

CREATE TABLE `tb_company_wiki_onebox_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `guid` varchar(225) NOT NULL,
  `user_id` int(11) unsigned NOT NULL DEFAULT '0',
  `box_url` varchar(255) NOT NULL DEFAULT '',
  `ip` varchar(255) NOT NULL DEFAULT '',
  `digest` varchar(32) NOT NULL DEFAULT '',
  `user_agent` varchar(255) NOT NULL DEFAULT '',
  `referer` varchar(255) NOT NULL DEFAULT '',
  `city` varchar(40) NOT NULL DEFAULT '',
  `short_city` varchar(10) NOT NULL DEFAULT '',
  `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 `short_city` (`short_city`) USING BTREE,
  KEY `user_id` (`user_id`),
  KEY `referer` (`referer`) USING BTREE,
  KEY `box_url` (`box_url`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;