diff options
author | Edward Rudd | 2004-02-12 03:44:12 +0000 |
---|---|---|
committer | Edward Rudd | 2004-02-12 03:44:12 +0000 |
commit | bdb5c0e5ea921d274b797f3b9b311b713eb0b792 (patch) | |
tree | bb70807189c0e14d5f5c87b57d345bca6ab98115 /contrib/create_tables.sql | |
parent | 6caf2429c3ff47657c8ce2579be1224063505f80 (diff) |
moved create_tables.sql and make_combined_log.pl into contrib directory.
Added contrib directory to build system.
Updated new maintainer information in AUTHORS,LICENSE, and manual.xml
Diffstat (limited to 'contrib/create_tables.sql')
-rw-r--r-- | contrib/create_tables.sql | 51 |
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 @@ | |||
1 | create 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 | |||
29 | create table notes ( | ||
30 | id char(19), | ||
31 | item varchar(80), | ||
32 | val varchar(80) | ||
33 | ); | ||
34 | |||
35 | create table headers_in ( | ||
36 | id char(19), | ||
37 | item varchar(80), | ||
38 | val varchar(80) | ||
39 | ); | ||
40 | |||
41 | create table headers_out ( | ||
42 | id char(19), | ||
43 | item varchar(80), | ||
44 | val varchar(80) | ||
45 | ); | ||
46 | |||
47 | create table cookies ( | ||
48 | id char(19), | ||
49 | item varchar(80), | ||
50 | val varchar(80) | ||
51 | ); | ||