I have a users table which has a user_id and points field. I have a points_events table which logs each time a user_id receive points for an action
I need the points field in the users table to sum the total points associated with that user_id from the records in the points_events table.
How can I do this? I need it to be as automatic as possible. Thanks for any help you can offer!