
CREATE TABLE `phplist_sendprocess` (
  `id` int(11) NOT NULL auto_increment,
  `started` datetime default NULL,
  `modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `alive` int(11) default '1',
  `ipaddress` varchar(50) default NULL,
  `page` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=777 DEFAULT CHARSET=utf8;

/*Data for the table `phplist_sendprocess` */

/*Table structure for table `phplist_subscribepage` */


CREATE TABLE `phplist_subscribepage` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `active` tinyint(4) default '0',
  `owner` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `phplist_subscribepage` */

insert  into `phplist_subscribepage`(`id`,`title`,`active`,`owner`) values (1,'Suscribete para mas novedades',1,1);

/*Table structure for table `phplist_subscribepage_data` */


CREATE TABLE `phplist_subscribepage_data` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `data` text,
  PRIMARY KEY  (`id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*Data for the table `phplist_subscribepage_data` */

insert  into `phplist_subscribepage_data`(`id`,`name`,`data`) values (1,'button','Suscribir'),(1,'attributes',''),(1,'footer','</div>\r\n</div>\r\n</div><!-- ENDOF #mainContent-->\r\n</div><!-- ENDOF .wrapper -->\r\n</div><!-- ENDOF #container -->\r\n\r\n<div id=\\\"footer\\\">\r\n<div id=\\\"footerframe\\\">\r\n<ul>\r\n<li>&nbsp;</li>\r\n</ul>\r\n</div>\r\n</div>\r\n\r\n</body>\r\n\r\n</html>\r\n'),(1,'thankyoupage','<h3>Gracias por suscribirse a nuestros boletines.</h3>\r\n<p>Su correo electronico ha sido agregado a nuestro sistema. En breve recibirá un mensaje solicitando su confirmación. Por favor, haga clic en el enlace de ese mensaje para confirmar la suscripción.</p>'),(1,'htmlchoice','checkfortext'),(1,'emaildoubleentry','yes'),(1,'ajax_subscribeconfirmation','<h3>Gracias por suscribirse a nuestros boletines.</h3><p>En breve recibirá un mensaje solicitando su confirmación. Por favor, haga clic en el enlace de ese mensaje para confirmar la suscripción.</p>'),(1,'language_file',''),(1,'intro','Suscríbase a una o más de nuestros boletines usando el siguiente formulario'),(1,'header','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1, maximum-scale=1\" />\n\n<link rel=\"apple-touch-icon\" href=\"./images/efnmailer-touch-icon.png\" />\n<link rel=\"apple-touch-icon-precomposed\" href=\"./images/efnmailer-touch-icon.png\" />\n<link rel=\"stylesheet\" href=\"styles/subscribe.css\" type=\"text/css\" />\n<link rel=\"stylesheet\" href=\"styles/color.css\" type=\"text/css\" />\n</head>\n\n<body class=\"fixed\">\n\n<div id=\"container\">\n\n<div id=\"header\" >\n<div id=\"rack-functions\">\n<h1 id=\"logo\"><a href=\"http://effinet.com.pe:35155\" title=\"Tecnología a tu alcance\">[ORGANISATION_NAME]</a></h1>\n</div>\n</div>\n<div id=\"wrapper\">\n<div id=\"mainContent\">\n\n<div class=\"panel\">\n<div class=\"content\">'),(1,'title','Suscribete para mas novedades');

/*Table structure for table `phplist_template` */


CREATE TABLE `phplist_template` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `template` longblob,
  `listorder` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `phplist_template` */

insert  into `phplist_template`(`id`,`title`,`template`,`listorder`) values (1,'1','<p>[CONTENT]</p>\r\n<p><img src=\\\"http://www.effinet.com.pe/marketing/mercadolibre/aa.jpg\\\" alt=\\\"Effinet\\\" height=\\\"auto\\\" width=\\\"920\\\" /> <img src=\\\"http://www.effinet.com.pe/marketing/mercadolibre/NOMBREDEPRODUCTO.jpg\\\" alt=\\\"Effinet\\\" height=\\\"auto\\\" width=\\\"920\\\" /> <img src=\\\"http://www.effinet.com.pe/marketing/mercadolibre/down.jpg\\\" alt=\\\"Effinet\\\" height=\\\"auto\\\" width=\\\"920\\\" /></p>',NULL),(2,'System Template','<div style=\"margin:0; text-align:center; width:100%; background:#EEE;min-width:240px;height:100%;\"><br />\n    <div style=\"width:96%;margin:0 auto; border-top:6px solid #369;border-bottom: 6px solid #369;background:#DEF;\" >\n        <h3 style=\"margin-top:5px;background-color:#69C; font-weight:normal; color:#FFF; text-align:center; margin-bottom:5px; padding:10px; line-height:1.2; font-size:21px; text-transform:capitalize;\">[SUBJECT]</h3>\n        <div style=\"text-align:justify;background:#FFF;padding:20px; border-top:2px solid #369;min-height:200px;font-size:13px; border-bottom:2px solid #369;\">[CONTENT]<div style=\"clear:both\"></div></div>\n        <div style=\"clear:both;background:#69C;font-weight:normal; padding:10px;color:#FFF;text-align:center;font-size:11px;margin:5px 0px\">[FOOTER]<br/>[SIGNATURE]</div>\n    </div>\n<br /></div>',0);

/*Table structure for table `phplist_templateimage` */


CREATE TABLE `phplist_templateimage` (
  `id` int(11) NOT NULL auto_increment,
  `template` int(11) NOT NULL default '0',
  `mimetype` varchar(100) default NULL,
  `filename` varchar(100) default NULL,
  `data` longblob,
  `width` int(11) default NULL,
  `height` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `templateidx` (`template`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

/*Data for the table `phplist_templateimage` */

insert  into `phplist_templateimage`(`id`,`template`,`mimetype`,`filename`,`data`,`width`,`height`) values (1,0,'image/png','powerphplist.png','[encoded data, 5100 characters]',70,30),(2,1,'image/png','powerphplist.png','[encoded data, 5100 characters]',70,30),(3,1,'image/jpeg','http://www.effinet.com.pe/marketing/mercadolibre/aa.jpg','[encoded data, 419144 characters]',1500,1500);
