K0HMVPRf

1-- -----------------------------------------------------
2-- Table `events`.`user_roles`
3-- -----------------------------------------------------
4CREATE TABLE IF NOT EXISTS `events`.`user_roles` (
5  `idUser` INT NOT NULL,
6  `idRole` INT NOT NULL,
7  PRIMARY KEY (`idUser`, `idRole`),
8  INDEX `fk_user_roles_roles1_idx` (`idRole` ASC),
9  CONSTRAINT `fk_user_roles_users1`
10    FOREIGN KEY (`idUser`)
11    REFERENCES `events`.`users` (`id`)
12    ON DELETE NO ACTION
13    ON UPDATE NO ACTION,
14  CONSTRAINT `fk_user_roles_roles1`
15    FOREIGN KEY (`idRole`)
16    REFERENCES `events`.`roles` (`idRole`)
17    ON DELETE NO ACTION
18    ON UPDATE NO ACTION) 
19     
20> #1005 - Can't create table `events`.`user_roles` (errno: 150 "Foreign key constraint is incorrectly formed")