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.
| 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 |