userusage — Keep track of when users did certain things.
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| userid | int unsigned | 0 | Userid of user. One row in this table per user. | |
| timecreate | datetime | 0000-00-00 00:00:00 | When the user created their journal. | |
| timeupdate | datetime | YES | When the user last updated their journal. | |
| timecheck | datetime | YES | unused. | |
| lastitemid | int unsigned | 0 | Itemid of their last post (see log/log2) |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| timeupdate | INDEX |