CREATE TABLE `comments` ( | |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT, | |
`comment` varchar(100) NOT NULL, | |
`article_id` int(11) unsigned NOT NULL, | |
PRIMARY KEY (`id`), | |
KEY `FK_COMMENTS_ARTICLE_ID` (`article_id`), | |
CONSTRAINT `FK_COMMENTS_ARTICLE_ID` FOREIGN KEY (`article_id`) REFERENCES `articles` (`id`) ON UPDATE NO ACTION | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment