 LOCK TABLES `phplist_linktrack` WRITE;
 UNLOCK TABLES;
 /*!40000 ALTER TABLE `phplist_linktrack` ENABLE KEYS */;
+
+--
+-- Table structure for table `phplist_linktrack_forward`
+--
+
+DROP TABLE IF EXISTS `phplist_linktrack_forward`;
+CREATE TABLE `phplist_linktrack_forward` (
+  `id` int(11) NOT NULL auto_increment,
+  `url` varchar(255) default NULL,
+  `personalise` tinyint(4) default '0',
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `urlunique` (`url`),
+  KEY `urlindex` (`url`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `phplist_linktrack_forward`
+--
+
+
+/*!40000 ALTER TABLE `phplist_linktrack_forward` DISABLE KEYS */;
+LOCK TABLES `phplist_linktrack_forward` WRITE;
+UNLOCK TABLES;
+/*!40000 ALTER TABLE `phplist_linktrack_forward` ENABLE KEYS */;
+
+--
+-- Table structure for table `phplist_linktrack_ml`
+--
+
+DROP TABLE IF EXISTS `phplist_linktrack_ml`;
+CREATE TABLE `phplist_linktrack_ml` (
+  `messageid` int(11) NOT NULL,
+  `forwardid` int(11) NOT NULL,
+  `firstclick` datetime default NULL,
+  `latestclick` datetime default NULL,
+  `total` int(11) default '0',
+  `clicked` int(11) default '0',
+  `htmlclicked` int(11) default '0',
+  `textclicked` int(11) default '0',
+  PRIMARY KEY  (`messageid`,`forwardid`),
+  KEY `midindex` (`messageid`),
+  KEY `fwdindex` (`forwardid`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `phplist_linktrack_ml`
+--
+
+
+/*!40000 ALTER TABLE `phplist_linktrack_ml` DISABLE KEYS */;
+LOCK TABLES `phplist_linktrack_ml` WRITE;
+UNLOCK TABLES;
+/*!40000 ALTER TABLE `phplist_linktrack_ml` ENABLE KEYS */;
+
+--
+-- Table structure for table `phplist_linktrack_uml_click`
+--
+
+DROP TABLE IF EXISTS `phplist_linktrack_uml_click`;
+CREATE TABLE `phplist_linktrack_uml_click` (
+  `id` int(11) NOT NULL auto_increment,
+  `messageid` int(11) NOT NULL,
+  `userid` int(11) NOT NULL,
+  `forwardid` int(11) default NULL,
+  `firstclick` datetime default NULL,
+  `latestclick` datetime default NULL,
+  `clicked` int(11) default '0',
+  `htmlclicked` int(11) default '0',
+  `textclicked` int(11) default '0',
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `miduidfwdid` (`messageid`,`userid`,`forwardid`),
+  KEY `midindex` (`messageid`),
+  KEY `uidindex` (`userid`),
+  KEY `miduidindex` (`messageid`,`userid`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `phplist_linktrack_uml_click`
+--
+
+
+/*!40000 ALTER TABLE `phplist_linktrack_uml_click` DISABLE KEYS */;
+LOCK TABLES `phplist_linktrack_uml_click` WRITE;
+UNLOCK TABLES;
+/*!40000 ALTER TABLE `phplist_linktrack_uml_click` ENABLE KEYS */;
 
 --
 -- Table structure for table `phplist_linktrack_userclick`

  `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,
  PRIMARY KEY  (`id`),
  KEY `user` (`user`,`message`,`bounce`)
) TYPE=MyISAM;

--
-- Dumping data for table `phplist_user_message_bounce`

  `listorder` int(11) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phplist_listattr_hiddenfiel`
