rAH6aL9S

1CREATE  TABLE IF NOT EXISTS `zeugdb`.`movie_has_tag` (
2  `movie_id` INT NOT NULL ,
3  `tag_id` INT NOT NULL ,
4  `added_by` INT NULL ,
5  `added` TIMESTAMP NULL DEFAULT current_timestamp ,
6  PRIMARY KEY (`movie_id`, `tag_id`) ,
7  INDEX `fk_movie_has_tag_tag1_idx` (`tag_id` ASC) ,
8  INDEX `fk_movie_has_tag_movie1_idx` (`movie_id` ASC) ,
9  INDEX `fk_movie_has_tag_user1_idx` (`added_by` ASC) ,
10  CONSTRAINT `fk_movie_has_tag_movie1`
11    FOREIGN KEY (`movie_id` )
12    REFERENCES `zeugdb`.`movie` (`id` )
13    ON DELETE NO ACTION
14    ON UPDATE NO ACTION,
15  CONSTRAINT `fk_movie_has_tag_tag1`
16    FOREIGN KEY (`tag_id` )
17    REFERENCES `zeugdb`.`tag` (`id` )
18    ON DELETE NO ACTION
19    ON UPDATE NO ACTION,
20  CONSTRAINT `fk_movie_has_tag_user1`
21    FOREIGN KEY (`added_by` )
22    REFERENCES `zeugdb`.`user` (`id` )
23    ON DELETE NO ACTION
24    ON UPDATE NO ACTION)
25ENGINE = InnoDB;