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


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`efnmailer_old` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `efnmailer_old`;

/*Table structure for table `efnmsg` */

DROP TABLE IF EXISTS `efnmsg`;

CREATE TABLE `efnmsg` (
  `efnmlr_cod` int(10) unsigned NOT NULL auto_increment,
  `efnmlr_asun` varchar(50) NOT NULL,
  `efnmlr_msg` varchar(255) NOT NULL,
  `efnmlr_adj` varchar(200) default NULL,
  `efnmlr_fond` varchar(200) default NULL,
  PRIMARY KEY  (`efnmlr_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

/*Data for the table `efnmsg` */

insert  into `efnmsg`(`efnmlr_cod`,`efnmlr_asun`,`efnmlr_msg`,`efnmlr_adj`,`efnmlr_fond`) values (1,'test','hola prueba',NULL,NULL),(2,'test2','hola prueba2',NULL,NULL),(3,'test3','test',NULL,NULL),(4,'sdfsdf','sdfsdf','adjunto/2016-12-01-06-30-24adj_22012811F.pdf','adjunto/2016-12-01-06-30-24fondo_22012811F.pdf'),(5,'dddddd','adadadad','adjunto/2017-01-16-11-59-46adj_prueba2.csv',''),(6,'fff','fffffffffffffff','',''),(7,'ro','rosa','',''),(8,'asunto','mensaje','','');

/*Table structure for table `efnprm` */

DROP TABLE IF EXISTS `efnprm`;

CREATE TABLE `efnprm` (
  `efnmlr_cod` int(10) unsigned NOT NULL auto_increment,
  `efnmlr_cntmsg` mediumint(8) unsigned NOT NULL default '1',
  `efnmlr_cnttiem` mediumint(8) unsigned NOT NULL default '1',
  `efnmlr_coetau` varchar(10) NOT NULL,
  `efnmlr_coenau` varchar(10) NOT NULL,
  `efnmlr_coetenc` varchar(10) NOT NULL,
  `efnmlr_coesrv` varchar(50) NOT NULL,
  `efnmlr_coeprt` int(10) unsigned NOT NULL,
  `efnmlr_coeusu` varchar(50) NOT NULL,
  `efnmlr_coecnt` varchar(50) NOT NULL,
  `efnmlr_coecc` varchar(70) NOT NULL,
  PRIMARY KEY  (`efnmlr_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `efnprm` */

insert  into `efnprm`(`efnmlr_cod`,`efnmlr_cntmsg`,`efnmlr_cnttiem`,`efnmlr_coetau`,`efnmlr_coenau`,`efnmlr_coetenc`,`efnmlr_coesrv`,`efnmlr_coeprt`,`efnmlr_coeusu`,`efnmlr_coecnt`,`efnmlr_coecc`) values (1,2,4,'smtp','true','ssl','192.168.1.222',587,'info@effinet.com.pe','te5839525','');

/*Table structure for table `efntiem` */

DROP TABLE IF EXISTS `efntiem`;

CREATE TABLE `efntiem` (
  `efnmlr_cod` int(10) unsigned NOT NULL auto_increment,
  `efnmlr_tiem` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`efnmlr_cod`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `efntiem` */

insert  into `efntiem`(`efnmlr_cod`,`efnmlr_tiem`) values (1,2),(2,5),(3,1),(4,6);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
