mysql schema has `on update cascade` here which makes sense imo. any reason you are using `on update restrict` here and in AuthAssignment table below?