From: Elliott Polk <elliott.polk@thekaroshiworkshop.com>
Date: Thu, 24 May 2012 09:51:39 +0000 (+0800)
Subject: Merge branch 'master' of http://git.roojs.com:8081/Pman.Core
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=1b3b4456d14a2b1e8243a20c6688e6783e6f438b;hp=4ad9d7819715e0458c401db16768c9b3e351922f

Merge branch 'master' of git.roojs.com:8081/Pman.Core
---

diff --git a/mysql/core_ftpxferlog.sql b/mysql/core_ftpxferlog.sql
new file mode 100644
index 00000000..f4590dc8
--- /dev/null
+++ b/mysql/core_ftpxferlog.sql
@@ -0,0 +1,14 @@
+CREATE TABLE core_ftpxferlog (
+  id INT NOT NULL AUTO_INCREMENT,
+  username VARCHAR(30) NOT NULL DEFAULT '',
+  filename text,
+  txsize BIGINT(20) DEFAULT NULL,
+  host tinytext,
+  ip tinytext,
+  action tinytext,
+  duration tinytext,
+  txlocaltime TIMESTAMP DEFAULT NULL,
+  success INT(1) NOT NULL DEFAULT 0,
+  PRIMARY KEY  (id),
+  KEY idx_usersucc (username, success)
+);