>> Installation and troubleshooting
   >> Installing MySQL
   >> Installing proFTPd
   >> Installing proFTPd Administrator
   >> Troubleshooting

>> Configuration examples for use with MySQL
   >> Sample "proftpd.conf"-file
   >> Sample "proftpd.conf"-file with Quota
   >> Database structure
   >> Database structure, upgrade to v0.9
   >> Database structure, needed for VHOST extension
   >> Database structure, needed for PowerDNS extension

>> Miscellaneous
   >> GPL-License
   >> Pending features and changes
   >> Project homepage

USE proftpd_admin;

CREATE TABLE `domains` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `master` varchar(20) default NULL,
  `last_check` int(11) default NULL,
  `type` varchar(6) NOT NULL default '',
  `notified_serial` int(11) default NULL,
  `account` varchar(40) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name_index` (`name`)
) TYPE=MyISAM;

CREATE TABLE `records` (
  `id` int(11) NOT NULL auto_increment,
  `domain_id` int(11) default NULL,
  `name` varchar(255) default NULL,
  `type` varchar(6) default NULL,
  `content` varchar(255) default NULL,
  `ttl` int(11) default NULL,
  `prio` int(11) default NULL,
  `change_date` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `rec_name_index` (`name`),
  KEY `nametype_index` (`name`,`type`),
  KEY `domain_id` (`domain_id`)
) TYPE=MyISAM;

CREATE TABLE `supermasters` (
  `ip` varchar(25) NOT NULL default '',
  `nameserver` varchar(255) NOT NULL default '',
  `account` varchar(40) default NULL
) TYPE=MyISAM;