USE `aws_logs`;
CREATE TABLE `log_data` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `file_id` int(11) NOT NULL,
  `bucket` varchar(100) NOT NULL DEFAULT '',
  `time` datetime NOT NULL,
  `remote_ip` varchar(100) DEFAULT NULL,
  `operation` varchar(100) DEFAULT NULL,
  `path` varchar(200) NOT NULL DEFAULT '',
  `request_uri` varchar(500) NOT NULL DEFAULT '',
  `status` varchar(10) DEFAULT NULL,
  `error` varchar(100) DEFAULT NULL,
  `sent` int(10) DEFAULT NULL,
  `size` int(10) DEFAULT NULL,
  `millisecs` int(11) DEFAULT NULL,
  `referrer` varchar(500) DEFAULT NULL,
  `user_agent` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `PathKey` (`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
