Ja. Kannst du noch ändern.
# MySQL-Front Dump 2.5
USE ftpserver;
#
# Table structure for table 'ftpconf'
#
DROP TABLE IF EXISTS `ftpconf`;
CREATE TABLE `ftpconf` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`value` blob,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM COMMENT='Direktiven';
#
# Dumping data for table 'ftpconf'
#
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("1", "ServerName", "\"SERVER\"");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("2", "ServerType", "standalone");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("3", "ServerAdmin", "support@server");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("4", "ServerIdent", "on \"localhost\"");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("5", "DeferWelcome", "on");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("6", "DefaultServer", "on");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("7", "Port", "21");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("8", "Umask", "022");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("9", "MaxInstances", "30");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("10", "AllowForeignAddress", "off");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("11", "MaxClientsPerHost", "2 \"Nicht mehr als %m Verbindungen\"");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("12", "MaxClients", "50 \"Leider sind schon %m Clients verbunden\"");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("13", "MaxLoginAttempts", "3");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("14", "AllowStoreRestart", "off");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("15", "AllowRetrieveRestart", "off");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("16", "DefaultRoot", "~");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("17", "RequireValidShell", "off");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("18", "TransferLog", "/var/log/proftpd.xferlog");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("19", "LogFormat", "default \"%h %l %u %t \\\"%r\\\" %s %b\"");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("20", "LogFormat", "auth \"%v [%P] %h %t \\\"%r\\\" %s\"");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("21", "LogFormat", "write \"%h %l %u %t \\\"%r\\\" %s %b\"");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("22", "ExtendedLog", "/var/log/proftpd.access_log WRITE,READ write");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("23", "ExtendedLog", "/var/log/proftpd.auth_log AUTH auth");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("24", "SQLAuthTypes", "Plaintext");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("25", "SQLAuthenticate", "users*");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("26", "SQLConnectInfo", "ftpserver @localhost ftpserver PASSWORT");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("27", "SQLDefaultGID", "65534");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("28", "SQLDefaultUID", "65534");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("29", "SQLMinUserGID", "100");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("30", "SQLMinUserUID", "500");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("31", "SQLUserInfo", "users username password uid gid homedir shell");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("32", "SQLLog", "PASS counter");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("33", "SQLNamedQuery", "counter UPDATE \"letzter_zugriff=now(), count=count+1 WHERE username=\'%u\'\" users");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("34", "SQLLog", "RETR,STOR transfer1");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("35", "SQLNamedQuery", "transfer1 INSERT \"\'%u\', \'%f\', \'%b\', \'%h\', \'%a\', \'%m\', \'%T\',now(), \'c\', NULL\" xfer_stat");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("36", "SQLLOG", "ERR_RETR,ERR_STOR transfer2");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("37", "SQLNamedQuery", "transfer2 INSERT \"\'%u\', \'%f\', \'%b\', \'%h\', \'%a\', \'%m\', \'%T\',now(), \'i\', NULL\" xfer_stat");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("38", "QuotaEngine", "on");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("39", "QuotaShowQuotas", "on");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("40", "QuotaLimitTable", "sql:/get-quota-limit");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("41", "QuotaTallyTable", "sql:/get-quota-tally/update-quota-tally/insert-quota-tally");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("42", "SQLNamedQuery", "get-quota-limit SELECT \"name, quota_type, per_session,limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM quotalimits WHERE name = \'%{0}\' AND quota_type = \'%{1}\'\"");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("43", "SQLNamedQuery", "get-quota-tally SELECT \"name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM quotatallies WHERE name = \'%{0}\' AND quota_type = \'%{1}\'\"");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("44", "SQLNamedQuery", "update-quota-tally UPDATE \"bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name = \'%{6}\' AND quota_type = \'%{7}\'\" quotatallies");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("45", "SQLNamedQuery", "insert-quota-tally INSERT \"%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}\" quotatallies");
INSERT INTO `ftpconf` (`id`, `name`, `value`) VALUES("46", "AllowOverwrite", "on");
#
# Table structure for table 'ftpctxt'
#
DROP TABLE IF EXISTS `ftpctxt`;
CREATE TABLE `ftpctxt` (
`id` int(10) unsigned NOT NULL auto_increment,
`parent_id` int(10) unsigned default NULL,
`name` varchar(255) default NULL,
`value` varchar(255) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM COMMENT='Kontexte';
#
# Dumping data for table 'ftpctxt'
#
INSERT INTO `ftpctxt` (`id`, `parent_id`, `name`, `value`) VALUES("1", NULL, "default", NULL);
INSERT INTO `ftpctxt` (`id`, `parent_id`, `name`, `value`) VALUES("2", "1", "Directory", "/");
#
# Table structure for table 'ftpmap'
#
DROP TABLE IF EXISTS `ftpmap`;
CREATE TABLE `ftpmap` (
`conf_id` int(10) unsigned NOT NULL default '0',
`ctxt_id` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM COMMENT='Direktiven2Kontexte';
#
# Dumping data for table 'ftpmap'
#
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("1", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("2", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("3", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("4", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("5", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("6", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("7", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("8", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("9", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("10", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("11", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("12", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("13", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("14", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("15", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("16", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("17", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("18", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("19", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("20", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("21", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("22", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("23", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("24", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("25", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("26", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("27", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("28", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("29", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("30", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("31", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("32", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("33", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("34", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("35", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("36", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("37", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("38", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("39", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("40", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("41", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("42", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("43", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("44", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("45", "1");
INSERT INTO `ftpmap` (`conf_id`, `ctxt_id`) VALUES("46", "2");
