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 @@
+create table access_log (
+    id char(19) ,
+        agent varchar(255) ,
+        bytes_sent int unsigned ,
+        child_pid smallint unsigned,
+        cookie varchar(255),
+    machine_id varchar(25),
+        request_file varchar(255),
+        referer varchar(255) ,
+        remote_host varchar(50) ,
+        remote_logname varchar(50) ,
+        remote_user varchar(50) ,
+        request_duration smallint unsigned ,
+        request_line varchar(255),
+        request_method varchar(10) ,
+        request_protocol varchar(10) ,
+        request_time char(28),
+        request_uri varchar(50) ,
+        server_port smallint unsigned,
+        ssl_cipher varchar(25),
+        ssl_keysize smallint unsigned,
+        ssl_maxkeysize smallint unsigned,
+        status smallint unsigned ,
+        time_stamp int unsigned ,
+        virtual_host varchar(50)
+);
+
+create table notes (
+    id char(19),
+    item varchar(80),
+    val varchar(80)
+);
+
+create table headers_in (
+    id char(19),
+    item varchar(80),
+    val varchar(80)
+);
+
+create table headers_out (
+    id char(19),
+    item varchar(80),
+    val varchar(80)
+);
+
+create table cookies (
+    id char(19),
+    item varchar(80),
+    val varchar(80)
+);
\ No newline at end of file