Help with adding transaction tracking data

The php video web script that I’m trying to modify has a process where Users generate credit units from viewed videos.
The total ‘balance’ of credits is stored in mysql db table named 'User', in a column titled “balance”, with each total reflected in a users’ row, and the 'balance' total gets updated (goes up or down), depending on the activity of the credits.

However, if 2 credits get added to the balance, for example, there is no tracking of what type of activity caused the balance total...

Help with adding transaction tracking data

from MySQL https://ift.tt/2Meq4qn
via IFTTT