#
# Table structure for table 'jos_letterman'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ `jos_letterman` (
  `id` int(11) NOT NULL auto_increment,
  `subject` varchar(50) NOT NULL default '',
  `headers` text NOT NULL,
  `message` text NOT NULL,
  `html_message` text NOT NULL,
  `published` tinyint(1) NOT NULL default '0',
  `checked_out` int(11) NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `send` datetime NOT NULL default '0000-00-00 00:00:00',
  `hits` int(11) NOT NULL default '0',
  `access` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Used to store all newsletters for Letterman.';



#
# Dumping data for table 'jos_letterman'
#

/*!40000 ALTER TABLE `jos_letterman` DISABLE KEYS;*/
LOCK TABLES `jos_letterman` WRITE;
REPLACE INTO `jos_letterman` (`id`, `subject`, `headers`, `message`, `html_message`, `published`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `created`, `send`, `hits`, `access`) VALUES (1,'Sample Newsletter','',CHAR(
72, 101, 108, 108, 111, 32, 91, 78, 65, 77, 69, 93, 44, 13, 10, 
13, 10, 116, 104, 105, 115, 32, 105, 115, 32, 97, 32, 110, 105, 99, 
101, 32, 115, 97, 109, 112, 108, 101, 32, 78, 101, 119, 115, 108, 101, 
116, 116, 101, 114, 32, 42, 84, 101, 120, 116, 32, 69, 100, 105, 116, 
105, 111, 110, 42, 32, 102, 114, 111, 109, 32, 121, 111, 117, 114, 32, 
103, 117, 121, 115, 32, 97, 116, 32, 116, 104, 101, 32, 110, 101, 119, 
115, 108, 101, 116, 116, 101, 114, 32, 116, 101, 97, 109, 33, 46, 13, 
10, 13, 10, 65, 102, 116, 101, 114, 32, 104, 97, 118, 105, 110, 103, 
32, 115, 101, 116, 32, 117, 112, 32, 116, 104, 105, 115, 32, 110, 101, 
119, 115, 108, 101, 116, 116, 101, 114, 32, 99, 111, 109, 112, 111, 110, 
101, 110, 116, 32, 121, 111, 117, 32, 99, 97, 110, 32, 101, 97, 115, 
105, 108, 121, 32, 100, 101, 108, 101, 116, 101, 32, 111, 114, 32, 109, 
111, 100, 105, 102, 121, 32, 116, 104, 105, 115, 32, 78, 101, 119, 115, 
108, 101, 116, 116, 101, 114, 46, 13, 10, 13, 10, 78, 111, 119, 32, 
112, 108, 101, 97, 115, 101, 32, 101, 110, 106, 111, 121, 32, 76, 101, 
116, 116, 101, 114, 109, 97, 110, 33, 13, 10, 13, 10, 82, 101, 103, 
97, 114, 100, 115, 44, 32, 88, 88, 88, 13, 10),CHAR(
13, 10, 60, 112, 32, 115, 116, 121, 108, 101, 61, 34, 102, 111, 110, 
116, 45, 102, 97, 109, 105, 108, 121, 58, 32, 118, 101, 114, 100, 97, 
110, 97, 44, 97, 114, 105, 97, 108, 44, 104, 101, 108, 118, 101, 116, 
105, 99, 97, 44, 115, 97, 110, 115, 45, 115, 101, 114, 105, 102, 59, 
34, 62, 72, 101, 108, 108, 111, 32, 91, 78, 65, 77, 69, 93, 44, 
60, 105, 109, 103, 32, 118, 115, 112, 97, 99, 101, 61, 34, 53, 34, 
32, 104, 115, 112, 97, 99, 101, 61, 34, 51, 34, 32, 98, 111, 114, 
100, 101, 114, 61, 34, 48, 34, 32, 97, 108, 105, 103, 110, 61, 34, 
114, 105, 103, 104, 116, 34, 32, 115, 114, 99, 61, 34, 99, 111, 109, 
112, 111, 110, 101, 110, 116, 115, 47, 99, 111, 109, 95, 108, 101, 116, 
116, 101, 114, 109, 97, 110, 47, 108, 101, 116, 116, 101, 114, 109, 97, 
110, 46, 103, 105, 102, 34, 32, 47, 62, 60, 47, 112, 62, 60, 112, 
32, 115, 116, 121, 108, 101, 61, 34, 102, 111, 110, 116, 45, 102, 97, 
109, 105, 108, 121, 58, 32, 118, 101, 114, 100, 97, 110, 97, 44, 97, 
114, 105, 97, 108, 44, 104, 101, 108, 118, 101, 116, 105, 99, 97, 44, 
115, 97, 110, 115, 45, 115, 101, 114, 105, 102, 59, 34, 62, 116, 104, 
105, 115, 32, 105, 115, 32, 97, 32, 110, 105, 99, 101, 32, 115, 97, 
109, 112, 108, 101, 32, 78, 101, 119, 115, 108, 101, 116, 116, 101, 114, 
32, 60, 115, 112, 97, 110, 32, 115, 116, 121, 108, 101, 61, 34, 102, 
111, 110, 116, 45, 119, 101, 105, 103, 104, 116, 58, 32, 98, 111, 108, 
100, 59, 34, 62, 119, 105, 116, 104, 32, 71, 114, 97, 112, 104, 105, 
99, 115, 60, 47, 115, 112, 97, 110, 62, 32, 102, 114, 111, 109, 32, 
121, 111, 117, 114, 32, 103, 117, 121, 115, 32, 97, 116, 32, 116, 104, 
101, 32, 110, 101, 119, 115, 108, 101, 116, 116, 101, 114, 32, 116, 101, 
97, 109, 33, 46, 60, 47, 112, 62, 60, 112, 32, 115, 116, 121, 108, 
101, 61, 34, 102, 111, 110, 116, 45, 119, 101, 105, 103, 104, 116, 58, 
32, 98, 111, 108, 100, 59, 34, 62, 60, 98, 114, 32, 47, 62, 60, 
47, 112, 62, 60, 112, 32, 115, 116, 121, 108, 101, 61, 34, 102, 111, 
110, 116, 45, 102, 97, 109, 105, 108, 121, 58, 32, 118, 101, 114, 100, 
97, 110, 97, 44, 97, 114, 105, 97, 108, 44, 104, 101, 108, 118, 101, 
116, 105, 99, 97, 44, 115, 97, 110, 115, 45, 115, 101, 114, 105, 102, 
59, 34, 62, 65, 102, 116, 101, 114, 32, 104, 97, 118, 105, 110, 103, 
32, 115, 101, 116, 32, 117, 112, 32, 116, 104, 105, 115, 32, 110, 101, 
119, 115, 108, 101, 116, 116, 101, 114, 32, 99, 111, 109, 112, 111, 110, 
101, 110, 116, 32, 121, 111, 117, 32, 99, 97, 110, 32, 101, 97, 115, 
105, 108, 121, 32, 100, 101, 108, 101, 116, 101, 32, 111, 114, 32, 109, 
111, 100, 105, 102, 121, 32, 116, 104, 105, 115, 32, 78, 101, 119, 115, 
108, 101, 116, 116, 101, 114, 46, 60, 98, 114, 32, 47, 62, 60, 47, 
112, 62, 60, 112, 32, 115, 116, 121, 108, 101, 61, 34, 102, 111, 110, 
116, 45, 119, 101, 105, 103, 104, 116, 58, 32, 98, 111, 108, 100, 59, 
34, 62, 60, 115, 112, 97, 110, 32, 115, 116, 121, 108, 101, 61, 34, 
102, 111, 110, 116, 45, 119, 101, 105, 103, 104, 116, 58, 32, 110, 111, 
114, 109, 97, 108, 59, 32, 102, 111, 110, 116, 45, 102, 97, 109, 105, 
108, 121, 58, 32, 118, 101, 114, 100, 97, 110, 97, 44, 97, 114, 105, 
97, 108, 44, 104, 101, 108, 118, 101, 116, 105, 99, 97, 44, 115, 97, 
110, 115, 45, 115, 101, 114, 105, 102, 59, 34, 62, 78, 111, 119, 32, 
112, 108, 101, 97, 115, 101, 32, 101, 110, 106, 111, 121, 32, 76, 101, 
116, 116, 101, 114, 109, 97, 110, 33, 60, 47, 115, 112, 97, 110, 62, 
60, 98, 114, 32, 47, 62, 60, 47, 112, 62, 60, 112, 32, 115, 116, 
121, 108, 101, 61, 34, 102, 111, 110, 116, 45, 119, 101, 105, 103, 104, 
116, 58, 32, 98, 111, 108, 100, 59, 34, 62, 82, 101, 103, 97, 114, 
100, 115, 44, 32, 88, 88, 88, 60, 98, 114, 32, 47, 62, 60, 47, 
112, 62),1,0,NULL,'2005-02-04','2007-02-23','2005-02-01 15:26:02','2005-02-07 15:42:13',6,'0');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_letterman` ENABLE KEYS;*/