/*
SQLyog Ultimate v8.71 
MySQL - 5.0.95 : Database - efnftpdb
*********************************************************************
*/




CREATE DATABASE /*!32312 IF NOT EXISTS*/`efnftpdb` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `efnftpdb`;

/*Table structure for table `ftpgroup` */


CREATE TABLE `ftpgroup` (
  `groupname` varchar(16) NOT NULL default '',
  `gid` smallint(6) NOT NULL default '5500',
  `members` varchar(16) NOT NULL default '',
  KEY `groupname` (`groupname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Tabla para grupos ProFTP';

/*Data for the table `ftpgroup` */

insert  into `ftpgroup`(`groupname`,`gid`,`members`) values ('efn_ftp_group',5500,'efnftp');

/*Table structure for table `ftpquotalimits` */


CREATE TABLE `ftpquotalimits` (
  `name` varchar(30) default NULL,
  `quota_type` enum('user','group','class','all') NOT NULL default 'user',
  `per_session` enum('false','true') NOT NULL default 'false',
  `limit_type` enum('soft','hard') NOT NULL default 'soft',
  `bytes_in_avail` int(10) unsigned NOT NULL default '0',
  `bytes_out_avail` int(10) unsigned NOT NULL default '0',
  `bytes_xfer_avail` int(10) unsigned NOT NULL default '0',
  `files_in_avail` int(10) unsigned NOT NULL default '0',
  `files_out_avail` int(10) unsigned NOT NULL default '0',
  `files_xfer_avail` int(10) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `ftpquotalimits` */

insert  into `ftpquotalimits`(`name`,`quota_type`,`per_session`,`limit_type`,`bytes_in_avail`,`bytes_out_avail`,`bytes_xfer_avail`,`files_in_avail`,`files_out_avail`,`files_xfer_avail`) values ('MLopez','user','true','hard',15728640,0,0,0,0,0),('RDavila','user','true','hard',15728640,0,0,0,0,0),('JCrespin','user','true','hard',15728640,0,0,0,0,0),('Carnicon','user','true','hard',15728640,0,0,0,0,0),('Marketing','user','true','hard',15728640,0,0,0,0,0),('JMunoz','user','true','hard',15728640,0,0,0,0,0),('JMunoz','user','true','hard',15728640,0,0,0,0,0);

/*Table structure for table `ftpquotatallies` */


CREATE TABLE `ftpquotatallies` (
  `name` varchar(30) NOT NULL default '',
  `quota_type` enum('user','group','class','all') NOT NULL default 'user',
  `bytes_in_used` int(10) unsigned NOT NULL default '0',
  `bytes_out_used` int(10) unsigned NOT NULL default '0',
  `bytes_xfer_used` int(10) unsigned NOT NULL default '0',
  `files_in_used` int(10) unsigned NOT NULL default '0',
  `files_out_used` int(10) unsigned NOT NULL default '0',
  `files_xfer_used` int(10) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `ftpquotatallies` */

insert  into `ftpquotatallies`(`name`,`quota_type`,`bytes_in_used`,`bytes_out_used`,`bytes_xfer_used`,`files_in_used`,`files_out_used`,`files_xfer_used`) values ('MLopez','user',0,0,0,0,0,0),('RDavila','user',0,0,0,0,0,0),('JCrespin','user',0,0,0,0,0,0),('Carnicon','user',0,0,0,0,0,0),('Marketing','user',0,0,0,0,0,0);

