infohistory

infohistory — Global. Stores a history log of certain types of changes (like user e-mail changes), so the old values can be looked at by administrators or automatically retrieved. Please see also statushistory.

infohistory

Column name Type Null Default Description
userid int unsigned   0 The userid of the user making the change.
what varchar(15)   Short name of the item being changed.
timechange datetime   0000-00-00 00:00:00 The time of the change.
oldvalue varchar(255) YES The old value of the item.
other varchar(30) YES Optional note space.
Key name Type Column(s)
userid INDEX