-- <?php die('This is not a program file.'); exit; ?>


--
-- Table structure for table `#TABLE_PREFIX#__nlb_settings`
--

DROP TABLE IF EXISTS `#TABLE_PREFIX#__nlb_settings`;

CREATE TABLE `#TABLE_PREFIX#__nlb_settings` (
  `num` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `createdDate` datetime NOT NULL,
  `createdByUserNum` int(10) unsigned NOT NULL,
  `updatedDate` datetime NOT NULL,
  `updatedByUserNum` int(10) unsigned NOT NULL,
  `from_email` mediumtext,
  `manage_url` mediumtext,
  `from_name` mediumtext,
  `default_subject` mediumtext,
  `confirm_html` mediumtext,
  `test_emails` mediumtext,
  `archive_url` mediumtext,
  `confirm_subject` mediumtext,
  `default_html` mediumtext,
  PRIMARY KEY (`num`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;


--
-- Dumping data for table `#TABLE_PREFIX#__nlb_settings`
--

INSERT INTO `#TABLE_PREFIX#__nlb_settings` VALUES("1","2012-08-14 16:29:36","0","2012-08-28 16:31:15","0","jsmith@example.com","http://example.com/m.php","Example Newsletter","#hostname# Newsletter #000","<p>Hello,</p>\n<p>We just received a request to add you to our newsletter.</p>\n<p>If that\'s right, just <a href=\"#confirm_url#\">click here to confirm</a> and we\'ll make those changes.</p>\n<p>Or copy and paste this URL into your browser:<br /> #confirm_url#</p>\n<p>Or if it wasn\'t you who made the request you can safely ignore this email and we won\'t add you.</p>\n<p>Thanks!</p>","","http://example.com/archive.php","#hostname# - Confirm newsletter subscription","<p>Hello, </p>\n<p>Here\'s our latest edition of our monthly newsletter.</p>\n<p><strong>Developers:</strong> This default newsletter content can be edited under: Newsletter Builder &gt; Newsletter Settings</p>\n<p>The following placeholders are available to be used in your newsletter content: </p>\n<ul>\n<li>#hostname# - Current hostname or domain being used to access server. </li>\n<li>#from_name# - \"From Name\" that newsletter is sent from</li>\n<li>#from_email# - \"From Email\" that newsletter is sent from</li>\n<li>#to_email# - \"To Email\" that newsletter is sent to (blank if not applicable)</li>\n<li>#archive_url# - Link to online archive of newsletter</li>\n<li>#confirm_url# - Link subscribers must click to confirm subscriptions (only for confirmation emails)</li>\n<li>#unsubscribe_url# - Link subscribers can click to unsubscribe from newsletter</li>\n</ul>\n<p>Thanks!</p>\n<p>---</p>\n<p>Please feel free to send this newsletter to friends, co-workers, or anyone else interested.<br />© Copyright 2012 <strong>#hostname#</strong></p>");

-- Dump completed on 2012-08-28 16:31:40 -0700
