
CREATE TABLE `__PREFIX__admin_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `admin_member_id` int(11) DEFAULT NULL,
  `admin_member_username` varchar(255) DEFAULT NULL,
  `url` varchar(1000) DEFAULT NULL COMMENT '访问url',
  `route` varchar(50) DEFAULT NULL COMMENT '访问路由',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `content` longtext COMMENT '内容',
  `ip` varchar(100) DEFAULT NULL COMMENT 'ip地址',
  `useragent` varchar(500) DEFAULT NULL COMMENT 'useragent',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `delete_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;