infohistory

infohistory — A history log table for certain types of changes (like user e-mail changes). So the old values can be looked at by administrators or automatically retrieved.

infohistory

Column nameTypeNullDefaultDescription
useridint unsigned0The userid of the user making the change.
whatvarchar(15)Short name of the item being changed.
timechangedatetime0000-00-00 00:00:00The time of the change.
oldvaluevarchar(255)YESThe old value of the item.
othervarchar(30)YESOptional note space.
Key nameTypeColumn(s)
useridINDEX