--
-- Host: localhost    Database: phplist
-- ------------------------------------------------------


--
-- Table structure for table `phplist_admin`
--

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

--
-- Dumping data for table `phplist_admin`
--

INSERT INTO `phplist_admin` VALUES (1,'admin','admin','Christiaan.deVries@hetg.ie','2014-03-27 18:15:05','2014-03-27 17:15:05',NULL,'3a11ee22381c682f40aa05e5db99336f','2014-03-27',1,0,NULL);

--
-- Table structure for table `phplist_admin_attribute`
--

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

--
-- Dumping data for table `phplist_admin_attribute`
--


--
-- Table structure for table `phplist_admin_password_request`
--

CREATE TABLE `phplist_admin_password_request` (
  `id_key` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `admin` int(11) DEFAULT NULL,
  `key_value` varchar(32) NOT NULL,
  PRIMARY KEY (`id_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_admin_password_request`
--


--
-- Table structure for table `phplist_adminattribute`
--

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

--
-- Dumping data for table `phplist_adminattribute`
--


--
-- Table structure for table `phplist_admintoken`
--

CREATE TABLE `phplist_admintoken` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adminid` int(11) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  `entered` int(11) NOT NULL,
  `expires` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_admintoken`
--

INSERT INTO `phplist_admintoken` VALUES (68,1,'fc08d83934547f0d422f290e6437c7e4',1395999540,'2014-03-28 11:39:00'),(69,1,'ba0f80a086468d49fb7821fd177e7247',1395999549,'2014-03-28 11:39:09'),(70,1,'f39c9405bf9f14ad148b3954e3b2b35d',1395999571,'2014-03-28 11:39:31'),(71,1,'a9cef8eca421b11a23ca4a5541a738f9',1395999571,'2014-03-28 11:39:31'),(72,1,'e7b025bc28628962abe3248604ad582c',1395999574,'2014-03-28 11:39:34'),(73,1,'2dec362bf3319f25223f119e05b5d878',1395999656,'2014-03-28 11:40:56'),(75,1,'77d70e6d0f3745121dcef9042402b141',1395999676,'2014-03-28 11:41:16'),(77,1,'63273043a7da77d95bd98bfb125723df',1395999698,'2014-03-28 11:41:38'),(79,1,'0f0cf80c9287564a8a50afd1ba28dc29',1395999710,'2014-03-28 11:41:50'),(80,1,'414be7531be16e54401fa15bccf22666',1395999774,'2014-03-28 11:42:54'),(82,1,'bfe6cd2cf224621978b3446e82d8254a',1395999797,'2014-03-28 11:43:17'),(83,1,'41faf7a7a7529a89635dbf9814331392',1395999907,'2014-03-28 11:45:07'),(84,1,'76eb4cd377ffcfbfde8d4ab2d9b0800c',1395999907,'2014-03-28 11:45:07'),(85,1,'18774a3d21d77fb31a7f237f88c7ff25',1395999922,'2014-03-28 11:45:22'),(86,1,'f9ccbd55b105d22755616c391a68dd03',1395999924,'2014-03-28 11:45:24'),(87,1,'479af5530a3d83b91759535c7ab27057',1395999964,'2014-03-28 11:46:04'),(88,1,'671338ee8c24f34d874ba57a97667863',1395999967,'2014-03-28 11:46:07'),(89,1,'6040307d155a708130fd0fd297d71a95',1395999983,'2014-03-28 11:46:23'),(90,1,'e2938a4a697b95f32ea9b916f57561cd',1396000013,'2014-03-28 11:46:53'),(91,1,'518c73086db6a271aae52aca0437dcbc',1396000013,'2014-03-28 11:46:53'),(92,1,'0905da79a88360d08d7e6842cb3f2b17',1396000015,'2014-03-28 11:46:55'),(93,1,'c74bd8af12b0c1d029683f658f4c7d44',1396000028,'2014-03-28 11:47:08'),(94,1,'0fbb5aafd00db08e9b41163516a15a0b',1396000037,'2014-03-28 11:47:17'),(95,1,'e8d9a458683016223cf5e5e1b57e0146',1396000037,'2014-03-28 11:47:17'),(96,1,'9a9a7629fca6e2f82a4743437ecf925e',1396000042,'2014-03-28 11:47:22'),(97,1,'d28a13300da218d673320e5637231abe',1396000042,'2014-03-28 11:47:22'),(98,1,'d8bf891306008dddab5d132c224f130b',1396000045,'2014-03-28 11:47:25'),(99,1,'57011f6c436d0bfdc6859003753f0e1b',1396000045,'2014-03-28 11:47:25'),(100,1,'b33386cfb084d7d802cde3bfbe73b6a4',1396000361,'2014-03-28 11:52:41'),(101,1,'9fea1fefb16bc28f2ec1ee46bebaddcf',1396000361,'2014-03-28 11:52:41'),(102,1,'d46526d205a18a298cbb418f038cc1b4',1396000367,'2014-03-28 11:52:47'),(103,1,'1b74f123ed6e715bd43d25371a081cb8',1396000369,'2014-03-28 11:52:49'),(104,1,'d4de01a698745aa6600765b65ae7146e',1396000809,'2014-03-28 12:00:09'),(105,1,'ddfe768c4672a274468da95441d3c5d7',1396001477,'2014-03-28 12:11:17'),(106,1,'acbf2a688013e18afa005c0c3b26bf72',1396001481,'2014-03-28 12:11:21'),(107,1,'e5e8a31defb6d1da990943d11b57f17b',1396001489,'2014-03-28 12:11:29'),(108,1,'5936486e50093581eba987e585c41992',1396001565,'2014-03-28 12:12:45'),(109,1,'89005018539b68f2aa0c5a04002034d5',1396001565,'2014-03-28 12:12:45'),(110,1,'46a1e5c2f17d16a226e18c8b3cb03b38',1396001568,'2014-03-28 12:12:48'),(111,1,'71a71a7b9f4f25dca8a61e3535db5699',1396001568,'2014-03-28 12:12:48'),(112,1,'3cc41c524cacf49dabe6651f108319e1',1396001570,'2014-03-28 12:12:50'),(113,1,'d5777e93c3e2a43b8336ff82bb4a235b',1396001570,'2014-03-28 12:12:50'),(114,1,'947c8f09a49dc14f50dcc61dc10368ce',1396001574,'2014-03-28 12:12:54'),(115,1,'0b6d1c960e648a6e3a9196816120ce50',1396001602,'2014-03-28 12:13:22'),(116,1,'781f161dda20a1bb5d712dd3fa9ced9d',1396001652,'2014-03-28 12:14:12'),(118,1,'d6b2959d0ce1eb5ef7ecccc373d54926',1396002888,'2014-03-28 12:34:48'),(119,0,'74d1015d3ec3c40f34fbeb4727601fc8',1414415095,'2014-10-27 15:04:55'),(120,0,'0cb9249d918e84bb087a245bdbce5965',1414787256,'2014-10-31 22:27:36'),(121,0,'e00771580080474d65f21b45070c67c1',1420025347,'2014-12-31 13:29:07');

--
-- Table structure for table `phplist_attachment`
--

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

--
-- Dumping data for table `phplist_attachment`
--


--
-- Table structure for table `phplist_bounce`
--

CREATE TABLE `phplist_bounce` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `header` text,
  `data` blob,
  `status` varchar(255) DEFAULT NULL,
  `comment` text,
  PRIMARY KEY (`id`),
  KEY `dateindex` (`date`),
  KEY `statusidx` (`status`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_bounce`
--


--
-- Table structure for table `phplist_bounceregex`
--

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

--
-- Dumping data for table `phplist_bounceregex`
--


--
-- Table structure for table `phplist_bounceregex_bounce`
--

CREATE TABLE `phplist_bounceregex_bounce` (
  `regex` int(11) NOT NULL,
  `bounce` int(11) NOT NULL,
  PRIMARY KEY (`regex`,`bounce`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_bounceregex_bounce`
--


--
-- Table structure for table `phplist_config`
--

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

--
-- Dumping data for table `phplist_config`
--

INSERT INTO `phplist_config` VALUES ('179086c5f0269ea80def0b97d4af3062','1395998543',0,NULL),('3de0db9a6872442e8dc75b4105f5cdae','2014-03-28',0,NULL),('3edea309deeb5d328a3ee19cfa6b6da8','1395998856',0,NULL),('admin_address','Christiaan.deVries@hetg.ie',1,NULL),('ajax_subscribeconfirmation','<h3>Thanks, you have been added to our newsletter</h3><p>You will receive an email to confirm your subscription. Please click the link in the email to confirm</p>',1,NULL),('alwayssendtextto','',1,NULL),('always_add_googletracking','1',1,NULL),('blacklisturl','http://phplist.chrisdevries.com/lists/?p=donotsend',1,NULL),('campaignfrom_default','Christiaan.deVries@hetg.ie',1,NULL),('check_new_version','7',1,NULL),('ckeditor_config_path','',1,NULL),('ckeditor_fulltemplate','0',1,NULL),('ckeditor_height','600',1,NULL),('ckeditor_path','plugins/CKEditorPlugin/ckeditor',1,NULL),('ckeditor_width','600',1,NULL),('confirmationmessage','  \r\nWelcome to the Digital Planet Major Incident Notification system. Your email address is now successfully subscribed and you will receive notifications is our systems are down.\r\n\r\nPlease keep this message for later reference.\r\n\r\nIf you do not want to receive any more messages, please go to [UNSUBSCRIBEURL].\r\n\r\nThank you,\r\nTeam Digital Planet\r\n  \r\n  ',1,NULL),('confirmationsubject','Welcome to the Digital Planet Major Incident Notification system',1,NULL),('confirmationurl','http://phplist.chrisdevries.com/lists/?p=confirm',1,NULL),('defaultmessagetemplate','0',1,NULL),('defaultsubscribepage','1',1,NULL),('domain','phplist.chrisdevries.com',1,NULL),('emailchanged_text','\n  When updating your details, your email address has changed.\n  Please confirm your new email address by visiting this webpage:\n  \n  [CONFIRMATIONURL]\n  \n  ',1,NULL),('emailchanged_text_oldaddress','\n  Please Note: when updating your details, your email address has changed.\n\n  A message has been sent to your new email address with a URL\n  to confirm this change. Please visit this website to activate\n  your membership.\n  ',1,NULL),('fckeditortoolbar_row2','',1,NULL),('fckeditor_height','',1,NULL),('fckeditor_path','plugins/fckphplist/fckeditor/',1,NULL),('fckeditor_width','600',1,NULL),('forwardfooter','....',1,NULL),('forwardurl','http://phplist.chrisdevries.com/lists/?p=forward',1,NULL),('hide_single_list','1',1,NULL),('html_charset','UTF-8',1,NULL),('html_email_style','',1,NULL),('internet_tlds','abogado|ac|academy|accountants|active|actor|ad|adult|ae|aero|af|ag|agency|ai|airforce|al|allfinanz|alsace|am|amsterdam|an|android|ao|aq|aquarelle|ar|archi|army|arpa|as|asia|associates|at|attorney|au|auction|audio|autos|aw|ax|axa|az|ba|band|bank|bar|barclaycard|barclays|bargains|bayern|bb|bd|be|beer|berlin|best|bf|bg|bh|bi|bid|bike|bio|biz|bj|black|blackfriday|bloomberg|blue|bm|bmw|bn|bnpparibas|bo|boo|boutique|br|brussels|bs|bt|budapest|build|builders|business|buzz|bv|bw|by|bz|bzh|ca|cab|cal|camera|camp|cancerresearch|capetown|capital|caravan|cards|care|career|careers|cartier|casa|cash|cat|catering|cc|cd|center|ceo|cern|cf|cg|ch|channel|cheap|christmas|chrome|church|ci|citic|city|ck|cl|claims|cleaning|click|clinic|clothing|club|cm|cn|co|coach|codes|coffee|college|cologne|com|community|company|computer|condos|construction|consulting|contractors|cooking|cool|coop|country|cr|credit|creditcard|cricket|crs|cruises|cu|cuisinella|cv|cw|cx|cy|cymru|cz|dabur|dad|dance|dating|day|dclk|de|deals|degree|delivery|democrat|dental|dentist|desi|design|dev|diamonds|diet|digital|direct|directory|discount|dj|dk|dm|dnp|do|docs|domains|doosan|durban|dvag|dz|eat|ec|edu|education|ee|eg|email|emerck|energy|engineer|engineering|enterprises|equipment|er|es|esq|estate|et|eu|eurovision|eus|events|everbank|exchange|expert|exposed|fail|farm|fashion|feedback|fi|finance|financial|firmdale|fish|fishing|fit|fitness|fj|fk|flights|florist|flowers|flsmidth|fly|fm|fo|foo|forsale|foundation|fr|frl|frogans|fund|furniture|futbol|ga|gal|gallery|garden|gb|gbiz|gd|ge|gent|gf|gg|ggee|gh|gi|gift|gifts|gives|gl|glass|gle|global|globo|gm|gmail|gmo|gmx|gn|goog|google|gop|gov|gp|gq|gr|graphics|gratis|green|gripe|gs|gt|gu|guide|guitars|guru|gw|gy|hamburg|hangout|haus|healthcare|help|here|hermes|hiphop|hiv|hk|hm|hn|holdings|holiday|homes|horse|host|hosting|house|how|hr|ht|hu|ibm|id|ie|ifm|il|im|immo|immobilien|in|industries|info|ing|ink|institute|insure|int|international|investments|io|iq|ir|irish|is|it|iwc|jcb|je|jetzt|jm|jo|jobs|joburg|jp|juegos|kaufen|kddi|ke|kg|kh|ki|kim|kitchen|kiwi|km|kn|koeln|kp|kr|krd|kred|kw|ky|kz|la|lacaixa|land|lat|latrobe|lawyer|lb|lc|lds|lease|legal|lgbt|li|lidl|life|lighting|limited|limo|link|lk|loans|london|lotte|lotto|lr|ls|lt|ltda|lu|luxe|luxury|lv|ly|ma|madrid|maison|management|mango|market|marketing|marriott|mc|md|me|media|meet|melbourne|meme|memorial|menu|mg|mh|miami|mil|mini|mk|ml|mm|mn|mo|mobi|moda|moe|monash|money|mormon|mortgage|moscow|motorcycles|mov|mp|mq|mr|ms|mt|mu|museum|mv|mw|mx|my|mz|na|nagoya|name|navy|nc|ne|net|network|neustar|new|nexus|nf|ng|ngo|nhk|ni|ninja|nl|no|np|nr|nra|nrw|nu|nyc|nz|okinawa|om|one|ong|onl|ooo|org|organic|osaka|otsuka|ovh|pa|paris|partners|parts|party|pe|pf|pg|ph|pharmacy|photo|photography|photos|physio|pics|pictures|pink|pizza|pk|pl|place|plumbing|pm|pn|pohl|poker|porn|post|pr|praxi|press|pro|prod|productions|prof|properties|property|ps|pt|pub|pw|py|qa|qpon|quebec|re|realtor|recipes|red|rehab|reise|reisen|reit|ren|rentals|repair|report|republican|rest|restaurant|reviews|rich|rio|rip|ro|rocks|rodeo|rs|rsvp|ru|ruhr|rw|ryukyu|sa|saarland|sale|samsung|sarl|sb|sc|sca|scb|schmidt|schule|schwarz|science|scot|sd|se|services|sew|sexy|sg|sh|shiksha|shoes|shriram|si|singles|sj|sk|sky|sl|sm|sn|so|social|software|sohu|solar|solutions|soy|space|spiegel|sr|st|su|supplies|supply|support|surf|surgery|suzuki|sv|sx|sy|sydney|systems|sz|taipei|tatar|tattoo|tax|tc|td|technology|tel|temasek|tf|tg|th|tienda|tips|tires|tirol|tj|tk|tl|tm|tn|to|today|tokyo|tools|top|town|toys|tp|tr|trade|training|travel|trust|tt|tui|tv|tw|tz|ua|ug|uk|university|uno|uol|us|uy|uz|va|vacations|vc|ve|vegas|ventures|versicherung|vet|vg|vi|viajes|video|villas|vision|vlaanderen|vn|vodka|vote|voting|voto|voyage|vu|wales|wang|watch|webcam|website|wed|wedding|wf|whoswho|wien|wiki|williamhill|wme|work|works|world|ws|wtc|wtf|xxx|xyz|yachts|yandex|ye|yoga|yokohama|youtube|yt|za|zip|zm|zone|zuerich|zw',0,NULL),('kcfinder_image_directory','image',1,NULL),('kcfinder_path','plugins/CKEditorPlugin/kcfinder',1,NULL),('lastlanguageupdate-en','1420439400',0,NULL),('list_categories','',1,NULL),('membership_columns','',1,NULL),('messagefooter','\r\n  ',1,NULL),('message_from_address','Christiaan.deVries@hetg.ie',1,NULL),('message_from_name','Christiaan de Vries',1,NULL),('message_replyto_address','Christiaan.deVries@hetg.ie',1,NULL),('organisation_name','Digital Planet',1,NULL),('pagefooter','</div>\n</div>\n</div><!-- ENDOF #mainContent-->\n</div><!-- ENDOF .wrapper -->\n</div><!-- ENDOF #container -->\n\n<div id=\"footer\">\n<div id=\"footerframe\">\n<ul>\n<li>&nbsp;</li>\n</ul>\n</div>\n</div>\n\n</body>\n\n</html>\n',1,NULL),('pageheader','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1, maximum-scale=1\" />\n\n<link rel=\"apple-touch-icon\" href=\"./images/phplist-touch-icon.png\" />\n<link rel=\"apple-touch-icon-precomposed\" href=\"./images/phplist-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://phplist.chrisdevries.com\" title=\"Visit our website\">[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,NULL),('personallocation_message','\n\nYou have requested your personal location to update your details from our website.\nThe location is below. Please make sure that you use the full line as mentioned below.\nSometimes email programmes can wrap the line into multiple lines.\n\nYour personal location is:\n[PREFERENCESURL]\n\nThank you.\n',1,NULL),('personallocation_subject','Your personal location',1,NULL),('plugins_disabled','a:1:{s:10:\"fckphplist\";i:1;}',0,NULL),('pqchoice','',1,NULL),('preferencesurl','http://phplist.chrisdevries.com/lists/?p=preferences',1,NULL),('remoteurl_append','',1,NULL),('report_address','Christiaan.deVries@hetg.ie',1,NULL),('send_admin_copies','0',1,NULL),('subscribemessage','\n\n  Almost welcome to our newsletter(s) ...\n\n  Someone, hopefully you, has subscribed your email address to the following newsletters:\n  \n  [LISTS]\n\n  If this is correct, please click the following link to confirm your subscription.\n  Without this confirmation, you will not receive any newsletters.\n  \n  [CONFIRMATIONURL]\n  \n  If this is not correct, you do not need to do anything, simply delete this message.\n\n  Thank you\n  \n    ',1,NULL),('subscribesubject','Request for confirmation',1,NULL),('subscribeurl','http://phplist.chrisdevries.com/lists/?p=subscribe',1,NULL),('systemmessagetemplate','0',1,NULL),('textarea_dimensions','10,40',1,NULL),('textline_width','40',1,NULL),('text_charset','UTF-8',1,NULL),('tld_last_sync','1422363364',0,NULL),('unsubscribemessage','\n  \n  Goodbye from our Newsletter, sorry to see you go.\n\n  You have been unsubscribed from our newsletters.\n\n  This is the last email you will receive from us. Our newsletter system, phpList,\n  will refuse to send you any further messages, without manual intervention by our administrator.\n\n  If there is an error in this information, you can re-subscribe:\n  please go to [SUBSCRIBEURL] and follow the steps.\n\n  Thank you\n  \n  ',1,NULL),('unsubscribesubject','Goodbye from our Newsletter',1,NULL),('unsubscribeurl','http://phplist.chrisdevries.com/lists/?p=unsubscribe',1,NULL),('updateavailable','3.3.1',0,NULL),('updatelastcheck','2017-04-14 12:47:39',0,NULL),('updatemessage','\n  \n  This message is to inform you of a change of your details on our newsletter database\n\n  You are currently member of the following newsletters:\n  \n  [LISTS]\n  \n  [CONFIRMATIONINFO]\n  \n  The information on our system for you is as follows:\n  \n  [USERDATA]\n  \n  If this is not correct, please update your information at the following location:\n  \n  [PREFERENCESURL]\n  \n  Thank you\n  \n    ',1,NULL),('updatesubject','[notify] Change of List-Membership details',1,NULL),('UTF8converted','2015-01-27 13:56',0,NULL),('version','3.0.11',0,NULL),('website','phplist.chrisdevries.com',1,NULL),('wordwrap','75',1,NULL),('xormask','1d3d23942b4777ee44e4a8bb6f9f341b',0,NULL);

--
-- Table structure for table `phplist_eventlog`
--

CREATE TABLE `phplist_eventlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entered` datetime DEFAULT NULL,
  `page` varchar(100) DEFAULT NULL,
  `entry` text,
  PRIMARY KEY (`id`),
  KEY `enteredidx` (`entered`),
  KEY `pageidx` (`page`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_eventlog`
--

INSERT INTO `phplist_eventlog` VALUES (1,'2014-03-28 10:09:03','login','invalid login from 185.5.242.94, tried logging in as admin'),(2,'2014-03-28 10:22:42','home','Fetching http://www.phplist.com/files/tlds-alpha-by-domain.txt success'),(3,'2014-03-28 10:22:43','home','Fetching http://www.phplist.com/files/tlds-alpha-by-domain.txt.md5 success'),(4,'2015-01-27 10:42:00','home','Fetching http://www.phplist.com/files/tlds-alpha-by-domain.txt success'),(5,'2015-01-27 10:42:01','home','Fetching http://www.phplist.com/files/tlds-alpha-by-domain.txt.md5 success'),(6,'2015-01-27 13:56:05','upgrade','Fetching https://www.phplist.com/files/tlds-alpha-by-domain.txt success'),(7,'2015-01-27 13:56:05','upgrade','Fetching https://www.phplist.com/files/tlds-alpha-by-domain.txt.md5 success');

--
-- Table structure for table `phplist_i18n`
--

CREATE TABLE `phplist_i18n` (
  `lan` varchar(10) NOT NULL,
  `original` text NOT NULL,
  `translation` text NOT NULL,
  UNIQUE KEY `lanorigunq` (`lan`,`original`(200)),
  KEY `lanorigidx` (`lan`,`original`(200))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_i18n`
--

INSERT INTO `phplist_i18n` VALUES ('en','Sorry, this page can only be used by super admins','Sorry, this page can only be used by super admins'),('en','Blacklisted by','Blacklisted by'),('en','All done, %d emails processed, %d emails marked unconfirmed, %d emails blacklisted<br/>','All done, %d emails processed, %d emails marked unconfirmed, %d emails blacklisted<br/>'),('en','Add more','Add more'),('en','Manage suppression list','Manage suppression list'),('en','Make suppression permanent','Make suppression permanent'),('en','Paste the emails to mark unconfirmed in this box, and click continue','Paste the emails to mark unconfirmed in this box, and click continue'),('en','continue','Continue'),('en','This page can only be called from the commandline','This page can only be called from the commandline'),('en','Bounce processing error','Bounce processing error'),('en','Bounce Processing info','Bounce processing info'),('en','system message bounced, user marked unconfirmed','system message bounced, subscriber marked unconfirmed'),('en','Bounced system message','Bounced system message'),('en','User marked unconfirmed','Subscriber marked unconfirmed'),('en','View Bounce','View bounce'),('en','system message bounced, but unknown user','system message bounced, but unknown subscriber'),('en','Cannot create POP3 connection to','Cannot create POP3 connection to'),('en','Cannot open mailbox file','Cannot open mailbox file'),('en','bounces to fetch from the mailbox','bounces to fetch from the mailbox'),('en','Please do not interrupt this process','Please do not interrupt this process'),('en','bounces to process','bounces to process'),('en','processing first','processing first'),('en','Bounces','Bounces'),('en','Running in test mode, not deleting messages from mailbox','Running in test mode, not deleting messages from mailbox'),('en','Processed messages will be deleted from mailbox','Processed messages will be deleted from mailbox'),('en','Deleting message','Deleting message'),('en','Closing mailbox, and purging messages','Closing mailbox, and purging messages'),('en','IMAP is not included in your PHP installation, cannot continue','IMAP is not included in your PHP installation, cannot continue'),('en','Check out','Check out'),('en','Bounce mechanism not properly configured','Bounce mechanism not properly configured'),('en','bounce_protocol not supported','bounce_protocol not supported'),('en','%d bounces to reprocess','%d bounces to reprocess'),('en','%d out of %d processed','%d out of %d processed'),('en','%d bounces were re-processed and %d bounces were re-identified','%d bounces were re-processed and %d bounces were re-identified'),('en','Processing bounces based on active bounce rules','Processing bounces based on active bounce rules'),('en','Process Killed by other process','Process Killed by other process'),('en','Auto unconfirmed','Auto unconfirmed'),('en','Subscriber auto unconfirmed for','Subscriber auto unconfirmed for'),('en','bounce rule','bounce rule'),('en','Auto Blacklisted','Auto blacklisted'),('en','User auto blacklisted for','User auto blacklisted for'),('en','Auto Unsubscribed','Auto unsubscribed'),('en','User auto unsubscribed for','User auto unsubscribed for'),('en','bounces processed by advanced processing','bounces processed by advanced processing'),('en','bounces were not matched by advanced processing rules','bounces were not matched by advanced processing rules'),('en','Identifying consecutive bounces','Identifying consecutive bounces'),('en','Nothing to do','Nothing to do'),('en','User (url:%s) has consecutive bounces (%d) over threshold (%d), user marked unconfirmed','Subscriber (url:%s) has consecutive bounces (%d) over threshold (%d), subscriber marked unconfirmed'),('en','Subscriber auto unconfirmed for %d consecutive bounces','Subscriber auto unconfirmed for %d consecutive bounces'),('en','%d consecutive bounces, threshold reached, blacklisting subscriber','%d consecutive bounces, threshold reached, blacklisting subscriber'),('en','%d consecutive bounces, threshold reached','%d consecutive bounces, threshold reached'),('en','Processed %d out of %d subscribers','Processed %d out of %d subscribers'),('en','total of %d subscribers processed','total of %d subscribers processed'),('en','Report:','Report:'),('en','Report of advanced bounce processing:','Report of advanced bounce processing:'),('en','Below are users who have been marked unconfirmed. The in () is the number of consecutive bounces.','Below are subscribers who have been marked unconfirmed. The in () is the number of consecutive bounces.'),('en','The temporary directory for uploading (%s) is not writable, so import will fail','The temporary directory for uploading (%s) is not writable, so import will fail'),('en','The maximum POST size is smaller than the maximum upload filesize. If your upload file is too large, import will fail. See the PHP documentation at <a href=\\\"%s\\\">%s</a>','The maximum POST size is smaller than the maximum upload filesize. If your upload file is too large, import will fail. See the PHP documentation at <a href=\\\"%s\\\">%s</a>'),('en','Import cleared','Import cleared'),('en','Are you sure you want to reset the import session?','Are you sure you want to reset the import session?'),('en','Reset Import session','Reset Import session'),('en','Invalid security token, please reload the page and try again','Invalid security token, please reload the page and try again'),('en','File is either too large or does not exist.','File is either too large or does not exist.'),('en','No file was specified. Maybe the file is too big?','No file was specified. Maybe the file is too big?'),('en','File too big, please split it up into smaller ones','File too big, please split it up into smaller ones'),('en','Please choose whether to sign up immediately or to send a notification','Please choose whether to sign up immediately or to send a notification'),('en','Cannot read %s. file is not readable !','Cannot read %s. file is not readable !'),('en','Something went wrong while uploading the file. Empty file received. Maybe the file is too big, or you have no permissions to read it.','Something went wrong while uploading the file. Empty file received. Maybe the file is too big, or you have no permissions to read it.'),('en','Reading emails from file ...','Reading emails from file ...'),('en','ok, %d lines','ok, %d lines'),('en','Create new one','Create new one'),('en','Skip Column','Skip Column'),('en','Import Attributes','Import Attributes'),('en','select','select'),('en','Please identify the target of the following unknown columns','Please identify the target of the following unknown columns'),('en','Cannot find column with email, you need to map at least one column to \\\"Email\\\"','Cannot find column with email, you need to map at least one column to \\\"Email\\\"'),('en','summary','summary'),('en','maps to','maps to'),('en','Create new Attribute','Create new Attribute'),('en','none','none'),('en','%d lines will be imported','%d lines will be imported'),('en','Confirm Import','Confirm Import'),('en','Test output','Test output'),('en','Importing %d subscribers to %d lists, please wait','Importing %d subscribers to %d lists, please wait'),('en','Record has no email','Record has no email'),('en','Invalid Email','Invalid Email'),('en','clear value','clear value'),('en','New Attribute','New Attribute'),('en','Skip value','Skip value'),('en','Test output<br/>If the output looks ok, click %s to submit for real','Test output<br/>If the output looks ok, click %s to submit for real'),('en','Import some more emails','Import some more emails'),('en','Adding users to list','Adding subscribers to list'),('en','Select the lists to add the emails to','Select the lists to add the emails to'),('en','No lists available','No lists available'),('en','Add a list','Add a list'),('en','Select the groups to add the users to','Select the groups to add the subscribers to'),('en','automatically added','automatically added'),('en','The file you upload will need to have the attributes of the records on    the first line.     Make sure that the email column is called \\\"email\\\" and not something like \\\"e-mail\\\" or     \\\"Email Address\\\".     Case is not important.          If you have a column called \\\"Foreign Key\\\", this will be used for synchronisation between an     external database and the phpList database. The foreignkey will take precedence when matching     an existing subscriber. This will slow down the import process. If you use this, it is allowed to have     records without email, but an \\\"Invalid Email\\\" will be created instead. You can then do     a search on \\\"invalid email\\\" to find those records. Maximum size of a foreign key is 100.          Warning: the file needs to be plain text. Do not upload binary files like a Word Document.','<p class=information>The file you upload will need to have the attributes of the records on    the first line.     Make sure that the email column is called email and not something like e-mail or     Email Address.     Case is not important.     </p>     If you have a column called Foreign Key, this will be used for synchronisation between an     external database and the phpList database. The foreignkey will take precedence when matching     an existing subscriber. This will slow down the import process. If you use this, it is allowed to have     records without email, but an Invalid Email will be created instead. You can then do     a search on invalid email to find those records. Maximum size of a foreign key is 100.     <br/><br/>     <b>Warning</b>: the file needs to be plain text. Do not upload binary files like a Word Document.     <br/>'),('en','File containing emails','File containing emails'),('en','The following limits are set by your server:<br/>Maximum size of a total data sent to server: %s<br/>Maximum size of each individual file: %s','The following limits are set by your server:<br/>Maximum size of a total data sent to server: %s<br/>Maximum size of each individual file: %s'),('en','phpList will not process files larger than %dMB','<br/>phpList will not process files larger than %dMB'),('en','Field Delimiter','Field Delimiter'),('en','default is TAB','default is TAB'),('en','Record Delimiter','Record Delimiter'),('en','default is line break','default is line break'),('en','If you check \\\"Test Output\\\", you will get the list of parsed emails on screen, and the database will not be filled with the information. This is useful to find out whether the format of your file is correct. It will only show the first 50 records.','If you check Test Output, you will get the list of parsed emails on screen, and the database will not be filled with the information. This is useful to find out whether the format of your file is correct. It will only show the first 50 records.'),('en','If you check \\\"Show Warnings\\\", you will get warnings for invalid records. Warnings will only be shown if you check \\\"Test Output\\\". They will be ignored when actually importing.','If you check Show Warnings, you will get warnings for invalid records. Warnings will only be shown if you check Test Output. They will be ignored when actually importing.'),('en','Show Warnings','Show Warnings'),('en','If you check \\\"Omit Invalid\\\", invalid records will not be added. Invalid records are records without an email. Any other attributes will be added automatically, ie if the country of a record is not found, it will be added to the list of countries.','If you check \\\"Omit Invalid\\\", invalid records will not be added. Invalid records are records without an email. Any other attributes will be added automatically, ie if the country of a record is not found, it will be added to the list of countries.'),('en','Omit Invalid','Omit Invalid'),('en','Assign Invalid will be used to create an email for subscribers with an invalid email address. You can use values between [ and ] to make up a value for the email. For example if your import file contains a column \\\"First Name\\\" and one called \\\"Last Name\\\", you can use \\\"[first name] [last name]\\\" to construct a new value for the email for this subscriber containing their first name and last name. The value [number] can be used to insert the sequence number for importing.','Assign Invalid will be used to create an email for subscribers with an invalid email address. You can use values between [ and ] to make up a value for the email. For example if your import file contains a column First Name and one called Last Name, you can use [first name] [last name] to construct a new value for the email for this subscriber containing their first name and last name. The value [number] can be used to insert the sequence number for importing.'),('en','Assign Invalid','Assign Invalid'),('en','If you check \\\"Overwrite Existing\\\", information about a subscriber in the database will be replaced by the imported information. Subscribers are matched by email or foreign key.','If you check \\\"Overwrite Existing\\\", information about a subscriber in the database will be replaced by the imported information. Subscribers are matched by email or foreign key.'),('en','Overwrite Existing','Overwrite Existing'),('en','If you check \\\"Retain Old Email\\\", a conflict of two emails being the same will keep the old one and add \\\"duplicate\\\" to the new one. If you don&quot;t check it, the old one will get \\\"duplicate\\\" and the new one will take precedence.','If you check \\\"Retain Old Email\\\", a conflict of two emails being the same will keep the old one and add \\\"duplicate\\\" to the new one. If you don\'t check it, the old one will get \\\"duplicate\\\" and the new one will take precedence.'),('en','Retain Old User Email','Retain Old Email'),('en','If you choose \\\"send notification email\\\" the subscribers you are adding will be sent the request for confirmation of subscription to which they will have to reply. This is recommended, because it will identify invalid emails.','If you choose \\\"send notification email\\\" the subscribers you are adding will be sent the request for confirmation of subscription to which they will have to reply. This is recommended, because it will identify invalid emails.'),('en','Send&nbsp;Notification&nbsp;email','Send&nbsp;Notification&nbsp;email'),('en','Make confirmed immediately','Make confirmed immediately'),('en','If you are going to send notification to users, you may want to add a little delay between messages','If you are going to send notification to subscribers, you may want to add a little delay between messages'),('en','Notification throttle','Notification throttle'),('en','(default is nothing, will send as fast as it can)','(default is nothing, will send as fast as it can)'),('en','Import','Import'),('en','you only have privileges to view this page, not change any of the information','you only have privileges to view this page, not change any of the information'),('en','Delete will remove subscriber from the list','Delete will remove subscriber from the list'),('en','Delete will remove subscriber from the system','Delete will remove subscriber from the system'),('en','Error adding subscriber, please check that the subscriber exists','Error adding subscriber, please check that the subscriber exists'),('en','Uploaded avatar file too big','Uploaded avatar file too big'),('en','Subscriber added to group','Subscriber added to group'),('en','Subscriber removed from list %s','Subscriber removed from list %s'),('en','Subscriber added to list %s','Subscriber added to list %s'),('en','(no data)','(no data)'),('en','changed from','changed from'),('en','No data changed','No data changed'),('en','Subscribed to %s','Subscribed to %s'),('en','Unsubscribed from %s','Unsubscribed from %s'),('en','Update by %s','Update by %s'),('en','Changes saved','Changes saved'),('en','deleting','deleting'),('en','done','done'),('en','Subscriber removed from group','Subscriber removed from group'),('en','No such subscriber','No such subscriber'),('en','No Lists','No Lists'),('en','History','History'),('en','Delete','delete'),('en','Add a new subscriber','Add a new subscriber'),('en','Email address','Email address'),('en','Yes','Yes'),('en','No','No'),('en','Add to blacklist','Add to blacklist'),('en','Remove from blacklist','Remove from blacklist'),('en','Save changes','Save changes'),('en','Subscriber is blacklisted. No emails will be sent to this email address.','Subscriber is blacklisted. No emails will be sent to this email address.'),('en','Mailinglist membership','Mailinglist membership'),('en','Group Membership','Group membership'),('en','Please select the groups this subscriber is a member of','Please select the groups this subscriber is a member of'),('en','Details','Details'),('en','Lists','Lists'),('en','Groups','Groups'),('en','no such User','no such subscriber'),('en','User','Subscriber'),('en','View','View'),('en','msg','msg'),('en','time','time'),('en','Messages','Messages'),('en','messages sent to this user','messages sent to this subscriber'),('en','clicks','clicks'),('en','Sent','Sent'),('en','viewed','viewed'),('en','responsetime','responsetime'),('en','bounce','bounce'),('en','average','average'),('en','Campaigns','Campaigns'),('en','Subscription','Subscription'),('en','subscriber is blacklisted since','Subscriber is blacklisted since'),('en','Blacklist info','Blacklist info'),('en','Value','Value'),('en','are you sure you want to delete this subscriber from the blacklist','are you sure you want to delete this subscriber from the blacklist'),('en','it should only be done with explicit permission from this subscriber','it should only be done with explicit permission from this subscriber'),('en','remove subscriber from blacklist','remove subscriber from blacklist'),('en','remove','remove'),('en','For this subscriber to be removed from the blacklist, you need to ask them to re-subscribe using the phpList subscribe page','For this subscriber to be removed from the blacklist, you need to ask them to re-subscribe using the phpList subscribe page'),('en','Subscription History','Subscription history'),('en','no details found','no details found'),('en','ip','ip'),('en','Date','Date'),('en','detail','detail'),('en','info','info'),('en','Database structure check','Database structure check'),('en','Database structure','Database structure'),('en','Delete will delete user and all listmemberships','Delete will delete subscriber and all listmemberships'),('en','Your privileges for this page are insufficient','Your privileges for this page are insufficient'),('en','Delete will delete user from the list','Delete will delete subscriber from the list'),('en','Sorry, only super users can delete users','Sorry, only super users can delete subscribers'),('en','User added','Subscriber added'),('en','%s users in total','%s subscribers in total'),('en','Users marked <span class=\\\"highlight\\\">red</span> are unconfirmed','Subscribers marked <span class=\\\"highlight\\\">red</span> are unconfirmed'),('en','Show only unconfirmed users','Show only unconfirmed subscribers'),('en','Show only blacklisted users','Show only blacklisted subscribers'),('en','Sort by','Sort by'),('en','desc','desc'),('en','asc','asc'),('en','Go','Go'),('en','Listing user %d to %d','Listing subscriber %d to %d'),('en','Subscribers','Subscribers'),('en','Find a user','Find a subscriber'),('en','Email','Email'),('en','Foreign Key','Foreign Key'),('en','Reset','reset'),('en','Find subscribers','Find subscribers'),('en','Download all users as CSV file','Download all subscribers in a CSV file'),('en','Add a User','Add a subscriber'),('en','users','Subscribers'),('en','msgs','msgs'),('en','bncs','bncs'),('en','no results','no results'),('en','No users apply','No subscribers apply'),('en','Email is a system attribute','Email is a system attribute'),('en','Converting %s from %s to %s','Converting %s from %s to %s'),('en','Cannot delete attribute, it is being used by the following forms:','Cannot delete attribute, it is being used by the following forms:'),('en','cannot merge just one attribute','cannot merge just one attribute'),('en','Merging %s into %d','Merging %s into %d'),('en','Can only merge attributes of the same type','Can only merge attributes of the same type'),('en','Sorry, merging of checkbox groups is not implemented yet','Sorry, merging of checkbox groups is not implemented yet'),('en','Warning, changing types of attributes can take a long time','Warning, changing types of attributes can take a long time'),('en','Load data from','Load data from'),('en','predefined defaults','predefined defaults'),('en','Existing attributes','Existing attributes'),('en','No Attributes have been defined yet','No attributes have been defined yet'),('en','attribute','attribute'),('en','used in','used in'),('en','forms','forms'),('en','Tag','Tag'),('en','Name','Name'),('en','Type','Type'),('en','authoritative list','authoritative list'),('en','edit values','edit values'),('en','Default value','Default Value'),('en','Order of listing','Order of listing'),('en','Is this attribute required ?','Is this attribute required?'),('en','Delete tagged attributes','Delete tagged attributes'),('en','Merge tagged attributes','Merge tagged attributes'),('en','Add new Attribute','Add new Attribute'),('en','Is this attribute required?','Is this attribute required?'),('en','Removed from blacklist by %s','Removed from blacklist by %s'),('en','Removed from blacklist','Removed from blacklist'),('en','Added to blacklist','Added to blacklist'),('en','Added to blacklist for reason %s','Added to blacklist for reason %s'),('en','sort by %s','sort by %s'),('en','Previous','Previous'),('en','back','back'),('en','Next','Next'),('en','Close this box','Close this box'),('en','Hide','Hide'),('en','open','open'),('en','close','close'),('en','Choose a list','Choose a list'),('en','list','list'),('en','# bounced','# bounced'),('en','None found','None found'),('en','Select another list','Select another list'),('en','Bounces on','Bounces on'),('en','# bounces','# bounces'),('en','import is not available','import is not available'),('en','The temporary directory for uploading is not writable, so import will fail','The temporary directory for uploading is not writable, so import will fail'),('en','Cannot read file. It is not readable !','Cannot read file. It is not readable !'),('en','Test output:','Test output:'),('en','There should only be ONE email per line.','There should only be ONE email per line.'),('en','If the output looks ok, go','If the output looks ok, go'),('en','to resubmit for real','to resubmit for real'),('en','adding_users','Adding subscribers'),('en','The file you upload will need to contain the emails you want to add to these lists. Anything after the email will be added as attribute \\\"Info\\\" of the Subscriber. You can specify the rest of the attributes of these subscribers below. Warning: the file needs to be plain text. Do not upload binary files like a Word Document.','The file you upload will need to contain the emails you want to add to these lists. Anything after the email will be added as attribute Info of the Subscriber. You can specify the rest of the attributes of these subscribers below. <b>Warning</b>: the file needs to be plain text. Do not upload binary files like a Word Document.'),('en','File containing emails:','File containing emails:'),('en','send notification email','send notification email'),('en','File is either to large or does not exist.','File is either to large or does not exist.'),('en','No file was specified.','No file was specified.'),('en','Some characters that are not valid have been found. These might be delimiters. Please check the file and select the right delimiter. Character found:','Some characters that are not valid have been found. These might be delimiters. Please check the file and select the right delimiter. Character found:'),('en','Name cannot be empty','Name cannot be empty'),('en','Name is not unique enough','Name is not unique enough'),('en','Cannot find the email in the header','Cannot find the email in the header'),('en','Cannot find the password in the header','Cannot find the password in the header'),('en','Cannot find the loginname in the header','Cannot find the loginname in the header'),('en','Import administrators, please wait','Importing administrators, please wait'),('en','Record has more values than header indicated, this may cause trouble','Record has more values than header indicated, this may cause trouble'),('en','Test output: If the output looks ok, go Back to resubmit for real','Test output<br/>If the output looks ok, go Back to submit for real'),('en','password','Password'),('en','login','login'),('en','Empty loginname, using email:','Empty loginname, using email:'),('en','added to attribute','added to attribute'),('en','List for','List for'),('en','new administrator was','new administrator was'),('en','new administrators were','new administrators were'),('en','All the administrators already exist in the database','All the administrators already exist in the database'),('en','Information has been updated from the import','Information has been updated from the import'),('en','succesfully imported to the database and added to the system.','successfully imported to the database and added to the system.'),('en','Import some more administrators','Import some more administrators'),('en','The file you upload will need to contain the administrators you want to add to the system. The columns need to have the following headers: email, loginname, password. Any other columns will be added as admin attributes.  Warning: the file needs to be plain text. Do not upload binary files like a Word Document.','The file you upload will need to contain the administrators you want to add to the system. The columns need to have the following headers: <b>email</b>, <b>loginname</b>, <b>password</b>. Any other columns will be added as admin attributes.  <b>Warning</b>: the file needs to be plain text. Do not upload binary files like a Word Document.'),('en','Check this box to create a list for each administrator, named after their loginname','Check this box to create a list for each administrator, named after their loginname'),('en','Privileges','Privileges'),('en','Manage subscribers','Manage subscribers'),('en','Send Campaigns','Send campaigns'),('en','View statistics','View statistics'),('en','Change Settings','Change settings'),('en','Do Import','Do Import'),('en','File not found','File not found'),('en','Import of existing subscriber','Import of existing subscriber'),('en','Import of new subscriber','Import of new subscriber'),('en','List subscriptions:','List subscriptions:'),('en','Was subscribed to:','Was subscribed to:'),('en','Is now subscribed to:','Is now subscribed to:'),('en','Not subscribed to any lists','Not subscribed to any lists'),('en','Import by','Import by'),('en','new email was','new email was'),('en','new emails were','new emails were'),('en','email was','email was'),('en','emails were','emails were'),('en','%d emails already existed in the database','%d emails already existed in the database'),('en','All the emails already exist in the database.','All the emails already exist in the database.'),('en','succesfully imported to the database and added to','succesfully imported to the database and added to'),('en','subscribed to the','subscribed to the'),('en','Manually blacklisted by %s','Manually blacklisted by %s'),('en','Unable to fetch list of languages, please check your network or try again later','Unable to fetch list of languages, please check your network or try again later'),('en','updated %d language terms','updated %d language terms'),('en','Network error updating language, please try again later','Network error updating language, please try again later'),('en','duplicate','duplicate'),('en','Duplicate Email','Duplicate Email'),('en','user imported as','subscriber imported as'),('en','All the emails already exist in the database and are member of the lists','All the emails already exist in the database and are member of the lists'),('en','%s emails succesfully imported to the database and added to %d lists.','%s emails succesfully imported to the database and added to %d lists.'),('en','%d emails subscribed to the lists','%d emails subscribed to the lists'),('en','%s emails already existed in the database','%s emails already existed in the database'),('en','%d Invalid Emails found.','%d Invalid Emails found.'),('en','These records were added, but the email has been made up from','These records were added, but the email has been made up from'),('en','These records were deleted. Check your source and reimport the data. Duplicates will be identified.','These records were deleted. Check your source and reimport the data. Duplicates will be identified.'),('en','%d duplicate emails found.','%d duplicate emails found.'),('en','Subscriber data was updated for %d subscribers','Subscriber data was updated for %d subscribers'),('en','%s emails were on the blacklist and have not been added to the lists','%s emails were on the blacklist and have not been added to the lists'),('en','%d subscribers were matched by foreign key, %d by email','%d subscribers were matched by foreign key, %d by email'),('en','phplist Import Results','phplist Import Results'),('en','Invalid Request','invalid request'),('en','Editing','Editing'),('en','Don\'t know how to handle type','Don\'t know how to handle type'),('en','Email address added','Email address added'),('en','Adding email address failed','Adding email address failed'),('en','unknown','unknown'),('en','%s left until embargo','%s left until embargo'),('en','Requeue','Requeue'),('en','still to process','still to process'),('en','limit reached','limit reached'),('en','next batch of %s in %s','next batch of %s in %s'),('en','Stalled','Stalled'),('en','Send the queue','Send the queue'),('en','processing','processing'),('en','ETA','ETA'),('en','msgs/hr','msgs/hr'),('en','You are trying to send a remote URL, but PEAR::HTTP_Request is not available, so this will fail','You are trying to send a remote URL, but PEAR::HTTP_Request is not available, so this will fail'),('en','Sample Newsletter Content','Sample newsletter content'),('en','The following restrictions have been set by your ISP:','The following restrictions have been set by your ISP:'),('en','Maximum time for queue processing','Maximum time for queue processing'),('en','Running in safe mode','Running in safe mode'),('en','Script stage','Script stage'),('en','Finished, Nothing to do','Finished, Nothing to do'),('en','Calculating','Calculating'),('en','messages sent in','messages sent in'),('en','seconds','seconds'),('en','%d invalid email addresses','%d invalid email addresses'),('en','%d failed (will retry later)','%d failed (will retry later)'),('en','%d emails unconfirmed (not sent)','%d emails unconfirmed (not sent)'),('en','Warning: script never reached stage 5','Warning: script never reached stage 5'),('en','This may be caused by a too slow or too busy server','This may be caused by a too slow or too busy server'),('en','Less than batch size were sent, so reloading imminently','Less than batch size were sent, so reloading imminently'),('en','Waiting for %d seconds before reloading','Waiting for %d seconds before reloading'),('en','Finished, All done','Finished, All done'),('en','All done','All done'),('en','Script finished, but not all messages have been sent yet.','Script finished, but not all messages have been sent yet.'),('en','Maillist errors','Maillist errors'),('en','Maillist Processing info','Maillist Processing info'),('en','Finished this run','Finished this run'),('en','(test)','(test)'),('en','Would have sent','Would have sent'),('en','to','to'),('en','Started','Started'),('en','Time now','Time now'),('en','Unable get lock for processing','Unable get lock for processing'),('en','Error processing','Error processing'),('en','Processing has been suspended by your ISP, please try again later','Processing has been suspended by your ISP, please try again later'),('en','In safe mode, batches are set to a maximum of 100','In safe mode, batches are set to a maximum of 100'),('en','Sending in batches of %d messages','Sending in batches of %d messages'),('en','This batch will be %d emails, because in the last %d seconds %d emails were sent','This batch will be %d emails, because in the last %d seconds %d emails were sent'),('en','Sending in batches of %d emails','Sending in batches of %d emails'),('en','In the last %d seconds more emails were sent (%d) than is currently allowed per batch (%d)','In the last %d seconds more emails were sent (%d) than is currently allowed per batch (%d)'),('en','Sent in last run','Sent in last run'),('en','Skipped in last run','Skipped in last run'),('en','Processing has started,','Processing has started,'),('en','message(s) to process.','message(s) to process.'),('en','Please leave this window open. You have batch processing enabled, so it will reload several times to send the messages. Reports will be sent by email to','Please leave this window open. You have batch processing enabled, so it will reload several times to send the messages. Reports will be sent by email to'),('en','Your webserver is running in safe_mode. Please keep this window open. It may reload several times to make sure all messages are sent.','Your webserver is running in safe_mode. Please keep this window open. It may reload several times to make sure all messages are sent.'),('en','Reports will be sent by email to','Reports will be sent by email to'),('en','sending of this campaign will stop, if it is still going in %s','sending of this campaign will stop, if it is still going in %s'),('en','Error loading message, please check the eventlog for details','Error loading message, please check the eventlog for details'),('en','Campaign started','Campaign started'),('en','phplist has started sending the campaign with subject %s','phplist has started sending the campaign with subject %s'),('en','to view the progress of this campaign, go to http://%s','to view the progress of this campaign, go to http://%s'),('en','Processing message','Processing message'),('en','Looking for users','Looking for subscribers'),('en','users apply for attributes, now checking lists','subscribers apply for attributes, now checking lists'),('en','No users apply for attributes','No subscribers apply for attributes'),('en','looking for users who can be excluded from this mailing','looking for subscribers who can be excluded from this mailing'),('en','Warning, finding the subscribers to send out to takes a long time, consider changing to commandline sending','Warning, finding the subscribers to send out to takes a long time, consider changing to commandline sending'),('en','Found them','Found them'),('en','to process','to process'),('en','No users to process for this batch','No subscribers to process for this batch'),('en','Processing batch of','Processing batch of'),('en','batch limit reached','batch limit reached'),('en','queue processing time has exceeded max processing time','queue processing has exceeded maximum processing time'),('en','Campaign sending timed out, is past date to process until','Campaign sending timed out, is past date to process until'),('en','Message I was working on has disappeared','Message I was working on has disappeared'),('en','Sending of this message has been suspended','Sending of this message has been suspended'),('en','There have been more than 10 attempts to send to %s that have been blocked for domain throttling.','There have been more than 10 attempts to send to %s that have been blocked for domain throttling.'),('en','Introducing extra delay to decrease throttle failures','Introducing extra delay to decrease throttle failures'),('en','%s is currently over throttle limit of %d per %d seconds','%s is currently over throttle limit of %d per %d seconds'),('en','Sending','Sending'),('en','It took','It took'),('en','seconds to send','seconds to send'),('en','Failed sending to','Failed sending to'),('en','waiting for %.1f seconds to meet target of %s seconds per message','waiting for %.1f seconds to meet target of %s seconds per message'),('en','Not sending to','Not sending to'),('en','Unconfirmed user','Unconfirmed subscriber'),('en','Invalid email address','Invalid email address'),('en','Marked unconfirmed while sending campaign %d','Marked unconfirmed while sending campaign %d'),('en','Subscriber marked unconfirmed for invalid email address','Subscriber marked unconfirmed for invalid email address'),('en','already sent','already sent'),('en','Hmmm, No users found to send to','Hmmm, No subscribers found to send to'),('en','Message campaign finished','Campaign finished'),('en','phpList has finished sending the campaign with subject %s','phpList has finished sending the campaign with subject %s'),('en','to view the results of this campaign, go to http://%s','to view the progress of this campaign, go to http://%s'),('en','to send this message','to send this message'),('en','Error fetching URL','Error fetching URL'),('en','Check your \\\"remoteurl_append\\\" setting.','Check your \\\"remoteurl_append\\\" setting.'),('en','URL is valid','URL is valid'),('en','Please verify that the URL entered is correct.','Please verify that the URL entered is correct.'),('en','Updating the regular expression of this rule caused an Sql conflict<br/>This is probably because there is already a rule like that. Do you want to delete this rule instead?','Updating the regular expression of this rule caused an Sql conflict<br/>This is probably because there is already a rule like that. Do you want to delete this rule instead?'),('en','back to list of bounce rules','back to list of bounce rules'),('en','Regular Expression','Regular Expression'),('en','Created By','Created By'),('en','action','action'),('en','Status','Status'),('en','Select Status','Select Status'),('en','Memo for this rule','Memo for this rule'),('en','related bounces','related bounces'),('en','no related bounces found','no related bounces found'),('en','and more, %d in total','and more, %d in total'),('en','Sending message %d with subject %s to %s','Sending message %d with subject %s to %s'),('en','sendingtextonlyto','Sending text only to'),('en','Error sending message %d (%d/%d) to %s (%s)','Error sending message %d (%d/%d) to %s (%s)'),('en','Delete will remove subscriber from the database','Delete will delete subscriber from the database'),('en','The default system template already exists','The default system template already exists'),('en','Go back to templates','Go back to templates'),('en','The default system template has been added as template with ID','The default system template has been added as template with ID'),('en','Edit template','Edit template'),('en','Never','Never'),('en','Last updated','Last updated'),('en','Last Modified','Last Modified'),('en','choose','choose'),('en','Your database version','Your database version'),('en','Your database is already the correct version, there is no need to upgrade','Your database is already the correct version, there is no need to upgrade'),('en','Please wait, upgrading your database, do not interrupt','Please wait, upgrading your database, do not interrupt'),('en','Upgrading the database to use UTF-8, please wait','Upgrading the database to use UTF-8, please wait'),('en','Upgrading table','Upgrading table'),('en','Upgrading column','Upgrading column'),('en','upgrade to UTF-8, done','upgrade to UTF-8, done'),('en','Database requires converting to UTF-8.','Database requires converting to UTF-8.'),('en','However, there is too little diskspace for this conversion','However, there is too little diskspace for this conversion'),('en','Please do a manual conversion.','Please do a manual conversion.'),('en','Run manual conversion to UTF8','Run manual conversion to UTF8'),('en','Success','Success'),('en','The clicktracking system has changed','The clicktracking system has changed'),('en','You have %s entries in the old statistics table','You have %s entries in the old statistics table'),('en','Convert Old data to new','Convert old data to new'),('en','Upgrade successful','Upgrade successful'),('en','Upgrade failed','Upgrade failed'),('en','Your database requires upgrading, please make sure to create a backup of your database first.','Your database requires upgrading, please make sure to create a backup of your database first.'),('en','If you have a large database, make sure you have sufficient diskspace available for upgrade.','If you have a large database, make sure you have sufficient diskspace available for upgrade.'),('en','upgrade','Upgrade'),('en','When you are ready click %s Depending on the size of your database, this may take quite a while. Please make sure not to interrupt the process, once it started.','When you are ready click %s Depending on the size of your database, this may take quite a while. Please make sure not to interrupt the process, once it started.'),('en','Please choose one of the import methods below','Please choose one of the import methods below'),('en','copy and paste list of emails','copy and paste list of emails'),('en','import by uploading a file with emails','import by uploading a file with emails'),('en','import by uploading a CSV file with emails and additional data','import by uploading a CSV file with emails and additional data'),('en','Sunday','Sunday'),('en','Monday','Monday'),('en','Tuesday','Tuesday'),('en','Wednesday','Wednesday'),('en','Thursday','Thursday'),('en','Friday','Friday'),('en','Saturday','Saturday'),('en','January','January'),('en','February','February'),('en','March','March'),('en','April','April'),('en','May','May'),('en','June','June'),('en','July','July'),('en','August','August'),('en','September','September'),('en','October','October'),('en','November','November'),('en','December','December'),('en','That rule exists already','That rule exists already'),('en','Number of %s rules: %d','Number of %s rules: %d'),('en','Active','Active'),('en','candidate','Candidate'),('en','Bounce Regular Expressions','Bounce Regular Expressions'),('en','No Rules found','No Rules found'),('en','rule','rule'),('en','match','match'),('en','expression','expression'),('en','#bncs','#bncs'),('en','order','order'),('en','Del','Del'),('en','with tagged rules:','with tagged rules:'),('en','make active','make active'),('en','make inactive','make inactive'),('en','add a new rule','add a new rule'),('en','Add new Rule','Add new Rule'),('en','Process Next %d','Process Next %d'),('en','No match','No match'),('en','bounces did not match any current active rule','bounces did not match any current active rule'),('en','bounce matched current active rules','bounce matched current active rules'),('en','Go there','Go there'),('en','Initialise Database','Initialise Database'),('en','Change admin password','Change admin password'),('en','Verify Settings','Verify settings'),('en','Configure attributes','Configure attributes'),('en','Create public lists','Create public lists'),('en','Create a subscribe page','Create a subscribe page'),('en','Add some subscribers','Add some subscribers'),('en','Congratulations, phpList is set up, you are ready to start mailing','Congratulations, phpList is set up, you are ready to start mailing'),('en','Start a message campaign','Start a message campaign'),('en','configuration steps','Configuration steps'),('en','Overview','Overview'),('en','View Clicks by URL','View clicks per URL'),('en','View Clicks by Message','View clicks by campaign'),('en','View Opens by Message','View opens by campaign'),('en','Domain Statistics','Domain statistics'),('en','To avoid overloading the system, this will convert 10000 records at a time','To avoid overloading the system, this will convert 10000 records at a time'),('en','Admin Authentication initialisation failure','Admin Authentication initialisation failure'),('en','invalid login from %s, tried logging in as %s','invalid login from %s, tried logging in as %s'),('en','Failed sending a change password token','Failed sending a change password token'),('en','login ip invalid from %s for %s (was %s)','login ip invalid from %s for %s (was %s)'),('en','Your IP address has changed. For security reasons, please login again','Your IP address has changed. For security reasons, please login again'),('en','invalidated login from %s for %s (error %s)','invalidated login from %s for %s (error %s)'),('en','Your session timed out, please login again','Your session timed out, please login again'),('en','goodbye','goodbye'),('en','good morning','good morning'),('en','good afternoon','good afternoon'),('en','good evening','good evening'),('en','Continue Configuration','Continue Configuration'),('en','phpList will work without Javascript, but it will be easier to use if you switch it on.','phpList will work without Javascript, but it will be easier to use if you switch it on.'),('en','Running in testmode, no emails will be sent. Check your config file.','Running in testmode, no emails will be sent. Check your config file.'),('en','phpList requires PHP version 5.1.2 or higher','phpList requires PHP version 5.1.2 or higher'),('en','You are trying to use RSS, but XML is not included in your PHP','You are trying to use RSS, but XML is not included in your PHP'),('en','open_basedir restrictions are in effect, which may be the cause of the next warning','open_basedir restrictions are in effect, which may be the cause of the next warning'),('en','The attachment repository does not exist or is not writable','The attachment repository does not exist or is not writable'),('en','Process the queue','Process the queue'),('en','View the queue','View the queue'),('en','You have %s message(s) waiting to be sent','You have %s message(s) waiting to be sent'),('en','You are trying to use PDF support without having FPDF loaded','You are trying to use PDF support without having FPDF loaded'),('en','The pageroot in your config does not match the current locationCheck your config file.','The pageroot in your config does not match the current location<br/>Check your config file.'),('en','Sorry this page was not found in the plugin','Sorry this page was not found in the plugin'),('en','Sorry, that module does not exist','Sorry, that module does not exist'),('en','Sorry, not implemented yet','Sorry not Implemented yet'),('en','Access Denied','Access denied'),('en','Download as CSV file','Download as CSV file'),('en','Top 50 domains with more than 5 emails','Top 50 domains with more than 5 emails'),('en','confirmed','confirmed'),('en','perc','perc'),('en','unconfirmed','unconfirmed'),('en','num','num'),('en','Process Next Batch','Process Next Batch'),('en','Hmm, duplicate entry,','Hmm, duplicate entry,'),('en','new rules found','new rules found'),('en','bounces not matched','bounces not matched'),('en','bounces matched to existing rules','bounces matched to existing rules'),('en','Name cannot be empty:','Name cannot be empty'),('en','Existing attributes:','Existing attributes:'),('en','Attribute:','Attribute:'),('en','Name:','Name:'),('en','Default Value:','Default value:'),('en','Order of Listing:','Order of listing:'),('en','Is this attribute required?:','Is this attribute required?:'),('en','Add a new Attribute:','Add a new attribute:'),('en','Statistics','Statistics'),('en','Send Campaign','Send campaign'),('en','You should not paste the results of a test message back into the editor<br/>This will break the click-track statistics, and overload the server.','You should not paste the results of a test message back into the editor<br/>This will break the click-track statistics, and overload the server.'),('en','Warning: You indicated the content was not HTML, but there were  some HTML  tags in it. This  may  cause  errors','Warning: You indicated the content was not HTML, but there were some HTML tags in it. This may cause errors'),('en','You are trying to send a remote URL, but PEAR::HTTP_Request or CURL is not available, so this will fail','You are trying to send a remote URL, but PEAR::HTTP_Request or CURL is not available, so this will fail'),('en','Mime Type is longer than 255 characters, this is trouble','Mime Type is longer than 255 characters, this will cause problems'),('en','addingattachment','You are trying to send a remote URL, but PEAR::HTTP_Request or CURL is not available, so this will fail'),('en','Uploaded file not properly received, empty file','Uploaded file not properly received, empty file'),('en','Campaign saved as draft','Campaign saved as draft'),('en','Campaign added','Campaign added'),('en','This campaign is scheduled to stop sending before the embargo time. No mails will be sent.','This campaign is scheduled to stop sending before the embargo time. No mails will be sent.'),('en','Review Scheduling','Review scheduling'),('en','Campaign queued','Campaign queued'),('en','processqueue','process queue'),('en','View progress','view progress'),('en','Sorry, you used invalid characters in the Subject field.','Sorry, you used invalid characters in the \\\"subject\\\" field.'),('en','Sorry, you used invalid characters in the From field.','Sorry, you used invalid characters in the \\\"from\\\" field.'),('en','Please enter a from line.','Please enter a from line.'),('en','Please enter a message','Please add some content'),('en','Please enter a subject','Please enter a subject'),('en','Error: you can use an attribute in one rule only','Error: you can use an attribute in one rule only'),('en','Please select the list(s) to send the campaign to','Please select the list(s) to send the campaign to'),('en','You can send a test mail once every %d seconds','You can send a test mail once every %d seconds'),('en','No target email addresses listed for testing.','No target email addresses listed for testing.'),('en','There is a maximum of %d test emails allowed','There is a maximum of %d test emails allowed'),('en','Sent test mail to','Sent test mail to'),('en','failed','failed'),('en','Email address not found to send test message.','Email address not found to send test message.'),('en','add','add'),('en','Removed Attachment','Removed attachment'),('en','Content','Content'),('en','Text','Text'),('en','Forward','Forward'),('en','Format','Format'),('en','Attach','Attach'),('en','Scheduling','Scheduling'),('en','Finish','Finish'),('en','What is prepare a message','What is prepare a message'),('en','subject','subject'),('en','From Line','From line'),('en','Send a Webpage','Send a webpage'),('en','Compose Message','Compose message'),('en','Send a Webpage - URL','Send a webpage - URL'),('en','phpList operates in the time zone','phpList operates in the time zone'),('en','Dates and times are relative to the Server Time','Dates and times are relative to the Server Time'),('en','Current Server Time is','Current Server Time is'),('en','Embargoed Until','Embargoed until'),('en','Stop sending after','Stop sending after'),('en','Repeat campaign every','Repeat campaign every'),('en','no repetition','no repetition'),('en','hour','hour'),('en','day','day'),('en','week','week'),('en','fortnight','fortnight'),('en','four weeks','four weeks'),('en','Repeat Until','Repeat until'),('en','Requeue every','Requeue every'),('en','do not requeue','do not requeue'),('en','Requeue Until','Requeue until'),('en','Send as','Send as'),('en','HTML','HTML'),('en','Use Template','Use template'),('en','select one','select one'),('en','Plain text version of message','Plain text version of message'),('en','generate from HTML','generate from HTML'),('en','Footer','Footer'),('en','forwardfooter','Forward footer'),('en','Add attachments to your campaign','Add attachments to your campaign'),('en','The upload has the following limits set by the server','The upload has the following limits set by the server'),('en','Maximum size of total data being sent to the server','Maximum size of total data being sent to the server'),('en','Maximum size of each individual file','Maximum size of each individual file'),('en','Current Attachments','Current attachments'),('en','Filename','Filename'),('en','Size','Size'),('en','file','file'),('en','delchecked','delete checked'),('en','New Attachment','New attachment'),('en','Add (and save)','Add (and save)'),('en','or','or'),('en','Path to file on server','Path to file on server'),('en','Description of attachment','Description of attachment'),('en','Send Test','Send test'),('en','to email address(es)','to email address(es)'),('en','(comma separate addresses - all must be existing subscribers)','(comma separate addresses - all must be existing subscribers)'),('en','email to alert when sending of this message starts','email to alert when sending of this message starts'),('en','separate multiple with a comma','separate multiple with a comma'),('en','email to alert when sending of this message has finished','email address to alert when sending of this campaign has finished'),('en','add Google Analytics tracking code','add Google Analytics tracking code'),('en','Reset click statistics','Reset click statistics'),('en','Estimated size of HTML email','Estimated size of HTML message'),('en','Estimated size of text email','Estimated size of text message'),('en','Estimated size of mailout','Estimated size of mailout'),('en','About %d users to receive HTML and %s users to receive text version of email','About %d subscribers to receive HTML version and %s subscribers to receive text version'),('en','subject missing','subject missing'),('en','message content missing','message content missing'),('en','From missing','From missing'),('en','destination lists missing','destination lists missing'),('en','Content contains click track links.','Content contains click track links.'),('en','Some required information is missing. The send button will be enabled when this is resolved.','Some required information is missing. The send button will be enabled when this is resolved.'),('en','Save as draft','Save as draft'),('en','You do not have access to this page','You do not have access to this page'),('en','Select Message to view','Select Campaign to view'),('en','There are currently no messages to view','There are currently no campaigns to view'),('en','Campaigns in the last year','Campaigns in the last year'),('en','fwds','fwds'),('en','views','views'),('en','rate','rate'),('en','Comparison to other admins','Comparison to other admins'),('en','View all campaigns','View all campaigns'),('en','Date entered','Date entered'),('en','Date sent','Date sent'),('en','Sent as HTML','Sent as HTML'),('en','Sent as text','Sent as text'),('en','Bounced','Bounced'),('en','Opened','Opened'),('en','% Opened','% Opened'),('en','Clicked','Clicked'),('en','% Clicked','% Clicked'),('en','Forwarded','Forwarded'),('en','Available URLs','Available URLs'),('en','last clicked','last clicked'),('en','Select URL to view','Select URL to view'),('en','There are currently no statistics available','There are currently no statistics available'),('en','URL Click Statistics','URL click statistics'),('en','Click Details for a URL','Click details for a URL'),('en','firstclick','first click'),('en','latestclick','latest click'),('en','view users','view subscribers'),('en','click rate','click rate'),('en','total','total'),('en','To install phpList, you need to enable Javascript','To install phpList, you need to enable Javascript'),('en','The default system language is different from your browser language.','The default system language is different from your browser language.'),('en','You can set <pre>$default_system_language = \\\"%s\\\";</pre> in your config file, to use your language as the fallback language.','You can set <pre>$default_system_language = \\\"%s\\\";</pre> in your config file, to use your language as the fallback language.'),('en','It is best to do this before initialising the database.','It is best to do this before initialising the database.'),('en','phpList initialisation','phpList initialisation'),('en','Please enter your name.','Please enter your name.'),('en','The name of your organisation','The name of your organisation'),('en','Please enter your email address.','Please enter your email address.'),('en','The initial <i>login name</i> will be','The initial <i>login name</i> will be'),('en','Please enter the password you want to use for this account.','Please enter the password you want to use for this account.'),('en','minimum of 8 characters.','minimum of 8 characters.'),('en','creating tables','creating tables'),('en','Initialising table','Initialising table'),('en','Table already exists','Table already exists'),('en','ok','ok'),('en','Initialise plugin','Initialise plugin'),('en','List for testing.','List for testing.'),('en','Sign up to our newsletter','Sign up to our newsletter'),('en','Tell us about it','Tell us about it'),('en','Please make sure to read the file README.security that can be found in the zip file.','Please make sure to read the file README.security that can be found in the zip file.'),('en','Please make sure to','Please make sure to'),('en','subscribe to the announcements list','subscribe to the announcements list'),('en','to make sure you are updated when new versions come out. Sometimes security bugs are found which make it important to upgrade. Traffic on the list is very low.','to make sure you are updated when new versions come out. Sometimes security bugs are found which make it important to upgrade. Traffic on the list is very low.'),('en','Continue with','Continue with'),('en','phpList Setup','phpList Setup'),('en','Maybe you want to','Maybe you want to'),('en','instead?','instead?'),('en','Force Initialisation','Force Initialisation'),('en','(will erase all data!)','(will erase all data!)'),('en','Your database is out of date, please make sure to upgrade','Your database is out of date, please make sure to upgrade'),('en','Your version','Your version'),('en','phplist version','<a href=http://www.phplist.com>phpList</a> version'),('en','Database has not been initialised','Database has not been initialised'),('en','go to','go to'),('en','to continue','to continue'),('en','A new version of phpList is available!','A new version of phpList is available!'),('en','The new version may have fixed security issues,<br/>so it is recommended to upgrade as soon as possible','The new version may have fixed security issues,<br/>so it is recommended to upgrade as soon as possible'),('en','Latest version','Latest version'),('en','Read what has changed in the new version','Read what has changed in the new version'),('en','View what has changed','View what has changed'),('en','Download the new version','Download the new version'),('en','Download','Download'),('en','Continue the Configuration process of phpList','Continue the Configuration process of phpList'),('en','Send a campaign','Send a campaign'),('en','Start or continue a campaign','Start or continue a campaign'),('en','Manage Campaigns','Manage campaigns'),('en','View current campaigns','View current campaigns'),('en','Search, edit and add Subscribers','Search, edit and add subscribers'),('en','Main','Main'),('en','Manage Lists','Manage lists'),('en','View, edit and add lists, that your subscribers can sign up to','View, edit and add lists, that your subscribers can sign up to'),('en','List all Users','List all subscribers'),('en','Import Users','Import subscribers'),('en','Export','Export'),('en','Export Users','Export subscribers'),('en','reconcileusers','Reconcile subscribers'),('en','Reconcile the User Database','Reconcile the subscriber database'),('en','List and user functions','List and user functions'),('en','Configure','Configure'),('en','attributes','Attributes'),('en','Control values for','Control values for'),('en','spage','Subscribe page'),('en','Configure Subscribe Pages','Configure subscribe pages'),('en','Configuration Functions','Configuration functions'),('en','admins','admins'),('en','Add, edit and remove Administrators','Add, edit and remove Administrators'),('en','adminattributes','Admin attributes'),('en','Configure Attributes for administrators','Configure Attributes for administrators'),('en','Administrator Functions','Administrator functions'),('en','send','Send'),('en','Send a Message','Send a campaign'),('en','preparesend','preparesend'),('en','Prepare a Message','Prepare a Message'),('en','sendprepared','sendprepared'),('en','Send a Prepared Message','Send a Prepared Message'),('en','templates','templates'),('en','Configure Templates','Configure templates'),('en','List all Messages','List all campaigns'),('en','Process the Message Queue','Process the Queue'),('en','warning','Warning'),('en','You have set TEST in config.php to 1, so it will only show what would be sent','You have set TEST in config.php to 1, so it will only show what would be sent'),('en','processbounces','Process bounces'),('en','Process Bounces','Process Bounces'),('en','View Bounces','View Bounces'),('en','Message Functions','Campaign functions'),('en','Plugins','Plugins'),('en','Setup','Setup'),('en','dbcheck','Check database'),('en','Check Database structure','Check Database structure'),('en','eventlog','Eventlog'),('en','View the eventlog','View the eventlog'),('en','admin','admin'),('en','Change your details (e.g. password)','Change your details (e.g. password)'),('en','System Functions','System functions'),('en','Sorry, this help topic does not exist in your language. Below is the english version.','Sorry, this help topic does not exist in your language. Below is the english version.'),('en','Sorry, this help topic does not exist in your language.','Sorry, this help topic does not exist in your language.'),('en','The settings have been reset to the phpList default','The settings have been reset to the phpList default'),('en','Are you sure you want to reset the configuration to the default?','Are you sure you want to reset the configuration to the default?'),('en','Reset to default','Reset to default'),('en','You can edit all of the values in this page, and click the \\\"save changes\\\" button once to save all the changes you made.','You can edit all of the values in this page, and click the \\\"save changes\\\" button once to save all the changes you made.'),('en','cannot be empty','cannot be empty'),('en','Changes not saved','Changes not saved'),('en','settings','settings'),('en','edit this value','edit this value'),('en','Edit','Edit'),('en','No such record','No such record'),('en','Back to the list of bounces','Back to the list of bounces'),('en','Not Found','Not Found<br/>'),('en','Added %s to bouncecount for subscriber %s','Added %s to bouncecount for subscriber %s<br/>'),('en','Made subscriber %s unconfirmed','Made subscriber %s unconfirmed'),('en','Made subscriber %d to receive text','Made subscriber %d to receive text'),('en','Deleted subscriber %d','Deleted subscriber %d'),('en','Deleting bounce %d ..','Deleting bounce %d  ..'),('en','..Done, loading next bounce..','..Done, loading next bounce..'),('en','This bounce no longer exists in the database.','This bounce no longer exists in the database.'),('en','For subscriber with email','For subscriber with email'),('en','Increase bouncecount with','Increase bouncecount with'),('en','(use negative numbers to decrease)','(use negative numbers to decrease)'),('en','Mark subscriber as unconfirmed','Mark subscriber as unconfirmed'),('en','(so you can resend the request for confirmation)','(so you can resend the request for confirmation)'),('en','Set subscriber to receive text instead of HTML','Set subscriber to receive text instead of HTML'),('en','Delete subscriber','Delete subscriber'),('en','Delete this bounce and go to the next','Delete this bounce and go to the next'),('en','Do the above','Do the above'),('en','Create New Rule based on this bounce','Create New Rule based on this bounce'),('en','Possible Actions:','Possible Actions:'),('en','ID','ID'),('en','Comment','Comment'),('en','Header','Header'),('en','Body','Body'),('en','Bounce Details','Bounce details'),('en','New Rule','New rule'),('en','Test email not set','Test email address not set'),('en','Sending HTML version to','Sending HTML version to'),('en','Sending Text version to','Sending text version to'),('en','Note: Links in emails will not work, because this is a test message, which is deleted after sending','Note: Links in emails will not work, because this is a test message, which is deleted after sending'),('en','Check your INBOX to see if all worked ok','Check your INBOX to see if all worked ok'),('en','Converting to UTF-8 requires sufficient diskspace on your system.','Converting to UTF-8 requires sufficient diskspace on your system.'),('en','The maximum table size in your system is %s and space available on the root filesystem is %s, which means %s is required.','The maximum table size in your system is %s and space available on the root filesystem is %s, which means %s is required.'),('en','This is not a problem if your Database server is on a different filesystem. Click the button to continue.','This is not a problem if your Database server is on a different filesystem. Click the button to continue.'),('en','Otherwise, free up some diskspace and try again','Otherwise, free up some diskspace and try again'),('en','Confirm UTF8 conversion','Confirm UTF8 conversion'),('en','Converting DB to use UTF-8, please wait','Converting DB to use UTF-8, please wait'),('en','Unable to determine the name of the database to convert','Unable to determine the name of the database to convert'),('en','The DB was already converted to UTF-8 on','The DB was already converted to UTF-8 on'),('en','Certified Secure by','Certified secure by'),('en','phpList is licensed with the %sGNU Public License (GPL)%s','phpList is licensed with the %sGNU Public License (GPL)%s'),('en','Developers','Developers'),('en','Contributors','Contributors'),('en','Design','Design'),('en','Design implementation','Design implementation'),('en','Documentation','Documentation'),('en','Translations','Translations'),('en','The translations are provided by the phpList community (that includes you :-) )','The translations are provided by the phpList community (that includes you :-) )'),('en','The <a href=\\\"http://translate.phplist.com/\\\" target=\\\"translate\\\">translation site</a> runs <a href=\\\"http://translate.sourceforge.net/\\\" target=\\\"pootle\\\">Pootle</a> an Open Source translation tool, provided by <a href=\\\"http://translatehouse.org\\\" target=\\\"translatehouse\\\">Translate House</a>','The <a href=\\\"http://translate.phplist.com/\\\" target=\\\"translate\\\">translation site</a> runs <a href=\\\"http://translate.sourceforge.net/\\\" target=\\\"pootle\\\">Pootle</a> an Open Source translation tool, provided by <a href=\\\"http://translatehouse.org\\\" target=\\\"translatehouse\\\">Translate House</a>'),('en','Acknowledgements','Acknowledgements'),('en','The developers wish to thank the many contributors to this system, who have helped out with bug reports, suggestions, donations, feature requests, sponsoring, translations and many other contributions.','The developers wish to thank the many contributors to this system, who have helped out with bug reports, suggestions, donations, feature requests, sponsoring, translations and many other contributions.'),('en','Portions of the system include','Portions of the system include'),('en','All done, %d emails processed<br/>%d emails blacklisted<br/>%d emails deleted<br/>%d emails not found','All done, %d emails processed<br/>%d emails blacklisted<br/>%d emails deleted<br/>%d emails not found'),('en','Remove more','Remove more'),('en','Mass remove email addresses','Mass remove email addresses'),('en','Check to also add the emails to the blacklist','Check to also add the emails to the blacklist'),('en','Paste the emails to remove in this box, and click continue','Paste the emails to remove in this box, and click continue'),('en','List of Administrators','List of administrators'),('en','No Access','You do not have sufficient access'),('en','Error adding new admin, login name and/or email not inserted, email not valid or admin already exists','Error adding new administrator. Login name and/or email not inserted, email address not valid or admin already exists'),('en','Failed, you cannot delete yourself','Failed, you cannot delete yourself'),('en','Edit Administrator','Edit administrator'),('en','Add a new Administrator','Add a new administrator'),('en','hidden','hidden'),('en','Update it?','Update it?'),('en','Remind it?','Remind it?'),('en','Login Name','Login name'),('en','You do not have enough priviliges to view this page','You do not have enough priviliges to view this page'),('en','Members of','Members of'),('en','edit list details','edit list details'),('en','Download subscribers','Download subscribers'),('en','Import Subscribers to this list','Import subscribers to this list'),('en','subscribers were moved to','subscribers were moved to'),('en','subscribers were copied to','subscribers were copied to'),('en','subscribers were deleted from this list','subscribers were deleted from this list'),('en','Users found, click add to add this user','subscribers found, click add to add this subscriber'),('en','No user found with that email','No subscriber found with that email'),('en','add user','Add subscriber'),('en','Inserting user','Inserting subscriber'),('en','Listing subscriber %d to %d','Listing subscriber %d to %d'),('en','Listing subscriber 1 to 50','Listing subscriber 1 to 50'),('en','Tag all users in this page','Tag all subscribers in this page'),('en','Members','Members'),('en','Actions','Actions'),('en','What to do with \\\"Tagged\\\" users','What to do with \\\"Tagged\\\" subscribers'),('en','This will only process the users in this page that have the \\\"Tag\\\" checkbox checked','This will only process the subscribers in this page that have the \\\"Tag\\\" checkbox checked'),('en','from this list','from this list'),('en','Move','Move'),('en','Copy','Copy'),('en','Nothing','Nothing'),('en','do it','do it'),('en','Connection refused, check your host, user or password','Connection refused, check your host, user or password'),('en','processed','processed'),('en','unidentified','unidentified'),('en','view bounces by list','view bounces by list'),('en','are you sure you want to delete all unidentified bounces older than 2 months','are you sure you want to delete all unidentified bounces older than 2 months'),('en','delete all unidentified (&gt; 2 months old)','delete all unidentified (&gt; 2 months old)'),('en','are you sure you want to delete all bounces older than 2 months','Are you sure you want to delete all bounces older than 2 months'),('en','delete all processed (&gt; 2 months old)','Delete all processed (&gt; 2 months old)'),('en','are you sure you want to delete all bounces','are you sure you want to delete all bounces'),('en','Delete all','Delete all'),('en','no unidentified bounces available','no unidentified bounces available'),('en','no processed bounces available','no processed bounces available'),('en','System Message','System message'),('en','Message','Message'),('en','Website address (without http://)','Website address (without http://)'),('en','Domain Name of your server (for email)','Domain Name of your server (for email)'),('en','Person in charge of this system (one email address)','Person in charge of this system (one email address)'),('en','Name of the organisation','Name of the organisation'),('en','How often do you want to check for a new version of phplist (days)','How often do you want to check for a new version of phpList (days)'),('en','List of email addresses to CC in system messages (separate by commas)','List of email addresses to CC in system messages (separate by commas)'),('en','Default for \'From:\' in a campaign','Default for \'From:\' in a campaign'),('en','Default for \'address to alert when sending starts\'','Default for \'email address to alert when sending starts\''),('en','Default for \'address to alert when sending finishes\'','Default for \'email address to alert when sending finishes\''),('en','Always add Google tracking code to campaigns','Always add Google tracking code to campaigns'),('en','Who gets the reports (email address, separate multiple emails with a comma)','Who gets the reports (email address, separate multiple emails with a comma)'),('en','From email address for system messages','From email address for system messages'),('en','Webmaster','Webmaster'),('en','Name for system messages','Name for system messages'),('en','Reply-to email address for system messages','Reply-to email address for system messages'),('en','Categories for lists. Separate with commas.','Categories for lists. Separate with commas.'),('en','Width of a textline field (numerical)','width of a textline field (numerical)'),('en','Dimensions of a textarea field (rows,columns)','dimensions of a textarea field (rows,columns)'),('en','The default subscribe page when there are multiple','The default subscribe page when there are multiple'),('en','The default HTML template to use when sending a message','The default HTML template to use when sending a message'),('en','The HTML wrapper template for system messages','The HTML wrapper template for system messages'),('en','URL where subscribers can sign up','URL where subscribers can sign up'),('en','URL where subscribers can unsubscribe','URL where subscribers can unsubscribe'),('en','URL where unknown users can unsubscribe (do-not-send-list)','URL where unknown visitors can unsubscribe (do-not-send-list)'),('en','URL where subscribers have to confirm their subscription','URL where subscribers have to confirm their subscription'),('en','URL where subscribers can update their details','URL where subscribers can update their details'),('en','URL for forwarding messages','URL for forwarding messages'),('en','<h3>Thanks, you have been added to our newsletter</h3><p>You will receive an email to confirm your subscription. Please click the link in the email to confirm</p>','<h3>Thanks, you have been added to our newsletter</h3><p>You will receive an email message to confirm your subscription. Please click the link in the email to confirm</p>'),('en','Text to display when subscription with an AJAX request was successful','Text to display when subscription with an AJAX request was successful'),('en','Request for confirmation','Request for confirmation'),('en','Subject of the message subscribers receive when they sign up','Subject of the message subscribers receive when they sign up'),('en','Message subscribers receive when they sign up','Message subscribers receive when they sign up'),('en','Goodbye from our Newsletter','Goodbye from our newsletter'),('en','Subject of the message subscribers receive when they unsubscribe','Subject of the message subscribers receive when they unsubscribe'),('en','Message subscribers receive when they unsubscribe','Message subscribers receive when they unsubscribe'),('en','Welcome to our Newsletter','Welcome to our Newsletter'),('en','Subject of the message subscribers receive after confirming their email address','Subject of the message subscribers receive after confirming their email address'),('en','Message subscribers receive after confirming their email address','Message subscribers receive after confirming their email address'),('en','[notify] Change of List-Membership details','[notify] Change of List-Membership details'),('en','Subject of the message subscribers receive when they have changed their details','Subject of the message subscribers receive when they have changed their details'),('en','Message subscribers receive when they have changed their details','Message content subscribers receive when they have changed their details'),('en','Part of the message that is sent to their new email address when subscribers change their information, and the email address has changed','Part of the message that is sent to their new email address when subscribers change their information, and the email address has changed'),('en','Part of the message that is sent to their old email address when subscribers change their information, and the email address has changed','Part of the message that is sent to their old email address when subscribers change their information, and the email address has changed'),('en','Your personal location','Your personal location'),('en','Subject of message when subscribers request their personal location','Subject of message to send when subscribers request their personal location'),('en','Message when subscribers request their personal location','Content of message to send when subscribers request their personal location'),('en','Default footer for sending a campaign','Default footer for sending a campaign'),('en','Footer used when a message has been forwarded','Footer used when a message has been forwarded'),('en','Header of public pages.','Header of public pages'),('en','Footer of public pages','Footer of public pages'),('en','Message to send when they request their personal location','Message to send when they request their personal location'),('en','String to always append to remote URL when using send-a-webpage','String to always append to remote URL when using send-a-webpage'),('en','Width for Wordwrap of Text messages','Width for Wordwrap of Text messages'),('en','CSS for HTML messages without a template','CSS for HTML messages without a template'),('en','Domains that only accept text emails, one per line','Domains that only accept text emails, one per line'),('en','last time TLDs were fetched','last time TLDs were fetched'),('en','Top level domains','Top level domains'),('en','Back to edit template','Back to edit template'),('en','phplist test suite','phplist test suite'),('en','Test passed','Test passed'),('en','Test failed','Test failed'),('en','Tests available','Tests available'),('en','Purpose','Purpose'),('en','This page requires Javascript to be enabled.','This page requires Javascript to be enabled.'),('en','Processing queued campaigns','Processing queued campaigns'),('en','List Bounce Rules','List Bounce Rules'),('en','View Bounces per list','View Bounces per list'),('en','Check Current Bounce Rules','Check Current Bounce Rules'),('en','You currently have no rules defined.      You can click \\\"Generate Bounce Rules\\\" in order to auto-generate rules from your existing bounces.      This will results in a lot of rules which you will need to review and activate.      It will however, not catch every single bounce, so it will be necessary to add new rules over      time when new bounces come in.','You currently have no rules defined. You can click Generate Bounce Rules in order to auto-generate rules from your existing bounces. This will results in a lot of rules which you will need to review and activate. It will however, not catch every single bounce, so it will be necessary to add new rules over time when new bounces come in.'),('en','You have already defined bounce rules in your system.      Be careful with generating new ones, because these may interfere with the ones that exist.','You have already defined bounce rules in your system.      Be careful with generating new ones, because these may interfere with the ones that exist.'),('en','Generate Bounce Rules','Generate Bounce Rules'),('en','over treshold, user marked unconfirmed','over treshold, subscriber marked unconfirmed'),('en','Invalid security token. Please reload the page and try again.','Invalid security token, please reload the page and try again'),('en','phpList Export on %s from %s to %s (%s).csv','phpList subscribers on %s from %s to %s (%s).csv'),('en','phpList Export from %s to %s (%s).csv','phpList subscribers from %s to %s (%s).csv'),('en','List Membership','List Membership'),('en','Export subscribers on %s','<h4>Export subscribers on %s</h4>'),('en','What date needs to be used:','What date needs to be used:'),('en','Any date','Any date'),('en','When they signed up','When they signed up'),('en','When the record was changed','When the record was changed'),('en','Based on changelog','Based on changelog'),('en','When they subscribed to','When they subscribed to'),('en','Date From:','Date From:'),('en','Date To:','Date To:'),('en','Select the columns to include in the export','Select the columns to include in the export'),('en','add_list','Add a new list'),('en','Please enter details of the remote Server','Please enter details of the remote server'),('en','Server:','Server'),('en','Password:','Password'),('en','Database Name:','Database Name'),('en','Table prefix:','Table prefix'),('en','Usertable prefix:','Usertable prefix'),('en','select_lists','Select the lists'),('en','Copy lists from remote server (lists are matched by name)','Copy lists from remote server (lists are matched by name)'),('en','Mark new users as HTML:','Mark new subscribers as HTML'),('en','If you check \\\"Overwrite Existing\\\", information about a user in the database will be replaced by the imported information. Users are matched by email.','If you check \\\"Overwrite existing\\\", information about a subscriber in the database will be replaced by the imported information. Subscribers are matched by email.'),('en','Overwrite Existing:','Overwrite existing'),('en','Making connection with remote database','Making connection with remote database'),('en','cannot connect to remote database','Unable to connect to the remote database'),('en','Getting data from','Getting data from'),('en','Remote version is','Remote version is'),('en','Remote version has','Remote version has'),('en','No users to copy, is the prefix correct?','No subscribers to copy, is the prefix correct?'),('en','Copying lists','Copying lists'),('en','exists locally','exists locally'),('en','created locally','created locally'),('en','Remote list','Remote list'),('en','not created','not created'),('en','Copying attributes','Copying attributes'),('en','Copying users','Copying subscribers'),('en','Error, no mapped attribute for','Error, no mapped attribute for'),('en','Error, no local list defined for','Error, no local list defined for'),('en','new users','new subscribers'),('en','and','and'),('en','existing users','existing subscribers'),('en','pagetitle:home','Dashboard'),('en','pagetitle:setup','Configuration'),('en','pagetitle:about','About phpList'),('en','pagetitle:attributes','Configure attributes'),('en','pagetitle:stresstest','Stress test'),('en','pagetitle:list','Subscriber lists'),('en','pagetitle:catlists','Categorise lists'),('en','pagetitle:editattributes','Configure attributes'),('en','pagetitle:editlist','Edit a list'),('en','pagetitle:checki18n','Check that translations exist'),('en','pagetitle:importsimple','Import subscribers by copy-and-paste'),('en','pagetitle:import4','Import subscribers from a remote database'),('en','pagetitle:import3','Import subscribers from IMAP'),('en','pagetitle:import2','Import subscribers from CSV file'),('en','pagetitle:import1','Import subscribers from text file'),('en','pagetitle:import','Import emails'),('en','pagetitle:export','Export subscribers'),('en','pagetitle:initialise','Initialise the database'),('en','pagetitle:send','Send a campaign'),('en','pagetitle:preparesend','Prepare a message for sending'),('en','pagetitle:sendprepared','Send a prepared message'),('en','pagetitle:members','List membership'),('en','pagetitle:users','Search subscribers'),('en','pagetitle:reconcileusers','Reconcile subscribers'),('en','pagetitle:user','Subscriber profile'),('en','pagetitle:userhistory','History of a subscriber profile'),('en','pagetitle:messages','List of campaigns'),('en','pagetitle:message','View a campaign'),('en','pagetitle:processqueue','Send the queue'),('en','pagetitle:defaults','Some default attribute values'),('en','pagetitle:upgrade','Upgrade phpList'),('en','pagetitle:templates','Manage campaign templates'),('en','pagetitle:template','Add or edit a template'),('en','pagetitle:viewtemplate','Template preview'),('en','pagetitle:configure','Settings'),('en','pagetitle:admin','Edit or add an administrator'),('en','pagetitle:admins','Manage administrators'),('en','pagetitle:adminattributes','Configure administrator attributes'),('en','pagetitle:processbounces','Process bounces'),('en','pagetitle:bounces','View bounces'),('en','pagetitle:bounce','View a bounce'),('en','pagetitle:spageedit','Edit a subscribe page'),('en','pagetitle:spage','Subscribe pages'),('en','pagetitle:eventlog','Log of events'),('en','pagetitle:getrss','Retrieve RSS feeds'),('en','pagetitle:viewrss','View RSS items'),('en','pagetitle:community','Help'),('en','pagetitle:vote','Vote for phpList'),('en','pagetitle:login','Login'),('en','pagetitle:logout','Log out'),('en','pagetitle:mclicks','Campaign click statistics'),('en','pagetitle:uclicks','URL click statistics'),('en','pagetitle:massunconfirm','Suppression list'),('en','pagetitle:massremove','Remove subscribers'),('en','pagetitle:usermgt','Manage subscribers'),('en','pagetitle:bouncemgt','Manage bounces'),('en','pagetitle:domainstats','Domain statistics'),('en','pagetitle:mviews','View opens'),('en','pagetitle:statsmgt','Manage statistics'),('en','pagetitle:statsoverview','Statistics overview'),('en','pagetitle:subscriberstats','Subscriber statistics'),('en','pagetitle:dbcheck','Verify the DB structure'),('en','pagetitle:importadmin','Import administrators'),('en','pagetitle:dbadmin','DB management'),('en','pagetitle:usercheck','Verify that subscribers exist'),('en','pagetitle:listbounces','View bounces per list'),('en','pagetitle:bouncerules','Bounce rules'),('en','pagetitle:checkbouncerules','Check bounce rules'),('en','pagetitle:translate','Translate phpList'),('en','pagetitle:ajaxform','Ajax integration'),('en','pagetitle:updatetranslation','Update translations'),('en','pagetitle:reindex','Rebuild DB indexes'),('en','pagetitle:config','Settings'),('en','pagetitle:info','System info'),('en','pagetitle:converttoutf8','Convert to UTF8'),('en','pagetitlehover:home','Go to the dashboard page'),('en','pagetitlehover:setup','List of things to do to configure phpList correctly'),('en','pagetitlehover:about','More information about the phpList application'),('en','pagetitlehover:attributes','Create, edit and change attributes for subscribers'),('en','pagetitlehover:stresstest','Stress test'),('en','pagetitlehover:list','Lists that subscribers can sign up to'),('en','pagetitlehover:catlists','Organise the subscriber lists in categories'),('en','pagetitlehover:editattributes','Edit the details for an attribute'),('en','pagetitlehover:editlist','Change the details for a list'),('en','pagetitlehover:checki18n','Verify the existing translations'),('en','pagetitlehover:importsimple','Import subscribers by copying them from a document and pasting them into phpLIst'),('en','pagetitlehover:import4','Import subscribers from a remote database'),('en','pagetitlehover:import3','Import subscribers from IMAP'),('en','pagetitlehover:import2','Import subscribers from a file containing their email and additional information'),('en','pagetitlehover:import1','Import subscribers by uploading a plan-text file with email addresses'),('en','pagetitlehover:import','Import subscribers into the database'),('en','pagetitlehover:export','Download subscribers in the system'),('en','pagetitlehover:initialise','Create all the database tables required for phpList to work correctly'),('en','pagetitlehover:send','Create a campaign to send out to your subscribers'),('en','pagetitlehover:preparesend','Prepare a message for sending'),('en','pagetitlehover:sendprepared','Send a prepared message'),('en','pagetitlehover:members','View the subscribers who are member of a list'),('en','pagetitlehover:users','Search subscribers in the system'),('en','pagetitlehover:reconcileusers','Several functions to clean up the database of subscribers'),('en','pagetitlehover:user','View the profile of a subscriber in the system'),('en','pagetitlehover:userhistory','View the history of the profile  of a subscriber'),('en','pagetitlehover:messages','View the list of campaigns'),('en','pagetitlehover:message','View details for a campaign'),('en','pagetitlehover:processqueue','Send the queued campaigns'),('en','pagetitlehover:defaults','Choose from some common attributes provided by the phpList community'),('en','pagetitlehover:upgrade','Upgrade the phpList database to be in line with the current version of the code'),('en','pagetitlehover:templates','View and manage campaign templates, that are used to send out HTML emails'),('en','pagetitlehover:template','Add or edit a campaign template'),('en','pagetitlehover:viewtemplate','Template preview'),('en','pagetitlehover:configure','Change the settings that control how phpList behaves'),('en','pagetitlehover:admin','Edit or add an administrator who can login to phpList to manage aspects of the system'),('en','pagetitlehover:admins','View, edit and add administrators who have access to all or part of the phpList system'),('en','pagetitlehover:adminattributes','Configure administrator attributes'),('en','pagetitlehover:processbounces','Fetch the bounced emails from the bounce mailbox and process them'),('en','pagetitlehover:bounces','View the bounced emails in the system'),('en','pagetitlehover:bounce','View a bounce'),('en','pagetitlehover:spageedit','Edit a page your subscribers can use to sign up to the system'),('en','pagetitlehover:spage','View and edit the pages that subscribers can use to sign up to the system'),('en','pagetitlehover:eventlog','View some interesting events that have happened in phpList'),('en','pagetitlehover:getrss','Retrieve RSS feeds'),('en','pagetitlehover:viewrss','View RSS items'),('en','pagetitlehover:community','How to get help and how to help out with phpList'),('en','pagetitlehover:vote','Vote for phpList on sites around the world'),('en','pagetitlehover:login','Login'),('en','pagetitlehover:logout','Log out'),('en','pagetitlehover:mclicks','Statistics of subscribers who clicked on links in the campaigns'),('en','pagetitlehover:uclicks','Statistics for URLs that were sent out across all campaigns, listed by URL'),('en','pagetitlehover:massunconfirm','Manage the list of subscribers who should NOT be sent emails'),('en','pagetitlehover:massremove','Remove subscribers from the system.'),('en','pagetitlehover:usermgt','Common functions to manage the subscribers'),('en','pagetitlehover:bouncemgt','Manage messages that were returned due to delivery errors'),('en','pagetitlehover:domainstats','Statistics of domains of the subscribers in the system'),('en','pagetitlehover:mviews','View who opened the campaigns that were sent out'),('en','pagetitlehover:statsmgt','List of common statistics functions in phpList'),('en','pagetitlehover:statsoverview','Summary of statistics of the last few campaigns sent out'),('en','pagetitlehover:subscriberstats','Subscriber statistics'),('en','pagetitlehover:dbcheck','Verify that the current database structure is correct for the current version of the code'),('en','pagetitlehover:importadmin','Import administrators who have access to all or some parts of the system'),('en','pagetitlehover:dbadmin','DB management'),('en','pagetitlehover:usercheck','Copy and paste a list of emails and verify that they exist in the system, without adding them'),('en','pagetitlehover:listbounces','View bounced emails per subscriber list'),('en','pagetitlehover:bouncerules','Manage the rules that determine what to do with bounced emails'),('en','pagetitlehover:checkbouncerules','Check bounce rules'),('en','pagetitlehover:translate','Translate phpList'),('en','pagetitlehover:ajaxform','Ajax integration'),('en','pagetitlehover:updatetranslation','Fetch the latest translation from the community translation system'),('en','pagetitlehover:reindex','Rebuild database indexes to speed up database queries'),('en','pagetitlehover:config','Configuration functions'),('en','pagetitlehover:info','System information, useful for developers and more technical people'),('en','pagetitlehover:converttoutf8','Check and action upgrade of the phpList database to use UTF8, which allows the use of special characters'),('en','Subscribe page information saved','Subscribe page information saved'),('en','Title of this set of lists','Title of this set of lists'),('en','Please indicate how often you want to receive messages','Please indicate how often you want to receive messages'),('en','General Information','General Information'),('en','Title','Title'),('en','default','default'),('en','Language file to use','Language file to use'),('en','Intro','Intro'),('en','Thank you page','Thank you page'),('en','Text for Button','Text for button'),('en','HTML Email choice','HTML Email choice'),('en','Don\'t offer choice, default to <b>text</b>','Don\'t offer choice, default to <b>text</b>'),('en','Don\'t offer choice, default to <b>HTML</b>','Don\'t offer choice, default to <b>HTML</b>'),('en','Offer checkbox for text','Offer checkbox for text'),('en','Offer checkbox for HTML','Offer checkbox for HTML'),('en','Radio buttons, default to text','Radio buttons, default to text'),('en','Radio buttons, default to HTML','Radio buttons, default to HTML'),('en','Display email confirmation','Display email address confirmation field'),('en','Don\'t display email confirmation','Don\'t display email address confirmation field'),('en','Transaction messages','Transaction messages'),('en','Message they receive when they subscribe','Content of message subscribers receive when they subscribe'),('en','Message they receive when they confirm their subscription','Message they receive when they confirm their subscription'),('en','Message they receive when they unsubscribe','Content of the message they receive when they unsubscribe'),('en','Select the attributes to use','Select the attributes to use'),('en','Check this box to use this attribute in the page','Check this box to use this attribute in the page'),('en','Information needed for %s','Information needed for %s'),('en','Select the lists to offer','Select the lists to offer'),('en','You can only select \\\"public\\\" lists for subscribe pages.','You can only select \\\"public\\\" lists for subscribe pages.'),('en','No lists available, please create one first','No lists available, please create one first'),('en','Owner','Owner'),('en','default login is','Default login is'),('en','with password','with password'),('en','In order to login, you need to enable cookies in your browser','In order to login, you need to enable cookies in your browser'),('en','Forgot password','Forgot Password?'),('en','Enter your email address','Enter your email address'),('en','Send password','Send Password'),('en','Your password was changed succesfully','Your password was changed successfully'),('en','The passwords you entered are not the same.','The passwords you entered are not the same.'),('en','You have requested a password update','You have requested a password update'),('en','New password','New password'),('en','Confirm password','confirm password'),('en','Unknown token or time expired (More than 24 hrs. passed since the notification email was sent)','Unknown token or time expired (More than 24 hrs. passed since the notification email was sent)'),('en','Choose a message','Choose a campaign'),('en','Listing %s to %s','Listing %s to %s'),('en','Add new admin','Add new admin'),('en','You cannot delete yourself','You cannot delete yourself'),('en','Admin added','Admin added'),('en','Administrators','Administrators'),('en','found','found'),('en','Find an admin','Find an admin'),('en','Show','Show'),('en','Import list of admins','Import list of admins'),('en','Open Source','Open Source'),('en','How to get help','How to get help'),('en','How to help out','How to help out'),('en','phpList is Open Source software','phpList is Open Source software'),('en','The concept behind open source is collaboration. A loosely organised network of many contributors where the whole is greater than the sum of its parts.','The concept behind open source is collaboration. A loosely organised network of many contributors where the whole is greater than the sum of its parts.'),('en','If you are interested to know more about Open Source, you can visit the links below','If you are interested to know more about Open Source, you can visit the links below'),('en','Get help with phpList','Get help with phpList'),('en','To be written. In the meantime you can <a href=\\\"http://www.phplist.com/support\\\">visit the support section on the phpList website</a>','To be written. In the meantime you can <a href=\\\"http://www.phplist.com/support\\\">visit the support section on the phpList website</a>'),('en','Help out with phpList','Help out with phpList'),('en','To be written. In the meantime you can <a href=\\\"http://www.phplist.com/developers\\\">visit the developers section on the phpList website</a>','To be written. In the meantime you can <a href=\\\"http://www.phplist.com/developers\\\">visit the developers section on the phpList website</a>'),('en','Initialising language','Initialising language'),('en','Up to date','Up to date'),('en','The plugin','The plugin'),('en','Invalid download URL, please reload the page and try again','Invalid download URL, please reload the page and try again'),('en','Fetching plugin','Fetching plugin'),('en','developer','Developer'),('en','Project','Project'),('en','Unable to download plugin package, check your connection','Unable to download plugin package, check your connection'),('en','Installing plugin','Installing plugin'),('en','updating existing plugin','updating existing plugin'),('en','new plugin','new plugin'),('en','Plugin installed successfully','Plugin installed successfully'),('en','Error installing plugin','Error installing plugin'),('en','Plugin directory is not writable','Plugin directory is not writable'),('en','Plugin installation failed','Plugin installation failed'),('en','The plugin root directory is not writable, please install plugins manually','The plugin root directory is not writable, please install plugins manually'),('en','PHP has no <a href=\\\"http://php.net/zip\\\">Zip capability</a>. This is required to allow installation from a remote URL','PHP has no <a href=\\\"http://php.net/zip\\\">Zip capability</a>. This is required to allow installation from a remote URL'),('en','Install a new plugin','Install a new plugin'),('en','Find plugins','Find plugins'),('en','Plugin package URL','Plugin package URL'),('en','Install plugin','Install plugin'),('en','Installed plugins','Installed plugins'),('en','version','version'),('en','Description','Description'),('en','installed','installed'),('en','installation Url','installation Url'),('en','enabled','enabled'),('en','Initialise','Initialise'),('en','delete this plugin','delete this plugin'),('en','update this plugin','update this plugin'),('en','update','update'),('en','delete user','delete subscriber'),('en','unconfirm user','unconfirm subscriber'),('en','blacklist user','blacklist subscriber'),('en','delete user and bounce','delete subscriber and bounce'),('en','unconfirm user and delete bounce','unconfirm subscriber and delete bounce'),('en','blacklist user and delete bounce','blacklist subscriber and delete bounce'),('en','delete bounce','delete bounce'),('en','Unnamed List','Unnamed list'),('en','Hello','Hello'),('en','You have requested a new password for phpList.','You have requested a new password for phpList.'),('en','To enter a new one, please visit the following link:','To enter a new one, please visit the following link:'),('en','You have 24 hours left to change your password. After that, your token won\'t be valid.','You have 24 hours left to change your password. After that, your token won\'t be valid.'),('en','A password change token has been sent to the corresponding email address.','A password change token has been sent to the corresponding email address.'),('en','Error sending password change token','Error sending password change token'),('en','Sending admin copy to','Sending admin copy to'),('en','very little time','very little time'),('en','This is the Newsletter Subject','This is the Newsletter Subject'),('en','A process for this page is already running and it was still alive %s seconds ago','A process for this page is already running and it was still alive %s seconds ago'),('en','Running commandline, quitting. We\'ll find out what to do in the next run.','Running commandline, quitting. We\'ll find out what to do in the next run.'),('en','Sleeping for 20 seconds, aborting will quit','Sleeping for 20 seconds, aborting will quit'),('en','We have been waiting too long, I guess the other process is still going ok','We have been waiting too long, I guess the other process is still going ok'),('en','Categorise lists','Categorise lists'),('en','Uncategorised','Uncategorised'),('en','You seem to have quite a lot of lists, do you want to organise them in categories?','You seem to have quite a lot of lists, do you want to organise them in categories?'),('en','Great idea!','Great idea!'),('en','Public','Public'),('en','Are you sure you want to delete this list?','Are you sure you want to delete this list?'),('en','delete this list','delete this list'),('en','start a new campaign targetting this list','start a new campaign targetting this list'),('en','No lists, use Add List to add one','No lists, use Add List to add one'),('en','Import emails from IMAP folders','Import emails from IMAP folders'),('en','can\'t connect','can\'t connect'),('en','imap_getmailboxes failed','imap_getmailboxes failed'),('en','Please enter details of the IMAP account','Please enter details of the IMAP account'),('en','Server','Server'),('en','Select the headers fields to search','Select the headers fields to search'),('en','Mark new users as HTML','Mark new subscribers as HTML'),('en','If you check','If you check'),('en','information about a user in the database will be replaced by the imported information. Users are matched by email.','information about a subscriber in the database will be replaced by the imported information. Subscribers are matched by email.'),('en','Only use complete addresses','Only use complete addresses'),('en','addresses that do not have a real name will be ignored. Otherwise all emails will be imported.','addresses that do not have a real name will be ignored. Otherwise all emails will be imported.'),('en','If you choose','If you choose'),('en','the users you are adding will be sent the request for confirmation of subscription to which they will have to reply. This is recommended, because it will identify invalid emails.','the subscribers you are adding will be sent the request for confirmation of subscription to which they will have to reply. This is recommended, because it will identify invalid emails.'),('en','Send&nbsp;Notification&nbsp;email&nbsp;','Send&nbsp;Notification&nbsp;email&nbsp;'),('en','There are two ways to add the names of the users,  either one attribute for the entire name or two attributes, one for first name and one for last name. If you use &quot;two attributes&quot;, the name will be split after the first space.','There are two ways to add the names of the subscribers,  either one attribute for the entire name or two attributes, one for first name and one for last name. If you use \'two attributes\', the name will be split after the first space.'),('en','Use one attribute for name','Use one attribute for name'),('en','Use two attributes for the name','Use two attributes for the name'),('en','Attribute one','Attribute one'),('en','Create Attribute','Create Attribute'),('en','Attribute two','Attribute two'),('en','Cannot continue','Cannot continue'),('en','Process Selected Folders','Process Selected Folders'),('en','folders and','folders and'),('en','unique emails found','unique emails found'),('en','All the emails already exist in the database and are members of the','All the emails already exist in the database and are members of the'),('en','emails already existed in the database','emails already existed in the database'),('en','Invalid Emails found.','Invalid Emails found.'),('en','These records were added, but the email has been made up. You can find them by doing a search on','These records were added, but the email has been made up. You can find them by doing a search on'),('en','No emails found','No emails found'),('en','Please select a message to display','Please select a message to display'),('en','campaign requeued','Campaign re-queued'),('en','This campaign is scheduled to stop sending in the past. No mails will be sent.','This campaign is scheduled to stop sending in the past. No mails will be sent.'),('en','No such message','No such message'),('en','Edit this message','Edit this campaign'),('en','Attachments for this message','Attachments for this message'),('en','No attachments','No attachments'),('en','Mime Type','Mime Type'),('en','This campaign has been sent to subscribers, who are member of the following lists','This campaign has been sent to subscribers, who are member of the following lists'),('en','None yet','None yet'),('en','Except when they were also member of these lists','Except when they were also member of these lists'),('en','Send this (same) message to (a) new list(s)','Send this (same) message to (a) new list(s)'),('en','List is Active','List is Active'),('en','List is not Active','List is not Active'),('en','<b>Note:</b> this message has already been sent to all lists. To resend it to new users use the \\\"Requeue\\\" function.','<b>Note:</b> this message has already been sent to all lists. To resend it to new subscribers use the \\\"requeue\\\" function.'),('en','Resend','Resend'),('en','Existing subscribers','Existing subscribers'),('en','Non existing subscribers','Non existing subscribers'),('en','Key','Key'),('en','What is the type of information you want to check','What is the type of information you want to check'),('en','Paste the values to check in this box, one per line','Paste the values to check in this box, one per line'),('en','search subscribers','search subscribers'),('en','manage subscriber attributes','manage subscriber attributes'),('en','edit values for attributes','edit values for attributes'),('en','Reconcile Subscribers','Reconcile Subscribers'),('en','Suppression list','Suppression list'),('en','Bulk remove subscribers','Bulk remove subscribers'),('en','Verify subscribers','Verify subscribers'),('en','Import subscribers','Import subscribers'),('en','Export subscribers','Export subscribers'),('en','subscriber management functions','subscriber management functions'),('en','Available Messages','Available campaigns'),('en','in progress','in progress'),('en','Entered','Entered'),('en','Open statistics','Open statistics'),('en','Entries','Entries'),('en','firstview','firstview'),('en','lastview','lastview'),('en','Jan','Jan'),('en','Feb','Feb'),('en','Mar','Mar'),('en','Apr','Apr'),('en','Jun','Jun'),('en','Jul','Jul'),('en','Aug','Aug'),('en','Sep','Sep'),('en','Oct','Oct'),('en','Nov','Nov'),('en','Dec','Dec'),('en','Adding index <b>%s</b> to %s</li>','Adding index <b>%s</b> to %s</li>'),('en','Adding index <b>%s</b> to %s<br/>','Adding index <b>%s</b> to %s<br/>'),('en','Adding unique index <b>%s</b> to %s</li>','Adding unique index <b>%s</b> to %s</li>'),('en','Adding unique index <b>%s</b> to %s<br/>','Adding unique index <b>%s</b> to %s<br/>'),('en','Start a new campaign','Start a new campaign'),('en','draft','draft'),('en','static','static'),('en','Requeuing','Requeuing'),('en','Suspending','Suspending'),('en','Marking as sent','Marking as sent'),('en','Suspending all','Suspending all'),('en','Marking all as sent','Marking all as sent'),('en','Unique Views','Unique Views'),('en','Time to send','Time to send'),('en','PDF','PDF'),('en','both','both'),('en','Suspend','Suspend'),('en','Mark&nbsp;sent','Mark&nbsp;sent'),('en','Mark sent','Mark sent'),('en','Suspend All','Suspend all'),('en','Mark All Sent','Mark all sent'),('en','Deleted all entries older than 2 months','Deleted all entries older than 2 months'),('en','Deleted all entries','Deleted all entries'),('en','Events','Events'),('en','Are you sure you want to delete all events older than 2 months?','Are you sure you want to delete all events older than 2 months?'),('en','Delete all (&gt; 2 months old)','Delete all (&gt; 2 months old)'),('en','Are you sure you want to delete all events matching this filter?','Are you sure you want to delete all events matching this filter?'),('en','No events available','No events available'),('en','Filter','Filter'),('en','Exclude filter','Exclude filter'),('en','page','page'),('en','Hint: this page also works from commandline','Hint: this page also works from commandline'),('en','creating tables done','creating tables done'),('en','%d entries still to convert','%d entries still to convert'),('en','converting data','converting data'),('en','processing cancelled','processing cancelled'),('en','Optimizing table to recover space','Optimizing table to recover space'),('en','Finished','Finished'),('en','Convert some more','Convert some more'),('en','\\n-------------------------------------------------------------------------------- \\n    This is a notification of a possible spam attack to your phplist subscribe page.\\n    The data submitted has been copied below, so you can check whether this was actually the case.\\n    The submitted data has been converted into non-html characters, for security reasons.\\n    If you want to stop receiving this message, set \\n    \\n     define(\\\"NOTIFY_SPAM\\\",0);  \\n     \\n     in your phplist config file.  \\n     \\n     This subscriber has NOT been added to the database. \\n     If there is an error, you will need to  add them manually.\\n--------------------------------------------------------------------------------','\\n------------------------------------------------------------------------------- \\nThis is a notification of a possible spam attack to your phplist subscribe page.\\nThe data submitted has been copied below, so you can check whether this was actually the case. \\nThe submitted data has been converted into non-html characters, for security reasons.\\nIf you want to stop receiving this message, set \\n\\ndefine(NOTIFY_SPAM,0);\\n\\n in your phplist config file.\\nThis subscriber has not been added to the database.\\nIf there is an error, you will need to  add them manually\\n\\n --------------------------------------------------------------------------------  \\n'),('en','phplist Spam blocked','phplist Spam blocked'),('en','Email is blacklisted, so request for confirmation has been sent.','Subscriber is blacklisted, so request for confirmation has been sent.'),('en','If user confirms subscription, they will be removed from the blacklist.','If subscriber confirms subscription, they will be removed from the blacklist.'),('en','Deleted','Deleted'),('en','subscribe pages','Subscribe pages'),('en','not active','not active'),('en','Resending confirmation request to','Resending confirmation request to'),('en','user found','subscriber found'),('en','no user found','no subscriber found'),('en','unable to find original email','unable to find original email address'),('en','Marking all subscribers confirmed','Marking all subscribers confirmed'),('en','Marking all subscribers on list %s confirmed','Marking all subscribers on list %s confirmed'),('en','subscribers apply','subscribers apply'),('en','Creating UniqID for all subscribers who do not have one','Creating UniqID for all subscribers who do not have one'),('en','Marking all subscribers to receive HTML','Marking all subscribers to receive HTML'),('en','Marking all subscribers to receive text','Marking all subscribers to receive text'),('en','Deleting subscribers who are not on any list','Deleting subscribers who are not on any list'),('en','Moving subscribers who are not on any list to','Moving subscribers who are not on any list to'),('en','Deleting subscribers with more than','Deleting subscribers with more than'),('en','Resending request for confirmation to subscribers who signed up after','Resending request for confirmation to subscribers who signed up after'),('en','and before','and before'),('en','Deleting unconfirmed subscribers who signed up after','Deleting unconfirmed subscribers who signed up after'),('en','Trying to merge duplicates','Trying to merge duplicates'),('en','Don\'t know how to','Don\'t know how to'),('en','Trying to fix subscribers with an invalid email','Trying to fix subscribers with an invalid email address'),('en','subscribers fixed','subscribers fixed'),('en','subscribers could not be fixed','subscribers could not be fixed'),('en','Deleting subscribers with an invalid email','Deleting subscribers with an invalid email address'),('en','subscribers deleted','subscribers deleted'),('en','Marking subscribers with an invalid email as unconfirmed','Marking subscribers with an invalid email as unconfirmed'),('en','subscribers updated','subscribers updated'),('en','Cleaning some user tables of invalid entries','Cleaning some user tables of invalid entries'),('en','entries apply','entries apply'),('en','in the database','in the database'),('en','-All-','-All-'),('en','Mark all subscribers to receive HTML','Mark all subscribers to receive HTML'),('en','Mark all subscribers to receive text','Mark all subscribers to receive text'),('en','Mark all subscribers on list %s confirmed','Mark all subscribers on list %s confirmed'),('en','Click here','Click here'),('en','To move all subscribers who are not subscribed to any list to %s','To move all subscribers who are not subscribed to any list to %s'),('en','To delete all subscribers with more than','To delete all subscribers with more than'),('en','Note: this will use the total count of bounces on a subscriber, not consecutive bounces','Note: this will use the total count of bounces on a subscriber, not consecutive bounces'),('en','To delete subscribers who signed up and have not confirmed their subscription','To delete subscribers who signed up and have not confirmed their subscription'),('en','Date they signed up after','Date they signed up after'),('en','Date they signed up before','Date they signed up before'),('en','You cannot create a new list because you have reached maximum number of lists.','You cannot create a new list because you have reached maximum number of lists.'),('en','Members of this list','Members of this list'),('en','New list added','New list added'),('en','List name','List name'),('en','Public list (listed on the frontend)','Public list (listed on the frontend)'),('en','Order for listing','Order for listing'),('en','Category','Category'),('en','choose category','Choose category'),('en','List Description','List Description'),('en','save','Save'),('en','Cancel','Cancel'),('en','Do not save, and go back to the lists','Do not save, and go back to the lists'),('en','No list categories have been defined','No list categories have been defined'),('en','Once you have set up a few categories, come back to this page to classify your lists with your categories.','Once you have set up a few categories, come back to this page to classify your lists with your categories.'),('en','Configure Categories','Configure categories'),('en','Categories saved','Categories saved'),('en','All lists have already been assigned a category','All lists have already been assigned a category'),('en','Loading','Loading'),('en','return to editing attributes','return to editing attributes'),('en','N/A','N/A'),('en','links','links'),('en','user clicks','user clicks'),('en','clickrate','click rate'),('en','total clicks','total clicks'),('en','Click Details for a Message','Click details for a campaign'),('en','Sent to','Sent to'),('en','Message Click Statistics','Campaign click statistics'),('en','import_by','imported by'),('en','Imported','Imported'),('en','%d lines processed','%d lines processed'),('en','%d email imported','%d email imported'),('en','%d duplicates','%d duplicates'),('en','%d invalidated','%d invalidated'),('en','%d addresses were blacklisted and have not been subscribed to the list','%d addresses were blacklisted and have not been subscribed to the list'),('en','Adding subscribers','Adding subscribers'),('en','Please enter the emails to import, one per line, in the box below and click \\\"Import Emails\\\"','Please enter the email addresses to import, one per line, in the box below and click \\\"Import Emails\\\"'),('en','Check to skip emails that are not valid','Check to skip email addresses that are not valid'),('en','Import emails','Import emails'),('en','Invalid value for email address','Invalid value for email address'),('en','error','Error'),('en','fatalerror','Fatal error'),('en','Documentation about this error','Documentation about this error'),('en','Main Page','Dashboard'),('en','about','about'),('en','In this section','In this section'),('en','Recently visited','Recently Visited'),('en','All Lists','All Lists'),('en','All Active Lists','All Active Lists'),('en','Public list','Public list'),('en','Private list','Private list'),('en','There are no lists available','There are no lists available'),('en','years','years'),('en','days','days'),('en','hours','hours'),('en','mins','minutes'),('en','secs','seconds'),('en','Placeholder','Placeholder'),('en','Listing %d to %d of %d','Listing %d to %d of %d'),('en','Listing %d to %d','Listing %d to %d'),('en','First Page','First Page'),('en','Last Page','Last Page'),('en','All draft campaigns deleted','All draft campaigns deleted'),('en','campaigns deleted','campaigns deleted'),('en','Campaign deleted','Campaign deleted'),('en','start a new message','start a new campaign'),('en','Choose an existing draft message to work on','Choose an existing draft campaign to work on'),('en','Draft messages','Draft campaigns'),('en','age','age'),('en','Please select the lists you want to send your campaign to','Please select the lists you want to send your campaign to'),('en','Please select the lists you want to exclude from this campaign','Please select the lists you want to exclude from this campaign'),('en','The campaign will go to users who are a member of the lists above,     unless they are a member of one of the lists you select here.','The campaign will go to subscribers who are a member of the lists above, unless they are also a member of one of the lists you select here.'),('en','test processing error','test processing error'),('en','test Processing info','test processing info'),('en','mails in mailbox','mails in mailbox'),('en','tests','tests'),('en','test_protocol not supported','test_protocol not supported'),('en','User Click Statistics','Subscriber click statistics'),('en','User Click Details for a URL in a message','Subscriber click details for a URL in a message'),('en','User Click Details for a Message','Subscriber click details for a message'),('en','User Click Details for a URL','Subscriber click details for a URL'),('en','User Click Details','Subscriber click details'),('en','view user','view subscriber'),('en','No such attribute:','No such attribute'),('en','This datatype does not have editable values','This datatype does not have editable values'),('en','Back to attributes','Back to attributes'),('en','Add new','Add new'),('en','Are you sure you want to delete all values?','Are you sure you want to delete all values?'),('en','Alternatively you can replace all values with another one:','Alternatively you can replace all values with another one:'),('en','Replace with','Replace with'),('en','Delete and replace','Delete and replace'),('en','Cannot delete','Cannot delete'),('en','The following subscriber(s) are dependent on this value<br />Update the subscriber profiles to not use this attribute value and try again','The following subscriber(s) are dependent on this value<br />Update the subscriber profiles to not use this attribute value and try again'),('en','* Too many to list, total dependencies:','* Too many to list, total dependencies:'),('en','* Too many errors, quitting','* Too many errors, quitting'),('en','one per line','one per line'),('en','Change order','Change order'),('en','No template have been defined','No template have been defined'),('en','Existing templates','Existing templates'),('en','Campaign Default','Campaign default'),('en','System','System'),('en','Add new Template','Add new template'),('en','Add default system template','Add default system template'),('en','No such template','No such template'),('en','Images stored','Images stored'),('en','No images found','No images found'),('en','Template saved and ready for use in campaigns','Template saved and ready for use in campaigns'),('en','Image','Image'),('en','\\\"not full URL','not full URL'),('en','does not exist','does not exist'),('en','Not a full URL','Not a full URL'),('en','No Title','No title'),('en','Template does not contain the [CONTENT] placeholder','Template does not contain the [CONTENT] placeholder'),('en','Template saved','Template saved'),('en','Images','Images'),('en','Below is the list of images used in your template. If an image is currently unavailable, please upload it to the database.','Below is the list of images used in your template. If an image is currently unavailable, please upload it to the database.'),('en','This includes all images, also fully referenced ones, so you may choose not to upload some. If you upload images, they will be included in the campaigns that use this template.','This includes all images, also fully referenced ones, so you may choose not to upload some. If you upload images, they will be included in the campaigns that use this template.'),('en','Image name:','Image name'),('en','%d times used','%d times used'),('en','Save Images','Save images'),('en','Template does not contain local images','Template does not contain local images'),('en','Some errors were found, template NOT saved!','Some errors were found, template NOT saved!'),('en','Sending test','Sending test'),('en','Sending test \\\"Request for confirmation\\\" to','Sending test \\\"Request for confirmation\\\" to'),('en','Sending test \\\"Welcome\\\" to','Sending test \\\"Welcome\\\" to'),('en','Sending test \\\"Unsubscribe confirmation\\\" to','Sending test \\\"Unsubscribe confirmation\\\" to'),('en','Error sending test messages to','Error sending test messages to'),('en','List of Templates','List of templates'),('en','Title of this template','Title of this template'),('en','Content of the template.','Content of the template.'),('en','The content should at least have <b>[CONTENT]</b> somewhere.','The content should at least have <b>[CONTENT]</b> somewhere.'),('en','You can upload a template file or paste the text in the box below','You can upload a template file or paste the text in the box below'),('en','Template file.','Template file.'),('en','Check that all links have a full URL','Check that all links have a full URL'),('en','Check that all images have a full URL','Check that all images have a full URL'),('en','Check that all external images exist','Check that all external images exist'),('en','Send test message','Send test message'),('en','to email addresses','to email addresses'),('en','You are logged in as administrator (%s) of this phpList system','You are logged in as administrator (%s) of this phpList system'),('en','You are therefore offered the following choice, which your subscribers will not see when they load this page.','You are therefore offered the following choice, which your subscribers will not see when they load this page.'),('en','Go back to admin area','Go back to admin area'),('en','Please choose','Please choose'),('en','Make this subscriber confirmed immediately','Make this subscriber confirmed immediately'),('en','Send this subscriber a request for confirmation email','Send this subscriber a request for confirmation email'),('en','Forwarded receiver requested blacklist','Forwarded receiver requested blacklist'),('en','\\\"Jump off\\\" used by subscriber, reason not requested','\\\"Jump off\\\" used by subscriber, reason not requested'),('en','\\\"Jump off\\\" set, reason not requested','\\\"Jump off\\\" set, reason not requested'),('en','When testing the phpList forward functionality, you need to be logged in as an administrator.','When testing the phpList forward functionality, you need to be logged in as an administrator.'),('en','Message Forwarded','Message forwarded'),('en','%s has forwarded message %d to %s','%s has forwarded message %d to %s'),('en','%s tried forwarding message %d to %s but failed','%s tried forwarding message %d to %s but failed'),('en','Forward request from invalid user ID: %s','Forward request from invalid user ID: %s'),('en','Subscriber removed from Blacklist for manual confirmation of subscription','Subscriber removed from do-not-send list for manual confirmation of subscription'),('en','Subscriber has been removed from blacklist','Subscriber has been removed from do-not-send list'),('en','%d bounces to list %s','%d bounces to list %s'),('en','unconfirm subscriber','unconfirm subscriber'),('en','blacklist subscriber','blacklist subscriber'),('en','blacklist email address','blacklist email address'),('en','delete subscriber and bounce','delete subscriber and bounce'),('en','unconfirm subscriber and delete bounce','unconfirm subscriber and delete bounce'),('en','blacklist subscriber and delete bounce','add subscriber to the do-not-send-list and delete bounce'),('en','blacklist email address and delete bounce','add email address to the do-no-send-list and delete bounce'),('en','Error, incorrect session token','Error, incorrect session token'),('en','Sign up to receive news and updates about phpList','Sign up to receive news and updates about phpList'),('en','Subscribe','Subscribe'),('en','Campaign not found','Campaign not found'),('en','Size of HTML email: %s','Size of HTML email: %s'),('en','Size of Text email: %s','Size of Text email: %s'),('en','Message too large (%s is over %s), suspending','Message too large (%s is over %s), suspending'),('en','Warning: the final message exceeds the sending limit, this campaign will fail sending. Reduce the size by removing attachments or images','Warning: the final message exceeds the sending limit, this campaign will fail sending. Reduce the size by removing attachments or images'),('en','Campaign %d suspended. Message too large','Campaign %d suspended. Message too large'),('en','Campaign %d suspended, message too large','Campaign %d suspended, message too large'),('en','Insufficient memory to add attachment to campaign %d %d - %d','Insufficient memory to add attachment to campaign %d %d - %d'),('en','Error, when trying to send campaign %d the attachment (%s) could not be copied to the repository. Check for permissions.','Error, when trying to send campaign %d the attachment (%s) could not be copied to the repository. Check for permissions.'),('en','phpList system error','phpList system error'),('en','failed to open attachment (%s) to add to campaign %d','failed to open attachment (%s) to add to campaign %d'),('en','Attachment %s does not exist','Attachment %s does not exist'),('en','Error, when trying to send campaign %d the attachment (%s) could not be found in the repository','Error, when trying to send campaign %d the attachment (%s) could not be found in the repository'),('en','Campaign %d suspended for too many errors with attachments','Campaign %d suspended for too many errors with attachments'),('en','Not deleting processed message','Not deleting processed message'),('en','Not deleting unprocessed message','Not deleting unprocessed message'),('en','email auto blacklisted for','email auto blacklisted for'),('en','email auto unsubscribed for','email auto unsubscribed for'),('en','Delete subscribers who have an invalid email address','Delete subscribers who have an invalid email address'),('en','Removing %d from this list','Removing %d from this list'),('en','%d subscribers','%d subscribers'),('en','What to do with all subscribers','What to do with all subscribers'),('en','This will process all subscribers on this list, confirmed and unconfirmed','This will process all subscribers on this list, confirmed and unconfirmed'),('en','Add a new subscribe page','Add a new subscribe page'),('en','Ascending','Ascending'),('en','Descending','Descending'),('en','Embargo','Embargo'),('en','Clear','Clear'),('en','Are you sure you want to delete this campaign?','Are you sure you want to delete this campaign?'),('en','delete this campaign','delete this campaign'),('en','Attachment %d succesfully added','Attachment %d succesfully added'),('en','Adding attachment %d failed','Adding attachment %d failed'),('en','Adding attachment','Adding attachment'),('en','Sending test mails is currently not available','Sending test mails is currently not available'),('en','Delete checked','Delete checked'),('en','The total size of attachments is very large. Sending this campaign may fail due to resource limits.','The total size of attachments is very large. Sending this campaign may fail due to resource limits.'),('en','This is a test campaign','This is a test campaign'),('en','Save and continue editing','Save and continue editing'),('en','Editing an active or finished campaign will place it back in the draft queue, continue?','Editing an active or finished campaign will place it back in the draft queue, continue?'),('en','Edit campaign','Edit campaign'),('en','Processing blocked by plugin %s','Processing blocked by plugin %s'),('en','Warning: a lot of errors while sending campaign %d','Warning: a lot of errors while sending campaign %d'),('en','Top level domains were updated successfully','Top level domains were updated successfully'),('en','All subscribers','All subscribers'),('en','Confirmed members','Confirmed members'),('en','Unconfirmed members','Unconfirmed members'),('en','View Members','View members of this list'),('en','This is a system list. You cannot delete it.','This is a system list. You cannot delete it.'),('en','start a new campaign targetting all lists','start a new campaign targetting all lists'),('en','Add Members','Add members'),('en','Edit this list','Edit this list'),('en','Are you sure you want to remove this subscriber from the system.','Are you sure you want to remove this subscriber from the system.'),('en','remove subscriber','remove subscriber'),('en','Please upload a plain text file only. You cannot use a spreadsheet. You need to export the data from the spreadsheet into a TAB delimited text file','Please upload a plain text file only. You cannot use a spreadsheet. You need to export the data from the spreadsheet into a TAB delimited text file'),('en','Please upload a plain text file only. You cannot use a spreadsheet. You can only upload a plain text file with one email address per line.','Please upload a plain text file only. You cannot use a spreadsheet. You can only upload a plain text file with one email address per line.'),('en','Error sending email to %s','Error sending email to %s'),('en','Error, empty message-body sending email to %s','Error, empty message-body sending email to %s'),('en','Processing export, this may take a while. Please wait','Processing export, this may take a while. Please wait'),('en','Cannot save admin, that email address already exists for another admin','Cannot save admin, that email address already exists for another admin'),('en','Back to edit admin','Back to edit admin'),('en','Campaign click statistics','Campaign click statistics'),('en','If there is only one visible list, should it be hidden in the page and automatically subscribe users who sign up','If there is only one visible list, should it be hidden in the page and automatically subscribe users who sign up'),('en','Send notifications about subscribe, update and unsubscribe','Send notifications about subscribe, update and unsubscribe'),('en','Your session timed out, please log in again','Your session timed out, please login again'),('en','Top 25 pre-@ of email addresses','Top 25 pre-@ of email addresses'),('en','amount','amount'),('en','view subscribers who clicked','view subscribers who clicked'),('en','Please edit your config file and change \\\"mysql.inc\\\" to \\\"mysqli.inc\\\" to avoid future PHP incompatibility','Please edit your config file and change \\\"mysql.inc\\\" to \\\"mysqli.inc\\\" to avoid future PHP incompatibility'),('en','update Top Level Domains','update Top Level Domains'),('en','Subscribe to our newsletter','Subscribe to our newsletter'),('en','Type of attribute','Type of attribute'),('en','Required for subscriber to fill out','Required for subscriber to fill out'),('en','Name of table with values','Name of table with values'),('en','subscriber ID','subscriber ID'),('en','Value of this attribute for this subscriber','Value of this attribute for this subscriber'),('en','PKey','PKey'),('en','Is this subscriber confirmed','Is this subscriber confirmed'),('en','Is this subscriber blacklisted','Is this subscriber blacklisted'),('en','Did this subscriber manually confirm','Did this subscriber manually confirm'),('en','Number of bounces','Number of bounces'),('en','Unique ID','Unique ID'),('en','Send this subscriber HTML emails','Send this subscriber HTML emails'),('en','Which page was used to subscribe','Which page was used to subscribe'),('en','RSS Frequency','RSS Frequency'),('en','Last time password was changed','Last time password was changed'),('en','Is this account disabled?','Is this account disabled?'),('en','Additional data','Additional data'),('en','History Summary','History Summary'),('en','History Detail','History Detail'),('en','System Information','System Information'),('en','Subject prefix','Subject prefix'),('en','Rss Feed','Rss Feed'),('en','Modified','Modified'),('en','Admin who is owner of this list','Admin who is owner of this list'),('en','List category','List category'),('en','List ID','List ID'),('en','Primary key','Primary key'),('en','from','from'),('en','tofield','tofield'),('en','reply-to','reply-to'),('en','Text version of Message','Text version of Message'),('en','Footer for a message','Footer for a message'),('en','Time to send message','Time to send message'),('en','Number of seconds to repeat the message','Number of seconds to repeat the message'),('en','Final time to stop repetition','Final time to stop repetition'),('en','Number of seconds to requeue the message','Number of seconds to requeue the message'),('en','Final time to stop requeueing','Final time to stop requeueing'),('en','query to select the subscribers for this message','query to select the subscribers for this message'),('en','Is this message HTML formatted','Is this message HTML formatted'),('en','Format to send this message in','Format to send this message in'),('en','Template to use','Template to use'),('en','Number Processed','Number Processed'),('en','Sent as Text and HTML','Sent as Text and HTML'),('en','Sent as PDF','Sent as PDF'),('en','Sent as Text and PDF','Sent as Text and PDF'),('en','Was the message viewed','Was the message viewed'),('en','How many bounces on this message','How many bounces on this message'),('en','When did sending of this message start','When did sending of this message start'),('en','if used as a RSS template, what frequency','if used as a RSS template, what frequency'),('en','Admin who is owner','Admin who is owner'),('en','Name of field','Name of field'),('en','Message ID','Message ID'),('en','data','data'),('en','When added to blacklist','When added to blacklist'),('en','Name of Dataitem','Name of Dataitem'),('en','Attachment ID','Attachment ID'),('en','The original location on the uploader machine','The original location on the uploader machine'),('en','The type of attachment','The type of attachment'),('en','Size of the file','Size of the file'),('en','When viewed','When viewed'),('en','Status of message','Status of message'),('en','Start Time','Start Time'),('en','Is this process still alive?','Is this process still alive?'),('en','IP Address of who started it','IP Address of who started it'),('en','The page that this process runs in','The page that this process runs in'),('en','The template','The template'),('en','id of template','id of template'),('en','The image','The image'),('en','Date received','Date received'),('en','Header of bounce','Header of bounce'),('en','The bounce','The bounce'),('en','Status of this bounce','Status of this bounce'),('en','System Comment','System Comment'),('en','Bounce ID','Bounce ID'),('en','When did it bounce','When did it bounce'),('en','Forward email','Forward email'),('en','Status of forward','Status of forward'),('en','When was it forwarded','When was it forwarded'),('en','Editable?','Editable?'),('en','Type of data','Type of data'),('en','Login Name (max 25 chars)','Login name (max 25 chars)'),('en','Normalised loginname','Normalised loginname'),('en','Time Created','Time created'),('en','Time modified','Time modified'),('en','Modified by','Modified by'),('en','Is this admin Super Admin?','Is this admin Super Admin?'),('en','Required','Required'),('en','attribute number','attribute number'),('en','id of admin','id of admin'),('en','Value of this attribute for this admin','Value of this attribute for this admin'),('en','When the password change request was made','When the password change request was made'),('en','Admin\'s Id','Admin\'s Id'),('en','Admin who is owner of this page','Admin who is owner of this page'),('en','page this log was for','page this log was for'),('en','Link ID','Link ID'),('en','URL to log','URL to log'),('en','URL to forward to','URL to forward to'),('en','When first clicked','When first clicked'),('en','When last clicked','When last clicked'),('en','Number of clicks','Number of clicks'),('en','ID in forward table','ID in forward table'),('en','Number of times this link has been sent to subscribers for this message','Number of times this link has been sent to subscribers for this message'),('en','Number of clicks from HTML emails','Number of clicks from HTML emails'),('en','Number of clicks from text emails','Number of clicks from text emails'),('en','forward ID','forward ID'),('en','Forward adding the UID?','Forward adding the UID?'),('en','URL should be unique','URL should be unique'),('en','Name of data','Name of data'),('en','date in unix format','date in unix format'),('en','Regex','Regex'),('en','Action on rule','Action on rule'),('en','Count of matching bounces on this rule','Count of matching bounces on this rule'),('en','Related regex','Related regex'),('en','Related bounce','Related bounce'),('en','adminid','adminid'),('en','Language ISO','Language ISO'),('en','Original string','Original string'),('en','Translated string','Translated string'),('en','pagetitle:plugins','Manage plugins'),('en','pagetitlehover:plugins','Manage plugins and switch them on or off');

--
-- Table structure for table `phplist_linktrack`
--

CREATE TABLE `phplist_linktrack` (
  `linkid` int(11) NOT NULL AUTO_INCREMENT,
  `messageid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `forward` text,
  `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 `miduidurlindex` (`messageid`,`userid`,`url`),
  KEY `midindex` (`messageid`),
  KEY `uidindex` (`userid`),
  KEY `urlindex` (`url`),
  KEY `miduidindex` (`messageid`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_linktrack`
--


--
-- Table structure for table `phplist_linktrack_forward`
--

CREATE TABLE `phplist_linktrack_forward` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL,
  `personalise` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `urlunique` (`url`),
  KEY `urlindex` (`url`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_linktrack_forward`
--

INSERT INTO `phplist_linktrack_forward` VALUES (1,'http://phplist.chrisdevries.com/lists/?p=forward&mid=1',1),(2,'http://phplist.chrisdevries.com/lists/?p=preferences',1),(3,'http://phplist.chrisdevries.com/lists/?p=unsubscribe',1),(4,'http://www.digitalplanet.ie/',0);

--
-- Table structure for table `phplist_linktrack_ml`
--

CREATE TABLE `phplist_linktrack_ml` (
  `messageid` int(11) NOT NULL,
  `forwardid` int(11) NOT NULL,
  `firstclick` datetime DEFAULT NULL,
  `latestclick` datetime DEFAULT NULL,
  `total` int(11) DEFAULT '0',
  `clicked` int(11) DEFAULT '0',
  `htmlclicked` int(11) DEFAULT '0',
  `textclicked` int(11) DEFAULT '0',
  PRIMARY KEY (`messageid`,`forwardid`),
  KEY `midindex` (`messageid`),
  KEY `fwdindex` (`forwardid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_linktrack_ml`
--

INSERT INTO `phplist_linktrack_ml` VALUES (1,1,NULL,NULL,3,0,0,0),(1,2,NULL,NULL,3,0,0,0),(1,3,NULL,NULL,3,0,0,0),(1,4,'2014-03-28 11:13:10','2014-03-28 11:13:10',1,1,1,0);

--
-- Table structure for table `phplist_linktrack_uml_click`
--

CREATE TABLE `phplist_linktrack_uml_click` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `messageid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `forwardid` int(11) DEFAULT NULL,
  `firstclick` datetime DEFAULT NULL,
  `latestclick` datetime DEFAULT NULL,
  `clicked` int(11) DEFAULT '0',
  `htmlclicked` int(11) DEFAULT '0',
  `textclicked` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `miduidfwdid` (`messageid`,`userid`,`forwardid`),
  KEY `midindex` (`messageid`),
  KEY `uidindex` (`userid`),
  KEY `miduidindex` (`messageid`,`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_linktrack_uml_click`
--

INSERT INTO `phplist_linktrack_uml_click` VALUES (1,1,3,4,'2014-03-28 11:13:10','2014-03-28 11:13:10',1,1,0);

--
-- Table structure for table `phplist_linktrack_userclick`
--

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

--
-- Dumping data for table `phplist_linktrack_userclick`
--


--
-- Table structure for table `phplist_list`
--

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

--
-- Dumping data for table `phplist_list`
--

INSERT INTO `phplist_list` VALUES (1,'test','List for testing.','2014-03-27 18:15:05',NULL,NULL,NULL,'2014-03-27 17:15:05',0,1,''),(2,'newsletter','Sign up to our newsletter','2014-03-27 18:15:05',NULL,NULL,NULL,'2014-03-27 17:15:05',1,1,''),(3,'Major Outage Notifications','Major Outage Notifications','2014-03-27 18:31:25',0,'',NULL,'2014-03-27 17:31:25',0,1,'');

--
-- Table structure for table `phplist_listmessage`
--

CREATE TABLE `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=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_listmessage`
--

INSERT INTO `phplist_listmessage` VALUES (1,1,0,'2014-03-28 10:52:41','2014-03-28 09:52:41');

--
-- Table structure for table `phplist_listuser`
--

CREATE TABLE `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`),
  KEY `useridx` (`userid`),
  KEY `listidx` (`listid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_listuser`
--

INSERT INTO `phplist_listuser` VALUES (1,1,'2014-03-27 18:15:05','2014-03-27 17:15:05'),(1,2,'2014-03-27 18:15:05','2014-03-27 17:15:05'),(1,3,'2014-03-27 18:31:42','2014-03-27 17:31:42'),(3,3,'2014-03-27 18:31:42','2014-03-27 17:31:42'),(4,3,'2014-03-27 18:32:08','2014-03-27 17:32:08');

--
-- Table structure for table `phplist_message`
--

CREATE TABLE `phplist_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) NOT NULL DEFAULT '(no subject)',
  `fromfield` varchar(255) NOT NULL DEFAULT '',
  `tofield` varchar(255) NOT NULL DEFAULT '',
  `replyto` varchar(255) NOT NULL DEFAULT '',
  `message` longtext,
  `textmessage` longtext,
  `footer` text,
  `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,
  `requeueinterval` int(11) DEFAULT '0',
  `requeueuntil` datetime DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `userselection` text,
  `sent` datetime DEFAULT NULL,
  `htmlformatted` tinyint(4) DEFAULT '0',
  `sendformat` varchar(20) 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) DEFAULT NULL,
  `owner` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_message`
--

INSERT INTO `phplist_message` VALUES (1,'Network Outage 1st April 2014','admin Christiaan.deVries@hetg.ie','','','<p>We&#39;re currently experiencing a major service degredation of our Internet uplinks due to a DDOS attack aimed at one of our clients. This is impacting other clients, and we&#39;re doing all we can to fight off the attack.</p>\r\n','','','2014-03-27 18:32:10','2014-03-28 10:13:10','2014-03-27 18:00:00',0,'2014-03-28 11:12:00',0,'2014-03-27 18:00:00','draft',NULL,NULL,1,'HTML',1,0,0,0,0,0,0,1,0,NULL,NULL,1);

--
-- Table structure for table `phplist_message_attachment`
--

CREATE TABLE `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=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_message_attachment`
--


--
-- Table structure for table `phplist_messagedata`
--

CREATE TABLE `phplist_messagedata` (
  `name` varchar(100) NOT NULL,
  `id` int(11) NOT NULL,
  `data` longtext,
  PRIMARY KEY (`name`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_messagedata`
--

INSERT INTO `phplist_messagedata` VALUES ('embargo',1,'SER:a:5:{s:3:\"day\";s:2:\"27\";s:5:\"month\";s:2:\"03\";s:4:\"year\";s:4:\"2014\";s:4:\"hour\";s:2:\"18\";s:6:\"minute\";s:1:\"0\";}'),('ETA',1,'Unknown'),('finishsending',1,'SER:a:5:{s:3:\"day\";s:1:\"3\";s:5:\"month\";s:2:\"04\";s:4:\"year\";s:4:\"2014\";s:4:\"hour\";s:2:\"19\";s:6:\"minute\";s:1:\"0\";}'),('followupto',1,''),('footer',1,''),('formtoken',1,'d5777e93c3e2a43b8336ff82bb4a235b'),('fromfield',1,'admin Christiaan.deVries@hetg.ie'),('htmlformatted',1,'auto'),('htmlsize',1,'14069'),('id',1,'1'),('message',1,'<p>We&#39;re currently experiencing a major service degredation of our Internet uplinks due to a DDOS attack aimed at one of our clients. This is impacting other clients, and we&#39;re doing all we can to fight off the attack.</p>\r\n'),('msg/hr',1,'0 '),('page',1,'send'),('requeueinterval',1,'0'),('requeueuntil',1,'SER:a:5:{s:3:\"day\";s:2:\"27\";s:5:\"month\";s:2:\"03\";s:4:\"year\";s:4:\"2014\";s:4:\"hour\";s:2:\"18\";s:6:\"minute\";s:1:\"0\";}'),('samplesent',1,'0'),('sampletime',1,'1396001565'),('savedraft',1,'Save as draft'),('sendformat',1,'HTML'),('sendmethod',1,'inputhere'),('sendtest',1,'Send test'),('sendurl',1,''),('status',1,'draft'),('subject',1,'Network Outage 1st April 2014'),('tab',1,'Format'),('targetlist',1,'SER:a:1:{s:8:\"unselect\";s:2:\"-1\";}'),('template',1,'1'),('testtarget',1,'Christiaan.deVries@hetg.ie, chrisdus@gmail.com'),('workaround_fck_bug',1,'1');

--
-- Table structure for table `phplist_sendprocess`
--

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=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for 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=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_subscribepage`
--


--
-- 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=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_subscribepage_data`
--


--
-- 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=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_template`
--

INSERT INTO `phplist_template` VALUES (1,'DP Major Incident Template','<div class=\\\"WordSection1\\\">\r\n<table border=\\\"1\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" class=\\\"MsoTableGrid\\\" style=\\\"background:white;border-collapse:collapse;border:none\\\">\r\n	<tbody>\r\n		<tr>\r\n			<td colspan=\\\"3\\\" style=\\\"width:450.8pt;border:solid white 1.0pt;\r\n  padding:0cm 5.4pt 0cm 5.4pt\\\" valign=\\\"top\\\" width=\\\"601\\\">\r\n			<p align=\\\"center\\\" class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;\r\n  text-align:center;line-height:normal\\\"><img id=\\\"Picture 1\\\" src=\\\"http://phplist.chrisdevries.com/images/image/Digital-Planet-Logo---Black-and-Red.png\\\" style=\\\"width: 340px; height: 64px;\\\" /></p>\r\n\r\n			<p align=\\\"center\\\" class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;\r\n  text-align:center;line-height:normal\\\">&nbsp;</p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\\\"width:150.25pt;border:solid white 1.0pt;\r\n  border-top:none;padding:0cm 5.4pt 0cm 5.4pt\\\" valign=\\\"top\\\" width=\\\"200\\\">\r\n			<p align=\\\"center\\\" class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;\r\n  text-align:center;line-height:normal\\\"><a href=\\\"http://www.digitalplanet.ie/\\\">HOME</a></p>\r\n			</td>\r\n			<td style=\\\"width:150.25pt;border-top:none;border-left:\r\n  none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;\r\n  padding:0cm 5.4pt 0cm 5.4pt\\\" valign=\\\"top\\\" width=\\\"200\\\">\r\n			<p align=\\\"center\\\" class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;\r\n  text-align:center;line-height:normal\\\">SUPPORT PORTAL</p>\r\n			</td>\r\n			<td style=\\\"width:150.3pt;border-top:none;border-left:\r\n  none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;\r\n  padding:0cm 5.4pt 0cm 5.4pt\\\" valign=\\\"top\\\" width=\\\"200\\\">\r\n			<p align=\\\"center\\\" class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;\r\n  text-align:center;line-height:normal\\\">CONTACT</p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\\\"width:150.25pt;border:solid white 1.0pt;\r\n  border-top:none;padding:0cm 5.4pt 0cm 5.4pt\\\" valign=\\\"top\\\" width=\\\"200\\\">\r\n			<p class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;line-height:\r\n  normal\\\">&nbsp;</p>\r\n			</td>\r\n			<td style=\\\"width:150.25pt;border-top:none;border-left:\r\n  none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;\r\n  padding:0cm 5.4pt 0cm 5.4pt\\\" valign=\\\"top\\\" width=\\\"200\\\">\r\n			<p class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;line-height:\r\n  normal\\\">&nbsp;</p>\r\n\r\n			<p class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;line-height:\r\n  normal\\\">&nbsp;</p>\r\n\r\n			<p class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;line-height:\r\n  normal\\\">&nbsp;</p>\r\n\r\n			<p align=\\\"center\\\" class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;\r\n  text-align:center;line-height:normal\\\">[CONTENT]</p>\r\n\r\n			<p class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;line-height:\r\n  normal\\\">&nbsp;</p>\r\n\r\n			<p class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;line-height:\r\n  normal\\\">&nbsp;</p>\r\n\r\n			<p class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;line-height:\r\n  normal\\\">&nbsp;</p>\r\n			</td>\r\n			<td style=\\\"width:150.3pt;border-top:none;border-left:\r\n  none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;\r\n  padding:0cm 5.4pt 0cm 5.4pt\\\" valign=\\\"top\\\" width=\\\"200\\\">\r\n			<p class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;line-height:\r\n  normal\\\">&nbsp;</p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\\\"width:150.25pt;border:solid white 1.0pt;\r\n  border-top:none;padding:0cm 5.4pt 0cm 5.4pt\\\" valign=\\\"top\\\" width=\\\"200\\\">\r\n			<p align=\\\"center\\\" class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;\r\n  text-align:center;line-height:normal\\\"><img alt=\\\"microsoft\\\" id=\\\"Picture 2\\\" src=\\\"http://phplist.chrisdevries.com/images/image/microsoft-200x50.png\\\" style=\\\"border-width: 0px; border-style: solid; width: 151px; height: 38px;\\\" /></p>\r\n\r\n			<p align=\\\"center\\\" class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;\r\n  text-align:center;line-height:normal\\\">&nbsp;</p>\r\n			</td>\r\n			<td style=\\\"width:150.25pt;border-top:none;border-left:\r\n  none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;\r\n  padding:0cm 5.4pt 0cm 5.4pt\\\" valign=\\\"top\\\" width=\\\"200\\\">\r\n			<p align=\\\"center\\\" class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;\r\n  text-align:center;line-height:normal\\\"><img alt=\\\"vmware\\\" id=\\\"Picture 3\\\" src=\\\"http://phplist.chrisdevries.com/images/image/vmware-200x50.png\\\" style=\\\"border-width: 0px; border-style: solid; width: 151px; height: 38px;\\\" /></p>\r\n\r\n			<p align=\\\"center\\\" class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;\r\n  text-align:center;line-height:normal\\\">&nbsp;</p>\r\n			</td>\r\n			<td style=\\\"width:150.3pt;border-top:none;border-left:\r\n  none;border-bottom:solid white 1.0pt;border-right:solid white 1.0pt;\r\n  padding:0cm 5.4pt 0cm 5.4pt\\\" valign=\\\"top\\\" width=\\\"200\\\">\r\n			<p align=\\\"center\\\" class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;\r\n  text-align:center;line-height:normal\\\"><img alt=\\\"veeamProPartner_gold\\\" id=\\\"Picture 4\\\" src=\\\"http://phplist.chrisdevries.com/images/image/veeamProPartner_gold-200x67.png\\\" style=\\\"border-width: 0px; border-style: solid; width: 112px; height: 38px;\\\" /></p>\r\n\r\n			<p align=\\\"center\\\" class=\\\"MsoNormal\\\" style=\\\"margin-bottom:0cm;margin-bottom:.0001pt;\r\n  text-align:center;line-height:normal\\\">&nbsp;</p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p class=\\\"MsoNormal\\\">&nbsp;</p>\r\n</div>\r\n',NULL);

--
-- 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=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_templateimage`
--

INSERT INTO `phplist_templateimage` 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);

--
-- Table structure for table `phplist_urlcache`
--

CREATE TABLE `phplist_urlcache` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL,
  `lastmodified` int(11) DEFAULT NULL,
  `added` datetime DEFAULT NULL,
  `content` mediumtext,
  PRIMARY KEY (`id`),
  KEY `urlindex` (`url`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_urlcache`
--

INSERT INTO `phplist_urlcache` VALUES (1,'http://www.phplist.com/files/tlds-alpha-by-domain.txt',1422351719,'2015-01-27 10:42:00','# Version 2015012400, Last Updated Sat Jan 24 07:07:01 2015 UTC\nABOGADO\nAC\nACADEMY\nACCOUNTANTS\nACTIVE\nACTOR\nAD\nADULT\nAE\nAERO\nAF\nAG\nAGENCY\nAI\nAIRFORCE\nAL\nALLFINANZ\nALSACE\nAM\nAMSTERDAM\nAN\nANDROID\nAO\nAQ\nAQUARELLE\nAR\nARCHI\nARMY\nARPA\nAS\nASIA\nASSOCIATES\nAT\nATTORNEY\nAU\nAUCTION\nAUDIO\nAUTOS\nAW\nAX\nAXA\nAZ\nBA\nBAND\nBANK\nBAR\nBARCLAYCARD\nBARCLAYS\nBARGAINS\nBAYERN\nBB\nBD\nBE\nBEER\nBERLIN\nBEST\nBF\nBG\nBH\nBI\nBID\nBIKE\nBIO\nBIZ\nBJ\nBLACK\nBLACKFRIDAY\nBLOOMBERG\nBLUE\nBM\nBMW\nBN\nBNPPARIBAS\nBO\nBOO\nBOUTIQUE\nBR\nBRUSSELS\nBS\nBT\nBUDAPEST\nBUILD\nBUILDERS\nBUSINESS\nBUZZ\nBV\nBW\nBY\nBZ\nBZH\nCA\nCAB\nCAL\nCAMERA\nCAMP\nCANCERRESEARCH\nCAPETOWN\nCAPITAL\nCARAVAN\nCARDS\nCARE\nCAREER\nCAREERS\nCARTIER\nCASA\nCASH\nCAT\nCATERING\nCC\nCD\nCENTER\nCEO\nCERN\nCF\nCG\nCH\nCHANNEL\nCHEAP\nCHRISTMAS\nCHROME\nCHURCH\nCI\nCITIC\nCITY\nCK\nCL\nCLAIMS\nCLEANING\nCLICK\nCLINIC\nCLOTHING\nCLUB\nCM\nCN\nCO\nCOACH\nCODES\nCOFFEE\nCOLLEGE\nCOLOGNE\nCOM\nCOMMUNITY\nCOMPANY\nCOMPUTER\nCONDOS\nCONSTRUCTION\nCONSULTING\nCONTRACTORS\nCOOKING\nCOOL\nCOOP\nCOUNTRY\nCR\nCREDIT\nCREDITCARD\nCRICKET\nCRS\nCRUISES\nCU\nCUISINELLA\nCV\nCW\nCX\nCY\nCYMRU\nCZ\nDABUR\nDAD\nDANCE\nDATING\nDAY\nDCLK\nDE\nDEALS\nDEGREE\nDELIVERY\nDEMOCRAT\nDENTAL\nDENTIST\nDESI\nDESIGN\nDEV\nDIAMONDS\nDIET\nDIGITAL\nDIRECT\nDIRECTORY\nDISCOUNT\nDJ\nDK\nDM\nDNP\nDO\nDOCS\nDOMAINS\nDOOSAN\nDURBAN\nDVAG\nDZ\nEAT\nEC\nEDU\nEDUCATION\nEE\nEG\nEMAIL\nEMERCK\nENERGY\nENGINEER\nENGINEERING\nENTERPRISES\nEQUIPMENT\nER\nES\nESQ\nESTATE\nET\nEU\nEUROVISION\nEUS\nEVENTS\nEVERBANK\nEXCHANGE\nEXPERT\nEXPOSED\nFAIL\nFARM\nFASHION\nFEEDBACK\nFI\nFINANCE\nFINANCIAL\nFIRMDALE\nFISH\nFISHING\nFIT\nFITNESS\nFJ\nFK\nFLIGHTS\nFLORIST\nFLOWERS\nFLSMIDTH\nFLY\nFM\nFO\nFOO\nFORSALE\nFOUNDATION\nFR\nFRL\nFROGANS\nFUND\nFURNITURE\nFUTBOL\nGA\nGAL\nGALLERY\nGARDEN\nGB\nGBIZ\nGD\nGE\nGENT\nGF\nGG\nGGEE\nGH\nGI\nGIFT\nGIFTS\nGIVES\nGL\nGLASS\nGLE\nGLOBAL\nGLOBO\nGM\nGMAIL\nGMO\nGMX\nGN\nGOOG\nGOOGLE\nGOP\nGOV\nGP\nGQ\nGR\nGRAPHICS\nGRATIS\nGREEN\nGRIPE\nGS\nGT\nGU\nGUIDE\nGUITARS\nGURU\nGW\nGY\nHAMBURG\nHANGOUT\nHAUS\nHEALTHCARE\nHELP\nHERE\nHERMES\nHIPHOP\nHIV\nHK\nHM\nHN\nHOLDINGS\nHOLIDAY\nHOMES\nHORSE\nHOST\nHOSTING\nHOUSE\nHOW\nHR\nHT\nHU\nIBM\nID\nIE\nIFM\nIL\nIM\nIMMO\nIMMOBILIEN\nIN\nINDUSTRIES\nINFO\nING\nINK\nINSTITUTE\nINSURE\nINT\nINTERNATIONAL\nINVESTMENTS\nIO\nIQ\nIR\nIRISH\nIS\nIT\nIWC\nJCB\nJE\nJETZT\nJM\nJO\nJOBS\nJOBURG\nJP\nJUEGOS\nKAUFEN\nKDDI\nKE\nKG\nKH\nKI\nKIM\nKITCHEN\nKIWI\nKM\nKN\nKOELN\nKP\nKR\nKRD\nKRED\nKW\nKY\nKZ\nLA\nLACAIXA\nLAND\nLAT\nLATROBE\nLAWYER\nLB\nLC\nLDS\nLEASE\nLEGAL\nLGBT\nLI\nLIDL\nLIFE\nLIGHTING\nLIMITED\nLIMO\nLINK\nLK\nLOANS\nLONDON\nLOTTE\nLOTTO\nLR\nLS\nLT\nLTDA\nLU\nLUXE\nLUXURY\nLV\nLY\nMA\nMADRID\nMAISON\nMANAGEMENT\nMANGO\nMARKET\nMARKETING\nMARRIOTT\nMC\nMD\nME\nMEDIA\nMEET\nMELBOURNE\nMEME\nMEMORIAL\nMENU\nMG\nMH\nMIAMI\nMIL\nMINI\nMK\nML\nMM\nMN\nMO\nMOBI\nMODA\nMOE\nMONASH\nMONEY\nMORMON\nMORTGAGE\nMOSCOW\nMOTORCYCLES\nMOV\nMP\nMQ\nMR\nMS\nMT\nMU\nMUSEUM\nMV\nMW\nMX\nMY\nMZ\nNA\nNAGOYA\nNAME\nNAVY\nNC\nNE\nNET\nNETWORK\nNEUSTAR\nNEW\nNEXUS\nNF\nNG\nNGO\nNHK\nNI\nNINJA\nNL\nNO\nNP\nNR\nNRA\nNRW\nNU\nNYC\nNZ\nOKINAWA\nOM\nONE\nONG\nONL\nOOO\nORG\nORGANIC\nOSAKA\nOTSUKA\nOVH\nPA\nPARIS\nPARTNERS\nPARTS\nPARTY\nPE\nPF\nPG\nPH\nPHARMACY\nPHOTO\nPHOTOGRAPHY\nPHOTOS\nPHYSIO\nPICS\nPICTURES\nPINK\nPIZZA\nPK\nPL\nPLACE\nPLUMBING\nPM\nPN\nPOHL\nPOKER\nPORN\nPOST\nPR\nPRAXI\nPRESS\nPRO\nPROD\nPRODUCTIONS\nPROF\nPROPERTIES\nPROPERTY\nPS\nPT\nPUB\nPW\nPY\nQA\nQPON\nQUEBEC\nRE\nREALTOR\nRECIPES\nRED\nREHAB\nREISE\nREISEN\nREIT\nREN\nRENTALS\nREPAIR\nREPORT\nREPUBLICAN\nREST\nRESTAURANT\nREVIEWS\nRICH\nRIO\nRIP\nRO\nROCKS\nRODEO\nRS\nRSVP\nRU\nRUHR\nRW\nRYUKYU\nSA\nSAARLAND\nSALE\nSAMSUNG\nSARL\nSB\nSC\nSCA\nSCB\nSCHMIDT\nSCHULE\nSCHWARZ\nSCIENCE\nSCOT\nSD\nSE\nSERVICES\nSEW\nSEXY\nSG\nSH\nSHIKSHA\nSHOES\nSHRIRAM\nSI\nSINGLES\nSJ\nSK\nSKY\nSL\nSM\nSN\nSO\nSOCIAL\nSOFTWARE\nSOHU\nSOLAR\nSOLUTIONS\nSOY\nSPACE\nSPIEGEL\nSR\nST\nSU\nSUPPLIES\nSUPPLY\nSUPPORT\nSURF\nSURGERY\nSUZUKI\nSV\nSX\nSY\nSYDNEY\nSYSTEMS\nSZ\nTAIPEI\nTATAR\nTATTOO\nTAX\nTC\nTD\nTECHNOLOGY\nTEL\nTEMASEK\nTF\nTG\nTH\nTIENDA\nTIPS\nTIRES\nTIROL\nTJ\nTK\nTL\nTM\nTN\nTO\nTODAY\nTOKYO\nTOOLS\nTOP\nTOWN\nTOYS\nTP\nTR\nTRADE\nTRAINING\nTRAVEL\nTRUST\nTT\nTUI\nTV\nTW\nTZ\nUA\nUG\nUK\nUNIVERSITY\nUNO\nUOL\nUS\nUY\nUZ\nVA\nVACATIONS\nVC\nVE\nVEGAS\nVENTURES\nVERSICHERUNG\nVET\nVG\nVI\nVIAJES\nVIDEO\nVILLAS\nVISION\nVLAANDEREN\nVN\nVODKA\nVOTE\nVOTING\nVOTO\nVOYAGE\nVU\nWALES\nWANG\nWATCH\nWEBCAM\nWEBSITE\nWED\nWEDDING\nWF\nWHOSWHO\nWIEN\nWIKI\nWILLIAMHILL\nWME\nWORK\nWORKS\nWORLD\nWS\nWTC\nWTF\nXN--1QQW23A\nXN--3BST00M\nXN--3DS443G\nXN--3E0B707E\nXN--45BRJ9C\nXN--45Q11C\nXN--4GBRIM\nXN--55QW42G\nXN--55QX5D\nXN--6FRZ82G\nXN--6QQ986B3XL\nXN--80ADXHKS\nXN--80AO21A\nXN--80ASEHDB\nXN--80ASWG\nXN--90A3AC\nXN--B4W605FERD\nXN--C1AVG\nXN--CG4BKI\nXN--CLCHC0EA0B2G2A9GCD\nXN--CZR694B\nXN--CZRS0T\nXN--CZRU2D\nXN--D1ACJ3B\nXN--D1ALF\nXN--FIQ228C5HS\nXN--FIQ64B\nXN--FIQS8S\nXN--FIQZ9S\nXN--FLW351E\nXN--FPCRJ9C3D\nXN--FZC2C9E2C\nXN--GECRJ9C\nXN--H2BRJ9C\nXN--HXT814E\nXN--I1B6B1A6A2E\nXN--IO0A7I\nXN--J1AMH\nXN--J6W193G\nXN--KPRW13D\nXN--KPRY57D\nXN--KPUT3I\nXN--L1ACC\nXN--LGBBAT1AD8J\nXN--MGB9AWBF\nXN--MGBA3A4F16A\nXN--MGBAAM7A8H\nXN--MGBAB2BD\nXN--MGBAYH7GPA\nXN--MGBBH1A71E\nXN--MGBC0A9AZCG\nXN--MGBERP4A5D4AR\nXN--MGBX4CD0AB\nXN--NGBC5AZD\nXN--NODE\nXN--NQV7F\nXN--NQV7FS00EMA\nXN--O3CW4H\nXN--OGBPF8FL\nXN--P1ACF\nXN--P1AI\nXN--PGBS0DH\nXN--Q9JYB4C\nXN--QCKA1PMC\nXN--RHQV96G\nXN--S9BRJ9C\nXN--SES554G\nXN--UNUP4Y\nXN--VERMGENSBERATER-CTB\nXN--VERMGENSBERATUNG-PWB\nXN--VHQUV\nXN--WGBH1C\nXN--WGBL6A\nXN--XHQ521B\nXN--XKC2AL3HYE2A\nXN--XKC2DL3A5EE0H\nXN--YFRO4I67O\nXN--YGBI2AMMX\nXN--ZFR164B\nXXX\nXYZ\nYACHTS\nYANDEX\nYE\nYOGA\nYOKOHAMA\nYOUTUBE\nYT\nZA\nZIP\nZM\nZONE\nZUERICH\nZW\n'),(2,'http://www.phplist.com/files/tlds-alpha-by-domain.txt.md5',1422351720,'2015-01-27 10:42:01','f1a9d54f06ed61a789285aa2e279ada2  tlds-alpha-by-domain.txt\n'),(3,'https://www.phplist.com/files/tlds-alpha-by-domain.txt',1422363364,'2015-01-27 13:56:05','# Version 2015012400, Last Updated Sat Jan 24 07:07:01 2015 UTC\nABOGADO\nAC\nACADEMY\nACCOUNTANTS\nACTIVE\nACTOR\nAD\nADULT\nAE\nAERO\nAF\nAG\nAGENCY\nAI\nAIRFORCE\nAL\nALLFINANZ\nALSACE\nAM\nAMSTERDAM\nAN\nANDROID\nAO\nAQ\nAQUARELLE\nAR\nARCHI\nARMY\nARPA\nAS\nASIA\nASSOCIATES\nAT\nATTORNEY\nAU\nAUCTION\nAUDIO\nAUTOS\nAW\nAX\nAXA\nAZ\nBA\nBAND\nBANK\nBAR\nBARCLAYCARD\nBARCLAYS\nBARGAINS\nBAYERN\nBB\nBD\nBE\nBEER\nBERLIN\nBEST\nBF\nBG\nBH\nBI\nBID\nBIKE\nBIO\nBIZ\nBJ\nBLACK\nBLACKFRIDAY\nBLOOMBERG\nBLUE\nBM\nBMW\nBN\nBNPPARIBAS\nBO\nBOO\nBOUTIQUE\nBR\nBRUSSELS\nBS\nBT\nBUDAPEST\nBUILD\nBUILDERS\nBUSINESS\nBUZZ\nBV\nBW\nBY\nBZ\nBZH\nCA\nCAB\nCAL\nCAMERA\nCAMP\nCANCERRESEARCH\nCAPETOWN\nCAPITAL\nCARAVAN\nCARDS\nCARE\nCAREER\nCAREERS\nCARTIER\nCASA\nCASH\nCAT\nCATERING\nCC\nCD\nCENTER\nCEO\nCERN\nCF\nCG\nCH\nCHANNEL\nCHEAP\nCHRISTMAS\nCHROME\nCHURCH\nCI\nCITIC\nCITY\nCK\nCL\nCLAIMS\nCLEANING\nCLICK\nCLINIC\nCLOTHING\nCLUB\nCM\nCN\nCO\nCOACH\nCODES\nCOFFEE\nCOLLEGE\nCOLOGNE\nCOM\nCOMMUNITY\nCOMPANY\nCOMPUTER\nCONDOS\nCONSTRUCTION\nCONSULTING\nCONTRACTORS\nCOOKING\nCOOL\nCOOP\nCOUNTRY\nCR\nCREDIT\nCREDITCARD\nCRICKET\nCRS\nCRUISES\nCU\nCUISINELLA\nCV\nCW\nCX\nCY\nCYMRU\nCZ\nDABUR\nDAD\nDANCE\nDATING\nDAY\nDCLK\nDE\nDEALS\nDEGREE\nDELIVERY\nDEMOCRAT\nDENTAL\nDENTIST\nDESI\nDESIGN\nDEV\nDIAMONDS\nDIET\nDIGITAL\nDIRECT\nDIRECTORY\nDISCOUNT\nDJ\nDK\nDM\nDNP\nDO\nDOCS\nDOMAINS\nDOOSAN\nDURBAN\nDVAG\nDZ\nEAT\nEC\nEDU\nEDUCATION\nEE\nEG\nEMAIL\nEMERCK\nENERGY\nENGINEER\nENGINEERING\nENTERPRISES\nEQUIPMENT\nER\nES\nESQ\nESTATE\nET\nEU\nEUROVISION\nEUS\nEVENTS\nEVERBANK\nEXCHANGE\nEXPERT\nEXPOSED\nFAIL\nFARM\nFASHION\nFEEDBACK\nFI\nFINANCE\nFINANCIAL\nFIRMDALE\nFISH\nFISHING\nFIT\nFITNESS\nFJ\nFK\nFLIGHTS\nFLORIST\nFLOWERS\nFLSMIDTH\nFLY\nFM\nFO\nFOO\nFORSALE\nFOUNDATION\nFR\nFRL\nFROGANS\nFUND\nFURNITURE\nFUTBOL\nGA\nGAL\nGALLERY\nGARDEN\nGB\nGBIZ\nGD\nGE\nGENT\nGF\nGG\nGGEE\nGH\nGI\nGIFT\nGIFTS\nGIVES\nGL\nGLASS\nGLE\nGLOBAL\nGLOBO\nGM\nGMAIL\nGMO\nGMX\nGN\nGOOG\nGOOGLE\nGOP\nGOV\nGP\nGQ\nGR\nGRAPHICS\nGRATIS\nGREEN\nGRIPE\nGS\nGT\nGU\nGUIDE\nGUITARS\nGURU\nGW\nGY\nHAMBURG\nHANGOUT\nHAUS\nHEALTHCARE\nHELP\nHERE\nHERMES\nHIPHOP\nHIV\nHK\nHM\nHN\nHOLDINGS\nHOLIDAY\nHOMES\nHORSE\nHOST\nHOSTING\nHOUSE\nHOW\nHR\nHT\nHU\nIBM\nID\nIE\nIFM\nIL\nIM\nIMMO\nIMMOBILIEN\nIN\nINDUSTRIES\nINFO\nING\nINK\nINSTITUTE\nINSURE\nINT\nINTERNATIONAL\nINVESTMENTS\nIO\nIQ\nIR\nIRISH\nIS\nIT\nIWC\nJCB\nJE\nJETZT\nJM\nJO\nJOBS\nJOBURG\nJP\nJUEGOS\nKAUFEN\nKDDI\nKE\nKG\nKH\nKI\nKIM\nKITCHEN\nKIWI\nKM\nKN\nKOELN\nKP\nKR\nKRD\nKRED\nKW\nKY\nKZ\nLA\nLACAIXA\nLAND\nLAT\nLATROBE\nLAWYER\nLB\nLC\nLDS\nLEASE\nLEGAL\nLGBT\nLI\nLIDL\nLIFE\nLIGHTING\nLIMITED\nLIMO\nLINK\nLK\nLOANS\nLONDON\nLOTTE\nLOTTO\nLR\nLS\nLT\nLTDA\nLU\nLUXE\nLUXURY\nLV\nLY\nMA\nMADRID\nMAISON\nMANAGEMENT\nMANGO\nMARKET\nMARKETING\nMARRIOTT\nMC\nMD\nME\nMEDIA\nMEET\nMELBOURNE\nMEME\nMEMORIAL\nMENU\nMG\nMH\nMIAMI\nMIL\nMINI\nMK\nML\nMM\nMN\nMO\nMOBI\nMODA\nMOE\nMONASH\nMONEY\nMORMON\nMORTGAGE\nMOSCOW\nMOTORCYCLES\nMOV\nMP\nMQ\nMR\nMS\nMT\nMU\nMUSEUM\nMV\nMW\nMX\nMY\nMZ\nNA\nNAGOYA\nNAME\nNAVY\nNC\nNE\nNET\nNETWORK\nNEUSTAR\nNEW\nNEXUS\nNF\nNG\nNGO\nNHK\nNI\nNINJA\nNL\nNO\nNP\nNR\nNRA\nNRW\nNU\nNYC\nNZ\nOKINAWA\nOM\nONE\nONG\nONL\nOOO\nORG\nORGANIC\nOSAKA\nOTSUKA\nOVH\nPA\nPARIS\nPARTNERS\nPARTS\nPARTY\nPE\nPF\nPG\nPH\nPHARMACY\nPHOTO\nPHOTOGRAPHY\nPHOTOS\nPHYSIO\nPICS\nPICTURES\nPINK\nPIZZA\nPK\nPL\nPLACE\nPLUMBING\nPM\nPN\nPOHL\nPOKER\nPORN\nPOST\nPR\nPRAXI\nPRESS\nPRO\nPROD\nPRODUCTIONS\nPROF\nPROPERTIES\nPROPERTY\nPS\nPT\nPUB\nPW\nPY\nQA\nQPON\nQUEBEC\nRE\nREALTOR\nRECIPES\nRED\nREHAB\nREISE\nREISEN\nREIT\nREN\nRENTALS\nREPAIR\nREPORT\nREPUBLICAN\nREST\nRESTAURANT\nREVIEWS\nRICH\nRIO\nRIP\nRO\nROCKS\nRODEO\nRS\nRSVP\nRU\nRUHR\nRW\nRYUKYU\nSA\nSAARLAND\nSALE\nSAMSUNG\nSARL\nSB\nSC\nSCA\nSCB\nSCHMIDT\nSCHULE\nSCHWARZ\nSCIENCE\nSCOT\nSD\nSE\nSERVICES\nSEW\nSEXY\nSG\nSH\nSHIKSHA\nSHOES\nSHRIRAM\nSI\nSINGLES\nSJ\nSK\nSKY\nSL\nSM\nSN\nSO\nSOCIAL\nSOFTWARE\nSOHU\nSOLAR\nSOLUTIONS\nSOY\nSPACE\nSPIEGEL\nSR\nST\nSU\nSUPPLIES\nSUPPLY\nSUPPORT\nSURF\nSURGERY\nSUZUKI\nSV\nSX\nSY\nSYDNEY\nSYSTEMS\nSZ\nTAIPEI\nTATAR\nTATTOO\nTAX\nTC\nTD\nTECHNOLOGY\nTEL\nTEMASEK\nTF\nTG\nTH\nTIENDA\nTIPS\nTIRES\nTIROL\nTJ\nTK\nTL\nTM\nTN\nTO\nTODAY\nTOKYO\nTOOLS\nTOP\nTOWN\nTOYS\nTP\nTR\nTRADE\nTRAINING\nTRAVEL\nTRUST\nTT\nTUI\nTV\nTW\nTZ\nUA\nUG\nUK\nUNIVERSITY\nUNO\nUOL\nUS\nUY\nUZ\nVA\nVACATIONS\nVC\nVE\nVEGAS\nVENTURES\nVERSICHERUNG\nVET\nVG\nVI\nVIAJES\nVIDEO\nVILLAS\nVISION\nVLAANDEREN\nVN\nVODKA\nVOTE\nVOTING\nVOTO\nVOYAGE\nVU\nWALES\nWANG\nWATCH\nWEBCAM\nWEBSITE\nWED\nWEDDING\nWF\nWHOSWHO\nWIEN\nWIKI\nWILLIAMHILL\nWME\nWORK\nWORKS\nWORLD\nWS\nWTC\nWTF\nXN--1QQW23A\nXN--3BST00M\nXN--3DS443G\nXN--3E0B707E\nXN--45BRJ9C\nXN--45Q11C\nXN--4GBRIM\nXN--55QW42G\nXN--55QX5D\nXN--6FRZ82G\nXN--6QQ986B3XL\nXN--80ADXHKS\nXN--80AO21A\nXN--80ASEHDB\nXN--80ASWG\nXN--90A3AC\nXN--B4W605FERD\nXN--C1AVG\nXN--CG4BKI\nXN--CLCHC0EA0B2G2A9GCD\nXN--CZR694B\nXN--CZRS0T\nXN--CZRU2D\nXN--D1ACJ3B\nXN--D1ALF\nXN--FIQ228C5HS\nXN--FIQ64B\nXN--FIQS8S\nXN--FIQZ9S\nXN--FLW351E\nXN--FPCRJ9C3D\nXN--FZC2C9E2C\nXN--GECRJ9C\nXN--H2BRJ9C\nXN--HXT814E\nXN--I1B6B1A6A2E\nXN--IO0A7I\nXN--J1AMH\nXN--J6W193G\nXN--KPRW13D\nXN--KPRY57D\nXN--KPUT3I\nXN--L1ACC\nXN--LGBBAT1AD8J\nXN--MGB9AWBF\nXN--MGBA3A4F16A\nXN--MGBAAM7A8H\nXN--MGBAB2BD\nXN--MGBAYH7GPA\nXN--MGBBH1A71E\nXN--MGBC0A9AZCG\nXN--MGBERP4A5D4AR\nXN--MGBX4CD0AB\nXN--NGBC5AZD\nXN--NODE\nXN--NQV7F\nXN--NQV7FS00EMA\nXN--O3CW4H\nXN--OGBPF8FL\nXN--P1ACF\nXN--P1AI\nXN--PGBS0DH\nXN--Q9JYB4C\nXN--QCKA1PMC\nXN--RHQV96G\nXN--S9BRJ9C\nXN--SES554G\nXN--UNUP4Y\nXN--VERMGENSBERATER-CTB\nXN--VERMGENSBERATUNG-PWB\nXN--VHQUV\nXN--WGBH1C\nXN--WGBL6A\nXN--XHQ521B\nXN--XKC2AL3HYE2A\nXN--XKC2DL3A5EE0H\nXN--YFRO4I67O\nXN--YGBI2AMMX\nXN--ZFR164B\nXXX\nXYZ\nYACHTS\nYANDEX\nYE\nYOGA\nYOKOHAMA\nYOUTUBE\nYT\nZA\nZIP\nZM\nZONE\nZUERICH\nZW\n'),(4,'https://www.phplist.com/files/tlds-alpha-by-domain.txt.md5',1422363365,'2015-01-27 13:56:05','f1a9d54f06ed61a789285aa2e279ada2  tlds-alpha-by-domain.txt\n');

--
-- Table structure for table `phplist_user_attribute`
--

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

--
-- Dumping data for table `phplist_user_attribute`
--

INSERT INTO `phplist_user_attribute` VALUES (1,'FirstName','textline',0,'',0,'firstname'),(2,'LastName','textline',0,'',0,'lastname');

--
-- Table structure for table `phplist_user_blacklist`
--

CREATE TABLE `phplist_user_blacklist` (
  `email` varchar(255) NOT NULL,
  `added` datetime DEFAULT NULL,
  UNIQUE KEY `email` (`email`),
  KEY `emailidx` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_user_blacklist`
--


--
-- Table structure for table `phplist_user_blacklist_data`
--

CREATE TABLE `phplist_user_blacklist_data` (
  `email` varchar(150) NOT NULL,
  `name` varchar(25) NOT NULL,
  `data` text,
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `email_2` (`email`),
  KEY `emailidx` (`email`),
  KEY `emailnameidx` (`email`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_user_blacklist_data`
--


--
-- Table structure for table `phplist_user_message_bounce`
--

CREATE TABLE `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`),
  KEY `message_lookup` (`message`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_user_message_bounce`
--


--
-- Table structure for table `phplist_user_message_forward`
--

CREATE TABLE `phplist_user_message_forward` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `message` int(11) NOT NULL,
  `forward` varchar(255) DEFAULT NULL,
  `status` varchar(255) 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=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_user_message_forward`
--


--
-- Table structure for table `phplist_user_user`
--

CREATE TABLE `phplist_user_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `confirmed` tinyint(4) DEFAULT '0',
  `blacklisted` tinyint(4) DEFAULT '0',
  `optedin` 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) DEFAULT NULL,
  `htmlemail` tinyint(4) DEFAULT '0',
  `subscribepage` int(11) DEFAULT NULL,
  `rssfrequency` varchar(100) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `passwordchanged` date DEFAULT NULL,
  `disabled` tinyint(4) DEFAULT '0',
  `extradata` text,
  `foreignkey` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `foreignkey` (`foreignkey`),
  KEY `idxuniqid` (`uniqid`),
  KEY `enteredindex` (`entered`),
  KEY `confidx` (`confirmed`),
  KEY `blidx` (`blacklisted`),
  KEY `optidx` (`optedin`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_user_user`
--

INSERT INTO `phplist_user_user` VALUES (1,'Christiaan.deVries@hetg.ie',1,0,0,0,'2014-03-27 18:15:05','2014-03-28 09:41:15','26aa0e255ed84162470e9b0082f5f727',1,NULL,'','3a11ee22381c682f40aa05e5db99336f','2014-03-27',0,'',''),(3,'chrisdus@gmail.com',1,0,0,0,'2014-03-27 18:31:42','2014-03-28 09:41:38','6223173fe57fda276b59cb7694c8ec26',1,NULL,'',NULL,NULL,0,'',''),(4,'Michael.Rooney@hetg.ie',1,0,0,0,'2014-03-27 18:32:08','2014-03-28 09:41:50','20d0f93f372b4fcd95d3a72b8ab41a05',1,NULL,'',NULL,NULL,0,'','');

--
-- Table structure for table `phplist_user_user_attribute`
--

CREATE TABLE `phplist_user_user_attribute` (
  `attributeid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `value` text,
  PRIMARY KEY (`attributeid`,`userid`),
  KEY `userindex` (`userid`),
  KEY `attindex` (`attributeid`),
  KEY `attuserid` (`userid`,`attributeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_user_user_attribute`
--

INSERT INTO `phplist_user_user_attribute` VALUES (1,1,'Christiaan'),(1,3,'Chris'),(1,4,'Michael'),(2,1,'de Vries'),(2,3,'Dus'),(2,4,'Rooney');

--
-- Table structure for table `phplist_user_user_history`
--

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

--
-- Dumping data for table `phplist_user_user_history`
--

INSERT INTO `phplist_user_user_history` VALUES (1,3,'185.5.242.94','2014-03-27 18:31:42','import_by admin','import_by admin','\nREQUEST_URI = /lists/admin/?page=importsimple\nHTTP_USER_AGENT = Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.154 Safari/537.36\nHTTP_REFERER = http://phplist.chrisdevries.com/lists/admin/?page=importsimple\nREMOTE_ADDR = 185.5.242.94'),(2,4,'185.5.242.94','2014-03-27 18:32:08','import_by admin','import_by admin','\nREQUEST_URI = /lists/admin/?page=importsimple\nHTTP_USER_AGENT = Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.154 Safari/537.36\nHTTP_REFERER = http://phplist.chrisdevries.com/lists/admin/?page=importsimple\nREMOTE_ADDR = 185.5.242.94'),(3,1,'185.5.242.94','2014-03-28 10:41:15','Update by admin','FirstName = Christiaan\nchanged from (no data)\nLastName = de Vries\nchanged from (no data)\n','\nREQUEST_URI = /lists/admin/?page=user&amp;start=0&amp;id=1&amp;find=&amp;sortby=&amp;sortorder=desc&amp;unconfirmed=0&amp;blacklisted=0\nHTTP_USER_AGENT = Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.154 Safari/537.36\nHTTP_REFERER = http://phplist.chrisdevries.com/lists/admin/?page=user&amp;start=0&amp;id=1&amp;find=&amp;sortby=&amp;sortorder=desc&amp;unconfirmed=0&amp;blacklisted=0\nREMOTE_ADDR = 185.5.242.94'),(4,3,'185.5.242.94','2014-03-28 10:41:38','Update by admin','\nNo data changed\n','\nREQUEST_URI = /lists/admin/?page=user&amp;start=0&amp;id=3&amp;find=&amp;sortby=&amp;sortorder=desc&amp;unconfirmed=0&amp;blacklisted=0\nHTTP_USER_AGENT = Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.154 Safari/537.36\nHTTP_REFERER = http://phplist.chrisdevries.com/lists/admin/?page=user&amp;start=0&amp;id=3&amp;find=&amp;sortby=&amp;sortorder=desc&amp;unconfirmed=0&amp;blacklisted=0\nREMOTE_ADDR = 185.5.242.94'),(5,4,'185.5.242.94','2014-03-28 10:41:50','Update by admin','\nNo data changed\n','\nREQUEST_URI = /lists/admin/?page=user&amp;start=0&amp;id=4&amp;find=&amp;sortby=&amp;sortorder=desc&amp;unconfirmed=0&amp;blacklisted=0\nHTTP_USER_AGENT = Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.154 Safari/537.36\nHTTP_REFERER = http://phplist.chrisdevries.com/lists/admin/?page=user&amp;start=0&amp;id=4&amp;find=&amp;sortby=&amp;sortorder=desc&amp;unconfirmed=0&amp;blacklisted=0\nREMOTE_ADDR = 185.5.242.94');

--
-- Table structure for table `phplist_usermessage`
--

CREATE TABLE `phplist_usermessage` (
  `messageid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `entered` datetime NOT NULL,
  `viewed` datetime DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`userid`,`messageid`),
  KEY `messageidindex` (`messageid`),
  KEY `useridindex` (`userid`),
  KEY `enteredindex` (`entered`),
  KEY `statusidx` (`status`),
  KEY `viewedidx` (`viewed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_usermessage`
--


--
-- Table structure for table `phplist_userstats`
--

CREATE TABLE `phplist_userstats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unixdate` int(11) DEFAULT NULL,
  `item` varchar(255) 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=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `phplist_userstats`
--



