In MySQL, when using the InnoDB tables, can there be multiple foreign keys? I tried it but it keeps saying I have a syntax error.
Example:
CREATE TABLE wp_post2content (
id INT UNSIGNED NOT NULL auto_increment,
post_id BIGINT UNSIGNED NOT NULL,
content_id BIGINT UNSIGNED NOT NULL,
PRIMARY KEY(id),
FOREIGN KEY (post_id) REFERENCES wp_posts(ID) ON DELETE CASCADE,
FOREIGN KEY (content_id) REFERENCES wp_contentdb(id) ON DELETE CASCADE
} TYPE=InnoDB