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);