diff options
Diffstat (limited to 'access_log.sql')
| -rw-r--r-- | access_log.sql | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/access_log.sql b/access_log.sql index a667494..4966c62 100644 --- a/access_log.sql +++ b/access_log.sql | |||
| @@ -1,25 +1,25 @@ | |||
| 1 | create table access_log ( | 1 | create table access_log ( |
| 2 | agent varchar(255) not null, | 2 | agent varchar(255) , |
| 3 | bytes_sent int not null, | 3 | bytes_sent int , |
| 4 | child_pid smallint unsigned, | 4 | child_pid smallint unsigned, |
| 5 | cookie varchar(255), | 5 | cookie varchar(255), |
| 6 | request_file varchar(255), | 6 | request_file varchar(255), |
| 7 | referer varchar(255) not null, | 7 | referer varchar(255) , |
| 8 | remote_host varchar(50) not null, | 8 | remote_host varchar(50) , |
| 9 | remote_logname varchar(50) not null, | 9 | remote_logname varchar(50) , |
| 10 | remote_user varchar(50) not null, | 10 | remote_user varchar(50) , |
| 11 | request_duration smallint not null, | 11 | request_duration smallint , |
| 12 | request_line varchar(255), | 12 | request_line varchar(255), |
| 13 | request_method varchar(6) not null, | 13 | request_method varchar(6) , |
| 14 | request_protocol varchar(10) not null, | 14 | request_protocol varchar(10) , |
| 15 | request_time char(28), | 15 | request_time char(28), |
| 16 | request_uri varchar(50) not null, | 16 | request_uri varchar(50) , |
| 17 | server_port smallint unsigned, | 17 | server_port smallint unsigned, |
| 18 | ssl_cipher varchar(25), | 18 | ssl_cipher varchar(25), |
| 19 | ssl_keysize smallint unsigned, | 19 | ssl_keysize smallint unsigned, |
| 20 | ssl_maxkeysize smallint unsigned, | 20 | ssl_maxkeysize smallint unsigned, |
| 21 | status smallint not null, | 21 | status smallint , |
| 22 | time_stamp int unsigned not null, | 22 | time_stamp int unsigned , |
| 23 | virtual_host varchar(50) not null | 23 | virtual_host varchar(50) |
| 24 | ) | 24 | ) |
| 25 | 25 | ||
