Currently on page 120, but I cannot seem to run the query to manually assign the two users to Project 1. Everytime I run it I get an error that states:
#1452 - Cannot add or update a child row: a foreign key constraint fails (`trackstar_dev`.`tbl_project_user_assignment`, CONSTRAINT `FK_project_user` FOREIGN KEY (`project_id`) REFERENCES `tbl_project` (`id`) ON DELETE CASCADE)
I’m not entirely sure why this is failing as I set the foreign keys according to what the book said.
ALTER TABLE tbl_project_user_assignment
ADD CONSTRAINT FK_project_user FOREIGN KEY
(project_id)
REFERENCES tbl_project(id)
ON DELETE CASCADE
ON UPDATE RESTRICT
;
ALTER TABLE tbl_project_user_assignment
ADD CONSTRAINT FK_user_project FOREIGN KEY
(user_id)
REFERENCES tbl_user(id)
ON DELETE CASCADE
ON UPDATE RESTRICT
;
Any help in resolving this issue would be greatly appreciated.