summaryrefslogtreecommitdiffstats
path: root/access_log.sql
diff options
context:
space:
mode:
Diffstat (limited to 'access_log.sql')
-rw-r--r--access_log.sql26
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 @@
1create table access_log ( 1create 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