CREATE TABLE `email_banned_emails` (
  `banid` int(11) NOT NULL auto_increment,
  `emailaddress` varchar(255) default NULL,
  `list` varchar(10) default NULL,
  `bandate` int(11) default NULL,
  PRIMARY KEY  (`banid`),
  UNIQUE KEY `email_banned_emails_list_email_idx` (`list`,`emailaddress`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `email_list_subscribers` (
  `subscriberid` int(11) NOT NULL auto_increment,
  `listid` int(11) NOT NULL default '0',
  `emailaddress` varchar(200) default NULL,
  `domainname` varchar(100) default NULL,
  `format` char(1) default NULL,
  `confirmed` char(1) default '0',
  `confirmcode` varchar(32) default NULL,
  `requestdate` int(11) default '0',
  `requestip` varchar(20) default NULL,
  `confirmdate` int(11) default '0',
  `confirmip` varchar(20) default NULL,
  `subscribedate` int(11) default '0',
  `bounced` int(11) default '0',
  `unsubscribed` int(11) default '0',
  `unsubscribeconfirmed` char(1) default '0',
  `formid` int(11) default '0',
  PRIMARY KEY  (`subscriberid`),
  UNIQUE KEY `email_subscribers_email_list_idx` (`emailaddress`,`listid`),
  KEY `email_list_subscribers_sub_list_idx` (`subscriberid`,`listid`),
  KEY `email_subscribe_date_idx` (`subscribedate`),
  KEY `email_list_subscribers_listid_idx` (`listid`)
) ENGINE=MyISAM AUTO_INCREMENT=105536 DEFAULT CHARSET=utf8 ;

CREATE TABLE `email_lists` (
  `listid` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `ownername` varchar(255) default NULL,
  `owneremail` varchar(100) default NULL,
  `bounceemail` varchar(100) default NULL,
  `replytoemail` varchar(100) default NULL,
  `bounceserver` varchar(100) default NULL,
  `bounceusername` varchar(100) default NULL,
  `bouncepassword` varchar(100) default NULL,
  `extramailsettings` varchar(100) default NULL,
  `companyname` varchar(255) default NULL,
  `companyaddress` varchar(255) default NULL,
  `companyphone` varchar(20) default NULL,
  `format` char(1) default NULL,
  `notifyowner` char(1) default '0',
  `imapaccount` char(1) default '0',
  `createdate` int(11) default '0',
  `subscribecount` int(11) default '0',
  `unsubscribecount` int(11) default '0',
  `bouncecount` int(11) default '0',
  `processbounce` char(1) default '0',
  `agreedelete` char(1) default '0',
  `agreedeleteall` char(1) default '0',
  `visiblefields` text NOT NULL,
  `ownerid` int(11) default '0',
  PRIMARY KEY  (`listid`),
  KEY `email_lists_owner_idx` (`ownerid`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

START TRANSACTION;
SELECT banid, list FROM email_banned_emails be WHERE emailaddress IN ('email@address.com', 'hotmail.com', '@hotmail.com') AND list IN ('4','g') LIMIT 1;
SELECT subscriberid FROM email_list_subscribers WHERE emailaddress = 'email@address.com' AND listid=4;
INSERT INTO email_list_subscribers(listid, emailaddress, format, confirmed, confirmcode, subscribedate, bounced, unsubscribed, requestdate, requestip, confirmdate, confirmip, formid, domainname) VALUES ('4', 'email@address.com', 'h', '1', '84e6ab8d17cd1cc669dbb409f6875664', 1242432850, '0', '0', 1242432850, '', 1242432850, '', '0', SUBSTRING('email@address.com' FROM LOCATE('@', 'email@address.com')));
UPDATE email_lists SET subscribecount=subscribecount + 1 WHERE listid=4;
SAVEPOINT interspire4a0e91f2aa63e;
select 1;