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 | ||