Z1xfyC69

1Executing SQL script in server
2ERROR: Error 1215: Cannot add foreign key constraint
3SQL Code:
4        -- -----------------------------------------------------
5        -- Table `shareyourfind`.`user_role`
6        -- -----------------------------------------------------
7        CREATE TABLE IF NOT EXISTS `shareyourfind`.`user_role` (
8          `role_name` VARCHAR(45) NOT NULL,
9          `username` VARCHAR(45) NOT NULL,
10          PRIMARY KEY (`role_name`, `username`),
11          INDEX `fk_role_has_user_user1_idx` (`username` ASC),
12          INDEX `fk_role_has_user_role1_idx` (`role_name` ASC),
13          CONSTRAINT `fk_role_has_user_role1`
14            FOREIGN KEY (`role_name`)
15            REFERENCES `shareyourfind`.`role` (`role_name`)
16            ON DELETE NO ACTION
17            ON UPDATE NO ACTION,
18          CONSTRAINT `fk_role_has_user_username`
19            FOREIGN KEY (`username`)
20            REFERENCES `shareyourfind`.`user` (`username`)
21            ON DELETE NO ACTION
22            ON UPDATE NO ACTION)
23        ENGINE = InnoDB
24
25SQL script execution finished: statements: 9 succeeded, 1 failed
26
27Fetching back view definitions in final form.
28Nothing to fetch