-
Notifications
You must be signed in to change notification settings - Fork 2
Description
Hello,
I can not create table clients_has_domains & domains_has_keywords in MySQL : 5.0.51a.
But I have solved this problem, the SQL syntax must be separated.
CREATE TABLE domains_has_keywords (
domains_id int(11) NOT NULL,
keywords_id int(11) NOT NULL,
KEY keywords_id (keywords_id),
KEY domains_id (domains_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE domains_has_keywords
ADD CONSTRAINT domains_has_keywords_ibfk_2 FOREIGN KEY (keywords_id) REFERENCES keywords (keywords_id) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT domains_has_keywords_ibfk_1 FOREIGN KEY (domains_id) REFERENCES domains (domains_id) ON DELETE CASCADE ON UPDATE CASCADE;
And I run this script, but the analysis only two overlapping lines.
Does it working?

Thanks for your help!!