-- MySQL dump 9.11
--
-- Host: localhost    Database: virtual-users
-- ------------------------------------------------------
-- Server version	4.0.24_Debian-10sarge1-log

--
-- Table structure for table `ftp_groups`
--

CREATE TABLE `ftp_groups` (
  `groupname` varchar(30) NOT NULL default '',
  `gid` int(11) NOT NULL default '0',
  `members` text NOT NULL
) TYPE=MyISAM;

--
-- Dumping data for table `ftp_groups`
--


--
-- Table structure for table `ftp_quotalimits`
--

CREATE TABLE `ftp_quotalimits` (
  `name` varchar(50) NOT NULL default '',
  `quota_type` varchar(11) NOT NULL default '',
  `per_session` varchar(11) NOT NULL default '',
  `limit_type` varchar(11) NOT NULL default '',
  `bytes_in_avail` bigint(20) NOT NULL default '0',
  `bytes_out_avail` bigint(20) NOT NULL default '0',
  `bytes_xfer_avail` bigint(20) NOT NULL default '0',
  `files_in_avail` bigint(20) NOT NULL default '0',
  `files_out_avail` bigint(20) NOT NULL default '0',
  `files_xfer_avail` bigint(20) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `ftp_quotalimits`
--


--
-- Table structure for table `ftp_quotatallies`
--

CREATE TABLE `ftp_quotatallies` (
  `name` varchar(50) NOT NULL default '',
  `quota_type` varchar(11) NOT NULL default '',
  `bytes_in_used` bigint(20) NOT NULL default '0',
  `bytes_out_used` bigint(20) NOT NULL default '0',
  `bytes_xfer_used` bigint(20) NOT NULL default '0',
  `files_in_used` bigint(20) NOT NULL default '0',
  `files_out_used` bigint(20) NOT NULL default '0',
  `files_xfer_used` bigint(20) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `ftp_quotatallies`
--


--
-- Table structure for table `ftp_users`
--

CREATE TABLE `ftp_users` (
  `username` varchar(50) NOT NULL default '',
  `password` varchar(30) default NULL,
  `uid` int(11) NOT NULL default '107',
  `gid` int(11) NOT NULL default '100',
  `homedir` varchar(255) default NULL,
  `shell` varchar(50) default NULL,
  UNIQUE KEY `username` (`username`)
) TYPE=MyISAM;

--
-- Dumping data for table `ftp_users`
--


