added .sql file

diff --git a/mysql/ftp_xferlog.sql b/mysql/ftp_xferlog.sql
new file mode 100644 (file)
index 0000000..c483bbf
--- /dev/null
+++ b/mysql/ftp_xferlog.sql
@@ -0,0 +1,14 @@
+CREATE TABLE `ftpxferlog` (
+  `id` INT NOT NULL AUTO_INCREMENT,
+  `username` VARCHAR(30) NOT NULL DEFAULT '',
+  `filename` text,
+  `size` BIGINT(20) DEFAULT NULL,
+  `host` tinytext,
+  `ip` tinytext,
+  `action` tinytext,
+  `duration` tinytext,
+  `localtime` TIMESTAMP NULL DEFAULT NULL,
+  `success` BOOL NOT NULL DEFAULT '0',
+  PRIMARY KEY  (`id`),
+  KEY `idx_usersucc` (`username`, `success`)
+);
\ No newline at end of file