What does ON UPDATE RESTRICT do?

Solution 1:

RESTRICT prevents the action from happening if there's any foreign keys that rely on the field that's being changed.