1 files changed, 13 insertions, 0 deletions

diff --git a/access_log.sql b/access_log.sql
new file mode 100644
index 0000000..c38cb50
--- /dev/null
+++ b/access_log.sql
@@ -0,0 +1,13 @@
+create table access_log (
+        remote_host varchar(50) not null,
+        remote_user varchar(50) not null,
+        request_uri varchar(50) not null,
+        request_duration smallint not null,
+        virtual_host varchar(50) not null,
+        time_stamp int unsigned not null,
+        status smallint not null,
+        bytes_sent int not null,
+        referer varchar(255) not null,
+        agent varchar(255) not null
+)
+