summaryrefslogtreecommitdiffstats
path: root/contrib/create_tables.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/create_tables.sql')
-rw-r--r--contrib/create_tables.sql51
1 files changed, 51 insertions, 0 deletions
diff --git a/contrib/create_tables.sql b/contrib/create_tables.sql
new file mode 100644
index 0000000..0fe0f4b
--- /dev/null
+++ b/contrib/create_tables.sql
@@ -0,0 +1,51 @@
1create table access_log (
2 id char(19) ,
3 agent varchar(255) ,
4 bytes_sent int unsigned ,
5 child_pid smallint unsigned,
6 cookie varchar(255),
7 machine_id varchar(25),
8 request_file varchar(255),
9 referer varchar(255) ,
10 remote_host varchar(50) ,
11 remote_logname varchar(50) ,
12 remote_user varchar(50) ,
13 request_duration smallint unsigned ,
14 request_line varchar(255),
15 request_method varchar(10) ,
16 request_protocol varchar(10) ,
17 request_time char(28),
18 request_uri varchar(255),
19 request_args varchar(255),
20 server_port smallint unsigned,
21 ssl_cipher varchar(25),
22 ssl_keysize smallint unsigned,
23 ssl_maxkeysize smallint unsigned,
24 status smallint unsigned ,
25 time_stamp int unsigned ,
26 virtual_host varchar(255)
27);
28
29create table notes (
30 id char(19),
31 item varchar(80),
32 val varchar(80)
33);
34
35create table headers_in (
36 id char(19),
37 item varchar(80),
38 val varchar(80)
39);
40
41create table headers_out (
42 id char(19),
43 item varchar(80),
44 val varchar(80)
45);
46
47create table cookies (
48 id char(19),
49 item varchar(80),
50 val varchar(80)
51);