1 files changed, 15 insertions, 0 deletions
diff --git a/create-mysql.sql b/create-mysql.sql
new file mode 100644
index 0000000..c7b24e1
--- /dev/null
+++ b/create-mysql.sql
@@ -0,0 +1,15 @@
+create table icelog (
+  lognum int primary key auto_increment,
+  logdate datetime,
+  logmachine varchar(255),
+  logpos int,
+  customer varchar(255),
+  liveflag char(1),
+  hostname varchar(255),
+  start int,
+  mountpoint varchar(255),
+  bytes int,
+  useragent varchar(255),
+  seconds int
+);
+