I was able to still run the function without passing in the userId or eventId.
The queries still worked which might also mean that foreign keys aren't.
I think we're missing one from picture_events.eventId to events.id.
Fixed this by adding NOT NULL to both columns in the picture_events table;
Still need to add parameter validation.
I was able to still run the function without passing in the userId or eventId.
The queries still worked which might also mean that foreign keys aren't.I think we're missing one from picture_events.eventId to events.id.Fixed this by adding NOT NULL to both columns in the picture_events table;
Still need to add parameter validation.