PureFTPd SQL db

USE ftp;

--
-- Table structure for table 'admin'
--

CREATE TABLE admin (
  Username VARCHAR(35) NOT NULL DEFAULT '',
  PASSWORD CHAR(32) BINARY NOT NULL DEFAULT '') ENGINE=MYISAM;

--
-- Data for table 'admin'
--


INSERT INTO admin VALUES ('Administrator',MD5('tmppasswd'));

--
-- Table structure for table 'users'
--

CREATE TABLE `users` (
  `User` VARCHAR(16) NOT NULL DEFAULT '',
  `Password` VARCHAR(32) BINARY NOT NULL DEFAULT '',
  `Uid` INT(11) NOT NULL DEFAULT '14',
  `Gid` INT(11) NOT NULL DEFAULT '5',
  `Dir` VARCHAR(128) NOT NULL DEFAULT '',
  `QuotaFiles` INT(10) NOT NULL DEFAULT '500',
  `QuotaSize` INT(10) NOT NULL DEFAULT '30',
  `ULBandwidth` INT(10) NOT NULL DEFAULT '80',
  `DLBandwidth` INT(10) NOT NULL DEFAULT '80',
  `Ipaddress` VARCHAR(15) NOT NULL DEFAULT '*',
  `Comment` TINYTEXT,
  `Status` ENUM('0','1') NOT NULL DEFAULT '1',
  `ULRatio` SMALLINT(5) NOT NULL DEFAULT '1',
  `DLRatio` SMALLINT(5) NOT NULL DEFAULT '1',
  PRIMARY KEY  (`User`),
  UNIQUE KEY `User` (`User`)
) ENGINE=MYISAM;

--
-- Data for table 'users'
--


INSERT INTO ftpusers.users VALUES ('ftpuser_1',MD5('tmppasswd'),65534, 31, '/usr', 100, 50, 75, 75, '*', 'Ftp user (for example)', '1', 0, 0);