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

/*Table structure for table `ftpuser` */


CREATE TABLE `ftpuser` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` varchar(32) NOT NULL default '',
  `passwd` varchar(32) NOT NULL default '',
  `uid` smallint(6) NOT NULL default '5500',
  `gid` smallint(6) NOT NULL default '5500',
  `homedir` varchar(255) NOT NULL default '',
  `shell` varchar(16) NOT NULL default '/sbin/nologin',
  `count` int(11) NOT NULL default '0',
  `accessed` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COMMENT='ProFTP user table';

/*Data for the table `ftpuser` */

insert  into `ftpuser`(`id`,`userid`,`passwd`,`uid`,`gid`,`homedir`,`shell`,`count`,`accessed`,`modified`) values (1,'MLopez','te5839525',5500,5500,'/home/efnftp/MLopez','/sbin/nologin',278,'2021-03-26 06:11:23','2016-01-26 00:09:54'),(2,'GLopez','squall22',5500,5500,'/home/efnftp/GLopez','/sbin/nologin',12,'2013-12-22 23:33:17','2013-12-22 22:45:20'),(3,'RDavila','davila1604',5500,5500,'/home/efnftp/RDavila','/sbin/nologin',3,'2016-02-15 20:39:26','2016-02-15 20:38:47'),(4,'JCrespin','JC1234',5500,5500,'/home/efnftp/JCrespin','/sbin/nologin',17,'2016-12-06 17:48:34','2016-12-06 17:48:34'),(5,'Carnicon','C123654',5500,5500,'/var/www/carnicon','/sbin/nologin',7,'2016-12-07 11:41:29','2016-12-05 11:04:50'),(6,'Marketing','3fmr4t1!',5500,5500,'/var/www/effinet/marketing','/sbin/nologin',65,'2016-12-22 13:19:26','2016-12-20 10:23:04'),(7,'JMunoz','EFN33W09!',5500,5500,'/home/efnftp/JMunoz','/sbin/nologin',16,'2017-08-11 18:29:37','0000-00-00 00:00:00');

