vVp9aXPA

1CREATE  TABLE IF NOT EXISTS `abuse` (                                                                                                                                                                                                        
2  `id` INT NOT NULL AUTO_INCREMENT ,
3  `video_id` INT NOT NULL ,
4  `user_id` INT NOT NULL ,
5  `reason` TEXT NOT NULL ,
6  PRIMARY KEY (`id`) ,
7  INDEX `ab_user_id_fk` (`user_id` ASC) ,
8  INDEX `ab_video_id_fk` (`video_id` ASC) ,
9  CONSTRAINT `ab_user_id_fk`
10    FOREIGN KEY (`user_id` )
11    REFERENCES `users` (`id` )
12    ON DELETE SET NULL
13    ON UPDATE NO ACTION,
14  CONSTRAINT `ab_video_id_fk`
15    FOREIGN KEY (`video_id` )
16    REFERENCES `videos` (`id` )
17    ON DELETE CASCADE
18    ON UPDATE NO ACTION)
19ENGINE = InnoDB;