rendered paste body#
# 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;*/