audit_log

id

int unsigned

Primary Key – auto increment.

userID

int(10) unsigned

ID of the user affected by the change (foreign key to users table)

action

varchar(30)

The permission change i.e. ‘Add-Role’, ‘Module-Enrolment’

time

timestamp

The time/date when the change occurred.

sourceID

int

ID of the user that made the change (-1 if the system)

source

text

path to script that made the change

details

text

The role assign or module enrolled onto