--
-- Host: localhost    Database: tor14438_plst1
-- ------------------------------------------------------


--
-- Current Database: `tor14438_plst1`
--


--
-- 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`),
  KEY `loginnameidx` (`loginname`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `phplist_admin` (`id`, `loginname`, `namelc`, `email`, `created`, `modified`, `modifiedby`, `password`, `passwordchanged`, `superuser`, `disabled`) VALUES (1,'admin','admin','gwen@torchwoodaustralia.com','2008-02-25 00:31:19','2008-02-24 13:31:19','admin','TARDIS11','2008-02-25',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` (`item`, `value`, `editable`, `type`) VALUES ('version','2.10.17',0,NULL),('updatelastcheck','2012-09-16 15:55:16',0,NULL),('website','torchwoodaustralia.com',1,NULL),('domain','torchwoodaustralia.com',1,NULL),('xormask','c911ca365f14247fd5456be47f4cc983',0,NULL),('check_new_version','7',1,NULL),('admin_address','gwen@torchwoodaustralia.com',1,NULL),('admin_addresses','',1,NULL),('report_address','listreports@[DOMAIN]',1,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]/maillist/?p=subscribe',1,NULL),('unsubscribeurl','http://[WEBSITE]/maillist/?p=unsubscribe',1,NULL),('confirmationurl','http://[WEBSITE]/maillist/?p=confirm',1,NULL),('preferencesurl','http://[WEBSITE]/maillist/?p=preferences',1,NULL),('forwardurl','http://[WEBSITE]/maillist/?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  \n  You have requested your personal location to update your details from our website.\n  The location is below. Please make sure that you use the full line as mentioned below.\n  Sometimes email programme can wrap the line into multiple lines.\n  \n  Your personal location is:\n  [PREFERENCESURL]\n  \n  Thank you.\n  ',1,NULL),('messagefooter','--\nIf you do not want to receive any more newsletters,  [UNSUBSCRIBE]\n\nTo update your preferences and to unsubscribe visit [PREFERENCES]\nForward a Message to Someone [FORWARD]',1,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','UTF-8',1,NULL),('text_charset','UTF-8',1,NULL),('html_email_style','\n  <style type=\"text/css\">\n  body { font-size : 11px; font-family: Verdana, Arial, Helvetica, sans-serif; }\n  a { font-size: 11px; color: #ff6600; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; }\n  a:visited { color: #666666; }\n  a:hover {  text-decoration: underline; }\n  p { font-weight: normal; font-size: 11px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; }\n  h1 {font-weight: bold; font-size: 14px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none;}\n  h2 {font-weight: bold; font-size: 13px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none;}\n  h3 {font-weight: bold; font-size: 12px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; margin:0px; padding:0px;}\n  h4 {font-weight: bold; font-size: 11px; color: #666666; font-style: normal; font-family: verdana, sans-serif; text-decoration: none; margin:0px; padding:0px;}\n  hr {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;}\n  div.emailfooter { font-size : 11px; font-family: Verdana, Arial, Helvetica, sans-serif; }\n  div.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);

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

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


--
-- 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 `midindex` (`messageid`),
  KEY `uidindex` (`userid`),
  KEY `urlindex` (`url`),
  KEY `miduidindex` (`messageid`,`userid`),
  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 `linkindex` (`linkid`),
  KEY `uidindex` (`userid`),
  KEY `midindex` (`messageid`),
  KEY `linkuserindex` (`linkid`,`userid`),
  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`),
  KEY `nameidx` (`name`),
  KEY `listorderidx` (`listorder`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `phplist_list` (`id`, `name`, `description`, `entered`, `listorder`, `prefix`, `rssfeed`, `modified`, `active`, `owner`) VALUES (1,'test','List for testing.','2008-02-25 00:31:20',NULL,NULL,NULL,'2008-02-24 13:31:20',0,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`),
  KEY `listmessageidx` (`listid`,`messageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `phplist_listrss` (
  `listid` int(11) NOT NULL DEFAULT '0',
  `type` varchar(255) NOT NULL DEFAULT '',
  `entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `info` text,
  KEY `listididx` (`listid`),
  KEY `enteredidx` (`entered`)
) 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`),
  KEY `userenteredidx` (`userid`,`entered`),
  KEY `userlistenteredidx` (`userid`,`listid`,`entered`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


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

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


--
-- 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`),
  KEY `messageidx` (`messageid`),
  KEY `messageattidx` (`messageid`,`attachmentid`)
) 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`
--


--
-- 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) NOT NULL DEFAULT '0',
  `added` datetime DEFAULT NULL,
  `processed` mediumint(8) unsigned DEFAULT '0',
  `astext` int(11) DEFAULT '0',
  `ashtml` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `titlelinkidx` (`title`,`link`),
  KEY `titleidx` (`title`),
  KEY `listidx` (`list`)
) 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 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 DEFAULT CHARSET=latin1;

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


--
-- 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`
--


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

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

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

INSERT INTO `phplist_task` (`id`, `page`, `type`) 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) 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=MyISAM DEFAULT CHARSET=latin1;

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


--
-- 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`),
  KEY `nameindex` (`name`),
  KEY `idnameindex` (`id`,`name`)
) 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`),
  KEY `emailidx` (`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) NOT NULL DEFAULT '',
  `data` text,
  UNIQUE KEY `email` (`email`),
  KEY `emailidx` (`email`),
  KEY `emailnameidx` (`email`,`name`)
) 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 `umbindex` (`user`,`message`,`bounce`),
  KEY `useridx` (`user`),
  KEY `msgidx` (`message`),
  KEY `bounceidx` (`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 `usermessageidx` (`user`,`message`),
  KEY `useridx` (`user`),
  KEY `messageidx` (`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 `foreignkey` (`foreignkey`),
  KEY `idx_phplist_user_user_uniqid` (`uniqid`),
  KEY `emailidx` (`email`),
  KEY `enteredindex` (`entered`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- 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 `userindex` (`userid`),
  KEY `attindex` (`attributeid`),
  KEY `userattid` (`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`),
  KEY `userididx` (`userid`),
  KEY `dateidx` (`date`)
) 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 NOT NULL DEFAULT '0000-00-00 00:00:00',
  `viewed` datetime DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`userid`,`messageid`),
  KEY `messageidindex` (`messageid`),
  KEY `useridindex` (`userid`),
  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 `dateindex` (`unixdate`),
  KEY `itemindex` (`item`),
  KEY `listindex` (`listid`),
  KEY `listdateindex` (`listid`,`unixdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- Dumping events for database 'tor14438_plst1'
--

--
-- Dumping routines for database 'tor14438_plst1'
--


