DROP TABLE IF EXISTS dbmail_envelope;
CREATE TABLE dbmail_envelope (
 physmessage_id BIGINT NOT NULL,
 id BIGINT NOT NULL AUTO_INCREMENT,
 envelope TEXT NOT NULL,
 PRIMARY KEY (id),
 UNIQUE (physmessage_id, id),
 FOREIGN KEY (physmessage_id)
 REFERENCES dbmail_physmessage(id)
 ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=InnoDB;


ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REFERENCES dbmail_physmessage(id)
 ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=' at line 7