/* create table mailing */
CREATE TABLE IF NOT EXISTS mailing(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
addr VARCHAR(255) NOT NULL,
domain VARCHAR(255) NOT NULL)ENGINE = InnoDB
/* create table addr_count */
CREATE TABLE IF NOT EXISTS addr_count(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
e_addr VARCHAR(255) NOT NULL,
e_domain VARCHAR(255) NOT NULL,
count INT NOT NULL,
INDEX (e_addr),
INDEX (e_domain),
FOREIGN KEY (e_addr) REFERENCES mailing (addr) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (e_domain) REFERENCES mailing (domain) ON DELETE CASCADE ON UPDATE CASCADE)
ENGINE = InnoDB
Could you please help me with this error? Everything seems correct to me but not sure what I am missing!