I am trying to set a foreign key to constraint for on delete and on update to "NO ACTION", but for some reason after I apply the changes MySQL workbench changes it back to "RESTRICTED" on its own, I don't know why it's doing that.
This is the code MySQL Workbench generates when I try to change the constraints for on update and on delete to "NO ACTION"
ALTER TABLE `forums`.`post_replies`
DROP FOREIGN KEY `fk_post_replies_users`;
ALTER TABLE `forums`.`post_replies`
ADD CONSTRAINT `fk_post_replies_users`
FOREIGN KEY (`user_id`)
REFERENCES `forums`.`users` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION;