mysql

diff --git a/mysql/core_ftpxferlog.sql b/mysql/core_ftpxferlog.sql
new file mode 100644 (file)
index 0000000..79d4634
--- /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,
+  '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')
+) TYPE=InnoDB;
\ No newline at end of file

diff --git a/mysql/takkun@192.168.1.107 b/mysql/takkun@192.168.1.107
new file mode 100644 (file)
index 0000000..79d4634
--- /dev/null
+++ b/mysql/takkun@192.168.1.107
@@ -0,0 +1,14 @@
+CREATE TABLE 'core_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')
+) TYPE=InnoDB;
\ No newline at end of file