· 7 years ago · Jan 20, 2019, 11:08 PM
1INSERT INTO list_subscribers (subscriberid, listid, emailaddress, domainname, format, confirmed, confirmcode, requestdate, requestip, confirmdate, confirmip, subscribedate, unsubscribed, unsubscribeconfirmed)
2VALUES ('203404', 1, 'blah@gmail.com', '@gmail.com', 'h', 1, '1234', 1282196458, '', 1282196458, '', 1282196458, 0, 0 )
3ON DUPLICATE KEY UPDATE emailaddress='blah@gmail.com', domainname = '@gmail.com', unsubscribed = 0, unsubscribeconfirmed = 0
4
5Error Code: 1062. Duplicate entry 'blah@gmail.com-1' for key 'subscribers_email_list_idx'
6
7CREATE TABLE `list_subscribers` (
8 `subscriberid` int(11) NOT NULL AUTO_INCREMENT,
9 `listid` int(11) NOT NULL DEFAULT '0',
10 `emailaddress` varchar(200) DEFAULT NULL,
11 `domainname` varchar(100) DEFAULT NULL,
12 `format` char(1) DEFAULT NULL,
13 `confirmed` char(1) DEFAULT '0',
14 `confirmcode` varchar(32) DEFAULT NULL,
15 `requestdate` int(11) DEFAULT '0',
16 `requestip` varchar(20) DEFAULT NULL,
17 `confirmdate` int(11) DEFAULT '0',
18 `confirmip` varchar(20) DEFAULT NULL,
19 `subscribedate` int(11) DEFAULT '0',
20 `bounced` int(11) DEFAULT '0',
21 `unsubscribed` int(11) DEFAULT '0',
22 `unsubscribeconfirmed` char(1) DEFAULT '0',
23 `formid` int(11) DEFAULT '0',
24 PRIMARY KEY (`subscriberid`),
25 UNIQUE KEY `subscribers_email_list_idx` (`emailaddress`,`listid`),
26 KEY `list_subscribers_sub_list_idx` (`subscriberid`,`listid`),
27 KEY `subscribe_date_idx` (`subscribedate`),
28 KEY `list_subscribers_listid_idx` (`listid`),
29 KEY `confirmed_idx` (`confirmed`)
30) ENGINE=InnoDB AUTO_INCREMENT=4687107 DEFAULT CHARSET=utf8