userlog — Clustered. Stores general purpose status log data, such as when an entry is deleted or logging post-by-e-mail activity. The initiator of the event is stored here so we can look back and say, for example: "this person deleted the entry". This works for communities and individual journals, and the actions are logged on the account that lost the entry. The basic format is [ action, actiontarget ].
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| userid | int unsigned |
|
||
| logtime | int unsigned |
|
||
| action | varchar(30) |
|
A textual description of what happened (up to 30 characters). | |
| actiontarget | int unsigned | YES |
|
Optional, but is likely some numeric value. |
| remoteid | int unsigned | YES |
|
|
| ip | varchar(15) | YES |
|
|
| uniq | varchar(15) | YES |
|
|
| extra | varchar(255) | YES |
|
| Key name | Type | Column(s) |
|---|---|---|
| userid | INDEX |