userusage

userusage — Keep track of when users did certain things.

userusage

Column nameTypeNullDefaultDescription
useridint unsigned0Userid of user. One row in this table per user.
timecreatedatetime0000-00-00 00:00:00When the user created their journal.
timeupdatedatetimeYESWhen the user last updated their journal.
timecheckdatetimeYESunused.
lastitemidint unsigned0Itemid of their last post (see log/log2)
Key nameTypeColumn(s)
PRIMARYPRIMARY
timeupdateINDEX