infortec DB leaked #TrojanFM #GForce Pakistan

DataBase leaked by #TrojanFM #GForce Pakistan
Greetz:- #Mr.Instinct, #Keyboard005, #XTAM4, #Sea Monster!!!



http://www.infortec.in

-- phpMyAdmin SQL Dump
-- version 3.3.7deb7
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 23-06-2013 a las 16:43:54
-- Versión del servidor: 5.1.66
-- Versión de PHP: 5.3.3-7+squeeze15

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de datos: `phplistdb`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_admin`
--

CREATE TABLE IF NOT EXISTS `phplist_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `loginname` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `namelc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedby` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `passwordchanged` date DEFAULT NULL,
  `superuser` tinyint(4) DEFAULT '0',
  `disabled` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `loginname` (`loginname`),
  KEY `loginnameidx` (`loginname`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Volcar la base de datos para la tabla `phplist_admin`
--

INSERT INTO `phplist_admin` (`id`, `loginname`, `namelc`, `email`, `created`, `modified`, `modifiedby`, `password`, `passwordchanged`, `superuser`, `disabled`) VALUES
(1, 'admin', 'admin', '[email protected]', '2013-01-13 21:03:05', '2013-03-17 13:35:56', 'admin', '*a123456B', '2013-01-13', 1, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_adminattribute`
--

CREATE TABLE IF NOT EXISTS `phplist_adminattribute` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listorder` int(11) DEFAULT NULL,
  `default_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `required` tinyint(4) DEFAULT NULL,
  `tablename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_adminattribute`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_admintoken`
--

CREATE TABLE IF NOT EXISTS `phplist_admintoken` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adminid` int(11) NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entered` int(11) NOT NULL,
  `expires` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=70 ;

--
-- Volcar la base de datos para la tabla `phplist_admintoken`
--

INSERT INTO `phplist_admintoken` (`id`, `adminid`, `value`, `entered`, `expires`) VALUES
(27, 1, '6618c8890d715c4367eacfc4ef93a202', 1358100799, '2013-01-13 23:13:19'),
(13, 1, '52b819198940f4511a5bc570bbde578f', 1358098966, '2013-01-13 22:42:46'),
(14, 1, '284e808426a7085a75b8537155c3667c', 1358098970, '2013-01-13 22:42:50'),
(30, 1, 'b731797c21df7ca08f694f5bc0686cc3', 1358101688, '2013-01-13 23:28:08'),
(31, 1, 'f336ee2801b0417999afed6bfdc388d2', 1358101699, '2013-01-13 23:28:19'),
(32, 1, '5aadb26cbc90675e4453aea40756b80d', 1358101715, '2013-01-13 23:28:35'),
(33, 1, 'd5a8a8653089b16f626c21e9e535b9df', 1358101719, '2013-01-13 23:28:39'),
(34, 1, '166b3e2b33d958bea40469b06f105ab7', 1358101729, '2013-01-13 23:28:49'),
(35, 1, 'f2355418e2a9e1f92df6a6c50481b1fb', 1358101944, '2013-01-13 23:32:24'),
(38, 1, '436f898d537275aa8b44ac2e75d9ca22', 1358103576, '2013-01-13 14:59:36'),
(39, 1, 'a51621581f149a43b1b3a06f096a0d1d', 1358103622, '2013-01-13 15:00:22'),
(40, 1, '3d44dc59e5717466407ae6bef3b4ecc1', 1358104103, '2013-01-13 15:08:23'),
(41, 1, 'c975b20f4b70a294577502cf938097e8', 1358104111, '2013-01-13 15:08:31'),
(42, 1, '8a99b790229831fea7a3f2740e28fde6', 1358104126, '2013-01-13 15:08:46'),
(43, 1, 'e8e42f77f9985258e103de541539e854', 1358104129, '2013-01-13 15:08:49'),
(44, 1, '0ba326bc76e5b6d37c3df59efc035c7a', 1358104142, '2013-01-13 15:09:02'),
(45, 1, '29a271a61f296f2e3c5b1fe7178242a3', 1358104147, '2013-01-13 15:09:07'),
(46, 1, '200d286f1a3f975d64bda817795d93e9', 1358104170, '2013-01-13 15:09:30'),
(53, 1, '1cea59f4f0617022393070b033cf9205', 1358104696, '2013-01-13 15:18:16'),
(54, 1, 'de5eb06b7c11837ed21832097a7ff752', 1358104704, '2013-01-13 15:18:24'),
(55, 1, '965a8b4e4638a0270272384fb36b75ee', 1358104706, '2013-01-13 15:18:26'),
(56, 1, 'e45584bfd1c3c1c24e731eaf5375b5ef', 1358104717, '2013-01-13 15:18:37'),
(58, 1, '20593dfeb4769751f4d68afe27a398b4', 1358104736, '2013-01-13 15:18:56'),
(59, 1, '97edd8addf18c488cbc66e0a893df4f1', 1358104744, '2013-01-13 15:19:04'),
(60, 1, '716d463453909658d17ef260280752f5', 1358104787, '2013-01-13 15:19:47'),
(61, 1, '9bc0b068e0d2c393ebe0a1049c614f88', 1358105045, '2013-01-13 15:24:05'),
(62, 1, 'd81ea7595911a13d128739742d753398', 1358105329, '2013-01-13 15:28:49'),
(63, 1, 'd0538f12f56231715f350a3a075759a0', 1358105344, '2013-01-13 15:29:04'),
(64, 1, '26d29d2695d618cd8916d0540bde04be', 1358106622, '2013-01-13 15:50:22'),
(65, 1, '40d5d72941829a9852bdd7cc619438ab', 1358108038, '2013-01-13 16:13:58'),
(66, 1, '609c70f6600e15a8d3fddd0154edeb9f', 1358108346, '2013-01-13 16:19:06'),
(67, 1, 'b966ee031effbf717048ffc530757e69', 1358108433, '2013-01-13 16:20:33'),
(68, 0, 'dc8112f757647e866ab948b1528f9a59', 1358108474, '2013-01-13 16:21:14'),
(69, 0, 'c0bb16b47566c8d797ae355b707b7ff4', 1358108478, '2013-01-13 16:21:18');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_admin_attribute`
--

CREATE TABLE IF NOT EXISTS `phplist_admin_attribute` (
  `adminattributeid` int(11) NOT NULL,
  `adminid` int(11) NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`adminattributeid`,`adminid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_admin_attribute`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_admin_task`
--

CREATE TABLE IF NOT EXISTS `phplist_admin_task` (
  `adminid` int(11) NOT NULL,
  `taskid` int(11) NOT NULL,
  `level` int(11) DEFAULT NULL,
  PRIMARY KEY (`adminid`,`taskid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_admin_task`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_attachment`
--

CREATE TABLE IF NOT EXISTS `phplist_attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `remotefile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mimetype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `size` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_attachment`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_bounce`
--

CREATE TABLE IF NOT EXISTS `phplist_bounce` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `header` text COLLATE utf8_unicode_ci,
  `data` blob,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `dateindex` (`date`),
  KEY `statusindex` (`status`(10))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_bounce`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_bounceregex`
--

CREATE TABLE IF NOT EXISTS `phplist_bounceregex` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `regex` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `action` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listorder` int(11) DEFAULT '0',
  `admin` int(11) DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `count` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `regex` (`regex`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_bounceregex`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_bounceregex_bounce`
--

CREATE TABLE IF NOT EXISTS `phplist_bounceregex_bounce` (
  `regex` int(11) NOT NULL,
  `bounce` int(11) NOT NULL,
  PRIMARY KEY (`regex`,`bounce`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_bounceregex_bounce`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_config`
--

CREATE TABLE IF NOT EXISTS `phplist_config` (
  `item` varchar(35) COLLATE utf8_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8_unicode_ci,
  `editable` tinyint(4) DEFAULT '1',
  `type` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_config`
--

INSERT INTO `phplist_config` (`item`, `value`, `editable`, `type`) VALUES
('version', '2.10.19', 0, NULL),
('updatelastcheck', '2013-06-23 16:43:12', 0, NULL),
('website', 'www.infortec.in', 0, NULL),
('domain', 'infortec.in', 0, NULL),
('xormask', '771152d0d533d594adb98a59f6efeda9', 0, NULL),
('admin_address', '[email protected]', 0, NULL),
('check_new_version', '7', 1, NULL),
('admin_addresses', '', 1, NULL),
('report_address', '[email protected]', 0, NULL),
('message_from_address', 'noreply@[DOMAIN]', 1, NULL),
('message_from_name', 'Webmaster', 1, NULL),
('message_replyto_address', 'noreply@[DOMAIN]', 1, NULL),
('hide_single_list', '1', 1, NULL),
('textline_width', '40', 1, NULL),
('textarea_dimensions', '10,40', 1, NULL),
('send_admin_copies', '0', 1, NULL),
('defaultsubscribepage', '1', 0, NULL),
('defaultmessagetemplate', '0', 1, NULL),
('subscribeurl', 'http://[WEBSITE]/lists/?p=subscribe', 1, NULL),
('unsubscribeurl', 'http://[WEBSITE]/lists/?p=unsubscribe', 1, NULL),
('blacklisturl', 'http://[WEBSITE]/lists/?p=blacklist', 1, NULL),
('confirmationurl', 'http://[WEBSITE]/lists/?p=confirm', 1, NULL),
('preferencesurl', 'http://[WEBSITE]/lists/?p=preferences', 1, NULL),
('forwardurl', 'http://[WEBSITE]/lists/?p=forward', 1, NULL),
('subscribesubject', 'Requerimos su Confirmacion ', 0, NULL),
('subscribemessage', 'Ya casi terminamos de darle la  bienvenida  a nuestros boletines ...\r\nAlguien, esperamos que usted, ha suscrito su dirección de correo electrónico a los siguientes boletines:\r\n[LISTS]\r\nSi esto es correcto, por favor haga click en el siguiente enlace para confirmar su suscripción.\r\nSin esta confirmación, usted no recibirá ningún boletín de parte nuestra.\r\n[CONFIRMATIONURL]\r\nSi usted no desea suscribirse a nuestros boletines, tranquilo no le enviaremos mas información,  simplemente borre este mensaje.\r\nGracias,\r\n\r\n  ', 0, NULL),
('unsubscribesubject', 'Hasta pronto y gracias ', 0, NULL),
('unsubscribemessage', 'Lamentamos su partida de nuestro sistema, lamentamos que haya decidido marcharse.\r\nUsted ha sido eliminado de nuestros boletines\r\nEste es el último email que usted recibirá desde nosotros, le hemos añadido a nuestra lista de \\"No enviar información\\", lo cual significa que nuestro sistema no le enviara más mensajes.\r\nSi usted desea seguir recibiendo nuestros mensajes, puede volverse a suscribir, vaya a la siguiente dirección [SUBSCRIBEURL] y siga los pasos.\r\nGracias\r\n\r\n  \r\n  ', 0, NULL),
('confirmationsubject', 'Bienvenido a nuestros boletines de noticias', 0, NULL),
('confirmationmessage', 'Bienvenido a nuestros boletines de noticias  \r\nConserve este correo como referencia.\r\nSu dirección de correo electrónico ha sido añadido a los siguientes boletines:\r\n[LISTS]\r\nPara actualizar sus datos y preferencias, por favor visite\r\n[PREFERENCESURL].\r\nSi usted no desea recibir ningún mensaje, de parte nuestra, por favor visite [UNSUBSCRIBEURL].\r\nGracias\r\n\r\n  \r\n  ', 0, NULL),
('updatesubject', '[notify] Cambios en sus detalles en nuestras listas', 0, NULL),
('updatemessage', 'Le informamos que de cambios hechos a sus detalles en nuestra base de datos.\r\nUsted está actualmente suscrito a las siguientes listas de boletines\r\n[LISTS]\r\n [CONFIRMATIONINFO]\r\n Su información en nuestro sistema es la siguiente:\r\n[USERDATA]\r\nSi esto no es correcto, por favor actualice su información en la siguiente dirección:\r\n[PREFERENCESURL]\r\nGracias\r\n\r\n  \r\n    ', 0, NULL),
('emailchanged_text', 'Después de actualizar sus detalles, su dirección de correo electrónico ha cambiado.\r\nPor favor confirme su nueva dirección de correo electrónico visitando esta pagina:\r\n[CONFIRMATIONURL]\r\n\r\n  ', 0, NULL),
('emailchanged_text_oldaddress', 'Por favor tenga en cuenta: cuando usted actualizo sus detalles su dirección de correo electrónico en nuestros registros cambio.\r\nUn mensaje ha sido enviado a su nueva dirección de correo electrónico con una URL para que confirme este cambio. Por favor visite la dirección enviada para activar su membresía a nuestra página.\r\n  ', 0, NULL),
('personallocation_subject', 'Su localizacion personal ', 0, NULL),
('personallocation_message', 'Usted ha cambiado su localización personal en sus detalles personales en nuestro sistema.\r\nSu localización personal es:\r\n[PREFERENCESURL]\r\nGracias.\r\n\r\n  ', 0, NULL),
('messagefooter', '--\r\nSi usted no desea seguir recibiendo nuestros mensajes, [UNSUBSCRIBE]\r\nPara actualizar sus preferencia y de suscribirse visite [PREFERENCES]\r\nPara reenviar este mensaje a alguien más [FORWARD]\r\n[USERTRACK]', 0, NULL),
('forwardfooter', '--\r\nEste mensaje ha sido reenviado a usted por [FORWARDEDBY].\r\nUsted no ha sido suscrito automáticamente a ningún boletín o lista de correo.\r\nSi desea suscribirse a nuestras listas de correo visite:\r\n[SUBSCRIBE]\r\nHaga click en [BLACKLIST] si desea rechazar cualquier mensaje de nuestras listas.\r\nGracias\r\n', 0, NULL),
('pageheader', '<link href="styles/phplist.css" type="text/css" rel="stylesheet">\n</head>\n<body bgcolor="#ffffff" background="images/bg.png">\n<a name="top"></a>\n<div align=center>\n<table cellspacing=0 cellpadding=0 width=710 border=0>\n<tr>\n<td bgcolor="#000000" rowspan=3><img height=1 alt="" src="images/transparent.png" width=1 border=0></td>\n<td bgcolor="#000000"><img height=1 alt="" src="images/transparent.png" width=708 border=0></td>\n<td bgcolor="#000000" rowspan=3><img height=1 alt="" src="images/transparent.png" width=1 border=0></td>\n</tr>\n\n<tr valign="top" align="left">\n<td>\n<!--TOP TABLE starts-->\n<TABLE cellSpacing=0 cellPadding=0 width=708 bgColor=#ffffff border=0>\n  <TR vAlign=top>\n    <TD colSpan=2 rowspan="2" height="63" background="images/topstrip.png"><a href="http://www.phplist.com" target="_blank"><img src="images/masthead.png" border=0 width=577 height=75></a></TD>\n    <TD align=left\n      background="images/topstrip.png" bgcolor="#F0D1A3"><FONT\n      size=-2>&nbsp;<I>powered by: </I><BR>&nbsp;<B>[<A class=powered\n      href="http://www.php.net/" target=_new><I>PHP</I></A>]</B> + <B>[<A\n      class=powered href="http://www.mysql.com/"\n      target=_new>mySQL</A>]</B></FONT></TD></TR>\n  <TR vAlign=bottom>\n    <TD vAlign=bottom width=132\n    background="images/topright.png" bgcolor="#F0D1A3"><SPAN\n      class=webblermenu>PHPlist</SPAN></TD></TR>\n  <TR>\n    <TD bgColor=#000000><IMG height=1 alt=""\n      src="images/transparent.png" width=20\n      border=0></TD>\n    <TD bgColor=#000000><IMG height=1 alt=""\n      src="images/transparent.png" width=576\n      border=0></TD>\n    <TD bgColor=#000000><IMG height=1 alt=""\n      src="images/transparent.png" width=132\n      border=0></TD></TR>\n  <TR vAlign=top>\n    <TD>&nbsp;</TD>\n<td><div align=left>\n<br />\n', 1, NULL),
('pagefooter', '</div>\n</td>\n<td>\n<div class="menutableright">\n\n</div>\n</td>\n</tr>\n\n\n\n\n<tr><td colspan="4">&nbsp;</td></tr>\n\n\n\n<tr><td colspan="4">&nbsp;</td></tr>\n</table>\n<!--TOP TABLE ends-->\n\n</td></tr>\n\n\n<tr>\n<td bgcolor="#000000" colspan=3><img height=1 alt="" src="images/transparent.png" width=1 border=0></td>\n</tr>\n\n<tr>\n<td bgcolor="#000000"><img height=1 alt="" src="images/transparent.png" width=1 border=0></td>\n<td bgcolor="#ff9900" class="bottom">&copy; <a href="http://phplist.com" target="_phplist" class="urhere">phpList limited</a> | <a class="urhere" href="http://www.phplist.com" target="_blank">phplist</a></td>\n<td bgcolor="#000000"><img height=1 alt="" src="images/transparent.png" width=1 border=0></td>\n</tr>\n\n<tr>\n<td bgcolor="#000000" colspan=3><img height=1 alt="" src="images/transparent.png" width=1 border=0></td>\n</tr>\n\n<tr>\n<td colspan=3><img height=3 alt="" src="images/transparent.png" width=1 border=0></td>\n</tr>\n\n<tr>\n<td colspan=3>\n&nbsp;\n</td>\n</tr>\n</tbody>\n</table>\n\n</div>\n</body></html>\n', 1, NULL),
('html_charset', 'UTF-8', 1, NULL),
('text_charset', 'UTF-8', 1, NULL),
('html_email_style', '\n  <style type="text/css">\n  body { font-size : 11px; font-family: Verdana, Arial, Helvetica, sans-serif; }\n  a { font-size: 11px; color: #ff6600; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; }\n  a:visited { color: #666666; }\n  a:hover {  text-decoration: underline; }\n  p { font-weight: normal; font-size: 11px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; }\n  h1 {font-weight: bold; font-size: 14px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none;}\n  h2 {font-weight: bold; font-size: 13px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none;}\n  h3 {font-weight: bold; font-size: 12px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; margin:0px; padding:0px;}\n  h4 {font-weight: bold; font-size: 11px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; margin:0px; padding:0px;}\n  hr {width : 100%; height : 1px; color: #ff9900; size:1px;}\n  .forwardform {margin: 0 0 0 0; padding: 0 0 0 0;}\n  .forwardinput {margin: 0 0 0 0; padding: 0 0 0 0;}\n  .forwardsubmit {margin: 0 0 0 0; padding: 0 0 0 0;}\n  div.emailfooter { font-size : 11px; font-family: Verdana, Arial, Helvetica, sans-serif; }\n  div.emailfooter a { font-size: 11px; color: #ff6600; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; }\n  </style>\n  ', 1, NULL),
('alwayssendtextto', 'mail.com\nemail.com', 1, NULL),
('fckeditor_width', '600', 1, NULL),
('fckeditor_height', '600', 1, NULL),
('subscribesubject:1', 'Requerimos su Confirmacion ', 0, NULL),
('subscribemessage:1', 'Ya casi terminamos de darle la  bienvenida  a nuestros boletines ...\r\nAlguien, esperamos que usted, ha suscrito su dirección de correo electrónico a los siguientes boletines:\r\n[LISTS]\r\nSi esto es correcto, por favor haga click en el siguiente enlace para confirmar su suscripción.\r\nSin esta confirmación, usted no recibirá ningún boletín de parte nuestra.\r\n[CONFIRMATIONURL]\r\nSi usted no desea suscribirse a nuestros boletines, tranquilo no le enviaremos mas información,  simplemente borre este mensaje.\r\nGracias,\r\n\r\n  ', 0, NULL),
('confirmationsubject:1', 'Bienvenido a nuestros boletines de noticias', 0, NULL),
('confirmationmessage:1', 'Bienvenido a nuestros boletines de noticias  \r\nConserve este correo como referencia.\r\nSu dirección de correo electrónico ha sido añadido a los siguientes boletines:\r\n[LISTS]\r\nPara actualizar sus datos y preferencias, por favor visite\r\n[PREFERENCESURL].\r\nSi usted no desea recibir ningún mensaje, de parte nuestra, por favor visite [UNSUBSCRIBEURL].\r\nGracias\r\n\r\n  \r\n  ', 0, NULL);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_eventlog`
--

CREATE TABLE IF NOT EXISTS `phplist_eventlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entered` datetime DEFAULT NULL,
  `page` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `entry` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `enteredidx` (`entered`),
  KEY `pageidx` (`page`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_eventlog`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_linktrack`
--

CREATE TABLE IF NOT EXISTS `phplist_linktrack` (
  `linkid` int(11) NOT NULL AUTO_INCREMENT,
  `messageid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `forward` text COLLATE utf8_unicode_ci,
  `firstclick` datetime DEFAULT NULL,
  `latestclick` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `clicked` int(11) DEFAULT '0',
  PRIMARY KEY (`linkid`),
  UNIQUE KEY `messageid` (`messageid`,`userid`,`url`),
  KEY `midindex` (`messageid`),
  KEY `uidindex` (`userid`),
  KEY `urlindex` (`url`),
  KEY `miduidindex` (`messageid`,`userid`),
  KEY `miduidurlindex` (`messageid`,`userid`,`url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_linktrack`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_linktrack_userclick`
--

CREATE TABLE IF NOT EXISTS `phplist_linktrack_userclick` (
  `linkid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `messageid` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data` text COLLATE utf8_unicode_ci,
  `date` datetime DEFAULT NULL,
  KEY `linkindex` (`linkid`),
  KEY `uidindex` (`userid`),
  KEY `midindex` (`messageid`),
  KEY `linkuserindex` (`linkid`,`userid`),
  KEY `linkusermessageindex` (`linkid`,`userid`,`messageid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_linktrack_userclick`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_list`
--

CREATE TABLE IF NOT EXISTS `phplist_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `entered` datetime DEFAULT NULL,
  `listorder` int(11) DEFAULT NULL,
  `prefix` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rssfeed` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `active` tinyint(4) DEFAULT NULL,
  `owner` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `nameidx` (`name`),
  KEY `listorderidx` (`listorder`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Volcar la base de datos para la tabla `phplist_list`
--

INSERT INTO `phplist_list` (`id`, `name`, `description`, `entered`, `listorder`, `prefix`, `rssfeed`, `modified`, `active`, `owner`) VALUES
(1, 'test', 'List for testing.', '2013-01-13 21:03:05', 0, NULL, NULL, '2013-01-14 04:28:39', 0, 1),
(2, 'Pruebas', 'Lista de pruebas', '2013-01-13 14:18:37', 0, '', '', '2013-01-13 20:18:37', 1, 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_listmessage`
--

CREATE TABLE IF NOT EXISTS `phplist_listmessage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `messageid` int(11) NOT NULL,
  `listid` int(11) NOT NULL,
  `entered` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `messageid` (`messageid`,`listid`),
  KEY `listmessageidx` (`listid`,`messageid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_listmessage`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_listrss`
--

CREATE TABLE IF NOT EXISTS `phplist_listrss` (
  `listid` int(11) NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `entered` datetime NOT NULL,
  `info` text COLLATE utf8_unicode_ci,
  KEY `listididx` (`listid`),
  KEY `enteredidx` (`entered`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_listrss`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_listuser`
--

CREATE TABLE IF NOT EXISTS `phplist_listuser` (
  `userid` int(11) NOT NULL,
  `listid` int(11) NOT NULL,
  `entered` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`userid`,`listid`),
  KEY `userenteredidx` (`userid`,`entered`),
  KEY `userlistenteredidx` (`userid`,`listid`,`entered`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_listuser`
--

INSERT INTO `phplist_listuser` (`userid`, `listid`, `entered`, `modified`) VALUES
(1, 2, NULL, '2013-01-13 20:18:56');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_message`
--

CREATE TABLE IF NOT EXISTS `phplist_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '(no subject)',
  `fromfield` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `tofield` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `replyto` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `message` longtext COLLATE utf8_unicode_ci,
  `textmessage` longtext COLLATE utf8_unicode_ci,
  `footer` text COLLATE utf8_unicode_ci,
  `entered` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `embargo` datetime DEFAULT NULL,
  `repeatinterval` int(11) DEFAULT '0',
  `repeatuntil` datetime DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `userselection` text COLLATE utf8_unicode_ci,
  `sent` datetime DEFAULT NULL,
  `htmlformatted` tinyint(4) DEFAULT '0',
  `sendformat` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `template` int(11) DEFAULT NULL,
  `processed` mediumint(8) unsigned DEFAULT '0',
  `astext` int(11) DEFAULT '0',
  `ashtml` int(11) DEFAULT '0',
  `astextandhtml` int(11) DEFAULT '0',
  `aspdf` int(11) DEFAULT '0',
  `astextandpdf` int(11) DEFAULT '0',
  `viewed` int(11) DEFAULT '0',
  `bouncecount` int(11) DEFAULT '0',
  `sendstart` datetime DEFAULT NULL,
  `rsstemplate` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `owner` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Volcar la base de datos para la tabla `phplist_message`
--

INSERT INTO `phplist_message` (`id`, `subject`, `fromfield`, `tofield`, `replyto`, `message`, `textmessage`, `footer`, `entered`, `modified`, `embargo`, `repeatinterval`, `repeatuntil`, `status`, `userselection`, `sent`, `htmlformatted`, `sendformat`, `template`, `processed`, `astext`, `ashtml`, `astextandhtml`, `aspdf`, `astextandpdf`, `viewed`, `bouncecount`, `sendstart`, `rsstemplate`, `owner`) VALUES
(1, 'mensaje de prueba', 'Capacitacion [email protected]', '', '', '<p>Mensaje de peurbe</p>', '', '--\r\nSi usted no desea seguir recibiendo nuestros mensajes, [UNSUBSCRIBE]\r\nPara actualizar sus preferencia y de suscribirse visite [PREFERENCES]\r\nPara reenviar este mensaje a alguien más [FORWARD]\r\n[USERTRACK]', '2013-01-13 14:19:04', '2013-01-13 20:30:13', '2013-01-13 14:19:00', 0, '2013-01-13 14:19:04', 'draft', NULL, NULL, 1, 'HTML', 0, 0, 3, 3, 0, 0, 0, 1, 0, NULL, '', 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_messagedata`
--

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

--
-- Volcar la base de datos para la tabla `phplist_messagedata`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_message_attachment`
--

CREATE TABLE IF NOT EXISTS `phplist_message_attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `messageid` int(11) NOT NULL,
  `attachmentid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `messageidx` (`messageid`),
  KEY `messageattidx` (`messageid`,`attachmentid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_message_attachment`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_rssitem`
--

CREATE TABLE IF NOT EXISTS `phplist_rssitem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `link` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `list` int(11) NOT NULL,
  `added` datetime DEFAULT NULL,
  `processed` mediumint(8) unsigned DEFAULT '0',
  `astext` int(11) DEFAULT '0',
  `ashtml` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `titlelinkidx` (`title`,`link`),
  KEY `titleidx` (`title`),
  KEY `listidx` (`list`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_rssitem`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_rssitem_data`
--

CREATE TABLE IF NOT EXISTS `phplist_rssitem_data` (
  `itemid` int(11) NOT NULL,
  `tag` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `data` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`itemid`,`tag`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_rssitem_data`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_rssitem_user`
--

CREATE TABLE IF NOT EXISTS `phplist_rssitem_user` (
  `itemid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `entered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`itemid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_rssitem_user`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_sendprocess`
--

CREATE TABLE IF NOT EXISTS `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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `page` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_sendprocess`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_subscribepage`
--

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

--
-- Volcar la base de datos para la tabla `phplist_subscribepage`
--

INSERT INTO `phplist_subscribepage` (`id`, `title`, `active`, `owner`) VALUES
(1, 'Suscribase a nuestros boletines de Noticias', 1, 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_subscribepage_data`
--

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

--
-- Volcar la base de datos para la tabla `phplist_subscribepage_data`
--

INSERT INTO `phplist_subscribepage_data` (`id`, `name`, `data`) VALUES
(1, 'footer', '</div>\r\n</td>\r\n<td>\r\n<div class="menutableright">\r\n\r\n</div>\r\n</td>\r\n</tr>\r\n\r\n\r\n\r\n\r\n<tr><td colspan="4">&nbsp;</td></tr>\r\n\r\n\r\n\r\n<tr><td colspan="4">&nbsp;</td></tr>\r\n</table>\r\n<!--TOP TABLE ends-->\r\n\r\n</td></tr>\r\n\r\n\r\n<tr>\r\n<td bgcolor="#000000" colspan=3><img height=1 alt="" src="images/transparent.png" width=1 border=0></td>\r\n</tr>\r\n\r\n<tr>\r\n<td bgcolor="#000000"><img height=1 alt="" src="images/transparent.png" width=1 border=0></td>\r\n<td bgcolor="#ff9900" class="bottom">&copy; <a href="http://phplist.com" target="_phplist" class="urhere">phpList limited</a> | <a class="urhere" href="http://www.phplist.com" target="_blank">phplist</a></td>\r\n<td bgcolor="#000000"><img height=1 alt="" src="images/transparent.png" width=1 border=0></td>\r\n</tr>\r\n\r\n<tr>\r\n<td bgcolor="#000000" colspan=3><img height=1 alt="" src="images/transparent.png" width=1 border=0></td>\r\n</tr>\r\n\r\n<tr>\r\n<td colspan=3><img height=3 alt="" src="images/transparent.png" width=1 border=0></td>\r\n</tr>\r\n\r\n<tr>\r\n<td colspan=3>\r\n&nbsp;\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n\r\n</div>\r\n</body></html>\r\n'),
(1, 'thankyoupage', '<h3>Gracias por suscribirse a nuestros boletines.</h3>\r\nSu email ha sido añadido a nuestro sistema. Un mensaje ha sido enviado a su direccion de correo electronico, recuerde hacer click en el enlace requerido para confirmar su suscripcion.'),
(1, 'intro', 'Suscibase a una o mas de nuestras listas o boletines de noticias, usando el formulario de abajo:'),
(1, 'header', '<link href="styles/phplist.css" type="text/css" rel="stylesheet">\r\n</head>\r\n<body bgcolor="#ffffff" background="images/bg.png">\r\n<a name="top"></a>\r\n<div align=center>\r\n<table cellspacing=0 cellpadding=0 width=710 border=0>\r\n<tr>\r\n<td bgcolor="#000000" rowspan=3><img height=1 alt="" src="images/transparent.png" width=1 border=0></td>\r\n<td bgcolor="#000000"><img height=1 alt="" src="images/transparent.png" width=708 border=0></td>\r\n<td bgcolor="#000000" rowspan=3><img height=1 alt="" src="images/transparent.png" width=1 border=0></td>\r\n</tr>\r\n\r\n<tr valign="top" align="left">\r\n<td>\r\n<!--TOP TABLE starts-->\r\n<TABLE cellSpacing=0 cellPadding=0 width=708 bgColor=#ffffff border=0>\r\n  <TR vAlign=top>\r\n    <TD colSpan=2 rowspan="2" height="63" background="images/topstrip.png"><a href="http://www.phplist.com" target="_blank"><img src="images/masthead.png" border=0 width=577 height=75></a></TD>\r\n    <TD align=left\r\n      background="images/topstrip.png" bgcolor="#F0D1A3"><FONT\r\n      size=-2>&nbsp;<I>powered by: </I><BR>&nbsp;<B>[<A class=powered\r\n      href="http://www.php.net/" target=_new><I>PHP</I></A>]</B> + <B>[<A\r\n      class=powered href="http://www.mysql.com/"\r\n      target=_new>mySQL</A>]</B></FONT></TD></TR>\r\n  <TR vAlign=bottom>\r\n    <TD vAlign=bottom width=132\r\n    background="images/topright.png" bgcolor="#F0D1A3"><SPAN\r\n      class=webblermenu>PHPlist</SPAN></TD></TR>\r\n  <TR>\r\n    <TD bgColor=#000000><IMG height=1 alt=""\r\n      src="images/transparent.png" width=20\r\n      border=0></TD>\r\n    <TD bgColor=#000000><IMG height=1 alt=""\r\n      src="images/transparent.png" width=576\r\n      border=0></TD>\r\n    <TD bgColor=#000000><IMG height=1 alt=""\r\n      src="images/transparent.png" width=132\r\n      border=0></TD></TR>\r\n  <TR vAlign=top>\r\n    <TD>&nbsp;</TD>\r\n<td><div align=left>\r\n<br />\r\n'),
(1, 'language_file', 'spanish.inc'),
(1, 'title', 'Suscribase a nuestros boletines de Noticias'),
(1, 'button', 'Subscribe to the Selected Newsletters'),
(1, 'htmlchoice', 'checkforhtml'),
(1, 'emaildoubleentry', 'yes'),
(1, 'attributes', '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_task`
--

CREATE TABLE IF NOT EXISTS `phplist_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `page` (`page`),
  KEY `pageidx` (`page`),
  KEY `pagetypeidx` (`page`,`type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=51 ;

--
-- Volcar la base de datos para la tabla `phplist_task`
--

INSERT INTO `phplist_task` (`id`, `page`, `type`) VALUES
(1, 'adminattributes', 'system'),
(2, 'attributes', 'system'),
(3, 'upgrade', 'system'),
(4, 'configure', 'system'),
(5, 'spage', 'system'),
(6, 'spageedit', 'system'),
(7, 'defaultconfig', 'system'),
(8, 'defaults', 'system'),
(9, 'initialise', 'system'),
(10, 'bounces', 'system'),
(11, 'bounce', 'system'),
(12, 'processbounces', 'system'),
(13, 'eventlog', 'system'),
(14, 'reconcileusers', 'system'),
(15, 'getrss', 'system'),
(16, 'viewrss', 'system'),
(17, 'purgerss', 'system'),
(18, 'setup', 'system'),
(19, 'dbcheck', 'system'),
(20, 'list', 'list'),
(21, 'editlist', 'list'),
(22, 'members', 'list'),
(23, 'user', 'user'),
(24, 'users', 'user'),
(25, 'dlusers', 'user'),
(26, 'editattributes', 'user'),
(27, 'usercheck', 'user'),
(28, 'import1', 'user'),
(29, 'import2', 'user'),
(30, 'import3', 'user'),
(31, 'import4', 'user'),
(32, 'import', 'user'),
(33, 'export', 'user'),
(34, 'massunconfirm', 'user'),
(35, 'message', 'message'),
(36, 'messages', 'message'),
(37, 'processqueue', 'message'),
(38, 'send', 'message'),
(39, 'preparesend', 'message'),
(40, 'sendprepared', 'message'),
(41, 'template', 'message'),
(42, 'templates', 'message'),
(43, 'statsmgt', 'clickstats'),
(44, 'mclicks', 'clickstats'),
(45, 'uclicks', 'clickstats'),
(46, 'userclicks', 'clickstats'),
(47, 'mviews', 'clickstats'),
(48, 'statsoverview', 'clickstats'),
(49, 'admins', 'admin'),
(50, 'admin', 'admin');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_template`
--

CREATE TABLE IF NOT EXISTS `phplist_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `template` longblob,
  `listorder` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_template`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_templateimage`
--

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

--
-- Volcar la base de datos para la tabla `phplist_templateimage`
--

INSERT INTO `phplist_templateimage` (`id`, `template`, `mimetype`, `filename`, `data`, `width`, `height`) VALUES
(1, 0, 'image/png', 'powerphplist.png', 0x6956424f5277304b47676f414141414e5355684555674141414559414141416543414d414141436d4c5a6773414141444146424d564558597836666d664758666e6d43636847643356445069706d726f755949484277653371704e6c566b546d635748646d4672665254656f6a57334970586e32354c376d6f335461476865366d584c436d6d2b376c476e6e746e377378355378683175736b33616b6445664269465074794a66676f32626a7157376b726e546a716e4470726f4b3170496e764f44525254454b46656d6e757a614174495258656e46374b714948666e324b4863566a74795a6a6e7148726e6b6e4c6870476a6e743448654d797a6c6e6e487231724c6b6d5733574141446c6c477555666d50634b534d6346784c6e754943556431663033376b714a69447176343773785a4c594151484c744a4c664f5449374b6872496e6e4871775937685455487a327247446256547a3237586b7233584a764b506e6733487579707a6f756f5072776f2f68586b337831717a71774976697a6176727770447530617471595654716e6f4264547a37516c46767174596267535431346357506172333368596b727730715a4b516a6a646d6c3132586b50537635324e6848506f76496a6a72484c5a44517a3033626273785a486371336667516a73554567393259556d55696e6a67704762767a36505a74596a63703354723262574561557a7a334c5878314b68464f693770766f6a79324b333134727a6a76597a6a663245774c43627730715276557a6232354d426f536933676f6d58646d46766c735868424f7a496948787277303669386f487a78317172717749766d6a57743461566146586a6e6f70487a757935373234722f7375704d354d797a656d6c337176347278314b626f7534626d7559546f736f48687961546970576e676f57546d7448766d7333726a72584c6d736e32796630374f6b46663133377a7378356277314b766d73586a6f713333757a7154737870546f756f6a646c31766c5a6c76737770447931367244745a726b624671336a6d486855555868706d72624878726958302f6c736e7269726e663134722f747936425a5069586f7559666c736e6a6d735876696d6d5a6151536a6971477669706d6e68706d6e323437336d736e6a6f7649627478356e656d3133773061524b4e434469705772727735547376593771766f6b4f4441726857556e7177492f69703276656d567a6c706e54727735486a7133447931374469686c2f7853555076626c334e75353367554550665144506870576e6c68326e776933546f6958446f7559587432376e30334c4f316e5833624642486a6c6d626143416e726f485859434166427335665771585873785a626e77497a6a594650727735446477703370765979556144374f6e323752706e6a5870584473774a545770472f67736e336c774a4879344c763033376a69614662646d567a636c316b4441674545417749414141434a4a7a43734141414141574a4c52305141694155645341414141416c7753466c7a4141414c45674141437849423074312b2f414141414164305355314642394d4b46516f6c4377652f39355141414158755355524256486963725a4635584a4a33484d6456486f646d5a68636d4371627a52464e525362477043486b32744634367936795179697570374c444470536c67706f566d486a4e41586933545773304f6a3871743071784a7879686e314c5a676131753274566f75323930496e33312f44376a31393759507a2b2f372b78362f37357676383373736a50394234784d79576868662f6d737867745367307362727377456a4d52676b426f6d6442497a425947646e6b4944737a4c76456c4a57677750425341736c6a45454c434474597878516671306c4b4251504252446d41672b346c424b42516154444c7451736b7276726c4545496d616b43684a41414d516453574247525457312f4e777646636f302b446c67327a6e4d6678645753386b63437173336e6f4d4c4161473754785958772b2b544f6739567538394e6a68594c3653397078616f533957434a2b696c66454138716a507572446d59775a503179737035592b5579486857797549387a376f4e68506f5049594c302b5670435258665535794d61756f715a422f62504b526f4767636374314f6d43735150446e355653656c5257476a5a587a714a6833427072474373316868616168597067564b7073795670676d417a55785a6c2f66676c5435724e4e6f4d6334413861674d4270724757356242347a4634336b534367544f755967774d4177384d647048494f4f4d4d4270574865686930487138746a594252422b6e484c635956437247595231556f464f687578417076544d777256356a75527047684f5468784e39374f6341373869776f786c53635751304450726b54445650476c4e4d4451614f765877364c5261494777694944592f2f614a4b764c455968534b616159546e5433385252315656523156555671453065763163726e2b6b76776132755236666144386b7435616a724c36546e44312b76352b6553637136432f702b2f58366134487951446a5a4c33654e7175796f36756a59666f54536831374b756d396f614d6836434a6b2b61324c7647304c4f5244525237594f444b49334f77365036716e41373071493036644151594f69677556774f68385869734f496530756b5064527769594e366c3938306a697a5a447559394f6e79556133376d52506d4d723341354f4a763036447a596a576d79766f42773648544261726261477938714e4f2f6d306978555871745665304846794d2f3963474d37712b6b34625274596b61416e4e457545375a2f2b3042493963757a494c392f7435567554572f57536358564868455357464b6d4263566170755474654f344f445179617a544431577143354d35334a7268304c7336316d647253475252676b71566f314b70547248484e3674493550307a6e6a2b66627a2f2f7a504c644d6536525274755947462b4b613436724b3243536b704b36574e3344734f6c596d63464a53634d36546b457a524474597232386b6155522b535951414d2b2f4d5874795743467179612b506a44355159393862584a6b7452416a413955696d5464544e59657236396d336c795474763564706a47726131743667725770327351526e705a32765a6847357047476b5975435a76352f48484572535078386474586c65447035374b5655756e6c79314c41744c516f76786835744842507750314a5479666433784d51454d6370434a69365a38556a7a70633938464a2b5371577952616b38785461753750484e777645733277536e41305866784d636a7a444d4b64437462576742446f564361622b6243312b486b6a6e774c686a755a5535413544527a645567724355416a4e424d78766c4f6b6c496731386f4e556865586c46674c454e4d68557067496b414e56737952365a314d626e4d7270487765356d63676e766875557a4c3878455259534b525877516868486b63394e6f47587966507248474e5456356548734a51676b78567743516a4262574842732b315050376d334b6e446f584763754941356f584d6f6b435942427056665377624d3275585a73667933516b4a535066426c49532b4b59694a68476c4d78475442586d7378794f7a337465484254557a744d553966556c4978534a4247625a43704f46786e582f6e34754e65534e46792b4b6250483054596c48664f474476305055726a514235754e745a6a5872574b6472746d3044444c634f5170516e6954547054766232396b3554707250487730495770432b7a575856694e56746a6b2b68316577704d30325275425577316f596271616a63754b374f6d75727064783248574e565154767a414e72696d4a334c577278472b3343462f3939546f63332b3952675a4d395532747656302f5a68532f4a4a6a6f624767415461314a4b374e4c75384a4e754b6246756353787558596f7036565152435244416548366556624a7530344a6c575242376550376f667a76326c6d39575a4d495052474e734c4742477a55714c6167397769306f627662453433504b5830625452305a5355305130506e4234386348643374374859394c323778522f4678616b6e46746859654c6e6b7036536c76623362337466556d66492b594b4b6a382f4f6a7a59617754786266414876553063572f7472447954754b6866513444447355446f4f4a69423466695241472f4e5272712b6559323467474d4936476a61434535746a71322b76767a76516f4669776745614d426859414474446d566e457975392b4843474f50685059797467584d7a7968325a2b626131586f627279384a334576454e6e7938724b4846355632623745773456386c31666b622b357a41637a2f6f72384167336f7a5a465a5833473041414141415355564f524b35435949493d, 70, 30);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_urlcache`
--

CREATE TABLE IF NOT EXISTS `phplist_urlcache` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lastmodified` int(11) DEFAULT NULL,
  `added` datetime DEFAULT NULL,
  `content` mediumtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `urlindex` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_urlcache`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_usermessage`
--

CREATE TABLE IF NOT EXISTS `phplist_usermessage` (
  `messageid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `entered` datetime NOT NULL,
  `viewed` datetime DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`userid`,`messageid`),
  KEY `messageidindex` (`messageid`),
  KEY `useridindex` (`userid`),
  KEY `enteredindex` (`entered`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_usermessage`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_userstats`
--

CREATE TABLE IF NOT EXISTS `phplist_userstats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unixdate` int(11) DEFAULT NULL,
  `item` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listid` int(11) DEFAULT '0',
  `value` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `entry` (`unixdate`,`item`,`listid`),
  KEY `dateindex` (`unixdate`),
  KEY `itemindex` (`item`),
  KEY `listindex` (`listid`),
  KEY `listdateindex` (`listid`,`unixdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_userstats`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_user_attribute`
--

CREATE TABLE IF NOT EXISTS `phplist_user_attribute` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listorder` int(11) DEFAULT NULL,
  `default_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `required` tinyint(4) DEFAULT NULL,
  `tablename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `nameindex` (`name`),
  KEY `idnameindex` (`id`,`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Volcar la base de datos para la tabla `phplist_user_attribute`
--

INSERT INTO `phplist_user_attribute` (`id`, `name`, `type`, `listorder`, `default_value`, `required`, `tablename`) VALUES
(1, 'nombre', 'textline', 0, '', 1, 'nombre');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_user_blacklist`
--

CREATE TABLE IF NOT EXISTS `phplist_user_blacklist` (
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `added` datetime DEFAULT NULL,
  UNIQUE KEY `email` (`email`),
  KEY `emailidx` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_user_blacklist`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_user_blacklist_data`
--

CREATE TABLE IF NOT EXISTS `phplist_user_blacklist_data` (
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `data` text COLLATE utf8_unicode_ci,
  UNIQUE KEY `email` (`email`),
  KEY `emailidx` (`email`),
  KEY `emailnameidx` (`email`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_user_blacklist_data`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_user_message_bounce`
--

CREATE TABLE IF NOT EXISTS `phplist_user_message_bounce` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `message` int(11) NOT NULL,
  `bounce` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `umbindex` (`user`,`message`,`bounce`),
  KEY `useridx` (`user`),
  KEY `msgidx` (`message`),
  KEY `bounceidx` (`bounce`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_user_message_bounce`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_user_message_forward`
--

CREATE TABLE IF NOT EXISTS `phplist_user_message_forward` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `message` int(11) NOT NULL,
  `forward` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `usermessageidx` (`user`,`message`),
  KEY `useridx` (`user`),
  KEY `messageidx` (`message`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_user_message_forward`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_user_rss`
--

CREATE TABLE IF NOT EXISTS `phplist_user_rss` (
  `userid` int(11) NOT NULL,
  `last` datetime DEFAULT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_user_rss`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_user_user`
--

CREATE TABLE IF NOT EXISTS `phplist_user_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `confirmed` tinyint(4) DEFAULT '0',
  `blacklisted` tinyint(4) DEFAULT '0',
  `bouncecount` int(11) DEFAULT '0',
  `entered` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `uniqid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `htmlemail` tinyint(4) DEFAULT '0',
  `subscribepage` int(11) DEFAULT NULL,
  `rssfrequency` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `passwordchanged` date DEFAULT NULL,
  `disabled` tinyint(4) DEFAULT '0',
  `extradata` text COLLATE utf8_unicode_ci,
  `foreignkey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `foreignkey` (`foreignkey`),
  KEY `idx_phplist_user_user_uniqid` (`uniqid`),
  KEY `emailidx` (`email`),
  KEY `enteredindex` (`entered`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Volcar la base de datos para la tabla `phplist_user_user`
--

INSERT INTO `phplist_user_user` (`id`, `email`, `confirmed`, `blacklisted`, `bouncecount`, `entered`, `modified`, `uniqid`, `htmlemail`, `subscribepage`, `rssfrequency`, `password`, `passwordchanged`, `disabled`, `extradata`, `foreignkey`) VALUES
(1, '[email protected]', 1, 0, 0, '2013-01-13 14:18:56', '2013-01-13 20:18:56', '0231ee78b1aba0ff294952e9222f5664', 0, NULL, '', '', '2013-01-13', 0, '', '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_user_user_attribute`
--

CREATE TABLE IF NOT EXISTS `phplist_user_user_attribute` (
  `attributeid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `value` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`attributeid`,`userid`),
  KEY `userindex` (`userid`),
  KEY `attindex` (`attributeid`),
  KEY `userattid` (`attributeid`,`userid`),
  KEY `attuserid` (`userid`,`attributeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `phplist_user_user_attribute`
--

INSERT INTO `phplist_user_user_attribute` (`attributeid`, `userid`, `value`) VALUES
(1, 1, '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `phplist_user_user_history`
--

CREATE TABLE IF NOT EXISTS `phplist_user_user_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `summary` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `detail` text COLLATE utf8_unicode_ci,
  `systeminfo` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `userididx` (`userid`),
  KEY `dateidx` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `phplist_user_user_history`
--