------------------------------------------------------------------------------------------

#DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
Username varchar(32) NOT NULL default '',
`Password` varchar(32) NOT NULL default '',
PRIMARY KEY (Username)
);



INSERT INTO admin VALUES ('admin', md5('admin'));

#DROP TABLE IF EXISTS users;
CREATE TABLE users (
`User` varchar(16) NOT NULL default '',
`Password` varchar(32) 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`)
);



INSERT INTO users VALUES ('admin',md5('admin'),1001,1001,'/tmp/',100,50,75,75,'*','Ftp user (for example)','1','','');
-----------------------------------------------------------------------------------------------------
grant select on ftpd.* to ftpuser@localhost identified by '111';