-- This mysql script is made by M.Mastenbroek 2002/2003
-- For more info look at http://machiel.generaal.net
-- Version 1.2.2
--
--
-- Host: localhost    Database: ftpusers
---------------------------------------------------------
-- Server version	3.23 or 4.x
-- Script version	1.2.2
--

--
-- Create MySQL user called 'ftp'
-- Login = ftp
-- Password = tmppasswd
-- Host = 127.0.0.1
--

INSERT INTO mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES('127.0.0.1','ftp',PASSWORD('tmppasswd'),'Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N');

FLUSH PRIVILEGES;

CREATE DATABASE ftpusers;

USE ftpusers;

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

CREATE TABLE admin (
  Username varchar(35) NOT NULL default '',
  Password char(32) binary NOT NULL default '',
  PRIMARY KEY  (Username)
) TYPE=MyISAM;

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


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

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

CREATE TABLE users (
  User char(16) NOT NULL default '',
  Password char(32) binary NOT NULL default '',
  Uid int(11) NOT NULL default '14',
  Gid int(11) NOT NULL default '5',
  Dir char(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',
  PRIMARY KEY  (User)
) TYPE=MyISAM;

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


INSERT INTO users VALUES ('ftpuser_1',MD5('tmppasswd'),14,5,'/usr/',500,30,80,5);