Дамп MySql для PureFTPd

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