q6QMTVni

1CREATE TABLE IF NOT EXISTS `font_favorite` (
2  `id` INT NOT NULL AUTO_INCREMENT,
3  `user_id` INT NOT NULL,
4  `font_id` INT(11) NOT NULL,
5  PRIMARY KEY (`id`, `user_id`, `font_id`),
6  INDEX `fk_font_favorite_user_idx` (`user_id` ASC),
7  INDEX `fk_font_favorite_font_idx` (`font_id` ASC),
8  CONSTRAINT `fk_font_favorite_user`
9    FOREIGN KEY (`user_id`)
10    REFERENCES `user` (`user_id`)
11    ON DELETE CASCADE,
12  CONSTRAINT `fk_font_favorite_font`
13    FOREIGN KEY (`font_id`)
14    REFERENCES `font` (`font_id`)
15    ON DELETE CASCADE
16	)
17ENGINE = InnoDB