summaryrefslogtreecommitdiffstats
path: root/create_tables.sql
diff options
context:
space:
mode:
Diffstat (limited to 'create_tables.sql')
-rw-r--r--create_tables.sql50
1 files changed, 50 insertions, 0 deletions
diff --git a/create_tables.sql b/create_tables.sql
new file mode 100644
index 0000000..430d1a7
--- /dev/null
+++ b/create_tables.sql
@@ -0,0 +1,50 @@
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(50) ,
19 server_port smallint unsigned,
20 ssl_cipher varchar(25),
21 ssl_keysize smallint unsigned,
22 ssl_maxkeysize smallint unsigned,
23 status smallint unsigned ,
24 time_stamp int unsigned ,
25 virtual_host varchar(50)
26);
27
28create table notes (
29 id char(19),
30 item varchar(80),
31 val varchar(80)
32);
33
34create table headers_in (
35 id char(19),
36 item varchar(80),
37 val varchar(80)
38);
39
40create table headers_out (
41 id char(19),
42 item varchar(80),
43 val varchar(80)
44);
45
46create table cookies (
47 id char(19),
48 item varchar(80),
49 val varchar(80)
50); \ No newline at end of file