--
-- Host: localhost    Database: mikehond_phplist
-- ------------------------------------------------------


--
-- Current Database: `mikehond_phplist`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mikehond_phplist` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `mikehond_phplist`;

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

CREATE TABLE `phplist_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `loginname` varchar(25) NOT NULL DEFAULT '',
  `namelc` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL DEFAULT '',
  `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',
  PRIMARY KEY (`id`),
  UNIQUE KEY `loginname` (`loginname`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `phplist_admin` VALUES (1,'admin','admin','rob@mikehonda.org','2006-01-23 09:00:41','2006-01-23 14:01:32','admin','ca15password','2006-01-23',1,0);

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

CREATE TABLE `phplist_admin_attribute` (
  `adminattributeid` int(11) NOT NULL DEFAULT '0',
  `adminid` int(11) NOT NULL DEFAULT '0',
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`adminattributeid`,`adminid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `phplist_admin_task`
--

CREATE TABLE `phplist_admin_task` (
  `adminid` int(11) NOT NULL DEFAULT '0',
  `taskid` int(11) NOT NULL DEFAULT '0',
  `level` int(11) DEFAULT NULL,
  PRIMARY KEY (`adminid`,`taskid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phplist_admin_task`
--


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

CREATE TABLE `phplist_adminattribute` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `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=MyISAM DEFAULT CHARSET=latin1;

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


--
-- 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=MyISAM DEFAULT CHARSET=latin1;

--
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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=MyISAM DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `phplist_bounceregex_bounce` (
  `regex` int(11) NOT NULL DEFAULT '0',
  `bounce` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`regex`,`bounce`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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

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

INSERT INTO `phplist_config` VALUES ('version','2.10.2',0,NULL),('updatelastcheck','2006-01-23 09:00:41',0,NULL),('website','www.mikehonda.org',1,NULL),('domain','mikehonda.org',1,NULL),('xormask','3cb065eaf8b29756ab1e93a6790ef749',0,NULL),('check_new_version','7',1,NULL),('admin_address','rob@[DOMAIN]',0,NULL),('admin_addresses','',1,NULL),('report_address','rob@[DOMAIN]',0,NULL),('message_from_address','noreply@[DOMAIN]',1,NULL),('message_from_name','Webmaster',1,NULL),('message_replyto_address','noreply@[DOMAIN]',1,NULL),('hide_single_list','1',1,NULL),('textline_width','40',1,NULL),('textarea_dimensions','10,40',1,NULL),('send_admin_copies','0',1,NULL),('defaultsubscribepage','1',1,NULL),('defaultmessagetemplate','0',1,NULL),('subscribeurl','http://[WEBSITE]/lists/?p=subscribe',1,NULL),('unsubscribeurl','http://[WEBSITE]/lists/?p=unsubscribe',1,NULL),('confirmationurl','http://[WEBSITE]/lists/?p=confirm',1,NULL),('preferencesurl','http://[WEBSITE]/lists/?p=preferences',1,NULL),('forwardurl','http://[WEBSITE]/lists/?p=forward',1,NULL),('subscribesubject','Request for confirmation',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),('unsubscribesubject','Goodbye from our Newsletter',1,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. We have added you to our\n  \"blacklist\", which means that our newsletter system will refuse to send\n  you any other email, 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),('confirmationsubject','Welcome to our Newsletter',1,NULL),('confirmationmessage','\n\n  Welcome to our Newsletter\n\n  Please keep this email for later reference.\n\n  Your email address has been added to the following newsletter(s):\n[LISTS]\n\n  To update your details and preferences please go to [PREFERENCESURL].\n  If you do not want to receive any more messages, please go to [UNSUBSCRIBEURL].\n\n  Thank you\n\n',1,NULL),('updatesubject','[notify] Change of List-Membership details',1,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),('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),('personallocation_subject','Your personal location',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 programme can wrap the line into multiple lines.\n\nYour personal location is:\n[PREFERENCESURL]\n\nThank you.\n',1,NULL),('messagefooter','--\r\nIf you do not want to receive any more newsletters,  [UNSUBSCRIBE]\r\n\r\nTo update your preferences and to unsubscribe visit [PREFERENCES]\r\n',0,NULL),('forwardfooter','--\nThis message has been forwarded to you by [FORWARDEDBY].\n  You have not been automatically subscribed to this newsletter.\n  To subscribe to this newsletter go to\n\n [SUBSCRIBE]\n',1,NULL),('pageheader','<link href=\"styles/phplist.css\" type=\"text/css\" rel=\"stylesheet\">\n</head>\n<body bgcolor=\"#ffffff\" background=\"images/bg.png\">\n<a name=\"top\"></a>\n<div align=center>\n<table cellspacing=0 cellpadding=0 width=710 border=0>\n<tr>\n<td bgcolor=\"#000000\" rowspan=3><img height=1 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\n<td bgcolor=\"#000000\"><img height=1 alt=\"\" src=\"images/transparent.png\" width=708 border=0></td>\n<td bgcolor=\"#000000\" rowspan=3><img height=1 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\n</tr>\n\n<tr valign=\"top\" align=\"left\">\n<td>\n<!--TOP TABLE starts-->\n<TABLE cellSpacing=0 cellPadding=0 width=708 bgColor=#ffffff border=0>\n  <TR vAlign=top>\n    <TD colSpan=2 rowspan=\"2\" height=\"63\" background=\"images/topstrip.png\"><a href=\"http://www.phplist.com\" target=\"_blank\"><img src=\"images/masthead.png\" border=0 width=577 height=75></a></TD>\n    <TD align=left\n      background=\"images/topstrip.png\" bgcolor=\"#F0D1A3\"><FONT\n      size=-2>&nbsp;<I>powered by: </I><BR>&nbsp;<B>[<A class=powered\n      href=\"http://www.php.net/\" target=_new><I>PHP</I></A>]</B> + <B>[<A\n      class=powered href=\"http://www.mysql.com/\"\n      target=_new>mySQL</A>]</B></FONT></TD></TR>\n  <TR vAlign=bottom>\n    <TD vAlign=bottom width=132\n    background=\"images/topright.png\" bgcolor=\"#F0D1A3\"><SPAN\n      class=webblermenu>PHPlist</SPAN></TD></TR>\n  <TR>\n    <TD bgColor=#000000><IMG height=1 alt=\"\"\n      src=\"images/transparent.png\" width=20\n      border=0></TD>\n    <TD bgColor=#000000><IMG height=1 alt=\"\"\n      src=\"images/transparent.png\" width=576\n      border=0></TD>\n    <TD bgColor=#000000><IMG height=1 alt=\"\"\n      src=\"images/transparent.png\" width=132\n      border=0></TD></TR>\n  <TR vAlign=top>\n    <TD>&nbsp;</TD>\n<td><div align=left>\n<br />\n',1,NULL),('pagefooter','</div>\n</td>\n<td>\n<div class=\"menutableright\">\n\n</div>\n</td>\n</tr>\n\n\n\n\n<tr><td colspan=\"4\">&nbsp;</td></tr>\n\n\n\n<tr><td colspan=\"4\">&nbsp;</td></tr>\n</table>\n<!--TOP TABLE ends-->\n\n</td></tr>\n\n\n<tr>\n<td bgcolor=\"#000000\" colspan=3><img height=1 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\n</tr>\n\n<tr>\n<td bgcolor=\"#000000\"><img height=1 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\n<td bgcolor=\"#ff9900\" class=\"bottom\">&copy; <a href=\"http://tincan.co.uk\" target=\"_tincan\" class=\"urhere\">tincan limited</a> | <a class=\"urhere\" href=\"http://www.phplist.com\" target=\"_blank\">phplist</a> - version <?php echo VERSION?></td>\n<td bgcolor=\"#000000\"><img height=1 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\n</tr>\n\n<tr>\n<td bgcolor=\"#000000\" colspan=3><img height=1 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\n</tr>\n\n<tr>\n<td colspan=3><img height=3 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\n</tr>\n\n<tr>\n<td colspan=3>\n&nbsp;\n</td>\n</tr>\n</tbody>\n</table>\n\n</div>\n</body></html>\n',1,NULL),('html_charset','iso-8859-1',1,NULL),('text_charset','iso-8859-1',1,NULL),('html_email_style','\n<style type=\"text/css\">\nbody { font-size : 11px; font-family: Verdana, Arial, Helvetica, sans-serif; }\na { font-size: 11px; color: #ff6600; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; }\na:visited { color: #666666; }\na:hover {  text-decoration: underline; }\np { font-weight: normal; font-size: 11px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; }\nh1 {font-weight: bold; font-size: 14px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none;}\nh2 {font-weight: bold; font-size: 13px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none;}\nh3 {font-weight: bold; font-size: 12px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; margin:0px; padding:0px;}\nh4 {font-weight: bold; font-size: 11px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; margin:0px; padding:0px;}\nhr {width : 100%; height : 1px; color: #ff9900; size:1px;}\n.forwardform {margin: 0 0 0 0; padding: 0 0 0 0;}\n.forwardinput {margin: 0 0 0 0; padding: 0 0 0 0;}\n.forwardsubmit {margin: 0 0 0 0; padding: 0 0 0 0;}\ndiv.emailfooter { font-size : 11px; font-family: Verdana, Arial, Helvetica, sans-serif; }\ndiv.emailfooter a { font-size: 11px; color: #ff6600; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; }\n</style>\n',1,NULL),('alwayssendtextto','mail.com\nemail.com',1,NULL),('fckeditor_width','600',1,NULL),('fckeditor_height','600',1,NULL),('subscribesubject:1','Request for confirmation',0,NULL),('subscribemessage:1','  Almost welcome to our newsletter(s) ...\r\n\r\n  Someone, hopefully you, has subscribed your email address to the following newsletters:\r\n\r\n[LISTS]\r\n\r\n  If this is correct, please click the following link to confirm your subscription.\r\n  Without this confirmation, you will not receive any newsletters.\r\n\r\n[CONFIRMATIONURL]\r\n\r\n  If this is not correct, you do not need to do anything, simply delete this message.\r\n\r\n  Thank you\r\n\r\n  ',0,NULL),('confirmationsubject:1','Welcome to our Newsletter',0,NULL),('confirmationmessage:1','  Welcome to our Newsletter\r\n\r\n  Please keep this email for later reference.\r\n\r\n  Your email address has been added to the following newsletter(s):\r\n[LISTS]\r\n\r\n  To update your details and preferences please go to [PREFERENCESURL].\r\n  If you do not want to receive any more messages, please go to [UNSUBSCRIBEURL].\r\n\r\n  Thank you\r\n\r\n',0,NULL),('subscribesubject:2','Request for confirmation',0,NULL),('subscribemessage:2','  Almost welcome to our newsletter(s) ...\r\n\r\n  Someone, hopefully you, has subscribed your email address to the following newsletters:\r\n\r\n[LISTS]\r\n\r\n  If this is correct, please click the following link to confirm your subscription.\r\n  Without this confirmation, you will not receive any newsletters.\r\n\r\n[CONFIRMATIONURL]\r\n\r\n  If this is not correct, you do not need to do anything, simply delete this message.\r\n\r\n  Thank you\r\n\r\n  ',0,NULL),('confirmationsubject:2','Welcome to our Newsletter',0,NULL),('confirmationmessage:2','  Welcome to our Newsletter\r\n\r\n  Please keep this email for later reference.\r\n\r\n  Your email address has been added to the following newsletter(s):\r\n[LISTS]\r\n\r\n  To update your details and preferences please go to [PREFERENCESURL].\r\n  If you do not want to receive any more messages, please go to [UNSUBSCRIBEURL].\r\n\r\n  Thank you\r\n\r\n',0,NULL),('membership_columns','',1,NULL),('public_baseurl','',1,NULL),('rssthreshold','',1,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`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

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

INSERT INTO `phplist_eventlog` VALUES (1,'2006-01-23 09:11:43','processqueue','Processing has started, 1 message(s) to process.'),(2,'2006-01-23 09:11:43','processqueue','It is safe to click your \"stop\" button now, report will be sent by email to rob@mikehonda.org'),(3,'2006-01-23 09:11:43','processqueue','Processing message 2'),(4,'2006-01-23 09:11:43','processqueue','Looking for users'),(5,'2006-01-23 09:11:43','processqueue','Found them: 1 to process'),(6,'2006-01-23 09:11:43','processqueue','invalid email piersonr@gmail.com user marked unconfirmed'),(7,'2006-01-23 09:11:43','processqueue','Processed 1 out of 1 users'),(8,'2006-01-23 09:11:43','processqueue','1 emails failed (will retry later)'),(9,'2006-01-23 09:11:43','processqueue','Finished this run'),(10,'2006-01-23 09:11:43','processqueue','Waiting for 3600 seconds before reloading'),(11,'2006-01-23 10:11:43','processqueue','Sent in last run: 0'),(12,'2006-01-23 10:11:43','processqueue','Skipped in last run: 0'),(13,'2006-01-23 10:11:43','processqueue','Processing has started, 1 message(s) to process.'),(14,'2006-01-23 10:11:43','processqueue','It is safe to click your \"stop\" button now, report will be sent by email to rob@mikehonda.org'),(15,'2006-01-23 10:11:43','processqueue','Processing message 2'),(16,'2006-01-23 10:11:43','processqueue','Looking for users'),(17,'2006-01-23 10:11:43','processqueue','Found them: 0 to process'),(18,'2006-01-23 10:11:43','processqueue','Processed 0 out of 0 users'),(19,'2006-01-23 10:11:43','processqueue','Hmmm, No users found to send to'),(20,'2006-01-23 10:11:43','processqueue','It took 1 hours to send this message');

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

CREATE TABLE `phplist_linktrack` (
  `linkid` int(11) NOT NULL AUTO_INCREMENT,
  `messageid` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  `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 `messageid` (`messageid`,`userid`,`url`),
  KEY `miduidurlindex` (`messageid`,`userid`,`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `phplist_linktrack_userclick` (
  `linkid` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  `messageid` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `data` text,
  `date` datetime DEFAULT NULL,
  KEY `linkusermessageindex` (`linkid`,`userid`,`messageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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 DEFAULT '',
  `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,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

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

INSERT INTO `phplist_list` VALUES (1,'test','List for testing.','2006-01-23 09:00:41',0,NULL,NULL,'2006-01-23 14:06:02',0,1),(2,'All Contacts','','2006-01-23 09:06:30',1,'','','2006-01-23 14:06:30',1,1);

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

CREATE TABLE `phplist_listmessage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `messageid` int(11) NOT NULL DEFAULT '0',
  `listid` int(11) NOT NULL DEFAULT '0',
  `entered` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `messageid` (`messageid`,`listid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `phplist_listmessage` VALUES (1,2,2,'2006-01-23 09:11:40','2006-01-23 14:11:40');

--
-- Table structure for table `phplist_listrss`
--

CREATE TABLE `phplist_listrss` (
  `listid` int(11) NOT NULL DEFAULT '0',
  `type` varchar(255) DEFAULT NULL,
  `entered` datetime DEFAULT NULL,
  `info` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phplist_listrss`
--


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

CREATE TABLE `phplist_listuser` (
  `userid` int(11) NOT NULL DEFAULT '0',
  `listid` int(11) NOT NULL DEFAULT '0',
  `entered` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`userid`,`listid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `phplist_listuser` VALUES (1,2,'2006-01-23 09:08:46','2006-01-23 14:08:46');

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

CREATE TABLE `phplist_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) NOT NULL DEFAULT '',
  `fromfield` varchar(255) NOT NULL DEFAULT '',
  `tofield` varchar(255) NOT NULL DEFAULT '',
  `replyto` varchar(255) NOT NULL DEFAULT '',
  `message` text,
  `textmessage` text,
  `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,
  `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=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

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

INSERT INTO `phplist_message` VALUES (1,'(no subject)','','','',NULL,NULL,NULL,'2006-01-23 09:07:54','2006-01-23 14:07:54','2006-01-23 09:07:54',0,'2006-01-23 09:07:54','draft',NULL,NULL,0,'text and HTML',0,0,0,0,0,0,0,0,0,NULL,NULL,1),(2,'test message from php list','admin rob@mikehonda.org','','','this is a <span style=\"font-weight: bold;\">test</span>','','--\r\nIf you do not want to receive any more newsletters,  [UNSUBSCRIBE]\r\n\r\nTo update your preferences and to unsubscribe visit [PREFERENCES]\r\n','2006-01-23 09:09:55','2006-01-23 15:11:43','2006-01-23 09:09:00',0,'2006-01-23 09:09:55','sent',NULL,'2006-01-23 10:11:43',1,'text and HTML',0,1,0,0,1,0,0,0,0,'2006-01-23 09:11:43','',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 DEFAULT '0',
  `attachmentid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `phplist_messagedata` (
  `name` varchar(100) NOT NULL DEFAULT '',
  `id` int(11) NOT NULL DEFAULT '0',
  `data` text,
  PRIMARY KEY (`name`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `phplist_messagedata` VALUES ('to process',2,'0'),('ETA',2,'Mon 23 Jan 09:11'),('msg/hr',2,'0');

--
-- Table structure for table `phplist_rssitem`
--

CREATE TABLE `phplist_rssitem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '',
  `link` varchar(100) NOT NULL DEFAULT '',
  `source` varchar(255) DEFAULT NULL,
  `list` int(11) DEFAULT NULL,
  `added` datetime DEFAULT NULL,
  `processed` mediumint(8) unsigned DEFAULT '0',
  `astext` int(11) DEFAULT '0',
  `ashtml` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `title` (`title`,`link`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phplist_rssitem`
--


--
-- Table structure for table `phplist_rssitem_data`
--

CREATE TABLE `phplist_rssitem_data` (
  `itemid` int(11) NOT NULL DEFAULT '0',
  `tag` varchar(100) NOT NULL DEFAULT '',
  `data` text,
  PRIMARY KEY (`itemid`,`tag`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phplist_rssitem_data`
--


--
-- Table structure for table `phplist_rssitem_user`
--

CREATE TABLE `phplist_rssitem_user` (
  `itemid` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  `entered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`itemid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phplist_rssitem_user`
--


--
-- 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=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- 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 DEFAULT '',
  `active` tinyint(4) DEFAULT '0',
  `owner` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

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

INSERT INTO `phplist_subscribepage` VALUES (1,'Title of this set of lists',1,1);

--
-- Table structure for table `phplist_subscribepage_data`
--

CREATE TABLE `phplist_subscribepage_data` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL DEFAULT '',
  `data` text,
  PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `phplist_subscribepage_data` VALUES (1,'button','Subscribe to the Selected Newsletters'),(1,'footer','</div>\r\n</td>\r\n<td>\r\n<div class=\"menutableright\">\r\n\r\n</div>\r\n</td>\r\n</tr>\r\n\r\n\r\n\r\n\r\n<tr><td colspan=\"4\">&nbsp;</td></tr>\r\n\r\n\r\n\r\n<tr><td colspan=\"4\">&nbsp;</td></tr>\r\n</table>\r\n<!--TOP TABLE ends-->\r\n\r\n</td></tr>\r\n\r\n\r\n<tr>\r\n<td bgcolor=\"#000000\" colspan=3><img height=1 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\r\n</tr>\r\n\r\n<tr>\r\n<td bgcolor=\"#000000\"><img height=1 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\r\n<td bgcolor=\"#ff9900\" class=\"bottom\">&copy; <a href=\"http://tincan.co.uk\" target=\"_tincan\" class=\"urhere\">tincan limited</a> | <a class=\"urhere\" href=\"http://www.phplist.com\" target=\"_blank\">phplist</a> - version <?php echo VERSION?></td>\r\n<td bgcolor=\"#000000\"><img height=1 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\r\n</tr>\r\n\r\n<tr>\r\n<td bgcolor=\"#000000\" colspan=3><img height=1 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\r\n</tr>\r\n\r\n<tr>\r\n<td colspan=3><img height=3 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\r\n</tr>\r\n\r\n<tr>\r\n<td colspan=3>\r\n&nbsp;\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n\r\n</div>\r\n</body></html>\r\n'),(1,'thankyoupage','<h3>Thank you for subscribing to our newsletters.</h3>\r\nYour email has been added to our system. You will be e-mailed shortly with a request to confirm your membership. Please make sure to click the link in that message to confirm your subscription.'),(1,'header','<link href=\"styles/phplist.css\" type=\"text/css\" rel=\"stylesheet\">\r\n</head>\r\n<body bgcolor=\"#ffffff\" background=\"images/bg.png\">\r\n<a name=\"top\"></a>\r\n<div align=center>\r\n<table cellspacing=0 cellpadding=0 width=710 border=0>\r\n<tr>\r\n<td bgcolor=\"#000000\" rowspan=3><img height=1 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\r\n<td bgcolor=\"#000000\"><img height=1 alt=\"\" src=\"images/transparent.png\" width=708 border=0></td>\r\n<td bgcolor=\"#000000\" rowspan=3><img height=1 alt=\"\" src=\"images/transparent.png\" width=1 border=0></td>\r\n</tr>\r\n\r\n<tr valign=\"top\" align=\"left\">\r\n<td>\r\n<!--TOP TABLE starts-->\r\n<TABLE cellSpacing=0 cellPadding=0 width=708 bgColor=#ffffff border=0>\r\n  <TR vAlign=top>\r\n    <TD colSpan=2 rowspan=\"2\" height=\"63\" background=\"images/topstrip.png\"><a href=\"http://www.phplist.com\" target=\"_blank\"><img src=\"images/masthead.png\" border=0 width=577 height=75></a></TD>\r\n    <TD align=left\r\n      background=\"images/topstrip.png\" bgcolor=\"#F0D1A3\"><FONT\r\n      size=-2>&nbsp;<I>powered by: </I><BR>&nbsp;<B>[<A class=powered\r\n      href=\"http://www.php.net/\" target=_new><I>PHP</I></A>]</B> + <B>[<A\r\n      class=powered href=\"http://www.mysql.com/\"\r\n      target=_new>mySQL</A>]</B></FONT></TD></TR>\r\n  <TR vAlign=bottom>\r\n    <TD vAlign=bottom width=132\r\n    background=\"images/topright.png\" bgcolor=\"#F0D1A3\"><SPAN\r\n      class=webblermenu>PHPlist</SPAN></TD></TR>\r\n  <TR>\r\n    <TD bgColor=#000000><IMG height=1 alt=\"\"\r\n      src=\"images/transparent.png\" width=20\r\n      border=0></TD>\r\n    <TD bgColor=#000000><IMG height=1 alt=\"\"\r\n      src=\"images/transparent.png\" width=576\r\n      border=0></TD>\r\n    <TD bgColor=#000000><IMG height=1 alt=\"\"\r\n      src=\"images/transparent.png\" width=132\r\n      border=0></TD></TR>\r\n  <TR vAlign=top>\r\n    <TD>&nbsp;</TD>\r\n<td><div align=left>\r\n<br />\r\n'),(1,'intro','Subscribe to one or more of our newsletters using the form below'),(1,'title','Title of this set of lists'),(1,'attributes',''),(1,'emaildoubleentry','yes'),(1,'htmlchoice','checkforhtml');

--
-- Table structure for table `phplist_task`
--

CREATE TABLE `phplist_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page` varchar(25) DEFAULT NULL,
  `type` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `page` (`page`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phplist_task`
--

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

--
-- Table structure for table `phplist_template`
--

CREATE TABLE `phplist_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `template` longblob,
  `listorder` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `phplist_templateimage`
--

CREATE TABLE `phplist_templateimage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template` int(11) DEFAULT NULL,
  `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`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `phplist_templateimage` VALUES (1,0,'image/png','powerphplist.png','iVBORw0KGgoAAAANSUhEUgAAAEYAAAAeCAMAAACmLZgsAAADAFBMVEXYx6fmfGXfnmCchGd3VDPipmrouYIHBwe3qpNlVkTmcWHdmFrfRTeojW3IpXn25L7mo3TaGhe6mXLCmm+7lGnntn7sx5Sxh1usk3akdEfBiFPtyJfgo2bjqW7krnTjqnDproK1pInvODRRTEKFemnuzaAtIRXenF7KqIHfn2KHcVjtyZjnqHrnknLhpGjnt4HeMyzlnnHr1rLkmW3WAADllGuUfmPcKSMcFxLnuICUd1f037kqJiDqv47sxZLYAQHLtJLfOTI7KhrInnHqwY7hTUHz2rGDbVTz27Xkr3XJvKPng3HuypzouoPrwo/hXk3x1qzqwIvizavrwpDu0atqYVTqnoBdTz7QlFvqtYbgST14cWPar33hYkrw0qZKQjjdml12XkPSv52NhHPovIjjrHLZDQz03bbsxZHcq3fgQjsUEg92YUmUinjgpGbvz6PZtYjcp3Tr2bWEaUzz3LXx1KhFOi7pvojy2K314rzjvYzjf2EwLCbw0qRvUzb25MBoSi3gomXdmFvlsXhBOzIiHxrw06i8oHzx1qrqwIvmjWt4aVaFXjnopHzuy5724r/supM5Myzeml3qv4rx1Kbou4bmuYTosoHhyaTipWngoWTmtHvms3rjrXLmsn2yf07OkFf137zsx5bw1KvmsXjoq33uzqTsxpTouojdl1vlZlvswpDy16rDtZrkbFq3jmHhUUXhpmrbHxriX0/lsnrirnf14r/ty6BZPiXouYflsnjmsXvimmZaQSjiqGvipmnhpmn2473msnjovIbtx5nem13w0aRKNCDipWrrw5TsvY7qvokODArhWUnqwI/ip2vemVzlpnTrw5Hjq3Dy17Dihl/xSUPvbl3Nu53gUEPfQDPhpWnlh2nwi3ToiXDouYXt27n03LO1nX3bFBHjlmbaCAnroHXYCAfBs5fWqXXsxZbnwIzjYFPrw5Ddwp3pvYyUaD7On27RpnjXpXDswJTWpG/gsn3lwJHy4Lv037jiaFbdmVzcl1kDAgEEAwIAAACJJzCsAAAAAWJLR0QAiAUdSAAAAAlwSFlzAAALEgAACxIB0t1+/AAAAAd0SU1FB9MKFQolCwe/95QAAAXuSURBVHicrZF5XJJ3HMdVHodmZhcmCqbzRFNRSbGpCHk2tF46y6yQyiup7LDDpSlgpoVmHjNAXi3TWs0Oj8qt0qxJxyhn1LZga1u2tVou290In31/D7j197YPz+/7+x6/75vv83ssjP9B4xMyWhhf/msxgtSg0sbrswEjMRgkBomdBIzBYGdnkIDszLvElJWgwPBSAsljEELCDtYxxQfq0lKBQPBRDmAg+4lBKBQaTDLtQskrvrlEEImakChJAAMQdSWBGRTW1/NwvFco0+Dlg2znMfxdWS8kcCqs3noMLAaG7TxYXw++TOg9Vu89NjhYL6S9pxaoS9WCJ+ilfEA8qjPurDmYwZP1ysp5Y+UyHhWyuI8z7oNhPoPIYL0+VpCRXfU5yMauoqZB/bPKRoGgcct1OmCsQPDn5VSelRWGjZXzqJh3BprGCs1hhaahYpgVKpsyVpgmAzUxZl/fglT5rNNoMc4A8agMBprGW5bB4zF43kSCgTOuYgwMAw8MdpHIOOMMBpWHehi0Hq8tjYBRB+nHLcYVCrGYR1UoFOhuxApvTMwrV5juRpGhOThxN97OcA78iwoxlScWQ0DPrkTDVPGlNMDQaOvXw6LRaIGwiIDY//aJKvLEYhSKaaYTnT38RR1VVR1VUVqE0ev1crn+kvwa2uR6faD8kt5ajrL6TnD1+v5+eScq6C/p+/X6a4HyQDjZL3eNquyo6ujYfoTSh17Kum9oaMh6CJk+a2LvG0LORDRR7YODKI3Ow6P6qnA70qI06dAQYOiguVwOh8XisOIe0ukPdRwiYN6l980jizZDuY9OnyUa37mRPmMr3A5OJv06DzYjWmyvoBw6HTBarbaGy8qNO/m0ixUXqtVe0HFyM/9cGM7q+k4bRtYkaAnNEuE7Z/+0BI9cuzIL9/t5VuTW/WScXVHhESWFKmBcVapuTteO4ODQyazTD1WqC5M53Jrh0Ls61mdrSGRRgkqVo1KpTrHHN6tI5P0znj+fbz//zPLdMe6RRtuYGF+Ka46rK2CSkpK6WN3DsOlYmcFJScM6TkEzRDtYr28kaUR+SYQAM+/MXtyWCFqya+PjD5QY98bXJktRAjA9UimTdTNYer69m3lyTtv5dpjGra1t6grWp2sQRnpZ2vZhG5pGGkYuCZv5/HHErSPx8dtXleDp57KVUunly1LAtLQovxh5tHBPwP1JTyfd3xMQEMcpCJi6Z8Ujzpc98FJ+SqWyRak8xTau7PHNwvEs2wSnA0XfxMcjzDMKdCtbWgBDoVCab+bC1+HkjnwLhjuZU5A5DRzdUgrCUAjNBMxvlOklIg18oNUheXlFgLENMhUpgIkANVsyR6Z1MbnMrpHwe5mcgnvhuUzL8xERYSKRXwQhhHkc9NoGXyfPrHGNTV5eHsJQgkxVwCQjBbWHBs+1PP7m3KnDoXGcuIA5oXMokCYBBpVfSwbM2uXZsfy3QkJSPfBlIS+KYiJhGlMxGTBXmsxyOz3teHBTUztMU9fUlIxSJBGbZCpOFxnX/n4uNeSNFy+KbPH0TYlHfOGDv0PUrjQB5uNtZjXrWKdrtm0DDLcOQpQniTTpTvb29k5TprPHw0IWpC+zWXViNVtjk+h1ewpM02RuBUw1oYbqajcuK7Omurpdx2HWNVQTvzANrimJ3LWrxG+3CF/99Toc3+9RgZM9U2tvV0/ZhS/JJjobGgATa1JK7NLu8JNuKbFucSxuXYop6VQRCRDAeH6eVbJu04JlWRB7eP7ofzv2lm9WZMIPRGNsLGBGzUqLag9wi0obvbE43PKX0bTR0ZSU0Q0PnB48cHd3t7HY9L27xR/FxaknFthYeLnkp6Slvb3b3tfUmfI+YKKj8/OjzYawTxbfAHvU0cW/trDyTuKhfQ4DDsUDoOJiB4fiRAG/NRrq+eY24gGMI6GjaCE5tjq2+vvzvQoFiwgEaMBhYADtDmVnEyu9+HCGOPhPYytgXMzyh2Z+ba1Xobry8J3EvENny8rKHF5V2b7Ew4V8l1fkb+5zAcz/or8Ag3ozZFZX3G0AAAAASUVORK5CYII=',70,30);

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

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

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


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

CREATE TABLE `phplist_user_attribute` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `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=MyISAM DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `phplist_user_blacklist` (
  `email` varchar(255) NOT NULL DEFAULT '',
  `added` datetime DEFAULT NULL,
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `phplist_user_blacklist_data` (
  `email` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(100) DEFAULT NULL,
  `data` text,
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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 DEFAULT '0',
  `message` int(11) NOT NULL DEFAULT '0',
  `bounce` int(11) NOT NULL DEFAULT '0',
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user` (`user`,`message`,`bounce`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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 DEFAULT '0',
  `message` int(11) NOT NULL DEFAULT '0',
  `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 `user` (`user`,`message`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- Table structure for table `phplist_user_rss`
--

CREATE TABLE `phplist_user_rss` (
  `userid` int(11) NOT NULL DEFAULT '0',
  `last` datetime DEFAULT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phplist_user_rss`
--


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

CREATE TABLE `phplist_user_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL DEFAULT '',
  `confirmed` tinyint(4) DEFAULT '0',
  `blacklisted` tinyint(4) DEFAULT '0',
  `bouncecount` int(11) DEFAULT '0',
  `entered` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `uniqid` varchar(255) 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 `idx_phplist_user_user_uniqid` (`uniqid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `phplist_user_user` VALUES (1,'piersonr@gmail.com',0,0,0,'2006-01-23 09:08:46','2006-01-23 14:11:43','f7405053d137cf83492a79c2c384b491',1,NULL,NULL,NULL,NULL,0,NULL,NULL);

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

CREATE TABLE `phplist_user_user_attribute` (
  `attributeid` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`attributeid`,`userid`),
  KEY `attuserid` (`userid`,`attributeid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- 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 DEFAULT '0',
  `ip` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `summary` varchar(255) DEFAULT NULL,
  `detail` text,
  `systeminfo` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `phplist_usermessage` (
  `messageid` int(11) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  `entered` datetime DEFAULT NULL,
  `viewed` datetime DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`userid`,`messageid`),
  KEY `enteredindex` (`entered`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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 `listdateindex` (`listid`,`unixdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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



