track_changes

Purpose: Stores changes to data. Mainly used to log changes to questions.
Joins: users table.

Field	Type	Purpose
id	int(4)	Primary Key – auto increment.
type	varchar(40)	Type of the change, i.e. 'Edit Question' or 'New Option'
typeID	int(4)	ID of the piece of data that has been changed. Could be paper, question or option ID depending on the change.
editor	int(10) unsigned	User ID of the member of staff who did the change.
old	text	The old value of the object.
new	text	The new value of the object.
changed	datetime	Datetime when the change occurred.
part	text	The field changed.

ExamSys (Archive)