Difference between revisions of "Mysql setting constraints"
From MyWiki
| (3 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
<source lang="sql"> | <source lang="sql"> | ||
| − | |||
| − | |||
| − | |||
CONSTRAINT education_ibfk_1 | CONSTRAINT education_ibfk_1 | ||
FOREIGN KEY (profile_id) | FOREIGN KEY (profile_id) | ||
| Line 13: | Line 10: | ||
REFERENCES Institution (institution_id) | REFERENCES Institution (institution_id) | ||
ON DELETE CASCADE ON UPDATE CASCADE, | 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 | ||
| + | |||
| Line 22: | Line 29: | ||
FOREIGN KEY (hostname) | FOREIGN KEY (hostname) | ||
REFERENCES sslhosts (hostname) | REFERENCES sslhosts (hostname) | ||
| − | ); | + | ON DELETE CASCADE ON UPDATE CASCADE |
| + | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
</source> | </source> | ||
http://www.mysqltutorial.org/mysql-primary-key/<br> | http://www.mysqltutorial.org/mysql-primary-key/<br> | ||
Latest revision as of 17:04, 22 January 2019
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;
