Mysql setting constraints
From MyWiki
CONSTRAINT education_ibfk_1 FOREIGN KEY (profile_id) REFERENCES Profile (profile_id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT education_ibfk_2 FOREIGN KEY (institution_id) REFERENCES Institution (institution_id) ON DELETE CASCADE ON UPDATE CASCADE, CREATE TABLE sslhosts ( hostname VARCHAR(30) NOT NULL, port INT(11) DEFAULT 443, PRIMARY KEY (hostname) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 CREATE TABLE notes ( hostname VARCHAR(30), notes VARCHAR(100), CONSTRAINT myconst_1 FOREIGN KEY (hostname) REFERENCES sslhosts (hostname) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;